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_MSG_PUB

Line 45: fnd_msg_pub.ADD;

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:
49: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 51: fnd_msg_pub.initialize;

47: END IF;
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF fnd_api.to_boolean(p_init_msg_list) THEN
51: fnd_msg_pub.initialize;
52: END IF;
53:
54: -- Initialize API return status to success
55: x_return_status := fnd_api.g_ret_sts_success;

Line 95: fnd_msg_pub.ADD;

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';
99: p_lpn_id_table := l_valid_lpns;

Line 111: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

107: ROLLBACK TO Check_Purge_LPN_PVT;
108: END IF;
109:
110: -- Standard call to get message count and data
111: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
112: EXCEPTION
113: WHEN OTHERS THEN
114: x_return_status := fnd_api.g_ret_sts_unexp_error;
115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

111: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
112: EXCEPTION
113: WHEN OTHERS THEN
114: x_return_status := fnd_api.g_ret_sts_unexp_error;
115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
116: IF (l_debug = 1) THEN
117: inv_trx_util_pub.trace(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), l_api_name, 1);
118: END IF;
119: ROLLBACK TO Check_Purge_LPN_PVT;

Line 150: fnd_msg_pub.ADD;

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:
154: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 156: fnd_msg_pub.initialize;

152: END IF;
153:
154: -- Initialize message list if p_init_msg_list is set to TRUE.
155: IF fnd_api.to_boolean(p_init_msg_list) THEN
156: fnd_msg_pub.initialize;
157: END IF;
158:
159: -- Initialize API return status to success
160: x_return_status := fnd_api.g_ret_sts_success;

Line 226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

222:
223: EXCEPTION
224: WHEN OTHERS THEN
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
227: IF (l_debug = 1) THEN
228: inv_trx_util_pub.trace(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), l_api_name, 1);
229: END IF;
230: ROLLBACK TO PURGE_LPNS_PVT;

Line 279: FND_MSG_PUB.DELETE_msg;

275: ELSIF ( p_purge_age IS NOT NULL AND p_purge_date IS NOT NULL ) THEN
276: l_date := least(FND_DATE.canonical_to_date(p_purge_date),trunc(sysdate)-p_purge_age);
277: END IF;
278:
279: FND_MSG_PUB.DELETE_msg;
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;

Line 287: FND_MSG_PUB.ADD;

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
291: l_purge_count(1) := 0; -- WMS_PACKAGING_HIST

Line 333: FND_MSG_PUB.ADD;

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);
337: END IF;

Line 359: FND_MSG_PUB.ADD;

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);
363: END IF;

Line 394: FND_MSG_PUB.ADD;

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;
398: END LOOP;

Line 405: FND_MSG_PUB.ADD;

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));
409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');

Line 410: 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));
414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');

Line 415: 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));
419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');

Line 420: 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));
424: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EPC');

Line 425: 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
429:

Line 435: FND_MSG_PUB.ADD;

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 ;
439: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');

Line 442: FND_MSG_PUB.ADD;

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:
446: delete WMS_LABEL_REQUESTS_HIST

Line 451: FND_MSG_PUB.ADD;

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:
455: IF ( p_purge_type = EPC OR p_purge_type IS NULL ) THEN

Line 472: FND_MSG_PUB.ADD;

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:
476:

Line 500: FND_MSG_PUB.COUNT_AND_GET (

496: , NULL
497: , p_purge_name
498: , p_orgid );
499:
500: FND_MSG_PUB.COUNT_AND_GET (
501: p_count => x_msg_count
502: , p_data => x_msg_data );
503:
504: FOR i in 1..x_msg_count LOOP

Line 505: p_message := fnd_msg_pub.get(i,'F');

501: p_count => x_msg_count
502: , p_data => x_msg_data );
503:
504: FOR i in 1..x_msg_count LOOP
505: p_message := fnd_msg_pub.get(i,'F');
506: IF (l_debug = 1) THEN
507: INV_TRX_UTIL_PUB.TRACE (
508: p_mesg => p_message
509: , p_mod => p_module

Line 514: fnd_msg_pub.delete_msg;

510: , p_level => p_level );
511: END IF;
512: END LOOP;
513:
514: fnd_msg_pub.delete_msg;
515:
516: COMMIT;
517:
518: l_ret := fnd_concurrent.set_completion_status('NORMAL', 'WMS_PURGE_SUCCESS');