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.WMS_PURGE_PVT dependencies on FND_MESSAGE

Line 44: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');

40: SAVEPOINT Check_Purge_LPN_PVT;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
44: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
45: fnd_msg_pub.ADD;
46: RAISE fnd_api.g_exc_unexpected_error;
47: END IF;
48:

Line 94: fnd_message.set_name('WMS', 'WMS_LPN_INELIGIBLE_FOR_PURGE');

90: WHERE txn_source_name = 'WMS_LPN_PURGE';
91:
92: --bug 5150284 if any LPNs did not pass validation, add message to stack
93: IF ( p_lpn_id_table.count > l_valid_lpns.count ) THEN
94: fnd_message.set_name('WMS', 'WMS_LPN_INELIGIBLE_FOR_PURGE');
95: fnd_msg_pub.ADD;
96: END IF;
97:
98: l_progress := 'Replace LPNS in rec with only valid lpn_ids';

Line 149: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');

145: SAVEPOINT PURGE_LPNS_PVT;
146:
147: -- Standard call to check for call compatibility.
148: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
149: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
150: fnd_msg_pub.ADD;
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:

Line 284: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

280: IF ( p_purge_type = DEVICE OR p_purge_type IS NULL ) THEN
281:
282: delete from wms_device_requests_hist
283: where creation_date < l_date and organization_id = p_orgid;
284: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
285: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
286: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DEVICE_REQUESTS_HIST');
287: FND_MSG_PUB.ADD;
288: END IF; --Added bug#4415994

Line 285: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);

281:
282: delete from wms_device_requests_hist
283: where creation_date < l_date and organization_id = p_orgid;
284: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
285: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
286: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DEVICE_REQUESTS_HIST');
287: FND_MSG_PUB.ADD;
288: END IF; --Added bug#4415994
289: IF ( p_purge_type = LPN OR p_purge_type IS NULL ) THEN

Line 286: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DEVICE_REQUESTS_HIST');

282: delete from wms_device_requests_hist
283: where creation_date < l_date and organization_id = p_orgid;
284: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
285: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
286: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DEVICE_REQUESTS_HIST');
287: FND_MSG_PUB.ADD;
288: END IF; --Added bug#4415994
289: IF ( p_purge_type = LPN OR p_purge_type IS NULL ) THEN
290: -- initialize table delete count variables

Line 331: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');

327: , p_lock_flag => 'Y'
328: , p_lpn_id_table => l_lpn_tbl );
329:
330: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
331: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
332: FND_MESSAGE.SET_TOKEN('API', 'Check_Purge_LPNs');
333: FND_MSG_PUB.ADD;
334: EXIT;
335: ELSIF ( l_debug = 1 ) THEN

Line 332: FND_MESSAGE.SET_TOKEN('API', 'Check_Purge_LPNs');

328: , p_lpn_id_table => l_lpn_tbl );
329:
330: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
331: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
332: FND_MESSAGE.SET_TOKEN('API', 'Check_Purge_LPNs');
333: FND_MSG_PUB.ADD;
334: EXIT;
335: ELSIF ( l_debug = 1 ) THEN
336: inv_trx_util_pub.trace('WMS validation done first='||l_lpn_tbl.first||' last='||l_lpn_tbl.last, l_api_name, 4);

Line 357: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');

353: , x_msg_data => x_msg_data
354: , p_lpn_rec => l_wsh_lpn_rec );
355:
356: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
357: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
358: FND_MESSAGE.SET_TOKEN('API', 'WSH_WMS_LPN_GRP.Check_purge');
359: FND_MSG_PUB.ADD;
360: EXIT;
361: ELSIF ( l_debug = 1 ) THEN

Line 358: FND_MESSAGE.SET_TOKEN('API', 'WSH_WMS_LPN_GRP.Check_purge');

354: , p_lpn_rec => l_wsh_lpn_rec );
355:
356: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
357: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
358: FND_MESSAGE.SET_TOKEN('API', 'WSH_WMS_LPN_GRP.Check_purge');
359: FND_MSG_PUB.ADD;
360: EXIT;
361: ELSIF ( l_debug = 1 ) THEN
362: inv_trx_util_pub.trace('WSH validation done first='||l_wsh_lpn_rec.lpn_ids.first||' last='||l_wsh_lpn_rec.lpn_ids.last, l_api_name, 4);

Line 392: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');

388: , p_purge_count => l_purge_count );
389:
390: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
391: l_purge_count := l_tmp_purge_count;
392: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
393: FND_MESSAGE.SET_TOKEN('API', 'Purge_LPNs');
394: FND_MSG_PUB.ADD;
395: EXIT;
396: END IF;

Line 393: FND_MESSAGE.SET_TOKEN('API', 'Purge_LPNs');

389:
390: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
391: l_purge_count := l_tmp_purge_count;
392: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
393: FND_MESSAGE.SET_TOKEN('API', 'Purge_LPNs');
394: FND_MSG_PUB.ADD;
395: EXIT;
396: END IF;
397: END IF;

Line 402: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

398: END LOOP;
399:
400: CLOSE LPNS_FOR_PURGE;
401:
402: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
403: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(1));
404: FND_MESSAGE.SET_TOKEN('TABLE','WMS_PACKAGING_HIST');
405: FND_MSG_PUB.ADD;
406:

Line 403: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(1));

399:
400: CLOSE LPNS_FOR_PURGE;
401:
402: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
403: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(1));
404: FND_MESSAGE.SET_TOKEN('TABLE','WMS_PACKAGING_HIST');
405: FND_MSG_PUB.ADD;
406:
407: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

Line 404: FND_MESSAGE.SET_TOKEN('TABLE','WMS_PACKAGING_HIST');

400: CLOSE LPNS_FOR_PURGE;
401:
402: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
403: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(1));
404: FND_MESSAGE.SET_TOKEN('TABLE','WMS_PACKAGING_HIST');
405: FND_MSG_PUB.ADD;
406:
407: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
408: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(2));

Line 407: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

403: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(1));
404: FND_MESSAGE.SET_TOKEN('TABLE','WMS_PACKAGING_HIST');
405: FND_MSG_PUB.ADD;
406:
407: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
408: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(2));
409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');
410: FND_MSG_PUB.ADD;
411:

Line 408: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(2));

404: FND_MESSAGE.SET_TOKEN('TABLE','WMS_PACKAGING_HIST');
405: FND_MSG_PUB.ADD;
406:
407: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
408: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(2));
409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');
410: FND_MSG_PUB.ADD;
411:
412: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

Line 409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');

405: FND_MSG_PUB.ADD;
406:
407: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
408: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(2));
409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');
410: FND_MSG_PUB.ADD;
411:
412: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
413: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(3));

Line 412: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

408: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(2));
409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');
410: FND_MSG_PUB.ADD;
411:
412: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
413: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(3));
414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');
415: FND_MSG_PUB.ADD;
416:

Line 413: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(3));

409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');
410: FND_MSG_PUB.ADD;
411:
412: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
413: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(3));
414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');
415: FND_MSG_PUB.ADD;
416:
417: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

Line 414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');

410: FND_MSG_PUB.ADD;
411:
412: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
413: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(3));
414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');
415: FND_MSG_PUB.ADD;
416:
417: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
418: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(4));

Line 417: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

413: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(3));
414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');
415: FND_MSG_PUB.ADD;
416:
417: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
418: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(4));
419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');
420: FND_MSG_PUB.ADD;
421:

Line 418: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(4));

414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');
415: FND_MSG_PUB.ADD;
416:
417: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
418: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(4));
419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');
420: FND_MSG_PUB.ADD;
421:
422: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

Line 419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');

415: FND_MSG_PUB.ADD;
416:
417: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
418: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(4));
419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');
420: FND_MSG_PUB.ADD;
421:
422: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
423: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(5));

Line 422: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

418: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(4));
419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');
420: FND_MSG_PUB.ADD;
421:
422: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
423: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(5));
424: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');
425: FND_MSG_PUB.ADD;
426:

Line 423: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(5));

419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');
420: FND_MSG_PUB.ADD;
421:
422: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
423: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(5));
424: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');
425: FND_MSG_PUB.ADD;
426:
427: END IF; --Added bug#4415994

Line 424: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');

420: FND_MSG_PUB.ADD;
421:
422: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
423: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(5));
424: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');
425: FND_MSG_PUB.ADD;
426:
427: END IF; --Added bug#4415994
428: IF ( p_purge_type = TASK OR p_purge_type IS NULL ) THEN

Line 432: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

428: IF ( p_purge_type = TASK OR p_purge_type IS NULL ) THEN
429:
430: delete from wms_dispatched_tasks_history
431: where last_update_date < l_date and organization_id = p_orgid ;
432: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
433: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
434: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DISPATCHED_TASKS_HISTORY');
435: FND_MSG_PUB.ADD;
436:

Line 433: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);

429:
430: delete from wms_dispatched_tasks_history
431: where last_update_date < l_date and organization_id = p_orgid ;
432: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
433: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
434: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DISPATCHED_TASKS_HISTORY');
435: FND_MSG_PUB.ADD;
436:
437: delete from wms_exceptions

Line 434: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DISPATCHED_TASKS_HISTORY');

430: delete from wms_dispatched_tasks_history
431: where last_update_date < l_date and organization_id = p_orgid ;
432: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
433: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
434: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DISPATCHED_TASKS_HISTORY');
435: FND_MSG_PUB.ADD;
436:
437: delete from wms_exceptions
438: where creation_date < l_date and organization_id = p_orgid ;

Line 439: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

435: FND_MSG_PUB.ADD;
436:
437: delete from wms_exceptions
438: where creation_date < l_date and organization_id = p_orgid ;
439: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
440: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
441: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EXCEPTIONS');
442: FND_MSG_PUB.ADD;
443: END IF; --Added bug#4415994

Line 440: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);

436:
437: delete from wms_exceptions
438: where creation_date < l_date and organization_id = p_orgid ;
439: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
440: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
441: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EXCEPTIONS');
442: FND_MSG_PUB.ADD;
443: END IF; --Added bug#4415994
444: IF ( p_purge_type = LABEL OR p_purge_type IS NULL ) THEN

Line 441: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EXCEPTIONS');

437: delete from wms_exceptions
438: where creation_date < l_date and organization_id = p_orgid ;
439: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
440: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
441: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EXCEPTIONS');
442: FND_MSG_PUB.ADD;
443: END IF; --Added bug#4415994
444: IF ( p_purge_type = LABEL OR p_purge_type IS NULL ) THEN
445:

Line 448: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

444: IF ( p_purge_type = LABEL OR p_purge_type IS NULL ) THEN
445:
446: delete WMS_LABEL_REQUESTS_HIST
447: where creation_date < l_date and organization_id = p_orgid;
448: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
449: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
450: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LABEL_REQUESTS_HIST');
451: FND_MSG_PUB.ADD;
452:

Line 449: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);

445:
446: delete WMS_LABEL_REQUESTS_HIST
447: where creation_date < l_date and organization_id = p_orgid;
448: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
449: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
450: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LABEL_REQUESTS_HIST');
451: FND_MSG_PUB.ADD;
452:
453: END IF;

Line 450: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LABEL_REQUESTS_HIST');

446: delete WMS_LABEL_REQUESTS_HIST
447: where creation_date < l_date and organization_id = p_orgid;
448: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
449: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
450: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LABEL_REQUESTS_HIST');
451: FND_MSG_PUB.ADD;
452:
453: END IF;
454:

Line 469: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

465: AND msn.serial_number = we.serial_number
466: AND we.cross_ref_type = 2 --Serial-EPC
467: AND msn.current_status = 4 ); --Issue out of store
468:
469: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
470: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
471: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');
472: FND_MSG_PUB.ADD;
473:

Line 470: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);

466: AND we.cross_ref_type = 2 --Serial-EPC
467: AND msn.current_status = 4 ); --Issue out of store
468:
469: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
470: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
471: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');
472: FND_MSG_PUB.ADD;
473:
474: END IF;

Line 471: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');

467: AND msn.current_status = 4 ); --Issue out of store
468:
469: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
470: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
471: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');
472: FND_MSG_PUB.ADD;
473:
474: END IF;
475: