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 FND_MESSAGE

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

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

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

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

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

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

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

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

Line 1729: fnd_message.set_name('FND','FLEX-Bad DateTime 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');
1730: app_exception.raise_exception;
1731: END IF;
1732: ELSIF(valueset_r.format_type = 't') THEN
1733: IF (maxsize NOT IN (5,8)) THEN

Line 1734: fnd_message.set_name('FND','FLEX-Bad Time 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');
1735: app_exception.raise_exception;
1736: END IF;
1737: ELSIF(valueset_r.format_type = 'N') THEN
1738: IF (maxsize > 38) THEN

Line 1739: fnd_message.set_name('FND','FLEX-Bad Num 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');
1740: app_exception.raise_exception;
1741: END IF;
1742: END IF;
1743:

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

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

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

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

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

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

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

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

Line 3044: fnd_message.get());

3040:
3041: IF (NOT l_success) THEN
3042: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3043: 'Value validation failed with the error message: ' ||
3044: fnd_message.get());
3045: END IF;
3046:
3047: -- Populate the l_value, by default everything is NULL.
3048:

Line 3150: fnd_message.get());

3146:
3147: IF (NOT l_success) THEN
3148: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3149: 'Value validation failed with the error message: ' ||
3150: fnd_message.get());
3151: END IF;
3152:
3153: -- Populate the l_value, by default everything is NULL.
3154:

Line 3284: fnd_message.get());

3280:
3281: IF (NOT l_success) THEN
3282: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3283: 'Value validation failed with the error message: ' ||
3284: fnd_message.get());
3285: END IF;
3286:
3287: -- Update fields
3288:

Line 3393: fnd_message.get());

3389:
3390: IF (NOT l_success) THEN
3391: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3392: 'Value validation failed with the error message: ' ||
3393: fnd_message.get());
3394: END IF;
3395:
3396: -- Update fields
3397:

Line 3480: fnd_message.get());

3476:
3477: IF (NOT l_success) THEN
3478: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3479: 'Low Value validation failed with the error message: ' ||
3480: fnd_message.get());
3481: END IF;
3482:
3483:
3484: -- Validate the child value high

Line 3505: fnd_message.get());

3501:
3502: IF (NOT l_success) THEN
3503: raise_error(ERROR_VALUE_VALIDATION_FAILED,
3504: 'High Value validation failed with the error message: ' ||
3505: fnd_message.get());
3506: END IF;
3507:
3508: -- Make sure the order in Low and High Values
3509: IF (l_storage_value_low > l_storage_value_high) THEN

Line 3615: fnd_message.get());

3611: WHEN OTHERS THEN
3612: raise_error(ERROR_UNABLE_TO_SUBMIT_FDFCHY,
3613: 'Unable to submit FDFCHY request for flex value set: ' ||
3614: p_flex_value_set_name || '. Error: ' ||
3615: fnd_message.get());
3616: END;
3617:
3618: IF (l_request_id = 0) THEN
3619: raise_error(ERROR_UNABLE_TO_SUBMIT_FDFCHY,

Line 3622: fnd_message.get());

3618: IF (l_request_id = 0) THEN
3619: raise_error(ERROR_UNABLE_TO_SUBMIT_FDFCHY,
3620: 'Unable to submit FDFCHY request for flex value set: ' ||
3621: p_flex_value_set_name || '. Error: ' ||
3622: fnd_message.get());
3623: END IF;
3624:
3625: x_request_id := l_request_id;
3626:

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

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

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

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

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

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

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

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

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

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

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

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

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

3814: IF(NOT(p_allow_id_valuesets = 'Y' OR
3815: (p_allow_id_valuesets = 'N' AND
3816: l_validation_type <> 'X' AND l_validation_type <> 'Y')))
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;

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

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

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

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

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

3837: ((l_format_type = 'N' AND
3838: l_number_precision IS NOT NULL AND
3839: l_number_precision = 0)))))
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;

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

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

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

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

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

3887: select meaning
3888: into l_format_type_name
3889: from fnd_lookups
3890: where lookup_code=l_format_type and lookup_type='FIELD_TYPE';
3891: fnd_message.set_name('FND','FLEX-VSET FORMAT TYPE CONFLICT');
3892: ELSE
3893: select meaning
3894: into l_format_type_name
3895: from fnd_lookups

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

3893: select meaning
3894: into l_format_type_name
3895: from fnd_lookups
3896: where lookup_code=l_id_column_type and lookup_type='COLUMN_TYPE';
3897: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');
3898: END IF;
3899:
3900: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3901: fnd_message.set_token('SEG_NAME',p_segment_name);

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

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

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

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

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

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

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

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

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

3921: THEN
3922:
3923: IF( l_id_column_type is NULL )
3924: THEN
3925: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
3926: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);
3927: ELSE
3928: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
3929: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);

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

3922:
3923: IF( l_id_column_type is NULL )
3924: THEN
3925: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
3926: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);
3927: ELSE
3928: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
3929: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);
3930: END IF;

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

3924: THEN
3925: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
3926: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);
3927: ELSE
3928: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
3929: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);
3930: END IF;
3931:
3932: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

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

3925: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
3926: fnd_message.set_token('VSET_MAXSIZE',l_maximum_size);
3927: ELSE
3928: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
3929: fnd_message.set_token('ID_COL_SIZE',l_id_column_size);
3930: END IF;
3931:
3932: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);
3933: fnd_message.set_token('SEG_NAME',p_segment_name);

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

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

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

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

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

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

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

3965: from fnd_flex_value_sets
3966: where
3967: flex_value_set_id=l_parent_value_set_id;
3968:
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;

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

3966: where
3967: flex_value_set_id=l_parent_value_set_id;
3968:
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;

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

3967: flex_value_set_id=l_parent_value_set_id;
3968:
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:

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

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

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

3983: flex_value_set_id in (select parent_flex_value_set_id
3984: from fnd_flex_value_sets
3985: where flex_value_set_id=p_value_set_id);
3986:
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;

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

3984: from fnd_flex_value_sets
3985: where flex_value_set_id=p_value_set_id);
3986:
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;

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

3985: where flex_value_set_id=p_value_set_id);
3986:
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;

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

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

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

4026: from fnd_flex_value_sets
4027: where
4028: flex_value_set_id=l_parent_value_set_id;
4029:
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;

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

4027: where
4028: flex_value_set_id=l_parent_value_set_id;
4029:
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;

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

4028: flex_value_set_id=l_parent_value_set_id;
4029:
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

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

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

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

4043: flex_value_set_id in (select parent_flex_value_set_id
4044: from fnd_flex_value_sets
4045: where flex_value_set_id=p_value_set_id);
4046:
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;

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

4044: from fnd_flex_value_sets
4045: where flex_value_set_id=p_value_set_id);
4046:
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;

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

4045: where flex_value_set_id=p_value_set_id);
4046:
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;

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

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

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

4119: select meaning
4120: into l_format_type_name
4121: from fnd_lookups
4122: where lookup_code=p_format_type and lookup_type='FIELD_TYPE';
4123: fnd_message.set_name('FND','FLEX-VSET FORMAT TYPE CONFLICT');
4124: ELSE
4125: select meaning
4126: into l_format_type_name
4127: from fnd_lookups

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

4125: select meaning
4126: into l_format_type_name
4127: from fnd_lookups
4128: where lookup_code=p_id_column_type and lookup_type='COLUMN_TYPE';
4129: fnd_message.set_name('FND','FLEX-VSET ID COL TYPE CONFLICT');
4130: END IF;
4131:
4132: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4133: fnd_message.set_token('SEG_NAME',p_segment_name);

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

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

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

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

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

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

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

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

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

4152: THEN
4153:
4154: IF( p_id_column_type is NULL )
4155: THEN
4156: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4157: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);
4158: ELSE
4159: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4160: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);

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

4153:
4154: IF( p_id_column_type is NULL )
4155: THEN
4156: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4157: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);
4158: ELSE
4159: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4160: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);
4161: END IF;

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

4155: THEN
4156: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4157: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);
4158: ELSE
4159: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4160: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);
4161: END IF;
4162:
4163: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);

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

4156: fnd_message.set_name('FND','FLEX-VSET MAX SIZE');
4157: fnd_message.set_token('VSET_MAXSIZE',p_maximum_size);
4158: ELSE
4159: fnd_message.set_name('FND','FLEX-VSET ID COL SIZE');
4160: fnd_message.set_token('ID_COL_SIZE',p_id_column_size);
4161: END IF;
4162:
4163: fnd_message.set_token('VSET_NAME',p_flex_value_set_name);
4164: fnd_message.set_token('SEG_NAME',p_segment_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

4346: from fnd_flex_value_sets
4347: where
4348: flex_value_set_id=l_parent_value_set_id;
4349:
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;

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

4347: where
4348: flex_value_set_id=l_parent_value_set_id;
4349:
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;

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

4348: flex_value_set_id=l_parent_value_set_id;
4349:
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

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

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

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

4363: flex_value_set_id in (select parent_flex_value_set_id
4364: from fnd_flex_value_sets
4365: where flex_value_set_id=p_flex_value_set_id);
4366:
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;

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

4364: from fnd_flex_value_sets
4365: where flex_value_set_id=p_flex_value_set_id);
4366:
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;

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

4365: where flex_value_set_id=p_flex_value_set_id);
4366:
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;

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

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

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

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

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

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

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

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

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

4506: IF(NOT(l_allow_id_valuesets = 'Y' OR
4507: (l_allow_id_valuesets = 'N' AND
4508: l_validation_type <> 'X' AND l_validation_type <> 'Y')))
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;

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

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

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

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

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

4529: ((l_format_type = 'N' AND
4530: l_number_precision IS NOT NULL AND
4531: l_number_precision = 0)))))
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;

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

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

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

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

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

4579: from fnd_flex_value_sets
4580: where
4581: flex_value_set_id=l_parent_value_set_id;
4582:
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;

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

4580: where
4581: flex_value_set_id=l_parent_value_set_id;
4582:
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;

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

4581: flex_value_set_id=l_parent_value_set_id;
4582:
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:

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

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

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

4597: flex_value_set_id in (select parent_flex_value_set_id
4598: from fnd_flex_value_sets
4599: where flex_value_set_id=p_flex_value_set_id);
4600:
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;

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

4598: from fnd_flex_value_sets
4599: where flex_value_set_id=p_flex_value_set_id);
4600:
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;

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

4599: where flex_value_set_id=p_flex_value_set_id);
4600:
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;

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

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