eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on APP_EXCEPTION

Line 1710: app_exception.raise_exception;

1706: -- maxsize cannot be decreased for a database record.
1707: --
1708: IF (maxsize < maxsize_old) THEN
1709: fnd_message.set_name('FND', 'FLEX-CANNOT REDUCE MAX SIZE');
1710: app_exception.raise_exception;
1711: END IF;
1712:
1713: --
1714: -- Maximum_size cannot be changed if right justify is on

Line 1718: app_exception.raise_exception;

1714: -- Maximum_size cannot be changed if right justify is on
1715: --
1716: IF (valueset_r.numeric_mode_enabled_flag = 'Y') THEN
1717: fnd_message.set_name('FND', 'FLEX-NO SIZE CHANGE WITH NUM');
1718: app_exception.raise_exception;
1719: END IF;
1720:
1721: --
1722: -- maxsize must be positive

Line 1726: app_exception.raise_exception;

1722: -- maxsize must be positive
1723: --
1724: IF (maxsize < 1) THEN
1725: fnd_message.set_name('FND','FLEX-Max size must be positive');
1726: app_exception.raise_exception;
1727: END IF;
1728:
1729: --
1730: -- if format_type is date, datetime, or time, make sure maxsize is an

Line 1736: app_exception.raise_exception;

1732: --
1733: IF(valueset_r.format_type = 'D') THEN
1734: IF (maxsize NOT IN ('9','11')) THEN
1735: fnd_message.set_name('FND','FLEX-Bad Date Length');
1736: app_exception.raise_exception;
1737: END IF;
1738: ELSIF(valueset_r.format_type = 'T') THEN
1739: IF (maxsize NOT IN ('15','17','18','20')) THEN
1740: fnd_message.set_name('FND','FLEX-Bad DateTime Length');

Line 1741: app_exception.raise_exception;

1737: END IF;
1738: ELSIF(valueset_r.format_type = 'T') THEN
1739: IF (maxsize NOT IN ('15','17','18','20')) THEN
1740: fnd_message.set_name('FND','FLEX-Bad DateTime Length');
1741: app_exception.raise_exception;
1742: END IF;
1743: ELSIF(valueset_r.format_type = 't') THEN
1744: IF (maxsize NOT IN (5,8)) THEN
1745: fnd_message.set_name('FND','FLEX-Bad Time Length');

Line 1746: app_exception.raise_exception;

1742: END IF;
1743: ELSIF(valueset_r.format_type = 't') THEN
1744: IF (maxsize NOT IN (5,8)) THEN
1745: fnd_message.set_name('FND','FLEX-Bad Time Length');
1746: app_exception.raise_exception;
1747: END IF;
1748: ELSIF(valueset_r.format_type = 'N') THEN
1749: IF (maxsize > 38) THEN
1750: fnd_message.set_name('FND','FLEX-Bad Num Length');

Line 1751: app_exception.raise_exception;

1747: END IF;
1748: ELSIF(valueset_r.format_type = 'N') THEN
1749: IF (maxsize > 38) THEN
1750: fnd_message.set_name('FND','FLEX-Bad Num Length');
1751: app_exception.raise_exception;
1752: END IF;
1753: END IF;
1754:
1755: crosscheck_size(valueset_r);

Line 1971: app_exception.raise_exception;

1967: END;
1968: IF (table_r.id_column_size > width_i) THEN
1969: fnd_message.set_name('FND','FLEX-COLUMN WIDTH ERROR');
1970: fnd_message.set_token('SIZE',To_char(width_i));
1971: app_exception.raise_exception;
1972: END IF;
1973: EXCEPTION
1974: WHEN OTHERS THEN
1975: message('check id size failed: ' || Sqlerrm);

Line 2003: app_exception.raise_exception;

1999: END;
2000: IF(table_r.meaning_column_size > width_i) THEN
2001: fnd_message.set_name('FND','FLEX-COLUMN WIDTH ERROR');
2002: fnd_message.set_token('SIZE',To_char(width_i));
2003: app_exception.raise_exception;
2004: END IF;
2005: EXCEPTION
2006: WHEN OTHERS THEN
2007: message('check meaning size failed: ' || Sqlerrm);

Line 3903: app_exception.raise_exception;

3899: THEN
3900: fnd_message.set_name('FND','FLEX-VSET TYPE OBSOLETE');
3901: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3902: fnd_message.set_token('SEG_NAME',p_segment_name);
3903: app_exception.raise_exception;
3904: END IF;
3905:
3906:
3907: IF(p_flex_field = 'KFF') THEN

Line 3925: app_exception.raise_exception;

3921: THEN
3922: fnd_message.set_name('FND','FLEX-VSET IDVSET RESTRICTED');
3923: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3924: fnd_message.set_token('SEG_NAME',p_segment_name);
3925: app_exception.raise_exception;
3926: END IF;
3927:
3928:
3929: /*

Line 3949: app_exception.raise_exception;

3945: THEN
3946: fnd_message.set_name('FND','FLEX-VSET IDVSET TR RESTRICTED');
3947: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3948: fnd_message.set_token('SEG_NAME',p_segment_name);
3949: app_exception.raise_exception;
3950: END IF;
3951:
3952:
3953: /*

Line 3972: app_exception.raise_exception;

3968: THEN
3969: fnd_message.set_name('FND','FLEX-VSET IDVSET DN RESTRICTED');
3970: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3971: fnd_message.set_token('SEG_NAME',p_segment_name);
3972: app_exception.raise_exception;
3973: END IF;
3974: END IF; /* KFF Check */
3975:
3976:

Line 4032: app_exception.raise_exception;

4028: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4029: fnd_message.set_token('SEG_NAME',p_segment_name);
4030: fnd_message.set_token('FORMAT_TYPE',l_format_type_name);
4031: fnd_message.set_token('DATA_TYPE',l_appl_column_type_name);
4032: app_exception.raise_exception;
4033:
4034: END IF;
4035:
4036:

Line 4063: app_exception.raise_exception;

4059:
4060: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4061: fnd_message.set_token('SEG_NAME',p_segment_name);
4062: fnd_message.set_token('COL_SIZE',l_application_column_size);
4063: app_exception.raise_exception;
4064: END IF;
4065:
4066:
4067: IF(p_flex_field = 'KFF') THEN

Line 4101: app_exception.raise_exception;

4097: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');
4098: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4099: fnd_message.set_token('SEG_NAME',p_segment_name);
4100: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4101: app_exception.raise_exception;
4102: END IF;
4103:
4104: EXCEPTION
4105: WHEN NO_DATA_FOUND THEN

Line 4119: app_exception.raise_exception;

4115: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4116: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4117: fnd_message.set_token('SEG_NAME',p_segment_name);
4118: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4119: app_exception.raise_exception;
4120: WHEN OTHERS THEN RAISE;
4121: END;
4122: END IF;
4123: END IF; /* KFF Check */

Line 4162: app_exception.raise_exception;

4158: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');
4159: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4160: fnd_message.set_token('SEG_NAME',p_segment_name);
4161: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4162: app_exception.raise_exception;
4163: END IF;
4164: EXCEPTION
4165: WHEN NO_DATA_FOUND THEN
4166:

Line 4179: app_exception.raise_exception;

4175: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4176: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4177: fnd_message.set_token('SEG_NAME',p_segment_name);
4178: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4179: app_exception.raise_exception;
4180: WHEN OTHERS THEN RAISE;
4181: END;
4182: END IF;
4183: END IF; /* DFF Check */

Line 4264: app_exception.raise_exception;

4260: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4261: fnd_message.set_token('SEG_NAME',p_segment_name);
4262: fnd_message.set_token('FORMAT_TYPE',l_format_type_name);
4263: fnd_message.set_token('DATA_TYPE',l_appl_column_type_name);
4264: app_exception.raise_exception;
4265:
4266: END IF;
4267:
4268:

Line 4294: app_exception.raise_exception;

4290:
4291: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4292: fnd_message.set_token('SEG_NAME',p_segment_name);
4293: fnd_message.set_token('COL_SIZE',p_application_column_size);
4294: app_exception.raise_exception;
4295: END IF;
4296:
4297: END check_base_table_column;
4298:

Line 4316: app_exception.raise_exception;

4312: THEN
4313: fnd_message.set_name('FND','FLEX-VSET TYPE OBSOLETE');
4314: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4315: fnd_message.set_token('SEG_NAME',p_segment_name);
4316: app_exception.raise_exception;
4317: END IF;
4318:
4319: END is_vset_obsolete;
4320:

Line 4482: app_exception.raise_exception;

4478: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');
4479: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4480: fnd_message.set_token('SEG_NAME',p_end_user_column_name);
4481: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4482: app_exception.raise_exception;
4483: END IF;
4484: EXCEPTION
4485: WHEN NO_DATA_FOUND THEN
4486:

Line 4499: app_exception.raise_exception;

4495: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4496: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4497: fnd_message.set_token('SEG_NAME',p_end_user_column_name);
4498: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4499: app_exception.raise_exception;
4500: WHEN OTHERS THEN RAISE;
4501: END;
4502: END IF;
4503:

Line 4618: app_exception.raise_exception;

4614: THEN
4615: fnd_message.set_name('FND','FLEX-VSET IDVSET RESTRICTED');
4616: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4617: fnd_message.set_token('SEG_NAME',p_segment_name);
4618: app_exception.raise_exception;
4619: END IF;
4620:
4621:
4622: /*

Line 4641: app_exception.raise_exception;

4637: THEN
4638: fnd_message.set_name('FND','FLEX-VSET IDVSET TR RESTRICTED');
4639: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4640: fnd_message.set_token('SEG_NAME',p_segment_name);
4641: app_exception.raise_exception;
4642: END IF;
4643:
4644:
4645: /*

Line 4664: app_exception.raise_exception;

4660: THEN
4661: fnd_message.set_name('FND','FLEX-VSET IDVSET DN RESTRICTED');
4662: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4663: fnd_message.set_token('SEG_NAME',p_segment_name);
4664: app_exception.raise_exception;
4665: END IF;
4666:
4667:
4668: check_base_table_column(l_application_column_type,

Line 4715: app_exception.raise_exception;

4711: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');
4712: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4713: fnd_message.set_token('SEG_NAME',p_segment_name);
4714: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4715: app_exception.raise_exception;
4716: END IF;
4717:
4718: EXCEPTION
4719: WHEN NO_DATA_FOUND THEN

Line 4733: app_exception.raise_exception;

4729: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4730: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4731: fnd_message.set_token('SEG_NAME',p_segment_name);
4732: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);
4733: app_exception.raise_exception;
4734: WHEN OTHERS THEN RAISE;
4735: END;
4736: END IF;
4737: