420: --
421: EXCEPTION
422: WHEN OTHERS THEN
423: --
424: fnd_message.set_name('PER', 'HR_289334_GET_ORDR_NUM_ERROR');
425: fnd_message.raise_error;
426: --
427: END get_next_order_number;
428: --
421: EXCEPTION
422: WHEN OTHERS THEN
423: --
424: fnd_message.set_name('PER', 'HR_289334_GET_ORDR_NUM_ERROR');
425: fnd_message.raise_error;
426: --
427: END get_next_order_number;
428: --
429: -- ----------------------------------------------------------------------------
508: IF c_item_category%NOTFOUND THEN
509: --
510: CLOSE c_item_category;
511: --
512: fnd_message.set_name('PER', 'HR_289329_ITEM_TYPE_ERROR');
513: fnd_message.raise_error;
514: --
515: END IF;
516: --
509: --
510: CLOSE c_item_category;
511: --
512: fnd_message.set_name('PER', 'HR_289329_ITEM_TYPE_ERROR');
513: fnd_message.raise_error;
514: --
515: END IF;
516: --
517: hr_utility.set_location(l_proc, 20);
545: --
546: -- There has been an error in retrieving the
547: -- column type therefore we must error
548: --
549: fnd_message.set_name('PER', 'HR_289329_ITEM_TYPE_ERROR');
550: fnd_message.raise_error;
551: --
552: END IF;
553: --
546: -- There has been an error in retrieving the
547: -- column type therefore we must error
548: --
549: fnd_message.set_name('PER', 'HR_289329_ITEM_TYPE_ERROR');
550: fnd_message.raise_error;
551: --
552: END IF;
553: --
554: END IF;
910: -- Accept an error code, log the error message, and raise the error to the
911: -- calling code.
912: --
913: -- Used for errors which should be both logged in per_cagr_log table and
914: -- raised to calling APPS code, via fnd_message.
915: --
916: BEGIN
917: --
918: fnd_message.set_name('PER',p_error);
914: -- raised to calling APPS code, via fnd_message.
915: --
916: BEGIN
917: --
918: fnd_message.set_name('PER',p_error);
919: put_log(fnd_message.get,1);
920: write_log_file(p_cagr_request_id);
921: fnd_message.raise_error;
922: --
915: --
916: BEGIN
917: --
918: fnd_message.set_name('PER',p_error);
919: put_log(fnd_message.get,1);
920: write_log_file(p_cagr_request_id);
921: fnd_message.raise_error;
922: --
923: END log_and_raise_error;
917: --
918: fnd_message.set_name('PER',p_error);
919: put_log(fnd_message.get,1);
920: write_log_file(p_cagr_request_id);
921: fnd_message.raise_error;
922: --
923: END log_and_raise_error;
924:
925: --
970: open csr_filepath;
971: fetch csr_filepath into l_filepath;
972: if csr_filepath%notfound then
973: close csr_filepath;
974: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
975: fnd_message.raise_error;
976: end if;
977: close csr_filepath;
978:
971: fetch csr_filepath into l_filepath;
972: if csr_filepath%notfound then
973: close csr_filepath;
974: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
975: fnd_message.raise_error;
976: end if;
977: close csr_filepath;
978:
979: l_name := p_cagr_request_id||'.txt';
985: -- bug 2461389, raise error if filepath is not set
986: -- we have not been able to set a path, so raise an error
987: -- path is either full value or first string before a comma
988: if l_filepath is null then
989: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
990: fnd_message.raise_error;
991: end if;
992: --
993: -- check if the file alrteady exists, else
986: -- we have not been able to set a path, so raise an error
987: -- path is either full value or first string before a comma
988: if l_filepath is null then
989: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
990: fnd_message.raise_error;
991: end if;
992: --
993: -- check if the file alrteady exists, else
994: -- attempt to open a file for write
1016: utl_file.fclose(l_fileh);
1017:
1018: exception
1019: when UTL_FILE.INVALID_PATH then
1020: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
1021: fnd_message.raise_error;
1022: when UTL_FILE.WRITE_ERROR then
1023: fnd_message.set_name('PER', 'HR_289833_CAGR_FILE_WRITE_ERR');
1024: fnd_message.raise_error;
1017:
1018: exception
1019: when UTL_FILE.INVALID_PATH then
1020: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
1021: fnd_message.raise_error;
1022: when UTL_FILE.WRITE_ERROR then
1023: fnd_message.set_name('PER', 'HR_289833_CAGR_FILE_WRITE_ERR');
1024: fnd_message.raise_error;
1025: end;
1019: when UTL_FILE.INVALID_PATH then
1020: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
1021: fnd_message.raise_error;
1022: when UTL_FILE.WRITE_ERROR then
1023: fnd_message.set_name('PER', 'HR_289833_CAGR_FILE_WRITE_ERR');
1024: fnd_message.raise_error;
1025: end;
1026:
1027: -- id the directory separator?
1020: fnd_message.set_name('PER', 'HR_289832_CAGR_NO_FILEPATH');
1021: fnd_message.raise_error;
1022: when UTL_FILE.WRITE_ERROR then
1023: fnd_message.set_name('PER', 'HR_289833_CAGR_FILE_WRITE_ERR');
1024: fnd_message.raise_error;
1025: end;
1026:
1027: -- id the directory separator?
1028: