DBA Data[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on APP_EXCEPTION

Line 1699: app_exception.raise_exception;

1695: -- maxsize cannot be decreased for a database record.
1696: --
1697: IF (maxsize < maxsize_old) THEN
1698: fnd_message.set_name('FND', 'FLEX-CANNOT REDUCE MAX SIZE');
1699: app_exception.raise_exception;
1700: END IF;
1701:
1702: --
1703: -- Maximum_size cannot be changed if right justify is on

Line 1707: app_exception.raise_exception;

1703: -- Maximum_size cannot be changed if right justify is on
1704: --
1705: IF (valueset_r.numeric_mode_enabled_flag = 'Y') THEN
1706: fnd_message.set_name('FND', 'FLEX-NO SIZE CHANGE WITH NUM');
1707: app_exception.raise_exception;
1708: END IF;
1709:
1710: --
1711: -- maxsize must be positive

Line 1715: app_exception.raise_exception;

1711: -- maxsize must be positive
1712: --
1713: IF (maxsize < 1) THEN
1714: fnd_message.set_name('FND','FLEX-Max size must be positive');
1715: app_exception.raise_exception;
1716: END IF;
1717:
1718: --
1719: -- if format_type is date, datetime, or time, make sure maxsize is an

Line 1725: app_exception.raise_exception;

1721: --
1722: IF(valueset_r.format_type = 'D') THEN
1723: IF (maxsize NOT IN ('9','11')) THEN
1724: fnd_message.set_name('FND','FLEX-Bad Date Length');
1725: app_exception.raise_exception;
1726: END IF;
1727: ELSIF(valueset_r.format_type = 'T') THEN
1728: IF (maxsize NOT IN ('15','17','18','20')) THEN
1729: fnd_message.set_name('FND','FLEX-Bad DateTime Length');

Line 1730: app_exception.raise_exception;

1726: END IF;
1727: ELSIF(valueset_r.format_type = 'T') THEN
1728: IF (maxsize NOT IN ('15','17','18','20')) THEN
1729: fnd_message.set_name('FND','FLEX-Bad DateTime Length');
1730: app_exception.raise_exception;
1731: END IF;
1732: ELSIF(valueset_r.format_type = 't') THEN
1733: IF (maxsize NOT IN (5,8)) THEN
1734: fnd_message.set_name('FND','FLEX-Bad Time Length');

Line 1735: app_exception.raise_exception;

1731: END IF;
1732: ELSIF(valueset_r.format_type = 't') THEN
1733: IF (maxsize NOT IN (5,8)) THEN
1734: fnd_message.set_name('FND','FLEX-Bad Time Length');
1735: app_exception.raise_exception;
1736: END IF;
1737: ELSIF(valueset_r.format_type = 'N') THEN
1738: IF (maxsize > 38) THEN
1739: fnd_message.set_name('FND','FLEX-Bad Num Length');

Line 1740: app_exception.raise_exception;

1736: END IF;
1737: ELSIF(valueset_r.format_type = 'N') THEN
1738: IF (maxsize > 38) THEN
1739: fnd_message.set_name('FND','FLEX-Bad Num Length');
1740: app_exception.raise_exception;
1741: END IF;
1742: END IF;
1743:
1744: crosscheck_size(valueset_r);

Line 1960: app_exception.raise_exception;

1956: END;
1957: IF (table_r.id_column_size > width_i) THEN
1958: fnd_message.set_name('FND','FLEX-COLUMN WIDTH ERROR');
1959: fnd_message.set_token('SIZE',To_char(width_i));
1960: app_exception.raise_exception;
1961: END IF;
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: message('check id size failed: ' || Sqlerrm);

Line 1992: app_exception.raise_exception;

1988: END;
1989: IF(table_r.meaning_column_size > width_i) THEN
1990: fnd_message.set_name('FND','FLEX-COLUMN WIDTH ERROR');
1991: fnd_message.set_token('SIZE',To_char(width_i));
1992: app_exception.raise_exception;
1993: END IF;
1994: EXCEPTION
1995: WHEN OTHERS THEN
1996: message('check meaning size failed: ' || Sqlerrm);

Line 3775: app_exception.raise_exception;

3771: THEN
3772: fnd_message.set_name('FND','FLEX-VSET TYPE OBSOLETE');
3773: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3774: fnd_message.set_token('SEG_NAME',p_segment_name);
3775: app_exception.raise_exception;
3776: END IF;
3777:
3778:
3779: IF(p_flex_field = 'KFF') THEN

Line 3797: app_exception.raise_exception;

3793: THEN
3794: fnd_message.set_name('FND','FLEX-VSET IDVSET RESTRICTED');
3795: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3796: fnd_message.set_token('SEG_NAME',p_segment_name);
3797: app_exception.raise_exception;
3798: END IF;
3799:
3800:
3801: /*

Line 3821: app_exception.raise_exception;

3817: THEN
3818: fnd_message.set_name('FND','FLEX-VSET IDVSET TR RESTRICTED');
3819: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3820: fnd_message.set_token('SEG_NAME',p_segment_name);
3821: app_exception.raise_exception;
3822: END IF;
3823:
3824:
3825: /*

Line 3844: app_exception.raise_exception;

3840: THEN
3841: fnd_message.set_name('FND','FLEX-VSET IDVSET DN RESTRICTED');
3842: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3843: fnd_message.set_token('SEG_NAME',p_segment_name);
3844: app_exception.raise_exception;
3845: END IF;
3846: END IF; /* KFF Check */
3847:
3848:

Line 3904: app_exception.raise_exception;

3900: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3901: fnd_message.set_token('SEG_NAME',p_segment_name);
3902: fnd_message.set_token('FORMAT_TYPE',l_format_type_name);
3903: fnd_message.set_token('DATA_TYPE',l_appl_column_type_name);
3904: app_exception.raise_exception;
3905:
3906: END IF;
3907:
3908:

Line 3935: app_exception.raise_exception;

3931:
3932: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3933: fnd_message.set_token('SEG_NAME',p_segment_name);
3934: fnd_message.set_token('COL_SIZE',l_application_column_size);
3935: app_exception.raise_exception;
3936: END IF;
3937:
3938:
3939: IF(p_flex_field = 'KFF') THEN

Line 3973: app_exception.raise_exception;

3969: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');
3970: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3971: fnd_message.set_token('SEG_NAME',p_segment_name);
3972: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
3973: app_exception.raise_exception;
3974: END IF;
3975:
3976: EXCEPTION
3977: WHEN NO_DATA_FOUND THEN

Line 3991: app_exception.raise_exception;

3987: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
3988: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3989: fnd_message.set_token('SEG_NAME',p_segment_name);
3990: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
3991: app_exception.raise_exception;
3992: WHEN OTHERS THEN RAISE;
3993: END;
3994: END IF;
3995: END IF; /* KFF Check */

Line 4034: app_exception.raise_exception;

4030: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');
4031: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4032: fnd_message.set_token('SEG_NAME',p_segment_name);
4033: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4034: app_exception.raise_exception;
4035: END IF;
4036: EXCEPTION
4037: WHEN NO_DATA_FOUND THEN
4038:

Line 4051: app_exception.raise_exception;

4047: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4048: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4049: fnd_message.set_token('SEG_NAME',p_segment_name);
4050: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4051: app_exception.raise_exception;
4052: WHEN OTHERS THEN RAISE;
4053: END;
4054: END IF;
4055: END IF; /* DFF Check */

Line 4136: app_exception.raise_exception;

4132: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4133: fnd_message.set_token('SEG_NAME',p_segment_name);
4134: fnd_message.set_token('FORMAT_TYPE',l_format_type_name);
4135: fnd_message.set_token('DATA_TYPE',l_appl_column_type_name);
4136: app_exception.raise_exception;
4137:
4138: END IF;
4139:
4140:

Line 4166: app_exception.raise_exception;

4162:
4163: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4164: fnd_message.set_token('SEG_NAME',p_segment_name);
4165: fnd_message.set_token('COL_SIZE',p_application_column_size);
4166: app_exception.raise_exception;
4167: END IF;
4168:
4169: END check_base_table_column;
4170:

Line 4188: app_exception.raise_exception;

4184: THEN
4185: fnd_message.set_name('FND','FLEX-VSET TYPE OBSOLETE');
4186: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4187: fnd_message.set_token('SEG_NAME',p_segment_name);
4188: app_exception.raise_exception;
4189: END IF;
4190:
4191: END is_vset_obsolete;
4192:

Line 4354: app_exception.raise_exception;

4350: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');
4351: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4352: fnd_message.set_token('SEG_NAME',p_end_user_column_name);
4353: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4354: app_exception.raise_exception;
4355: END IF;
4356: EXCEPTION
4357: WHEN NO_DATA_FOUND THEN
4358:

Line 4371: app_exception.raise_exception;

4367: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4368: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4369: fnd_message.set_token('SEG_NAME',p_end_user_column_name);
4370: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4371: app_exception.raise_exception;
4372: WHEN OTHERS THEN RAISE;
4373: END;
4374: END IF;
4375:

Line 4490: app_exception.raise_exception;

4486: THEN
4487: fnd_message.set_name('FND','FLEX-VSET IDVSET RESTRICTED');
4488: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4489: fnd_message.set_token('SEG_NAME',p_segment_name);
4490: app_exception.raise_exception;
4491: END IF;
4492:
4493:
4494: /*

Line 4513: app_exception.raise_exception;

4509: THEN
4510: fnd_message.set_name('FND','FLEX-VSET IDVSET TR RESTRICTED');
4511: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4512: fnd_message.set_token('SEG_NAME',p_segment_name);
4513: app_exception.raise_exception;
4514: END IF;
4515:
4516:
4517: /*

Line 4536: app_exception.raise_exception;

4532: THEN
4533: fnd_message.set_name('FND','FLEX-VSET IDVSET DN RESTRICTED');
4534: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4535: fnd_message.set_token('SEG_NAME',p_segment_name);
4536: app_exception.raise_exception;
4537: END IF;
4538:
4539:
4540: check_base_table_column(l_application_column_type,

Line 4587: app_exception.raise_exception;

4583: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');
4584: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4585: fnd_message.set_token('SEG_NAME',p_segment_name);
4586: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4587: app_exception.raise_exception;
4588: END IF;
4589:
4590: EXCEPTION
4591: WHEN NO_DATA_FOUND THEN

Line 4605: app_exception.raise_exception;

4601: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4602: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4603: fnd_message.set_token('SEG_NAME',p_segment_name);
4604: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4605: app_exception.raise_exception;
4606: WHEN OTHERS THEN RAISE;
4607: END;
4608: END IF;
4609: