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.AK_ATTRIBUTE_GRP dependencies on FND_API

Line 23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

19: -- Version Initial version number = 1.0
20: -- History Current version number = 1.0
21: --=======================================================
22: procedure CREATE_ATTRIBUTE (
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_api_version_number IN NUMBER,
25: p_init_msg_tbl IN BOOLEAN := FALSE,
26: p_msg_count OUT NOCOPY NUMBER,
27: p_msg_data OUT NOCOPY VARCHAR2,

Line 31: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,

27: p_msg_data OUT NOCOPY VARCHAR2,
28: p_return_status OUT NOCOPY VARCHAR2,
29: p_attribute_application_id IN NUMBER,
30: p_attribute_code IN VARCHAR2,
31: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
32: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
33: p_bold IN VARCHAR2,
34: p_italic IN VARCHAR2,
35: p_vertical_alignment IN VARCHAR2,

Line 32: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,

28: p_return_status OUT NOCOPY VARCHAR2,
29: p_attribute_application_id IN NUMBER,
30: p_attribute_code IN VARCHAR2,
31: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
32: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
33: p_bold IN VARCHAR2,
34: p_italic IN VARCHAR2,
35: p_vertical_alignment IN VARCHAR2,
36: p_horizontal_alignment IN VARCHAR2,

Line 38: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

34: p_italic IN VARCHAR2,
35: p_vertical_alignment IN VARCHAR2,
36: p_horizontal_alignment IN VARCHAR2,
37: p_data_type IN VARCHAR2,
38: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
41: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 39: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: p_vertical_alignment IN VARCHAR2,
36: p_horizontal_alignment IN VARCHAR2,
37: p_data_type IN VARCHAR2,
38: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
41: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 40: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

36: p_horizontal_alignment IN VARCHAR2,
37: p_data_type IN VARCHAR2,
38: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
41: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_item_style IN VARCHAR2,

Line 41: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

37: p_data_type IN VARCHAR2,
38: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
41: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_item_style IN VARCHAR2,
45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

Line 42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

38: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
41: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_item_style IN VARCHAR2,
45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

39: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
41: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_item_style IN VARCHAR2,
45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

41: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_item_style IN VARCHAR2,
45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

42: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_item_style IN VARCHAR2,
45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

43: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_item_style IN VARCHAR2,
45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_precision IN NUMBER := FND_API.G_MISS_NUM,

Line 48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: p_item_style IN VARCHAR2,
45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_precision IN NUMBER := FND_API.G_MISS_NUM,
52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

Line 49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_precision IN NUMBER := FND_API.G_MISS_NUM,
52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

Line 50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_precision IN NUMBER := FND_API.G_MISS_NUM,
52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
54: p_name IN VARCHAR2,

Line 51: p_precision IN NUMBER := FND_API.G_MISS_NUM,

47: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_precision IN NUMBER := FND_API.G_MISS_NUM,
52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
54: p_name IN VARCHAR2,
55: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

48: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_precision IN NUMBER := FND_API.G_MISS_NUM,
52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
54: p_name IN VARCHAR2,
55: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

49: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_precision IN NUMBER := FND_API.G_MISS_NUM,
52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
54: p_name IN VARCHAR2,
55: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 55: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

51: p_precision IN NUMBER := FND_API.G_MISS_NUM,
52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
54: p_name IN VARCHAR2,
55: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ) is
59: l_api_version_number CONSTANT number := 1.0;

Line 56: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

52: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
54: p_name IN VARCHAR2,
55: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ) is
59: l_api_version_number CONSTANT number := 1.0;
60: l_api_name CONSTANT varchar2(30) := 'Create_Attribute';

Line 57: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

53: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
54: p_name IN VARCHAR2,
55: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
58: ) is
59: l_api_version_number CONSTANT number := 1.0;
60: l_api_name CONSTANT varchar2(30) := 'Create_Attribute';
61: l_return_status VARCHAR2(1);

Line 66: IF NOT FND_API.Compatible_API_Call (

62: l_pass NUMBER := 2;
63: l_copy_redo_flag BOOLEAN := FALSE;
64: begin
65: /* Check API version number */
66: IF NOT FND_API.Compatible_API_Call (
67: l_api_version_number, p_api_version_number, l_api_name,
68: G_PKG_NAME) then
69: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: return;

Line 69: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

65: /* Check API version number */
66: IF NOT FND_API.Compatible_API_Call (
67: l_api_version_number, p_api_version_number, l_api_name,
68: G_PKG_NAME) then
69: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: return;
71: END IF;
72:
73: -- Initialize the message table if requested.

Line 126: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

122:
123: --
124: -- If API call returns with an error status...
125: --
126: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
127: (l_return_status = FND_API.G_RET_STS_ERROR) then
128: RAISE FND_API.G_EXC_ERROR;
129: end if;
130:

Line 127: (l_return_status = FND_API.G_RET_STS_ERROR) then

123: --
124: -- If API call returns with an error status...
125: --
126: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
127: (l_return_status = FND_API.G_RET_STS_ERROR) then
128: RAISE FND_API.G_EXC_ERROR;
129: end if;
130:
131: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 128: RAISE FND_API.G_EXC_ERROR;

124: -- If API call returns with an error status...
125: --
126: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
127: (l_return_status = FND_API.G_RET_STS_ERROR) then
128: RAISE FND_API.G_EXC_ERROR;
129: end if;
130:
131: p_return_status := FND_API.G_RET_STS_SUCCESS;
132:

Line 131: p_return_status := FND_API.G_RET_STS_SUCCESS;

127: (l_return_status = FND_API.G_RET_STS_ERROR) then
128: RAISE FND_API.G_EXC_ERROR;
129: end if;
130:
131: p_return_status := FND_API.G_RET_STS_SUCCESS;
132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: p_return_status := FND_API.G_RET_STS_ERROR;

Line 134: WHEN FND_API.G_EXC_ERROR THEN

130:
131: p_return_status := FND_API.G_RET_STS_SUCCESS;
132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: p_return_status := FND_API.G_RET_STS_ERROR;
136: rollback to start_create_attribute;
137: WHEN OTHERS THEN
138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 135: p_return_status := FND_API.G_RET_STS_ERROR;

131: p_return_status := FND_API.G_RET_STS_SUCCESS;
132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: p_return_status := FND_API.G_RET_STS_ERROR;
136: rollback to start_create_attribute;
137: WHEN OTHERS THEN
138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

134: WHEN FND_API.G_EXC_ERROR THEN
135: p_return_status := FND_API.G_RET_STS_ERROR;
136: rollback to start_create_attribute;
137: WHEN OTHERS THEN
138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
140: SUBSTR (SQLERRM, 1, 240) );
141: FND_MSG_PUB.Add;
142: rollback to start_create_attribute;

Line 171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

167: -- Version Initial version number = 1.0
168: -- History Current version number = 1.0
169: --=======================================================
170: procedure DELETE_ATTRIBUTE (
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_api_version_number IN NUMBER,
173: p_init_msg_tbl IN BOOLEAN := FALSE,
174: p_msg_count OUT NOCOPY NUMBER,
175: p_msg_data OUT NOCOPY VARCHAR2,

Line 188: IF NOT FND_API.Compatible_API_Call (

184: begin
185: --
186: -- Check API version number
187: --
188: IF NOT FND_API.Compatible_API_Call (
189: l_api_version_number, p_api_version_number, l_api_name,
190: G_PKG_NAME) then
191: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: return;

Line 191: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: --
188: IF NOT FND_API.Compatible_API_Call (
189: l_api_version_number, p_api_version_number, l_api_name,
190: G_PKG_NAME) then
191: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: return;
193: END IF;
194:
195: -- Initialize the message table if requested.

Line 220: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

216:
217: --
218: -- If API call returns with an error status...
219: --
220: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
221: (l_return_status = FND_API.G_RET_STS_ERROR) then
222: RAISE FND_API.G_EXC_ERROR;
223: end if;
224:

Line 221: (l_return_status = FND_API.G_RET_STS_ERROR) then

217: --
218: -- If API call returns with an error status...
219: --
220: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
221: (l_return_status = FND_API.G_RET_STS_ERROR) then
222: RAISE FND_API.G_EXC_ERROR;
223: end if;
224:
225: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 222: RAISE FND_API.G_EXC_ERROR;

218: -- If API call returns with an error status...
219: --
220: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
221: (l_return_status = FND_API.G_RET_STS_ERROR) then
222: RAISE FND_API.G_EXC_ERROR;
223: end if;
224:
225: p_return_status := FND_API.G_RET_STS_SUCCESS;
226:

Line 225: p_return_status := FND_API.G_RET_STS_SUCCESS;

221: (l_return_status = FND_API.G_RET_STS_ERROR) then
222: RAISE FND_API.G_EXC_ERROR;
223: end if;
224:
225: p_return_status := FND_API.G_RET_STS_SUCCESS;
226:
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: p_return_status := FND_API.G_RET_STS_ERROR;

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224:
225: p_return_status := FND_API.G_RET_STS_SUCCESS;
226:
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: p_return_status := FND_API.G_RET_STS_ERROR;
230: rollback to start_delete_attribute;
231: WHEN OTHERS THEN
232: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 229: p_return_status := FND_API.G_RET_STS_ERROR;

225: p_return_status := FND_API.G_RET_STS_SUCCESS;
226:
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: p_return_status := FND_API.G_RET_STS_ERROR;
230: rollback to start_delete_attribute;
231: WHEN OTHERS THEN
232: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 232: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: WHEN FND_API.G_EXC_ERROR THEN
229: p_return_status := FND_API.G_RET_STS_ERROR;
230: rollback to start_delete_attribute;
231: WHEN OTHERS THEN
232: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
234: SUBSTR (SQLERRM, 1, 240) );
235: FND_MSG_PUB.Add;
236: rollback to start_delete_attribute;

Line 280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

276: -- Version Initial version number = 1.0
277: -- History Current version number = 1.0
278: --=======================================================
279: procedure DOWNLOAD_ATTRIBUTE (
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: p_api_version_number IN NUMBER,
282: p_init_msg_tbl IN BOOLEAN := FALSE,
283: p_msg_count OUT NOCOPY NUMBER,
284: p_msg_data OUT NOCOPY VARCHAR2,

Line 286: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,

282: p_init_msg_tbl IN BOOLEAN := FALSE,
283: p_msg_count OUT NOCOPY NUMBER,
284: p_msg_data OUT NOCOPY VARCHAR2,
285: p_return_status OUT NOCOPY VARCHAR2,
286: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
288: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type :=
290: AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL

Line 287: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

283: p_msg_count OUT NOCOPY NUMBER,
284: p_msg_data OUT NOCOPY VARCHAR2,
285: p_return_status OUT NOCOPY VARCHAR2,
286: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
288: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type :=
290: AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL
291: ) is

Line 288: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

284: p_msg_data OUT NOCOPY VARCHAR2,
285: p_return_status OUT NOCOPY VARCHAR2,
286: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
288: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type :=
290: AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL
291: ) is
292: l_api_version_number CONSTANT number := 1.0;

Line 304: IF NOT FND_API.Compatible_API_Call (

300: begin
301: --
302: -- Check verion number
303: --
304: IF NOT FND_API.Compatible_API_Call (
305: l_api_version_number, p_api_version_number, l_api_name,
306: G_PKG_NAME) then
307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: return;

Line 307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

303: --
304: IF NOT FND_API.Compatible_API_Call (
305: l_api_version_number, p_api_version_number, l_api_name,
306: G_PKG_NAME) then
307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: return;
309: END IF;
310:
311: -- Initialize the message table if requested.

Line 345: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

341: end if;
342: --
343: -- If API call returns with an error status...
344: --
345: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
346: (l_return_status = FND_API.G_RET_STS_ERROR) then
347: RAISE FND_API.G_EXC_ERROR;
348: end if;
349:

Line 346: (l_return_status = FND_API.G_RET_STS_ERROR) then

342: --
343: -- If API call returns with an error status...
344: --
345: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
346: (l_return_status = FND_API.G_RET_STS_ERROR) then
347: RAISE FND_API.G_EXC_ERROR;
348: end if;
349:
350: --

Line 347: RAISE FND_API.G_EXC_ERROR;

343: -- If API call returns with an error status...
344: --
345: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
346: (l_return_status = FND_API.G_RET_STS_ERROR) then
347: RAISE FND_API.G_EXC_ERROR;
348: end if;
349:
350: --
351: -- - call the download procedure for attributes to retrieve the

Line 368: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

364: --
365: -- If download call returns with an error status or
366: -- download failed to retrieve any information from the database..
367: --
368: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
369: (l_return_status = FND_API.G_RET_STS_ERROR) then
370: RAISE FND_API.G_EXC_ERROR;
371: end if;
372:

Line 369: (l_return_status = FND_API.G_RET_STS_ERROR) then

365: -- If download call returns with an error status or
366: -- download failed to retrieve any information from the database..
367: --
368: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
369: (l_return_status = FND_API.G_RET_STS_ERROR) then
370: RAISE FND_API.G_EXC_ERROR;
371: end if;
372:
373: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 370: RAISE FND_API.G_EXC_ERROR;

366: -- download failed to retrieve any information from the database..
367: --
368: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
369: (l_return_status = FND_API.G_RET_STS_ERROR) then
370: RAISE FND_API.G_EXC_ERROR;
371: end if;
372:
373: p_return_status := FND_API.G_RET_STS_SUCCESS;
374:

Line 373: p_return_status := FND_API.G_RET_STS_SUCCESS;

369: (l_return_status = FND_API.G_RET_STS_ERROR) then
370: RAISE FND_API.G_EXC_ERROR;
371: end if;
372:
373: p_return_status := FND_API.G_RET_STS_SUCCESS;
374:
375: FND_MSG_PUB.Count_And_Get (
376: p_count => p_msg_count,
377: p_data => p_msg_data);

Line 380: WHEN FND_API.G_EXC_ERROR THEN

376: p_count => p_msg_count,
377: p_data => p_msg_data);
378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: p_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get (
383: p_count => p_msg_count,
384: p_data => p_msg_data);

Line 381: p_return_status := FND_API.G_RET_STS_ERROR;

377: p_data => p_msg_data);
378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: p_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get (
383: p_count => p_msg_count,
384: p_data => p_msg_data);
385: WHEN OTHERS THEN

Line 386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: FND_MSG_PUB.Count_And_Get (
383: p_count => p_msg_count,
384: p_data => p_msg_data);
385: WHEN OTHERS THEN
386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
388: SUBSTR (SQLERRM, 1, 240) );
389: FND_MSG_PUB.Add;
390: FND_MSG_PUB.Count_And_Get (

Line 415: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

411: -- Version Initial version number = 1.0
412: -- History Current version number = 1.0
413: --=======================================================
414: procedure UPDATE_ATTRIBUTE (
415: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: p_api_version_number IN NUMBER,
417: p_init_msg_tbl IN BOOLEAN := FALSE,
418: p_msg_count OUT NOCOPY NUMBER,
419: p_msg_data OUT NOCOPY VARCHAR2,

Line 423: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,

419: p_msg_data OUT NOCOPY VARCHAR2,
420: p_return_status OUT NOCOPY VARCHAR2,
421: p_attribute_application_id IN NUMBER,
422: p_attribute_code IN VARCHAR2,
423: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
425: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 424: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,

420: p_return_status OUT NOCOPY VARCHAR2,
421: p_attribute_application_id IN NUMBER,
422: p_attribute_code IN VARCHAR2,
423: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
425: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 425: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,

421: p_attribute_application_id IN NUMBER,
422: p_attribute_code IN VARCHAR2,
423: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
425: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

422: p_attribute_code IN VARCHAR2,
423: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
425: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

423: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
424: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
425: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

424: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
425: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

425: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

Line 430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

426: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

427: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

428: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_item_style IN VARCHAR2,

Line 433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

429: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_item_style IN VARCHAR2,
437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

Line 434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

430: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_item_style IN VARCHAR2,
437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

431: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_item_style IN VARCHAR2,
437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

433: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_item_style IN VARCHAR2,
437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

434: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_item_style IN VARCHAR2,
437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

435: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_item_style IN VARCHAR2,
437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_precision IN NUMBER := FND_API.G_MISS_NUM,

Line 440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

436: p_item_style IN VARCHAR2,
437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_precision IN NUMBER := FND_API.G_MISS_NUM,
444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

Line 441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

437: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_precision IN NUMBER := FND_API.G_MISS_NUM,
444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

Line 442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

438: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_precision IN NUMBER := FND_API.G_MISS_NUM,
444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 443: p_precision IN NUMBER := FND_API.G_MISS_NUM,

439: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_precision IN NUMBER := FND_API.G_MISS_NUM,
444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

440: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_precision IN NUMBER := FND_API.G_MISS_NUM,
444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

441: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_precision IN NUMBER := FND_API.G_MISS_NUM,
444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

442: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_precision IN NUMBER := FND_API.G_MISS_NUM,
444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
450: ) is

Line 447: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

443: p_precision IN NUMBER := FND_API.G_MISS_NUM,
444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
450: ) is
451: l_api_version_number CONSTANT number := 1.0;

Line 448: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

444: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
450: ) is
451: l_api_version_number CONSTANT number := 1.0;
452: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';

Line 449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

445: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
446: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
450: ) is
451: l_api_version_number CONSTANT number := 1.0;
452: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';
453: l_return_status VARCHAR2(1);

Line 460: IF NOT FND_API.Compatible_API_Call (

456: begin
457: --
458: -- Check API version number
459: --
460: IF NOT FND_API.Compatible_API_Call (
461: l_api_version_number, p_api_version_number, l_api_name,
462: G_PKG_NAME) then
463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: return;

Line 463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459: --
460: IF NOT FND_API.Compatible_API_Call (
461: l_api_version_number, p_api_version_number, l_api_name,
462: G_PKG_NAME) then
463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: return;
465: END IF;
466:
467: -- Initialize the message table if requested.

Line 520: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

516:
517: --
518: -- If API call returns with an error status...
519: --
520: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
521: (l_return_status = FND_API.G_RET_STS_ERROR) then
522: --dbms_output.put_line('Update_Attribute failed');
523: RAISE FND_API.G_EXC_ERROR;
524: end if;

Line 521: (l_return_status = FND_API.G_RET_STS_ERROR) then

517: --
518: -- If API call returns with an error status...
519: --
520: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
521: (l_return_status = FND_API.G_RET_STS_ERROR) then
522: --dbms_output.put_line('Update_Attribute failed');
523: RAISE FND_API.G_EXC_ERROR;
524: end if;
525:

Line 523: RAISE FND_API.G_EXC_ERROR;

519: --
520: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
521: (l_return_status = FND_API.G_RET_STS_ERROR) then
522: --dbms_output.put_line('Update_Attribute failed');
523: RAISE FND_API.G_EXC_ERROR;
524: end if;
525:
526: p_return_status := FND_API.G_RET_STS_SUCCESS;
527:

Line 526: p_return_status := FND_API.G_RET_STS_SUCCESS;

522: --dbms_output.put_line('Update_Attribute failed');
523: RAISE FND_API.G_EXC_ERROR;
524: end if;
525:
526: p_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: p_return_status := FND_API.G_RET_STS_ERROR;

Line 529: WHEN FND_API.G_EXC_ERROR THEN

525:
526: p_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: p_return_status := FND_API.G_RET_STS_ERROR;
531: rollback to start_update_attribute;
532: WHEN OTHERS THEN
533: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 530: p_return_status := FND_API.G_RET_STS_ERROR;

526: p_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: p_return_status := FND_API.G_RET_STS_ERROR;
531: rollback to start_update_attribute;
532: WHEN OTHERS THEN
533: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
534: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 533: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

529: WHEN FND_API.G_EXC_ERROR THEN
530: p_return_status := FND_API.G_RET_STS_ERROR;
531: rollback to start_update_attribute;
532: WHEN OTHERS THEN
533: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
534: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
535: SUBSTR (SQLERRM, 1, 240) );
536: FND_MSG_PUB.Add;
537: rollback to start_update_attribute;