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

Line 337: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_DEVICE_LOCS');

333: , p_indent NUMBER
334: ) IS
335: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_RES_DEVICE_FEEDS';
336: BEGIN
337: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_DEVICE_LOCS');
338: fnd_message.set_token('DEVICE_TAG', p_device_tag);
339: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
340:
341: DELETE csf_gps_location_feeds

Line 338: fnd_message.set_token('DEVICE_TAG', p_device_tag);

334: ) IS
335: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_RES_DEVICE_FEEDS';
336: BEGIN
337: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_DEVICE_LOCS');
338: fnd_message.set_token('DEVICE_TAG', p_device_tag);
339: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
340:
341: DELETE csf_gps_location_feeds
342: WHERE device_id = p_device_id

Line 339: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);

335: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_RES_DEVICE_FEEDS';
336: BEGIN
337: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_DEVICE_LOCS');
338: fnd_message.set_token('DEVICE_TAG', p_device_tag);
339: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
340:
341: DELETE csf_gps_location_feeds
342: WHERE device_id = p_device_id
343: AND creation_date BETWEEN p_start_date AND p_end_date;

Line 345: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');

341: DELETE csf_gps_location_feeds
342: WHERE device_id = p_device_id
343: AND creation_date BETWEEN p_start_date AND p_end_date;
344: g_counter := g_counter + SQL%ROWCOUNT;
345: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
346: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
347: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent + 4);
348: END purge_res_device_feeds;
349:

Line 346: fnd_message.set_token('COUNT', SQL%ROWCOUNT);

342: WHERE device_id = p_device_id
343: AND creation_date BETWEEN p_start_date AND p_end_date;
344: g_counter := g_counter + SQL%ROWCOUNT;
345: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
346: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
347: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent + 4);
348: END purge_res_device_feeds;
349:
350: PROCEDURE purge_res_location_feeds(

Line 347: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent + 4);

343: AND creation_date BETWEEN p_start_date AND p_end_date;
344: g_counter := g_counter + SQL%ROWCOUNT;
345: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
346: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
347: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent + 4);
348: END purge_res_device_feeds;
349:
350: PROCEDURE purge_res_location_feeds(
351: p_resource_id NUMBER

Line 362: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_RES_LOCS');

358: l_res_info csf_resource_pub.resource_rec_type;
359: BEGIN
360: l_res_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
361:
362: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_RES_LOCS');
363: fnd_message.set_token('RESOURCE', l_res_info.resource_name || '(' || csf_resource_pub.get_resource_type_name(l_res_info.resource_type) || ', ' || l_res_info.resource_number || ')');
364: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
365:
366: DELETE csf_gps_location_feeds

Line 363: fnd_message.set_token('RESOURCE', l_res_info.resource_name || '(' || csf_resource_pub.get_resource_type_name(l_res_info.resource_type) || ', ' || l_res_info.resource_number || ')');

359: BEGIN
360: l_res_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
361:
362: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_RES_LOCS');
363: fnd_message.set_token('RESOURCE', l_res_info.resource_name || '(' || csf_resource_pub.get_resource_type_name(l_res_info.resource_type) || ', ' || l_res_info.resource_number || ')');
364: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
365:
366: DELETE csf_gps_location_feeds
367: WHERE device_id IN (

Line 364: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);

360: l_res_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
361:
362: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_RES_LOCS');
363: fnd_message.set_token('RESOURCE', l_res_info.resource_name || '(' || csf_resource_pub.get_resource_type_name(l_res_info.resource_type) || ', ' || l_res_info.resource_number || ')');
364: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
365:
366: DELETE csf_gps_location_feeds
367: WHERE device_id IN (
368: SELECT device_id

Line 377: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');

373: AND NVL(end_date_active, SYSDATE) > p_start_date
374: )
375: AND creation_date BETWEEN p_start_date AND p_end_date;
376: g_counter := g_counter + SQL%ROWCOUNT;
377: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
378: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
379: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent + 4);
380: END purge_res_location_feeds;
381:

Line 378: fnd_message.set_token('COUNT', SQL%ROWCOUNT);

374: )
375: AND creation_date BETWEEN p_start_date AND p_end_date;
376: g_counter := g_counter + SQL%ROWCOUNT;
377: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
378: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
379: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent + 4);
380: END purge_res_location_feeds;
381:
382: PROCEDURE purge_location_feeds(

Line 379: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent + 4);

375: AND creation_date BETWEEN p_start_date AND p_end_date;
376: g_counter := g_counter + SQL%ROWCOUNT;
377: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
378: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
379: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent + 4);
380: END purge_res_location_feeds;
381:
382: PROCEDURE purge_location_feeds(
383: errbuf OUT NOCOPY VARCHAR2

Line 417: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_CP_STARTED');

413:
414: l_datetime_format fnd_profile_option_values.profile_option_value%TYPE;
415:
416: BEGIN
417: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_CP_STARTED');
418: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
419:
420: IF p_num_days IS NULL THEN
421: IF p_start_date IS NOT NULL THEN

Line 418: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);

414: l_datetime_format fnd_profile_option_values.profile_option_value%TYPE;
415:
416: BEGIN
417: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_CP_STARTED');
418: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
419:
420: IF p_num_days IS NULL THEN
421: IF p_start_date IS NOT NULL THEN
422: l_start_date := fnd_date.canonical_to_date(p_start_date);

Line 443: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DATE_RANGE');

439: l_datetime_format := 'DD-MM-YYYY HH24:MI';
440: ELSE
441: l_datetime_format := l_datetime_format || ' HH24:MI';
442: END IF;
443: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DATE_RANGE');
444: fnd_message.set_token('START_DATE', to_char(l_start_date, l_datetime_format));
445: fnd_message.set_token('END_DATE', to_char(l_end_date, l_datetime_format));
446: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
447:

Line 444: fnd_message.set_token('START_DATE', to_char(l_start_date, l_datetime_format));

440: ELSE
441: l_datetime_format := l_datetime_format || ' HH24:MI';
442: END IF;
443: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DATE_RANGE');
444: fnd_message.set_token('START_DATE', to_char(l_start_date, l_datetime_format));
445: fnd_message.set_token('END_DATE', to_char(l_end_date, l_datetime_format));
446: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
447:
448: SAVEPOINT csf_gps_loc_purge;

Line 445: fnd_message.set_token('END_DATE', to_char(l_end_date, l_datetime_format));

441: l_datetime_format := l_datetime_format || ' HH24:MI';
442: END IF;
443: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DATE_RANGE');
444: fnd_message.set_token('START_DATE', to_char(l_start_date, l_datetime_format));
445: fnd_message.set_token('END_DATE', to_char(l_end_date, l_datetime_format));
446: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
447:
448: SAVEPOINT csf_gps_loc_purge;
449:

Line 446: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);

442: END IF;
443: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DATE_RANGE');
444: fnd_message.set_token('START_DATE', to_char(l_start_date, l_datetime_format));
445: fnd_message.set_token('END_DATE', to_char(l_end_date, l_datetime_format));
446: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
447:
448: SAVEPOINT csf_gps_loc_purge;
449:
450: IF p_vendor_id IS NOT NULL THEN

Line 454: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_VENDOR_LOCS');

450: IF p_vendor_id IS NOT NULL THEN
451: --
452: -- Purging the Locations of all the Devices attached to the Vendor
453: --
454: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_VENDOR_LOCS');
455: fnd_message.set_token('VENDOR', get_vendor_name(p_vendor_id));
456: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
457:
458: FOR v_device IN c_vendor_devices(p_vendor_id) LOOP

Line 455: fnd_message.set_token('VENDOR', get_vendor_name(p_vendor_id));

451: --
452: -- Purging the Locations of all the Devices attached to the Vendor
453: --
454: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_VENDOR_LOCS');
455: fnd_message.set_token('VENDOR', get_vendor_name(p_vendor_id));
456: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
457:
458: FOR v_device IN c_vendor_devices(p_vendor_id) LOOP
459: purge_res_device_feeds(v_device.device_id, v_device.device_tag, l_start_date, l_end_date, 4);

Line 456: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);

452: -- Purging the Locations of all the Devices attached to the Vendor
453: --
454: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_VENDOR_LOCS');
455: fnd_message.set_token('VENDOR', get_vendor_name(p_vendor_id));
456: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
457:
458: FOR v_device IN c_vendor_devices(p_vendor_id) LOOP
459: purge_res_device_feeds(v_device.device_id, v_device.device_tag, l_start_date, l_end_date, 4);
460: END LOOP;

Line 470: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_ASSIGN_LOCS');

466: ELSIF p_device_assignment_id IS NOT NULL THEN
467: --
468: -- Purging the Locations of the Device Assignment
469: --
470: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_ASSIGN_LOCS');
471: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
472:
473: DELETE csf_gps_location_feeds
474: WHERE device_id IN (

Line 471: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);

467: --
468: -- Purging the Locations of the Device Assignment
469: --
470: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_ASSIGN_LOCS');
471: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
472:
473: DELETE csf_gps_location_feeds
474: WHERE device_id IN (
475: SELECT device_id

Line 483: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');

479: AND NVL(end_date_active, SYSDATE) > l_start_date
480: )
481: AND creation_date BETWEEN l_start_date AND l_end_date;
482: g_counter := g_counter + SQL%ROWCOUNT;
483: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
484: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
485: debug(fnd_message.get, l_api_name, g_level_cp_output, 4);
486: ELSIF p_resource_id IS NOT NULL THEN
487: purge_res_location_feeds(p_resource_id, p_resource_type, l_start_date, l_end_date, 0);

Line 484: fnd_message.set_token('COUNT', SQL%ROWCOUNT);

480: )
481: AND creation_date BETWEEN l_start_date AND l_end_date;
482: g_counter := g_counter + SQL%ROWCOUNT;
483: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
484: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
485: debug(fnd_message.get, l_api_name, g_level_cp_output, 4);
486: ELSIF p_resource_id IS NOT NULL THEN
487: purge_res_location_feeds(p_resource_id, p_resource_type, l_start_date, l_end_date, 0);
488: ELSIF p_territory_id IS NOT NULL THEN

Line 485: debug(fnd_message.get, l_api_name, g_level_cp_output, 4);

481: AND creation_date BETWEEN l_start_date AND l_end_date;
482: g_counter := g_counter + SQL%ROWCOUNT;
483: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');
484: fnd_message.set_token('COUNT', SQL%ROWCOUNT);
485: debug(fnd_message.get, l_api_name, g_level_cp_output, 4);
486: ELSIF p_resource_id IS NOT NULL THEN
487: purge_res_location_feeds(p_resource_id, p_resource_type, l_start_date, l_end_date, 0);
488: ELSIF p_territory_id IS NOT NULL THEN
489: FOR v_res IN c_territory_resources LOOP

Line 494: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_VENDOR_LOCS');

490: purge_res_location_feeds(v_res.resource_id, v_res.resource_type, l_start_date, l_end_date, 4);
491: END LOOP;
492: ELSE
493: FOR v_vendor IN c_vendors LOOP
494: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_VENDOR_LOCS');
495: fnd_message.set_token('VENDOR', v_vendor.vendor_name);
496: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
497:
498: FOR v_device IN c_vendor_devices(v_vendor.vendor_id) LOOP

Line 495: fnd_message.set_token('VENDOR', v_vendor.vendor_name);

491: END LOOP;
492: ELSE
493: FOR v_vendor IN c_vendors LOOP
494: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_VENDOR_LOCS');
495: fnd_message.set_token('VENDOR', v_vendor.vendor_name);
496: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
497:
498: FOR v_device IN c_vendor_devices(v_vendor.vendor_id) LOOP
499: purge_res_device_feeds(v_device.device_id, v_device.device_tag, l_start_date, l_end_date, 4);

Line 496: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);

492: ELSE
493: FOR v_vendor IN c_vendors LOOP
494: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_VENDOR_LOCS');
495: fnd_message.set_token('VENDOR', v_vendor.vendor_name);
496: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
497:
498: FOR v_device IN c_vendor_devices(v_vendor.vendor_id) LOOP
499: purge_res_device_feeds(v_device.device_id, v_device.device_tag, l_start_date, l_end_date, 4);
500: END LOOP;

Line 504: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_CP_COMPLETED');

500: END LOOP;
501: END LOOP;
502: END IF;
503:
504: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_CP_COMPLETED');
505: fnd_message.set_token('COUNT', g_counter);
506: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
507:
508: COMMIT;

Line 505: fnd_message.set_token('COUNT', g_counter);

501: END LOOP;
502: END IF;
503:
504: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_CP_COMPLETED');
505: fnd_message.set_token('COUNT', g_counter);
506: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
507:
508: COMMIT;
509: g_counter := 0;

Line 506: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);

502: END IF;
503:
504: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_CP_COMPLETED');
505: fnd_message.set_token('COUNT', g_counter);
506: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
507:
508: COMMIT;
509: g_counter := 0;
510: retcode := 0;

Line 511: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');

507:
508: COMMIT;
509: g_counter := 0;
510: retcode := 0;
511: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
512: errbuf := fnd_message.get;
513: EXCEPTION
514: WHEN OTHERS THEN
515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 512: errbuf := fnd_message.get;

508: COMMIT;
509: g_counter := 0;
510: retcode := 0;
511: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
512: errbuf := fnd_message.get;
513: EXCEPTION
514: WHEN OTHERS THEN
515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
516: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 521: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');

517: END IF;
518:
519: retcode := 2;
520: g_counter := 0;
521: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
522: errbuf := fnd_message.get;
523: ROLLBACK TO csf_gps_loc_purge;
524: END purge_location_feeds;
525:

Line 522: errbuf := fnd_message.get;

518:
519: retcode := 2;
520: g_counter := 0;
521: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
522: errbuf := fnd_message.get;
523: ROLLBACK TO csf_gps_loc_purge;
524: END purge_location_feeds;
525:
526: PROCEDURE add_language IS