1200: (
1201: FND_LOG.level_statement
1202: , L_LOG_MODULE || 'check_date_format_start_1'
1203: , 'checking if p_creation_from_date is in the format '
1204: || fnd_date.user_mask
1205: );
1206:
1207: END IF;
1208:
1209: -- Check if p_creation_from_date is of the format
1210: -- as maintained in the profile option ICX_DATE_FORMAT
1211: -- and if not, throw an error.
1212:
1213: x_creation_from_date := fnd_date.string_to_date
1214: (
1215: p_creation_from_date
1216: , fnd_date.user_mask
1217: );
1212:
1213: x_creation_from_date := fnd_date.string_to_date
1214: (
1215: p_creation_from_date
1216: , fnd_date.user_mask
1217: );
1218:
1219: IF x_creation_from_date IS NULL
1220: THEN
1224: (
1225: FND_LOG.level_unexpected
1226: , L_LOG_MODULE || 'crtfrmdt_format_invalid'
1227: , 'format of field p_creation_from_date is invalid. should be '
1228: || fnd_date.user_mask
1229: );
1230:
1231: END IF ;
1232:
1242: AND descriptive_flexfield_name = '$SRS$.CSCSTPG';
1243:
1244: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
1245: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
1246: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
1247: FND_MSG_PUB.ADD;
1248:
1249: RAISE FND_API.G_EXC_ERROR;
1250:
1259: (
1260: FND_LOG.level_statement
1261: , L_LOG_MODULE || 'check_date_format_end_1'
1262: , 'after checking if p_creation_from_date is in the format '
1263: || fnd_date.user_mask
1264: );
1265: END IF;
1266: END IF;--p_creation_from_date IS NOT NULL
1267:
1275: (
1276: FND_LOG.level_statement
1277: , L_LOG_MODULE || 'check_date_format_start_2'
1278: , 'checking if p_creation_to_date is in the format '
1279: || fnd_date.user_mask
1280: );
1281: END IF;
1282:
1283: -- Check if p_creation_to_date is of the format
1283: -- Check if p_creation_to_date is of the format
1284: -- as maintained in the profile option ICX_DATE_FORMAT
1285: -- and if not, throw an error.
1286:
1287: x_creation_to_date := fnd_date.string_to_date
1288: (
1289: p_creation_to_date
1290: , fnd_date.user_mask
1291: );
1286:
1287: x_creation_to_date := fnd_date.string_to_date
1288: (
1289: p_creation_to_date
1290: , fnd_date.user_mask
1291: );
1292:
1293: IF x_creation_to_date IS NULL
1294: THEN
1298: (
1299: FND_LOG.level_unexpected
1300: , L_LOG_MODULE || 'crttodt_format_invalid'
1301: , 'format of field p_creation_to_date is invalid. should be ' ||
1302: fnd_date.user_mask
1303: );
1304: END IF ;
1305:
1306: SELECT
1315: AND descriptive_flexfield_name = '$SRS$.CSCSTPG';
1316:
1317: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
1318: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
1319: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
1320: FND_MSG_PUB.ADD;
1321:
1322: RAISE FND_API.G_EXC_ERROR;
1323:
1331: (
1332: FND_LOG.level_statement
1333: , L_LOG_MODULE || 'check_date_format_end_2'
1334: , 'after checking if p_creation_to_date is in the format ' ||
1335: fnd_date.user_mask
1336: );
1337: END IF;
1338:
1339: ---