DBA Data[Home] [Help]

APPS.HR_CHKFMT dependencies on HR_UTILITY

Line 1139: hr_utility.set_message(801,'HR_51159_INVAL_VALUE_FORMAT');

1135: begin
1136: rgeflg := RGE_SUCC; -- start by saying range checking succeeded.
1137: -- start by checking if the input is allowed to be null.
1138: if(nullok = 'N' and value is null) then
1139: hr_utility.set_message(801,'HR_51159_INVAL_VALUE_FORMAT');
1140: hr_utility.raise_error;
1141: end if;
1142: -- if ok to be null and value is null, then return immediately.
1143: if(nullok = 'Y' and value is null) then

Line 1140: hr_utility.raise_error;

1136: rgeflg := RGE_SUCC; -- start by saying range checking succeeded.
1137: -- start by checking if the input is allowed to be null.
1138: if(nullok = 'N' and value is null) then
1139: hr_utility.set_message(801,'HR_51159_INVAL_VALUE_FORMAT');
1140: hr_utility.raise_error;
1141: end if;
1142: -- if ok to be null and value is null, then return immediately.
1143: if(nullok = 'Y' and value is null) then
1144: output := NULL;

Line 1174: hr_utility.set_message(801,'HR_51152_INVAL_MON_FORMAT');

1170: --
1171: elsif(format = 'M' or format = 'MONEY') then
1172: chkmoney(value,output,curcode,minimum,maximum,rgeflg,result,FALSE);
1173: if(result = FALSE) then
1174: hr_utility.set_message(801,'HR_51152_INVAL_MON_FORMAT');
1175: hr_utility.raise_error;
1176: end if;
1177: elsif(format = 'I' or format = 'N' or format = 'NUMBER'
1178: or format = 'ND') then

Line 1175: hr_utility.raise_error;

1171: elsif(format = 'M' or format = 'MONEY') then
1172: chkmoney(value,output,curcode,minimum,maximum,rgeflg,result,FALSE);
1173: if(result = FALSE) then
1174: hr_utility.set_message(801,'HR_51152_INVAL_MON_FORMAT');
1175: hr_utility.raise_error;
1176: end if;
1177: elsif(format = 'I' or format = 'N' or format = 'NUMBER'
1178: or format = 'ND') then
1179: chknum(value,output,minimum,maximum,rgeflg,format,result,FALSE);

Line 1181: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');

1177: elsif(format = 'I' or format = 'N' or format = 'NUMBER'
1178: or format = 'ND') then
1179: chknum(value,output,minimum,maximum,rgeflg,format,result,FALSE);
1180: if(result = FALSE) then
1181: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');
1182: hr_utility.raise_error;
1183: end if;
1184: --output is in canonical format
1185: --output := fnd_number.number_to_canonical( to_number(value) );

Line 1182: hr_utility.raise_error;

1178: or format = 'ND') then
1179: chknum(value,output,minimum,maximum,rgeflg,format,result,FALSE);
1180: if(result = FALSE) then
1181: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');
1182: hr_utility.raise_error;
1183: end if;
1184: --output is in canonical format
1185: --output := fnd_number.number_to_canonical( to_number(value) );
1186: elsif(format = 'H_HH' or format = 'H_HHMM' or

Line 1190: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');

1186: elsif(format = 'H_HH' or format = 'H_HHMM' or
1187: format = 'H_HHMMSS') then
1188: chkhours(value,format,output,minimum,maximum,rgeflg,result);
1189: if(result = FALSE) then
1190: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');
1191: hr_utility.raise_error;
1192: end if;
1193: elsif(format = 'TIMES' or format = 'T') then
1194: chktime(value, minimum, maximum, rgeflg, result);

Line 1191: hr_utility.raise_error;

1187: format = 'H_HHMMSS') then
1188: chkhours(value,format,output,minimum,maximum,rgeflg,result);
1189: if(result = FALSE) then
1190: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');
1191: hr_utility.raise_error;
1192: end if;
1193: elsif(format = 'TIMES' or format = 'T') then
1194: chktime(value, minimum, maximum, rgeflg, result);
1195: if(result = FALSE) then

Line 1196: hr_utility.set_message(801,'HR_51154_INVAL_TIME_FORMAT');

1192: end if;
1193: elsif(format = 'TIMES' or format = 'T') then
1194: chktime(value, minimum, maximum, rgeflg, result);
1195: if(result = FALSE) then
1196: hr_utility.set_message(801,'HR_51154_INVAL_TIME_FORMAT');
1197: hr_utility.raise_error;
1198: end if;
1199: output := value;
1200:

Line 1197: hr_utility.raise_error;

1193: elsif(format = 'TIMES' or format = 'T') then
1194: chktime(value, minimum, maximum, rgeflg, result);
1195: if(result = FALSE) then
1196: hr_utility.set_message(801,'HR_51154_INVAL_TIME_FORMAT');
1197: hr_utility.raise_error;
1198: end if;
1199: output := value;
1200:
1201: --elsif(format = 'D_DDMONYY' or format = 'D_DDMONYYYY' or

Line 1208: hr_utility.set_message(801,'HR_51155_INVAL_DATE_FORMAT');

1204: --format = 'DATE') then
1205: elsif (format = 'D' or format = 'DATE') then
1206: chkdate(value,format,output,minimum,maximum,rgeflg,result);
1207: if(result = FALSE) then
1208: hr_utility.set_message(801,'HR_51155_INVAL_DATE_FORMAT');
1209: hr_utility.raise_error;
1210: end if;
1211: elsif(format = 'H_DECIMAL1' or format = 'H_DECIMAL2'
1212: or format = 'H_DECIMAL3' or format = 'HOURS') then

Line 1209: hr_utility.raise_error;

1205: elsif (format = 'D' or format = 'DATE') then
1206: chkdate(value,format,output,minimum,maximum,rgeflg,result);
1207: if(result = FALSE) then
1208: hr_utility.set_message(801,'HR_51155_INVAL_DATE_FORMAT');
1209: hr_utility.raise_error;
1210: end if;
1211: elsif(format = 'H_DECIMAL1' or format = 'H_DECIMAL2'
1212: or format = 'H_DECIMAL3' or format = 'HOURS') then
1213: chkdech(value,format,minimum,maximum,rgeflg,result,FALSE);

Line 1215: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');

1211: elsif(format = 'H_DECIMAL1' or format = 'H_DECIMAL2'
1212: or format = 'H_DECIMAL3' or format = 'HOURS') then
1213: chkdech(value,format,minimum,maximum,rgeflg,result,FALSE);
1214: if(result = FALSE) then
1215: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');
1216: hr_utility.raise_error;
1217: end if;
1218: --output is in canonical format
1219: output := fnd_number.number_to_canonical( to_number(value) );

Line 1216: hr_utility.raise_error;

1212: or format = 'H_DECIMAL3' or format = 'HOURS') then
1213: chkdech(value,format,minimum,maximum,rgeflg,result,FALSE);
1214: if(result = FALSE) then
1215: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');
1216: hr_utility.raise_error;
1217: end if;
1218: --output is in canonical format
1219: output := fnd_number.number_to_canonical( to_number(value) );
1220: elsif(format = 'DB_ITEM_NAME') then

Line 1222: hr_utility.set_message(801,'HR_51156_INVAL_NUM_FORMAT');

1218: --output is in canonical format
1219: output := fnd_number.number_to_canonical( to_number(value) );
1220: elsif(format = 'DB_ITEM_NAME') then
1221: if(chkdbi(value) = FALSE) then
1222: hr_utility.set_message(801,'HR_51156_INVAL_NUM_FORMAT');
1223: hr_utility.raise_error;
1224: end if;
1225: output := value;
1226: elsif(format = 'PAY_NAME') then

Line 1223: hr_utility.raise_error;

1219: output := fnd_number.number_to_canonical( to_number(value) );
1220: elsif(format = 'DB_ITEM_NAME') then
1221: if(chkdbi(value) = FALSE) then
1222: hr_utility.set_message(801,'HR_51156_INVAL_NUM_FORMAT');
1223: hr_utility.raise_error;
1224: end if;
1225: output := value;
1226: elsif(format = 'PAY_NAME') then
1227: if(chkpay(value) = FALSE) then

Line 1228: hr_utility.set_message(801,'HR_51157_INVAL_PAY_NAME_FORMAT');

1224: end if;
1225: output := value;
1226: elsif(format = 'PAY_NAME') then
1227: if(chkpay(value) = FALSE) then
1228: hr_utility.set_message(801,'HR_51157_INVAL_PAY_NAME_FORMAT');
1229: hr_utility.raise_error;
1230: end if;
1231: output := value;
1232: elsif(format = 'NACHA') then

Line 1229: hr_utility.raise_error;

1225: output := value;
1226: elsif(format = 'PAY_NAME') then
1227: if(chkpay(value) = FALSE) then
1228: hr_utility.set_message(801,'HR_51157_INVAL_PAY_NAME_FORMAT');
1229: hr_utility.raise_error;
1230: end if;
1231: output := value;
1232: elsif(format = 'NACHA') then
1233: chknacha(value,result); -- check for legal NACHA characters

Line 1235: hr_utility.set_message(801,'HR_51158_INVAL_NACHA_FORMAT');

1231: output := value;
1232: elsif(format = 'NACHA') then
1233: chknacha(value,result); -- check for legal NACHA characters
1234: if(result = FALSE) then
1235: hr_utility.set_message(801,'HR_51158_INVAL_NACHA_FORMAT');
1236: hr_utility.raise_error;
1237: end if;
1238: output := value;
1239: elsif(format = 'KANA'or format = 'K') then

Line 1236: hr_utility.raise_error;

1232: elsif(format = 'NACHA') then
1233: chknacha(value,result); -- check for legal NACHA characters
1234: if(result = FALSE) then
1235: hr_utility.set_message(801,'HR_51158_INVAL_NACHA_FORMAT');
1236: hr_utility.raise_error;
1237: end if;
1238: output := value;
1239: elsif(format = 'KANA'or format = 'K') then
1240: chk_half_kana(value,result);

Line 1242: hr_utility.set_message(801, 'HR_72021_PER_INVALID_KANA');

1238: output := value;
1239: elsif(format = 'KANA'or format = 'K') then
1240: chk_half_kana(value,result);
1241: if(result = FALSE) then
1242: hr_utility.set_message(801, 'HR_72021_PER_INVALID_KANA');
1243: hr_utility.raise_error;
1244: end if;
1245: else
1246: -- invalid format.

Line 1243: hr_utility.raise_error;

1239: elsif(format = 'KANA'or format = 'K') then
1240: chk_half_kana(value,result);
1241: if(result = FALSE) then
1242: hr_utility.set_message(801, 'HR_72021_PER_INVALID_KANA');
1243: hr_utility.raise_error;
1244: end if;
1245: else
1246: -- invalid format.
1247: hr_utility.set_message(801,'HR_51159_INVAL_VALUE_FORMAT');

Line 1247: hr_utility.set_message(801,'HR_51159_INVAL_VALUE_FORMAT');

1243: hr_utility.raise_error;
1244: end if;
1245: else
1246: -- invalid format.
1247: hr_utility.set_message(801,'HR_51159_INVAL_VALUE_FORMAT');
1248: hr_utility.raise_error;
1249: end if;
1250: end checkformat;
1251: --

Line 1248: hr_utility.raise_error;

1244: end if;
1245: else
1246: -- invalid format.
1247: hr_utility.set_message(801,'HR_51159_INVAL_VALUE_FORMAT');
1248: hr_utility.raise_error;
1249: end if;
1250: end checkformat;
1251: --
1252: --------------------------- changeformat -----------------------------------