4484: (
4485: FND_LOG.level_statement
4486: , L_LOG_MODULE || 'check_date_format_start_1'
4487: , 'checking if p_creation_from_date is in the format '
4488: || fnd_date.user_mask
4489: );
4490: END IF;
4491:
4492: -- Check if p_creation_from_date is of the format
4492: -- Check if p_creation_from_date is of the format
4493: -- as maintained in the profile option ICX_DATE_FORMAT
4494: -- and if not, throw an error.
4495:
4496: x_creation_from_date := fnd_date.string_to_date
4497: (
4498: p_creation_from_date
4499: , fnd_date.user_mask
4500: );
4495:
4496: x_creation_from_date := fnd_date.string_to_date
4497: (
4498: p_creation_from_date
4499: , fnd_date.user_mask
4500: );
4501:
4502: IF x_creation_from_date IS NULL
4503: THEN
4507: (
4508: FND_LOG.level_unexpected
4509: , L_LOG_MODULE || 'crtfrmdt_format_invalid'
4510: , 'format of field p_creation_from_date is invalid. should be '
4511: || fnd_date.user_mask
4512: );
4513: END IF ;
4514:
4515: SELECT
4524: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
4525:
4526: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
4527: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
4528: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
4529: FND_MSG_PUB.ADD;
4530:
4531: RAISE FND_API.G_EXC_ERROR;
4532: END IF;
4537: (
4538: FND_LOG.level_statement
4539: , L_LOG_MODULE || 'check_date_format_end_1'
4540: , 'after checking if p_creation_from_date is in the format '
4541: || fnd_date.user_mask
4542: );
4543: END IF;
4544: END IF;
4545:
4553: (
4554: FND_LOG.level_statement
4555: , L_LOG_MODULE || 'check_date_format_start_2'
4556: , 'checking if p_creation_to_date is in the format '
4557: || fnd_date.user_mask
4558: );
4559: END IF;
4560:
4561: -- Check if p_creation_to_date is of the format
4561: -- Check if p_creation_to_date is of the format
4562: -- as maintained in the profile option ICX_DATE_FORMAT
4563: -- and if not, throw an error.
4564:
4565: x_creation_to_date := fnd_date.string_to_date
4566: (
4567: p_creation_to_date
4568: , fnd_date.user_mask
4569: );
4564:
4565: x_creation_to_date := fnd_date.string_to_date
4566: (
4567: p_creation_to_date
4568: , fnd_date.user_mask
4569: );
4570:
4571: IF x_creation_to_date IS NULL
4572: THEN
4576: (
4577: FND_LOG.level_unexpected
4578: , L_LOG_MODULE || 'crttodt_format_invalid'
4579: , 'format of field p_creation_to_date is invalid. should be ' ||
4580: fnd_date.user_mask
4581: );
4582: END IF ;
4583:
4584: SELECT
4593: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
4594:
4595: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
4596: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
4597: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
4598: FND_MSG_PUB.ADD;
4599:
4600: RAISE FND_API.G_EXC_ERROR;
4601: END IF;
4606: (
4607: FND_LOG.level_statement
4608: , L_LOG_MODULE || 'check_date_format_end_2'
4609: , 'after checking if p_creation_to_date is in the format ' ||
4610: fnd_date.user_mask
4611: );
4612: END IF;
4613:
4614: ---
4664: (
4665: FND_LOG.level_statement
4666: , L_LOG_MODULE || 'check_date_format_start_3'
4667: , 'checking if p_last_update_from_date is in the format '
4668: || fnd_date.user_mask
4669: );
4670: END IF;
4671:
4672: -- Check if p_last_update_from_date is of the format
4672: -- Check if p_last_update_from_date is of the format
4673: -- as maintained in the profile option ICX_DATE_FORMAT
4674: -- and if not, throw an error.
4675:
4676: x_last_update_from_date := fnd_date.string_to_date
4677: (
4678: p_last_update_from_date
4679: , fnd_date.user_mask
4680: );
4675:
4676: x_last_update_from_date := fnd_date.string_to_date
4677: (
4678: p_last_update_from_date
4679: , fnd_date.user_mask
4680: );
4681:
4682: IF x_last_update_from_date IS NULL
4683: THEN
4687: (
4688: FND_LOG.level_unexpected
4689: , L_LOG_MODULE || 'lstupdfrmdt_format_invalid'
4690: , 'format of field p_last_update_from_date is invalid. should be '
4691: || fnd_date.user_mask
4692: );
4693: END IF ;
4694:
4695: SELECT
4704: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
4705:
4706: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
4707: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
4708: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
4709: FND_MSG_PUB.ADD;
4710:
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4717: (
4718: FND_LOG.level_statement
4719: , L_LOG_MODULE || 'check_date_format_end_3'
4720: , 'after checking if p_last_update_from_date is in the format '
4721: || fnd_date.user_mask
4722: );
4723: END IF;
4724: END IF;
4725:
4733: (
4734: FND_LOG.level_statement
4735: , L_LOG_MODULE || 'check_date_format_start_4'
4736: , 'checking if p_last_update_to_date is in the format '
4737: || fnd_date.user_mask
4738: );
4739: END IF;
4740:
4741: -- Check if p_last_update_to_date is of the format
4741: -- Check if p_last_update_to_date is of the format
4742: -- as maintained in the profile option ICX_DATE_FORMAT
4743: -- and if not, throw an error.
4744:
4745: x_last_update_to_date := fnd_date.string_to_date
4746: (
4747: p_last_update_to_date
4748: , fnd_date.user_mask
4749: );
4744:
4745: x_last_update_to_date := fnd_date.string_to_date
4746: (
4747: p_last_update_to_date
4748: , fnd_date.user_mask
4749: );
4750:
4751: IF x_last_update_to_date IS NULL
4752: THEN
4756: (
4757: FND_LOG.level_unexpected
4758: , L_LOG_MODULE || 'lstupdtodt_format_invalid'
4759: , 'format of field p_last_update_to_date is invalid. should be '
4760: || fnd_date.user_mask
4761: );
4762: END IF ;
4763:
4764: SELECT
4773: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
4774:
4775: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
4776: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
4777: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
4778: FND_MSG_PUB.ADD;
4779:
4780: RAISE FND_API.G_EXC_ERROR;
4781: END IF;
4786: (
4787: FND_LOG.level_statement
4788: , L_LOG_MODULE || 'check_date_format_end_4'
4789: , 'after checking if p_last_update_to_date is in the format '
4790: || fnd_date.user_mask
4791: );
4792: END IF;
4793:
4794: ---