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.

APPS.FND_FLEX_VAL_API dependencies on FND_MESSAGE

Line 1709: fnd_message.set_name('FND', 'FLEX-CANNOT REDUCE MAX SIZE');

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

Line 1717: fnd_message.set_name('FND', 'FLEX-NO SIZE CHANGE WITH NUM');

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

Line 1725: fnd_message.set_name('FND','FLEX-Max size must be positive');

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

Line 1735: fnd_message.set_name('FND','FLEX-Bad Date Length');

1731: -- acceptable value.
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

Line 1740: fnd_message.set_name('FND','FLEX-Bad DateTime 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');
1741: app_exception.raise_exception;
1742: END IF;
1743: ELSIF(valueset_r.format_type = 't') THEN
1744: IF (maxsize NOT IN (5,8)) THEN

Line 1745: fnd_message.set_name('FND','FLEX-Bad Time 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');
1746: app_exception.raise_exception;
1747: END IF;
1748: ELSIF(valueset_r.format_type = 'N') THEN
1749: IF (maxsize > 38) THEN

Line 1750: fnd_message.set_name('FND','FLEX-Bad Num 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');
1751: app_exception.raise_exception;
1752: END IF;
1753: END IF;
1754:

Line 1969: fnd_message.set_name('FND','FLEX-COLUMN WIDTH ERROR');

1965: -- it is possible for the table to not be specified properly
1966: NULL;
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

Line 1970: fnd_message.set_token('SIZE',To_char(width_i));

1966: NULL;
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

Line 2001: fnd_message.set_name('FND','FLEX-COLUMN WIDTH ERROR');

1997: -- it is possible for the table to not be specified properly
1998: NULL;
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

Line 2002: fnd_message.set_token('SIZE',To_char(width_i));

1998: NULL;
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

Line 3172: fnd_message.get());

3168:
3169: IF (NOT l_success) THEN
3170: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3171: 'Value validation failed with the error message: ' ||
3172: fnd_message.get());
3173: END IF;
3174:
3175: -- Populate the l_value, by default everything is NULL.
3176:

Line 3278: fnd_message.get());

3274:
3275: IF (NOT l_success) THEN
3276: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3277: 'Value validation failed with the error message: ' ||
3278: fnd_message.get());
3279: END IF;
3280:
3281: -- Populate the l_value, by default everything is NULL.
3282:

Line 3412: fnd_message.get());

3408:
3409: IF (NOT l_success) THEN
3410: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3411: 'Value validation failed with the error message: ' ||
3412: fnd_message.get());
3413: END IF;
3414:
3415: -- Update fields
3416:

Line 3521: fnd_message.get());

3517:
3518: IF (NOT l_success) THEN
3519: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3520: 'Value validation failed with the error message: ' ||
3521: fnd_message.get());
3522: END IF;
3523:
3524: -- Update fields
3525:

Line 3608: fnd_message.get());

3604:
3605: IF (NOT l_success) THEN
3606: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3607: 'Low Value validation failed with the error message: ' ||
3608: fnd_message.get());
3609: END IF;
3610:
3611:
3612: -- Validate the child value high

Line 3633: fnd_message.get());

3629:
3630: IF (NOT l_success) THEN
3631: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3632: 'High Value validation failed with the error message: ' ||
3633: fnd_message.get());
3634: END IF;
3635:
3636: -- Make sure the order in Low and High Values
3637: IF (l_storage_value_low > l_storage_value_high) THEN

Line 3743: fnd_message.get());

3739: WHEN OTHERS THEN
3740: raise_error(ERROR_UNABLE_TO_SUBMIT_FDFCHY,
3741: 'Unable to submit FDFCHY request for flex value set: ' ||
3742: p_flex_value_set_name || '. Error: ' ||
3743: fnd_message.get());
3744: END;
3745:
3746: IF (l_request_id = 0) THEN
3747: raise_error(ERROR_UNABLE_TO_SUBMIT_FDFCHY,

Line 3750: fnd_message.get());

3746: IF (l_request_id = 0) THEN
3747: raise_error(ERROR_UNABLE_TO_SUBMIT_FDFCHY,
3748: 'Unable to submit FDFCHY request for flex value set: ' ||
3749: p_flex_value_set_name || '. Error: ' ||
3750: fnd_message.get());
3751: END IF;
3752:
3753: x_request_id := l_request_id;
3754:

Line 3900: fnd_message.set_name('FND','FLEX-VSET TYPE OBSOLETE');

3896: are replaced by Standard Date(X) and Standard DateTime(Y) format types.
3897: */
3898: IF(l_format_type='D' or l_format_type='T')
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;

Line 3901: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

3897: */
3898: IF(l_format_type='D' or l_format_type='T')
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:

Line 3902: fnd_message.set_token('SEG_NAME',p_segment_name);

3898: IF(l_format_type='D' or l_format_type='T')
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:

Line 3922: fnd_message.set_name('FND','FLEX-VSET IDVSET RESTRICTED');

3918: */
3919: IF(NOT(p_allow_id_valuesets = 'Y' OR
3920: (p_allow_id_valuesets = 'N' AND l_id_column_name is NULL)))
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;

Line 3923: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

3919: IF(NOT(p_allow_id_valuesets = 'Y' OR
3920: (p_allow_id_valuesets = 'N' AND l_id_column_name is NULL)))
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:

Line 3924: fnd_message.set_token('SEG_NAME',p_segment_name);

3920: (p_allow_id_valuesets = 'N' AND l_id_column_name is NULL)))
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:

Line 3946: fnd_message.set_name('FND','FLEX-VSET IDVSET TR RESTRICTED');

3942: IF(NOT(p_allow_id_valuesets = 'Y' OR
3943: (p_allow_id_valuesets = 'N' AND
3944: l_validation_type <> 'X' AND l_validation_type <> 'Y')))
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;

Line 3947: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

3943: (p_allow_id_valuesets = 'N' AND
3944: l_validation_type <> 'X' AND l_validation_type <> 'Y')))
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:

Line 3948: fnd_message.set_token('SEG_NAME',p_segment_name);

3944: l_validation_type <> 'X' AND l_validation_type <> 'Y')))
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:

Line 3969: fnd_message.set_name('FND','FLEX-VSET IDVSET DN RESTRICTED');

3965: ((l_format_type = 'N' AND
3966: l_number_precision IS NOT NULL AND
3967: l_number_precision = 0)))))
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;

Line 3970: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

3966: l_number_precision IS NOT NULL AND
3967: l_number_precision = 0)))))
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 */

Line 3971: fnd_message.set_token('SEG_NAME',p_segment_name);

3967: l_number_precision = 0)))))
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:

Line 4019: fnd_message.set_name('FND','FLEX-VSET FORMAT TYPE CONFLICT');

4015: select meaning
4016: into l_format_type_name
4017: from fnd_lookups
4018: where lookup_code=l_format_type and lookup_type='FIELD_TYPE';
4019: fnd_message.set_name('FND','FLEX-VSET FORMAT TYPE CONFLICT');
4020: ELSE
4021: select meaning
4022: into l_format_type_name
4023: from fnd_lookups

Line 4025: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');

4021: select meaning
4022: into l_format_type_name
4023: from fnd_lookups
4024: where lookup_code=l_id_column_type and lookup_type='COLUMN_TYPE';
4025: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');
4026: END IF;
4027:
4028: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4029: fnd_message.set_token('SEG_NAME',p_segment_name);

Line 4028: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4024: where lookup_code=l_id_column_type and lookup_type='COLUMN_TYPE';
4025: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');
4026: END IF;
4027:
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;

Line 4029: fnd_message.set_token('SEG_NAME',p_segment_name);

4025: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');
4026: END IF;
4027:
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:

Line 4030: fnd_message.set_token('FORMAT_TYPE',l_format_type_name);

4026: END IF;
4027:
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;

Line 4031: fnd_message.set_token('DATA_TYPE',l_appl_column_type_name);

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

Line 4053: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');

4049: THEN
4050:
4051: IF( l_id_column_type is NULL )
4052: THEN
4053: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4054: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);
4055: ELSE
4056: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4057: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);

Line 4054: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);

4050:
4051: IF( l_id_column_type is NULL )
4052: THEN
4053: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4054: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);
4055: ELSE
4056: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4057: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);
4058: END IF;

Line 4056: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');

4052: THEN
4053: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4054: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);
4055: ELSE
4056: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4057: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);
4058: END IF;
4059:
4060: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

Line 4057: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);

4053: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4054: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);
4055: ELSE
4056: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4057: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);
4058: END IF;
4059:
4060: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
4061: fnd_message.set_token('SEG_NAME',p_segment_name);

Line 4060: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4056: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4057: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);
4058: END IF;
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;

Line 4061: fnd_message.set_token('SEG_NAME',p_segment_name);

4057: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);
4058: END IF;
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:

Line 4062: fnd_message.set_token('COL_SIZE',l_application_column_size);

4058: END IF;
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:

Line 4097: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

4093: from fnd_flex_value_sets
4094: where
4095: flex_value_set_id=l_parent_value_set_id;
4096:
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;

Line 4098: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4094: where
4095: flex_value_set_id=l_parent_value_set_id;
4096:
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;

Line 4099: fnd_message.set_token('SEG_NAME',p_segment_name);

4095: flex_value_set_id=l_parent_value_set_id;
4096:
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:

Line 4100: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);

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

Line 4115: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');

4111: flex_value_set_id in (select parent_flex_value_set_id
4112: from fnd_flex_value_sets
4113: where flex_value_set_id=p_value_set_id);
4114:
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;

Line 4116: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4112: from fnd_flex_value_sets
4113: where flex_value_set_id=p_value_set_id);
4114:
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;

Line 4117: fnd_message.set_token('SEG_NAME',p_segment_name);

4113: where flex_value_set_id=p_value_set_id);
4114:
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;

Line 4118: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);

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

Line 4158: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

4154: from fnd_flex_value_sets
4155: where
4156: flex_value_set_id=l_parent_value_set_id;
4157:
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;

Line 4159: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4155: where
4156: flex_value_set_id=l_parent_value_set_id;
4157:
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;

Line 4160: fnd_message.set_token('SEG_NAME',p_segment_name);

4156: flex_value_set_id=l_parent_value_set_id;
4157:
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

Line 4161: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);

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

Line 4175: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');

4171: flex_value_set_id in (select parent_flex_value_set_id
4172: from fnd_flex_value_sets
4173: where flex_value_set_id=p_value_set_id);
4174:
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;

Line 4176: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4172: from fnd_flex_value_sets
4173: where flex_value_set_id=p_value_set_id);
4174:
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;

Line 4177: fnd_message.set_token('SEG_NAME',p_segment_name);

4173: where flex_value_set_id=p_value_set_id);
4174:
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;

Line 4178: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);

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

Line 4251: fnd_message.set_name('FND','FLEX-VSET FORMAT TYPE CONFLICT');

4247: select meaning
4248: into l_format_type_name
4249: from fnd_lookups
4250: where lookup_code=p_format_type and lookup_type='FIELD_TYPE';
4251: fnd_message.set_name('FND','FLEX-VSET FORMAT TYPE CONFLICT');
4252: ELSE
4253: select meaning
4254: into l_format_type_name
4255: from fnd_lookups

Line 4257: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');

4253: select meaning
4254: into l_format_type_name
4255: from fnd_lookups
4256: where lookup_code=p_id_column_type and lookup_type='COLUMN_TYPE';
4257: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');
4258: END IF;
4259:
4260: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4261: fnd_message.set_token('SEG_NAME',p_segment_name);

Line 4260: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);

4256: where lookup_code=p_id_column_type and lookup_type='COLUMN_TYPE';
4257: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');
4258: END IF;
4259:
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;

Line 4261: fnd_message.set_token('SEG_NAME',p_segment_name);

4257: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');
4258: END IF;
4259:
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:

Line 4262: fnd_message.set_token('FORMAT_TYPE',l_format_type_name);

4258: END IF;
4259:
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;

Line 4263: fnd_message.set_token('DATA_TYPE',l_appl_column_type_name);

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

Line 4284: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');

4280: THEN
4281:
4282: IF( p_id_column_type is NULL )
4283: THEN
4284: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4285: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);
4286: ELSE
4287: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4288: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);

Line 4285: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);

4281:
4282: IF( p_id_column_type is NULL )
4283: THEN
4284: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4285: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);
4286: ELSE
4287: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4288: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);
4289: END IF;

Line 4287: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');

4283: THEN
4284: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4285: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);
4286: ELSE
4287: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4288: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);
4289: END IF;
4290:
4291: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);

Line 4288: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);

4284: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4285: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);
4286: ELSE
4287: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4288: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);
4289: END IF;
4290:
4291: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4292: fnd_message.set_token('SEG_NAME',p_segment_name);

Line 4291: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);

4287: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4288: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);
4289: END IF;
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;

Line 4292: fnd_message.set_token('SEG_NAME',p_segment_name);

4288: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);
4289: END IF;
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:

Line 4293: fnd_message.set_token('COL_SIZE',p_application_column_size);

4289: END IF;
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;

Line 4313: fnd_message.set_name('FND','FLEX-VSET TYPE OBSOLETE');

4309: are replaced by Standard Date(X) and Standard DateTime(Y) format types.
4310: */
4311: IF(p_format_type='D' or p_format_type='T')
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;

Line 4314: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);

4310: */
4311: IF(p_format_type='D' or p_format_type='T')
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:

Line 4315: fnd_message.set_token('SEG_NAME',p_segment_name);

4311: IF(p_format_type='D' or p_format_type='T')
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;

Line 4478: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

4474: from fnd_flex_value_sets
4475: where
4476: flex_value_set_id=l_parent_value_set_id;
4477:
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;

Line 4479: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4475: where
4476: flex_value_set_id=l_parent_value_set_id;
4477:
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;

Line 4480: fnd_message.set_token('SEG_NAME',p_end_user_column_name);

4476: flex_value_set_id=l_parent_value_set_id;
4477:
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

Line 4481: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);

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

Line 4495: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');

4491: flex_value_set_id in (select parent_flex_value_set_id
4492: from fnd_flex_value_sets
4493: where flex_value_set_id=p_flex_value_set_id);
4494:
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;

Line 4496: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4492: from fnd_flex_value_sets
4493: where flex_value_set_id=p_flex_value_set_id);
4494:
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;

Line 4497: fnd_message.set_token('SEG_NAME',p_end_user_column_name);

4493: where flex_value_set_id=p_flex_value_set_id);
4494:
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;

Line 4498: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);

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

Line 4615: fnd_message.set_name('FND','FLEX-VSET IDVSET RESTRICTED');

4611: */
4612: IF(NOT(l_allow_id_valuesets = 'Y' OR
4613: (l_allow_id_valuesets = 'N' AND l_id_column_name is NULL)))
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;

Line 4616: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4612: IF(NOT(l_allow_id_valuesets = 'Y' OR
4613: (l_allow_id_valuesets = 'N' AND l_id_column_name is NULL)))
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:

Line 4617: fnd_message.set_token('SEG_NAME',p_segment_name);

4613: (l_allow_id_valuesets = 'N' AND l_id_column_name is NULL)))
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:

Line 4638: fnd_message.set_name('FND','FLEX-VSET IDVSET TR RESTRICTED');

4634: IF(NOT(l_allow_id_valuesets = 'Y' OR
4635: (l_allow_id_valuesets = 'N' AND
4636: l_validation_type <> 'X' AND l_validation_type <> 'Y')))
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;

Line 4639: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4635: (l_allow_id_valuesets = 'N' AND
4636: l_validation_type <> 'X' AND l_validation_type <> 'Y')))
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:

Line 4640: fnd_message.set_token('SEG_NAME',p_segment_name);

4636: l_validation_type <> 'X' AND l_validation_type <> 'Y')))
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:

Line 4661: fnd_message.set_name('FND','FLEX-VSET IDVSET DN RESTRICTED');

4657: ((l_format_type = 'N' AND
4658: l_number_precision IS NOT NULL AND
4659: l_number_precision = 0)))))
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;

Line 4662: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4658: l_number_precision IS NOT NULL AND
4659: l_number_precision = 0)))))
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:

Line 4663: fnd_message.set_token('SEG_NAME',p_segment_name);

4659: l_number_precision = 0)))))
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:

Line 4711: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

4707: from fnd_flex_value_sets
4708: where
4709: flex_value_set_id=l_parent_value_set_id;
4710:
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;

Line 4712: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4708: where
4709: flex_value_set_id=l_parent_value_set_id;
4710:
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;

Line 4713: fnd_message.set_token('SEG_NAME',p_segment_name);

4709: flex_value_set_id=l_parent_value_set_id;
4710:
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:

Line 4714: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);

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

Line 4729: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');

4725: flex_value_set_id in (select parent_flex_value_set_id
4726: from fnd_flex_value_sets
4727: where flex_value_set_id=p_flex_value_set_id);
4728:
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;

Line 4730: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

4726: from fnd_flex_value_sets
4727: where flex_value_set_id=p_flex_value_set_id);
4728:
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;

Line 4731: fnd_message.set_token('SEG_NAME',p_segment_name);

4727: where flex_value_set_id=p_flex_value_set_id);
4728:
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;

Line 4732: fnd_message.set_token('PARENT_VSET_NAME',l_parent_value_set_name);

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