DBA Data[Home] [Help]

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 507: fnd_message.set_name('SQLAP', 'OIE_LOCATION_NOT_FOUND');

503: return null;
504:
505: EXCEPTION
506: when others then
507: fnd_message.set_name('SQLAP', 'OIE_LOCATION_NOT_FOUND');
508: fnd_message.set_token('LOCATION', p_location);
509: fnd_message.set_token('TYPE', p_location_type);
510: APP_EXCEPTION.RAISE_EXCEPTION;
511:

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

504:
505: EXCEPTION
506: when others then
507: fnd_message.set_name('SQLAP', 'OIE_LOCATION_NOT_FOUND');
508: fnd_message.set_token('LOCATION', p_location);
509: fnd_message.set_token('TYPE', p_location_type);
510: APP_EXCEPTION.RAISE_EXCEPTION;
511:
512: END GetLocation;

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

505: EXCEPTION
506: when others then
507: fnd_message.set_name('SQLAP', 'OIE_LOCATION_NOT_FOUND');
508: fnd_message.set_token('LOCATION', p_location);
509: fnd_message.set_token('TYPE', p_location_type);
510: APP_EXCEPTION.RAISE_EXCEPTION;
511:
512: END GetLocation;
513:

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

543:
544: if (undefined_conus_rec.location_id is not null) then
545: return undefined_conus_rec.location_id;
546: else
547: --FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER_US');
548: --return CreateLocation(p_location => FND_MESSAGE.GET,
549: return CreateLocation(p_location => 'All Other United States',
550: p_location_type => 'CITY',
551: p_city_locality_id => l_city_locality_id,

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

544: if (undefined_conus_rec.location_id is not null) then
545: return undefined_conus_rec.location_id;
546: else
547: --FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER_US');
548: --return CreateLocation(p_location => FND_MESSAGE.GET,
549: return CreateLocation(p_location => 'All Other United States',
550: p_location_type => 'CITY',
551: p_city_locality_id => l_city_locality_id,
552: p_county_id => null,

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

559: return null;
560:
561: EXCEPTION
562: when others then
563: fnd_message.set_name('SQLAP', 'OIE_UNDEFINED_CONUS_NOT_FOUND');
564: APP_EXCEPTION.RAISE_EXCEPTION;
565:
566: END GetUndefinedCONUS;
567:

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

587:
588: if (undefined_rec.location_id is not null) then
589: return undefined_rec.location_id;
590: else
591: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER');
592: return CreateLocation(p_location => FND_MESSAGE.GET,
593: p_location_type => 'CITY',
594: p_city_locality_id => null,
595: p_county_id => null,

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

588: if (undefined_rec.location_id is not null) then
589: return undefined_rec.location_id;
590: else
591: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_ALL_OTHER');
592: return CreateLocation(p_location => FND_MESSAGE.GET,
593: p_location_type => 'CITY',
594: p_city_locality_id => null,
595: p_county_id => null,
596: p_state_province_id => null,

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

602: return null;
603:
604: EXCEPTION
605: when others then
606: fnd_message.set_name('SQLAP', 'OIE_UNDEFINED_LOCATION_NOT_FOUND');
607: APP_EXCEPTION.RAISE_EXCEPTION;
608:
609: END GetUndefinedLocation;
610:

Line 3634: errbuf := fnd_message.get;

3630: put_line('Request Id to load CONUS: '||l_request_id);
3631: --
3632:
3633: if (l_request_id = 0) then
3634: errbuf := fnd_message.get;
3635: retcode := 2;
3636:
3637: else
3638:

Line 3710: errbuf := fnd_message.get;

3706: end if; /* nvl(retcode, 0) <> 2 */
3707:
3708: EXCEPTION
3709: WHEN OTHERS THEN
3710: errbuf := fnd_message.get;
3711: retcode := 2;
3712: END UploadCONUS;
3713:
3714:

Line 3757: errbuf := fnd_message.get;

3753: put_line('Request Id to load OCONUS: '||l_request_id);
3754: --
3755:
3756: if (l_request_id = 0) then
3757: errbuf := fnd_message.get;
3758: retcode := 2;
3759:
3760: else
3761:

Line 3833: errbuf := fnd_message.get;

3829: end if; /* nvl(retcode, 0) <> 2 */
3830:
3831: EXCEPTION
3832: WHEN OTHERS THEN
3833: errbuf := fnd_message.get;
3834: retcode := 2;
3835: END UploadOCONUS;
3836:
3837:

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

3990: EXCEPTION
3991: WHEN l_invalid_format THEN
3992: --utl_file.fclose_all;
3993: utl_file.fclose(l_datafileptr);
3994: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_FORMAT');
3995: errbuf := fnd_message.get;
3996: retcode := 2;
3997: WHEN l_invalid_rate_type THEN
3998: --utl_file.fclose_all;

Line 3995: errbuf := fnd_message.get;

3991: WHEN l_invalid_format THEN
3992: --utl_file.fclose_all;
3993: utl_file.fclose(l_datafileptr);
3994: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_FORMAT');
3995: errbuf := fnd_message.get;
3996: retcode := 2;
3997: WHEN l_invalid_rate_type THEN
3998: --utl_file.fclose_all;
3999: utl_file.fclose(l_datafileptr);

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

3996: retcode := 2;
3997: WHEN l_invalid_rate_type THEN
3998: --utl_file.fclose_all;
3999: utl_file.fclose(l_datafileptr);
4000: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_RATE_TYPE');
4001: errbuf := fnd_message.get;
4002: retcode := 2;
4003: WHEN OTHERS THEN
4004: --utl_file.fclose_all;

Line 4001: errbuf := fnd_message.get;

3997: WHEN l_invalid_rate_type THEN
3998: --utl_file.fclose_all;
3999: utl_file.fclose(l_datafileptr);
4000: fnd_message.set_name('SQLAP', 'OIE_APWUPDM_INVALID_RATE_TYPE');
4001: errbuf := fnd_message.get;
4002: retcode := 2;
4003: WHEN OTHERS THEN
4004: --utl_file.fclose_all;
4005: utl_file.fclose(l_datafileptr);

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

4002: retcode := 2;
4003: WHEN OTHERS THEN
4004: --utl_file.fclose_all;
4005: utl_file.fclose(l_datafileptr);
4006: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
4007: fnd_message.set_token('PATH', l_datafilepath);
4008: fnd_message.set_token('FILE', l_datafile);
4009: errbuf := fnd_message.get;
4010: retcode := 2;

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

4003: WHEN OTHERS THEN
4004: --utl_file.fclose_all;
4005: utl_file.fclose(l_datafileptr);
4006: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
4007: fnd_message.set_token('PATH', l_datafilepath);
4008: fnd_message.set_token('FILE', l_datafile);
4009: errbuf := fnd_message.get;
4010: retcode := 2;
4011:

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

4004: --utl_file.fclose_all;
4005: utl_file.fclose(l_datafileptr);
4006: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
4007: fnd_message.set_token('PATH', l_datafilepath);
4008: fnd_message.set_token('FILE', l_datafile);
4009: errbuf := fnd_message.get;
4010: retcode := 2;
4011:
4012: END ValidateFileFormat;

Line 4009: errbuf := fnd_message.get;

4005: utl_file.fclose(l_datafileptr);
4006: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
4007: fnd_message.set_token('PATH', l_datafilepath);
4008: fnd_message.set_token('FILE', l_datafile);
4009: errbuf := fnd_message.get;
4010: retcode := 2;
4011:
4012: END ValidateFileFormat;
4013: