DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on FND_MESSAGE

Line 2656: fnd_message.set_name('HXC', 'HXC_------INVALID_SQL_STATMENT');

2652: return (l_stmt);
2653:
2654: exception
2655: when others then
2656: fnd_message.set_name('HXC', 'HXC_------INVALID_SQL_STATMENT');
2657: fnd_message.raise_error;
2658: return ( null );
2659:
2660: END make_stmt;

Line 2657: fnd_message.raise_error;

2653:
2654: exception
2655: when others then
2656: fnd_message.set_name('HXC', 'HXC_------INVALID_SQL_STATMENT');
2657: fnd_message.raise_error;
2658: return ( null );
2659:
2660: END make_stmt;
2661:

Line 2814: fnd_message.set_name('HXC', 'HXC_------INVALID_ID_COL_TYPE');

2810: return l_id_col_type_return;
2811:
2812: exception
2813: when others then
2814: fnd_message.set_name('HXC', 'HXC_------INVALID_ID_COL_TYPE');
2815: fnd_message.raise_error;
2816: return ( null );
2817:
2818:

Line 2815: fnd_message.raise_error;

2811:
2812: exception
2813: when others then
2814: fnd_message.set_name('HXC', 'HXC_------INVALID_ID_COL_TYPE');
2815: fnd_message.raise_error;
2816: return ( null );
2817:
2818:
2819: END get_vset_id_col_type;

Line 2852: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');

2848: l_prompt);
2849:
2850:
2851: IF l_alias_type <> 'VALUE_SET_TABLE' THEN
2852: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');
2853: fnd_message.raise_error;
2854: END IF;
2855:
2856: -- call the FND package to get the SQL

Line 2853: fnd_message.raise_error;

2849:
2850:
2851: IF l_alias_type <> 'VALUE_SET_TABLE' THEN
2852: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');
2853: fnd_message.raise_error;
2854: END IF;
2855:
2856: -- call the FND package to get the SQL
2857: if l_reference_object is not null THEN

Line 2861: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');

2857: if l_reference_object is not null THEN
2858: x_select := make_stmt (l_reference_object,l_alias_type);
2859: p_id_type := get_vset_id_col_type(l_reference_object);
2860: ELSE
2861: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');
2862: fnd_message.raise_error;
2863: END IF;
2864:
2865: -- before sending back the information we do the profile replacement

Line 2862: fnd_message.raise_error;

2858: x_select := make_stmt (l_reference_object,l_alias_type);
2859: p_id_type := get_vset_id_col_type(l_reference_object);
2860: ELSE
2861: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');
2862: fnd_message.raise_error;
2863: END IF;
2864:
2865: -- before sending back the information we do the profile replacement
2866: -- x_select := replace_profile(x_select,p_block_name);

Line 2898: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');

2894: l_prompt);
2895:
2896:
2897: IF l_alias_type <> 'VALUE_SET_INDEPENDENT' THEN
2898: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');
2899: fnd_message.raise_error;
2900: END IF;
2901:
2902: -- call the FND package to get the SQL

Line 2899: fnd_message.raise_error;

2895:
2896:
2897: IF l_alias_type <> 'VALUE_SET_INDEPENDENT' THEN
2898: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');
2899: fnd_message.raise_error;
2900: END IF;
2901:
2902: -- call the FND package to get the SQL
2903: if l_reference_object is not null THEN

Line 2906: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');

2902: -- call the FND package to get the SQL
2903: if l_reference_object is not null THEN
2904: x_select := make_stmt (l_reference_object,l_alias_type);
2905: ELSE
2906: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');
2907: fnd_message.raise_error;
2908: END IF;
2909:
2910: END get_vset_indep_type_select;

Line 2907: fnd_message.raise_error;

2903: if l_reference_object is not null THEN
2904: x_select := make_stmt (l_reference_object,l_alias_type);
2905: ELSE
2906: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');
2907: fnd_message.raise_error;
2908: END IF;
2909:
2910: END get_vset_indep_type_select;
2911:

Line 2988: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');

2984: l_prompt);
2985:
2986:
2987: IF l_alias_type <> 'VALUE_SET_NONE' THEN
2988: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');
2989: fnd_message.raise_error;
2990: END IF;
2991:
2992: -- call the FND package to get the property

Line 2989: fnd_message.raise_error;

2985:
2986:
2987: IF l_alias_type <> 'VALUE_SET_NONE' THEN
2988: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');
2989: fnd_message.raise_error;
2990: END IF;
2991:
2992: -- call the FND package to get the property
2993: if l_reference_object is not null THEN

Line 2999: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');

2995: FETCH c_vset_none_info
2996: into p_format_type,p_maximum_size,p_minimum_value,p_maximum_value,p_number_precision;
2997: CLOSE c_vset_none_info;
2998: ELSE
2999: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');
3000: fnd_message.raise_error;
3001: END IF;
3002:
3003: END get_vset_none_type_property;

Line 3000: fnd_message.raise_error;

2996: into p_format_type,p_maximum_size,p_minimum_value,p_maximum_value,p_number_precision;
2997: CLOSE c_vset_none_info;
2998: ELSE
2999: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');
3000: fnd_message.raise_error;
3001: END IF;
3002:
3003: END get_vset_none_type_property;
3004:

Line 3036: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');

3032:
3033:
3034:
3035: IF l_alias_type <> 'OTL_ALT_DDF' THEN
3036: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');
3037: fnd_message.raise_error;
3038: END IF;
3039:
3040: -- call the FND package to get the SQL

Line 3037: fnd_message.raise_error;

3033:
3034:
3035: IF l_alias_type <> 'OTL_ALT_DDF' THEN
3036: fnd_message.set_name('HXC', 'HXC_------_INVALID_ALIAS_TYPE');
3037: fnd_message.raise_error;
3038: END IF;
3039:
3040: -- call the FND package to get the SQL
3041: IF l_reference_object is not null THEN --and p_timekeeper_person_type <> 'CWK' THEN

Line 3227: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');

3223: ' and nvl(hav.date_to,hr_general.end_of_time) >=fnd_profile.value(''OTL_TK_START_DATE'') ';
3224: END IF;
3225:
3226: ELSE
3227: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');
3228: fnd_message.raise_error;
3229: END IF;
3230:
3231: --if g_debug then

Line 3228: fnd_message.raise_error;

3224: END IF;
3225:
3226: ELSE
3227: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');
3228: fnd_message.raise_error;
3229: END IF;
3230:
3231: --if g_debug then
3232: --hr_utility.trace('x_select'||x_select);

Line 5085: -- fnd_message.set_name('HXC', 'HXC_ALIAS_DEF_NOT_FOUND');

5081:
5082: END LOOP;
5083:
5084: --IF not(l_found) THEN
5085: -- fnd_message.set_name('HXC', 'HXC_ALIAS_DEF_NOT_FOUND');
5086: -- fnd_msg_pub.add;
5087: --END IF;
5088:
5089: return l_alias_definition;

Line 5114: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_TYPE_ID');

5110: FETCH csr_bld_blk_id INTO l_type_id;
5111:
5112: IF csr_bld_blk_id%NOTFOUND THEN
5113: CLOSE csr_bld_blk_id;
5114: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_TYPE_ID');
5115: fnd_msg_pub.add;
5116:
5117: END IF;
5118:

Line 5125: fnd_message.set_name('HXC', 'HXC_ALIAS_EXCEPTION');

5121: RETURN l_type_id;
5122:
5123: EXCEPTION
5124: WHEN OTHERS THEN
5125: fnd_message.set_name('HXC', 'HXC_ALIAS_EXCEPTION');
5126: fnd_msg_pub.add;
5127:
5128:
5129: