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

Line 452: fnd_message.set_name('SQLAP', 'OIE_CREATE_LOCATION_ERROR');

448: return l_location_id;
449:
450: EXCEPTION
451: when others then
452: fnd_message.set_name('SQLAP', 'OIE_CREATE_LOCATION_ERROR');
453: fnd_message.set_token('LOCATION', p_location);
454: fnd_message.set_token('TYPE', p_location_type);
455: APP_EXCEPTION.RAISE_EXCEPTION;
456:

Line 453: fnd_message.set_token('LOCATION', p_location);

449:
450: EXCEPTION
451: when others then
452: fnd_message.set_name('SQLAP', 'OIE_CREATE_LOCATION_ERROR');
453: fnd_message.set_token('LOCATION', p_location);
454: fnd_message.set_token('TYPE', p_location_type);
455: APP_EXCEPTION.RAISE_EXCEPTION;
456:
457: END CreateLocation;

Line 454: fnd_message.set_token('TYPE', p_location_type);

450: EXCEPTION
451: when others then
452: fnd_message.set_name('SQLAP', 'OIE_CREATE_LOCATION_ERROR');
453: fnd_message.set_token('LOCATION', p_location);
454: fnd_message.set_token('TYPE', p_location_type);
455: APP_EXCEPTION.RAISE_EXCEPTION;
456:
457: END CreateLocation;
458:

Line 528: fnd_message.set_name('SQLAP', 'OIE_LOCATION_NOT_FOUND');

524: return null;
525:
526: EXCEPTION
527: when others then
528: fnd_message.set_name('SQLAP', 'OIE_LOCATION_NOT_FOUND');
529: fnd_message.set_token('LOCATION', p_location);
530: fnd_message.set_token('TYPE', p_location_type);
531: APP_EXCEPTION.RAISE_EXCEPTION;
532:

Line 529: fnd_message.set_token('LOCATION', p_location);

525:
526: EXCEPTION
527: when others then
528: fnd_message.set_name('SQLAP', 'OIE_LOCATION_NOT_FOUND');
529: fnd_message.set_token('LOCATION', p_location);
530: fnd_message.set_token('TYPE', p_location_type);
531: APP_EXCEPTION.RAISE_EXCEPTION;
532:
533: END GetLocation;

Line 530: fnd_message.set_token('TYPE', p_location_type);

526: EXCEPTION
527: when others then
528: fnd_message.set_name('SQLAP', 'OIE_LOCATION_NOT_FOUND');
529: fnd_message.set_token('LOCATION', p_location);
530: fnd_message.set_token('TYPE', p_location_type);
531: APP_EXCEPTION.RAISE_EXCEPTION;
532:
533: END GetLocation;
534:

Line 568: --FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER_US');

564:
565: if (undefined_conus_rec.location_id is not null) then
566: return undefined_conus_rec.location_id;
567: else
568: --FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER_US');
569: --return CreateLocation(p_location => FND_MESSAGE.GET,
570: return CreateLocation(p_location => 'All Other United States',
571: p_location_type => 'CITY',
572: p_city_locality_id => l_city_locality_id,

Line 569: --return CreateLocation(p_location => FND_MESSAGE.GET,

565: if (undefined_conus_rec.location_id is not null) then
566: return undefined_conus_rec.location_id;
567: else
568: --FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER_US');
569: --return CreateLocation(p_location => FND_MESSAGE.GET,
570: return CreateLocation(p_location => 'All Other United States',
571: p_location_type => 'CITY',
572: p_city_locality_id => l_city_locality_id,
573: p_county_id => null,

Line 584: fnd_message.set_name('SQLAP', 'OIE_UNDEFINED_CONUS_NOT_FOUND');

580: return null;
581:
582: EXCEPTION
583: when others then
584: fnd_message.set_name('SQLAP', 'OIE_UNDEFINED_CONUS_NOT_FOUND');
585: APP_EXCEPTION.RAISE_EXCEPTION;
586:
587: END GetUndefinedCONUS;
588:

Line 612: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER');

608:
609: if (undefined_rec.location_id is not null) then
610: return undefined_rec.location_id;
611: else
612: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER');
613: return CreateLocation(p_location => FND_MESSAGE.GET,
614: p_location_type => 'CITY',
615: p_city_locality_id => null,
616: p_county_id => null,

Line 613: return CreateLocation(p_location => FND_MESSAGE.GET,

609: if (undefined_rec.location_id is not null) then
610: return undefined_rec.location_id;
611: else
612: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER');
613: return CreateLocation(p_location => FND_MESSAGE.GET,
614: p_location_type => 'CITY',
615: p_city_locality_id => null,
616: p_county_id => null,
617: p_state_province_id => null,

Line 627: fnd_message.set_name('SQLAP', 'OIE_UNDEFINED_LOCATION_NOT_FOUND');

623: return null;
624:
625: EXCEPTION
626: when others then
627: fnd_message.set_name('SQLAP', 'OIE_UNDEFINED_LOCATION_NOT_FOUND');
628: APP_EXCEPTION.RAISE_EXCEPTION;
629:
630: END GetUndefinedLocation;
631:

Line 3671: errbuf := fnd_message.get;

3667: put_line('Request Id to load CONUS: '||l_request_id);
3668: --
3669:
3670: if (l_request_id = 0) then
3671: errbuf := fnd_message.get;
3672: retcode := 2;
3673:
3674: else
3675:

Line 3747: errbuf := fnd_message.get;

3743: end if; /* nvl(retcode, 0) <> 2 */
3744:
3745: EXCEPTION
3746: WHEN OTHERS THEN
3747: errbuf := fnd_message.get;
3748: retcode := 2;
3749: END UploadCONUS;
3750:
3751:

Line 3794: errbuf := fnd_message.get;

3790: put_line('Request Id to load OCONUS: '||l_request_id);
3791: --
3792:
3793: if (l_request_id = 0) then
3794: errbuf := fnd_message.get;
3795: retcode := 2;
3796:
3797: else
3798:

Line 3870: errbuf := fnd_message.get;

3866: end if; /* nvl(retcode, 0) <> 2 */
3867:
3868: EXCEPTION
3869: WHEN OTHERS THEN
3870: errbuf := fnd_message.get;
3871: retcode := 2;
3872: END UploadOCONUS;
3873:
3874:

Line 4031: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_FORMAT');

4027: EXCEPTION
4028: WHEN l_invalid_format THEN
4029: --utl_file.fclose_all;
4030: utl_file.fclose(l_datafileptr);
4031: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_FORMAT');
4032: errbuf := fnd_message.get;
4033: retcode := 2;
4034: WHEN l_invalid_rate_type THEN
4035: --utl_file.fclose_all;

Line 4032: errbuf := fnd_message.get;

4028: WHEN l_invalid_format THEN
4029: --utl_file.fclose_all;
4030: utl_file.fclose(l_datafileptr);
4031: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_FORMAT');
4032: errbuf := fnd_message.get;
4033: retcode := 2;
4034: WHEN l_invalid_rate_type THEN
4035: --utl_file.fclose_all;
4036: utl_file.fclose(l_datafileptr);

Line 4037: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_RATE_TYPE');

4033: retcode := 2;
4034: WHEN l_invalid_rate_type THEN
4035: --utl_file.fclose_all;
4036: utl_file.fclose(l_datafileptr);
4037: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_RATE_TYPE');
4038: errbuf := fnd_message.get;
4039: retcode := 2;
4040: WHEN OTHERS THEN
4041: --utl_file.fclose_all;

Line 4038: errbuf := fnd_message.get;

4034: WHEN l_invalid_rate_type THEN
4035: --utl_file.fclose_all;
4036: utl_file.fclose(l_datafileptr);
4037: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_RATE_TYPE');
4038: errbuf := fnd_message.get;
4039: retcode := 2;
4040: WHEN OTHERS THEN
4041: --utl_file.fclose_all;
4042: utl_file.fclose(l_datafileptr);

Line 4043: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');

4039: retcode := 2;
4040: WHEN OTHERS THEN
4041: --utl_file.fclose_all;
4042: utl_file.fclose(l_datafileptr);
4043: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
4044: fnd_message.set_token('PATH', l_datafilepath);
4045: fnd_message.set_token('FILE', l_datafile);
4046: errbuf := fnd_message.get;
4047: retcode := 2;

Line 4044: fnd_message.set_token('PATH', l_datafilepath);

4040: WHEN OTHERS THEN
4041: --utl_file.fclose_all;
4042: utl_file.fclose(l_datafileptr);
4043: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
4044: fnd_message.set_token('PATH', l_datafilepath);
4045: fnd_message.set_token('FILE', l_datafile);
4046: errbuf := fnd_message.get;
4047: retcode := 2;
4048:

Line 4045: fnd_message.set_token('FILE', l_datafile);

4041: --utl_file.fclose_all;
4042: utl_file.fclose(l_datafileptr);
4043: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
4044: fnd_message.set_token('PATH', l_datafilepath);
4045: fnd_message.set_token('FILE', l_datafile);
4046: errbuf := fnd_message.get;
4047: retcode := 2;
4048:
4049: END ValidateFileFormat;

Line 4046: errbuf := fnd_message.get;

4042: utl_file.fclose(l_datafileptr);
4043: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
4044: fnd_message.set_token('PATH', l_datafilepath);
4045: fnd_message.set_token('FILE', l_datafile);
4046: errbuf := fnd_message.get;
4047: retcode := 2;
4048:
4049: END ValidateFileFormat;
4050: