DBA Data[Home] [Help]

APPS.CS_SR_PURGE_CP dependencies on FND_DATE

Line 4488: || fnd_date.user_mask

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

Line 4496: x_creation_from_date := fnd_date.string_to_date

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: );

Line 4499: , fnd_date.user_mask

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

Line 4511: || fnd_date.user_mask

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

Line 4528: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);

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;

Line 4541: || fnd_date.user_mask

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:

Line 4557: || fnd_date.user_mask

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

Line 4565: x_creation_to_date := fnd_date.string_to_date

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: );

Line 4568: , fnd_date.user_mask

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

Line 4580: fnd_date.user_mask

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

Line 4597: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);

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;

Line 4610: fnd_date.user_mask

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: ---

Line 4668: || fnd_date.user_mask

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

Line 4676: x_last_update_from_date := fnd_date.string_to_date

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: );

Line 4679: , fnd_date.user_mask

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

Line 4691: || fnd_date.user_mask

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

Line 4708: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);

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;

Line 4721: || fnd_date.user_mask

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:

Line 4737: || fnd_date.user_mask

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

Line 4745: x_last_update_to_date := fnd_date.string_to_date

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: );

Line 4748: , fnd_date.user_mask

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

Line 4760: || fnd_date.user_mask

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

Line 4777: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);

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;

Line 4790: || fnd_date.user_mask

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: ---