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_PVT dependencies on FND_API

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

32: -- Version Initial version number = 1.0
33: -- History Current version number = 1.0
34: --=======================================================
35: function VALIDATE_ATTRIBUTE (
36: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37: p_api_version_number IN NUMBER,
38: p_return_status OUT NOCOPY VARCHAR2,
39: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
40: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 39: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

35: function VALIDATE_ATTRIBUTE (
36: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37: p_api_version_number IN NUMBER,
38: p_return_status OUT NOCOPY VARCHAR2,
39: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
40: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
42: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 40: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37: p_api_version_number IN NUMBER,
38: p_return_status OUT NOCOPY VARCHAR2,
39: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
40: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
42: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

37: p_api_version_number IN NUMBER,
38: p_return_status OUT NOCOPY VARCHAR2,
39: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
40: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
42: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

38: p_return_status OUT NOCOPY VARCHAR2,
39: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
40: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
42: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

39: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
40: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
42: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

40: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
42: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

41: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
42: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

42: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

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

43: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

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

44: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

45: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

46: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

47: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

48: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
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_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
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 54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

50: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
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: p_caller IN VARCHAR2,

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

51: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
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: p_caller IN VARCHAR2,
59: p_pass IN NUMBER := 2

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

52: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
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: p_caller IN VARCHAR2,
59: p_pass IN NUMBER := 2
60: ) return BOOLEAN is

Line 57: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

53: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
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: p_caller IN VARCHAR2,
59: p_pass IN NUMBER := 2
60: ) return BOOLEAN is
61: l_api_version_number CONSTANT number := 1.0;

Line 66: IF NOT FND_API.Compatible_API_Call (

62: l_api_name CONSTANT varchar2(30) := 'Validate_Attribute';
63: l_error BOOLEAN;
64: l_return_status VARCHAR2(1);
65: begin
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 FALSE;

Line 69: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

65: begin
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 FALSE;
71: END IF;
72:
73: l_error := FALSE;

Line 77: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then

73: l_error := FALSE;
74: --
75: -- if validation level is none, no validation is necessary
76: --
77: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
78: p_return_status := FND_API.G_RET_STS_SUCCESS;
79: return TRUE;
80: end if;
81:

Line 78: p_return_status := FND_API.G_RET_STS_SUCCESS;

74: --
75: -- if validation level is none, no validation is necessary
76: --
77: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
78: p_return_status := FND_API.G_RET_STS_SUCCESS;
79: return TRUE;
80: end if;
81:
82: --

Line 86: (p_attribute_application_id = FND_API.G_MISS_NUM)) then

82: --
83: -- check that key columns are not null and not missing
84: --
85: if ((p_attribute_application_id is null) or
86: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
87: l_error := TRUE;
88: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
89: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
90: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

Line 96: (p_attribute_code = FND_API.G_MISS_CHAR)) then

92: end if;
93: end if;
94:
95: if ((p_attribute_code is null) or
96: (p_attribute_code = FND_API.G_MISS_CHAR)) then
97: l_error := TRUE;
98: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
99: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
100: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

Line 108: (p_bold = FND_API.G_MISS_CHAR and

104:
105: /*** check that required columns are not null and, unless calling ***/
106: /*** from UPDATE procedure, the columns are not missing ***/
107: if ((p_bold is null) or
108: (p_bold = FND_API.G_MISS_CHAR and
109: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
110: l_error := TRUE;
111: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
112: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

Line 119: (p_italic = FND_API.G_MISS_CHAR and

115: end if;
116: end if;
117:
118: if ((p_italic is null) or
119: (p_italic = FND_API.G_MISS_CHAR and
120: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
121: l_error := TRUE;
122: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
123: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

Line 130: (p_vertical_alignment = FND_API.G_MISS_CHAR and

126: end if;
127: end if;
128:
129: if ((p_vertical_alignment is null) or
130: (p_vertical_alignment = FND_API.G_MISS_CHAR and
131: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
132: then
133: l_error := TRUE;
134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

Line 142: (p_horizontal_alignment = FND_API.G_MISS_CHAR and

138: end if;
139: end if;
140:
141: if ((p_horizontal_alignment is null) or
142: (p_horizontal_alignment = FND_API.G_MISS_CHAR and
143: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
144: then
145: l_error := TRUE;
146: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

Line 154: (p_data_type = FND_API.G_MISS_CHAR and

150: end if;
151: end if;
152:
153: if ((p_data_type is null) or
154: (p_data_type = FND_API.G_MISS_CHAR and
155: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
156: l_error := TRUE;
157: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
158: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

Line 165: (p_name = FND_API.G_MISS_CHAR and

161: end if;
162: end if;
163:
164: if ((p_name is null) or
165: (p_name = FND_API.G_MISS_CHAR and
166: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
167: l_error := TRUE;
168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
169: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

Line 178: if (p_attribute_application_id <> FND_API.G_MISS_NUM) then

174:
175: --*** Validate columns ***
176:
177: -- - application ID
178: if (p_attribute_application_id <> FND_API.G_MISS_NUM) then
179: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
180: p_api_version_number => 1.0,
181: p_return_status => l_return_status,
182: p_application_id => p_attribute_application_id)

Line 194: if (p_data_type <> FND_API.G_MISS_CHAR) then

190: end if;
191: end if;
192:
193: -- - data type
194: if (p_data_type <> FND_API.G_MISS_CHAR) then
195: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
196: p_api_version_number => 1.0,
197: p_return_status => l_return_status,
198: p_lookup_type => 'DATA_TYPE',

Line 210: if (p_bold <> FND_API.G_MISS_CHAR) then

206: end if;
207: end if;
208:
209: -- - bold
210: if (p_bold <> FND_API.G_MISS_CHAR) then
211: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
212: l_error := TRUE;
213: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
214: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

Line 222: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) then

218: end if;
219: end if;
220:
221: -- - upper_case_flag
222: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) then
223: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_upper_case_flag)) then
224: l_error := TRUE;
225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
226: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

Line 234: if (p_italic <> FND_API.G_MISS_CHAR) then

230: end if;
231: end if;
232:
233: -- - italic
234: if (p_italic <> FND_API.G_MISS_CHAR) then
235: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
236: l_error := TRUE;
237: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
238: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

Line 246: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then

242: end if;
243: end if;
244:
245: -- - vertical alignment
246: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
247: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
248: p_api_version_number => 1.0,
249: p_return_status => l_return_status,
250: p_lookup_type => 'VERTICAL_ALIGNMENT',

Line 262: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then

258: end if;
259: end if;
260:
261: /* - horizontal alignment */
262: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
263: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
264: p_api_version_number => 1.0,
265: p_return_status => l_return_status,
266: p_lookup_type => 'HORIZONTAL_ALIGNMENT',

Line 279: if ( (p_lov_region_application_id <> FND_API.G_MISS_NUM) and

275: end if;
276: end if;
277:
278: -- - lov_region_application_id and lov_region_code
279: if ( (p_lov_region_application_id <> FND_API.G_MISS_NUM) and
280: (p_lov_region_application_id is not null) ) or
281: ( (p_lov_region_code <> FND_API.G_MISS_CHAR) and
282: (p_lov_region_code is not null) )then
283: if (NOT AK_REGION_PVT.REGION_EXISTS (

Line 281: ( (p_lov_region_code <> FND_API.G_MISS_CHAR) and

277:
278: -- - lov_region_application_id and lov_region_code
279: if ( (p_lov_region_application_id <> FND_API.G_MISS_NUM) and
280: (p_lov_region_application_id is not null) ) or
281: ( (p_lov_region_code <> FND_API.G_MISS_CHAR) and
282: (p_lov_region_code is not null) )then
283: if (NOT AK_REGION_PVT.REGION_EXISTS (
284: p_api_version_number => 1.0,
285: p_return_status => l_return_status,

Line 298: p_return_status := FND_API.G_RET_STS_SUCCESS;

294: end if;
295: end if;
296:
297: /* return true if no error, false otherwise */
298: p_return_status := FND_API.G_RET_STS_SUCCESS;
299: return (not l_error);
300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN

Line 302: WHEN FND_API.G_EXC_ERROR THEN

298: p_return_status := FND_API.G_RET_STS_SUCCESS;
299: return (not l_error);
300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN
303: p_return_status := FND_API.G_RET_STS_ERROR;
304: return FALSE;
305: WHEN OTHERS THEN
306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 303: p_return_status := FND_API.G_RET_STS_ERROR;

299: return (not l_error);
300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN
303: p_return_status := FND_API.G_RET_STS_ERROR;
304: return FALSE;
305: WHEN OTHERS THEN
306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

302: WHEN FND_API.G_EXC_ERROR THEN
303: p_return_status := FND_API.G_RET_STS_ERROR;
304: return FALSE;
305: WHEN OTHERS THEN
306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
308: SUBSTR (SQLERRM, 1, 240) );
309: FND_MSG_PUB.Add;
310: return FALSE;

Line 352: IF NOT FND_API.Compatible_API_Call (

348: l_api_version_number CONSTANT number := 1.0;
349: l_api_name CONSTANT varchar2(30) := 'Attribute_Exists';
350: l_dummy number;
351: begin
352: IF NOT FND_API.Compatible_API_Call (
353: l_api_version_number, p_api_version_number, l_api_name,
354: G_PKG_NAME) then
355: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: return FALSE;

Line 355: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

351: begin
352: IF NOT FND_API.Compatible_API_Call (
353: l_api_version_number, p_api_version_number, l_api_name,
354: G_PKG_NAME) then
355: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: return FALSE;
357: END IF;
358:
359: open l_check_csr;

Line 363: p_return_status := FND_API.G_RET_STS_SUCCESS;

359: open l_check_csr;
360: fetch l_check_csr into l_dummy;
361: if (l_check_csr%notfound) then
362: close l_check_csr;
363: p_return_status := FND_API.G_RET_STS_SUCCESS;
364: return FALSE;
365: else
366: close l_check_csr;
367: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 367: p_return_status := FND_API.G_RET_STS_SUCCESS;

363: p_return_status := FND_API.G_RET_STS_SUCCESS;
364: return FALSE;
365: else
366: close l_check_csr;
367: p_return_status := FND_API.G_RET_STS_SUCCESS;
368: return TRUE;
369: end if;
370:
371: EXCEPTION

Line 372: WHEN FND_API.G_EXC_ERROR THEN

368: return TRUE;
369: end if;
370:
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: p_return_status := FND_API.G_RET_STS_ERROR;
374: return FALSE;
375: WHEN OTHERS THEN
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 373: p_return_status := FND_API.G_RET_STS_ERROR;

369: end if;
370:
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: p_return_status := FND_API.G_RET_STS_ERROR;
374: return FALSE;
375: WHEN OTHERS THEN
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

372: WHEN FND_API.G_EXC_ERROR THEN
373: p_return_status := FND_API.G_RET_STS_ERROR;
374: return FALSE;
375: WHEN OTHERS THEN
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
378: SUBSTR (SQLERRM, 1, 240) );
379: FND_MSG_PUB.Add;
380: return FALSE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

439: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_precision IN NUMBER := FND_API.G_MISS_NUM,
442: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
443: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

440: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_precision IN NUMBER := FND_API.G_MISS_NUM,
442: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
443: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

441: p_precision IN NUMBER := FND_API.G_MISS_NUM,
442: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
443: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

442: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
443: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

443: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

444: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

445: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

446: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

447: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

448: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

449: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

450: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

451: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

452: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_name IN VARCHAR2,

Line 457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

453: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_name IN VARCHAR2,
461: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

454: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_name IN VARCHAR2,
461: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

455: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_name IN VARCHAR2,
461: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

457: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_name IN VARCHAR2,
461: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

458: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_name IN VARCHAR2,
461: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

459: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_name IN VARCHAR2,
461: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

460: p_name IN VARCHAR2,
461: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 465: p_creation_date IN DATE := FND_API.G_MISS_DATE,

461: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

462: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
470: p_pass IN NUMBER,

Line 467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

463: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
470: p_pass IN NUMBER,
471: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

464: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
470: p_pass IN NUMBER,
471: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
472: ) is

Line 469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

465: p_creation_date IN DATE := FND_API.G_MISS_DATE,
466: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
467: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
468: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
469: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
470: p_pass IN NUMBER,
471: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
472: ) is
473: l_api_version_number CONSTANT number := 1.0;

Line 522: IF NOT FND_API.Compatible_API_Call (

518: l_poplist_value_attr VARCHAR2(80) := NULL;
519:
520: begin
521:
522: IF NOT FND_API.Compatible_API_Call (
523: l_api_version_number, p_api_version_number, l_api_name,
524: G_PKG_NAME) then
525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: return;

Line 525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

521:
522: IF NOT FND_API.Compatible_API_Call (
523: l_api_version_number, p_api_version_number, l_api_name,
524: G_PKG_NAME) then
525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: return;
527: END IF;
528:
529: -- Initialize the message table if requested.

Line 551: raise FND_API.G_EXC_ERROR;

547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
548: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_EXISTS');
549: FND_MSG_PUB.Add;
550: end if;
551: raise FND_API.G_EXC_ERROR;
552: end if; */
553:
554: --** create with blank lov region application id, and lov region code
555: --** if calling from the loader **

Line 559: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then

555: --** if calling from the loader **
556: -- (this is because no region records have been loaded
557: -- at the time when the loader is creating attributes)
558: --
559: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
560: l_lov_region_application_id := null;
561: l_lov_region_code := null;
562: else
563: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) then

Line 563: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) then

559: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
560: l_lov_region_application_id := null;
561: l_lov_region_code := null;
562: else
563: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) then
564: l_lov_region_application_id := p_lov_region_application_id;
565: end if;
566: if (p_lov_region_code <> FND_API.G_MISS_CHAR) then
567: l_lov_region_code := p_lov_region_code;

Line 566: if (p_lov_region_code <> FND_API.G_MISS_CHAR) then

562: else
563: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) then
564: l_lov_region_application_id := p_lov_region_application_id;
565: end if;
566: if (p_lov_region_code <> FND_API.G_MISS_CHAR) then
567: l_lov_region_code := p_lov_region_code;
568: end if;
569: end if;
570:

Line 574: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) then

570:
571: --
572: -- validate table columns passed in
573: --
574: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) then
575: --
576: -- If this API is called from the upload_attribute API,
577: -- we will create an attribute with a null lov region if
578: -- the lov region passed is invalid.

Line 580: if (p_loader_timestamp <> FND_API.G_MISS_DATE) and

576: -- If this API is called from the upload_attribute API,
577: -- we will create an attribute with a null lov region if
578: -- the lov region passed is invalid.
579: --
580: if (p_loader_timestamp <> FND_API.G_MISS_DATE) and
581: (p_lov_region_code is not null) and
582: (p_lov_region_code <> FND_API.G_MISS_CHAR) then
583: if NOT AK_REGION_PVT.REGION_EXISTS (
584: p_api_version_number => 1.0,

Line 582: (p_lov_region_code <> FND_API.G_MISS_CHAR) then

578: -- the lov region passed is invalid.
579: --
580: if (p_loader_timestamp <> FND_API.G_MISS_DATE) and
581: (p_lov_region_code is not null) and
582: (p_lov_region_code <> FND_API.G_MISS_CHAR) then
583: if NOT AK_REGION_PVT.REGION_EXISTS (
584: p_api_version_number => 1.0,
585: p_return_status => l_return_status,
586: p_region_application_id => p_lov_region_application_id,

Line 626: raise FND_API.G_EXC_ERROR;

622: -- insert the record
623: if (p_pass = 1) then
624: p_copy_redo_flag := TRUE;
625: else
626: raise FND_API.G_EXC_ERROR;
627: end if; -- /* if p_pass */
628: end if; --/* if VALIDATE_ATTRIBUTE */
629: end if; --/* if p_validation_level */
630:

Line 636: if (p_attribute_label_length <> FND_API.G_MISS_NUM) then

632: -- Load non-required columns if their values are given
633: -- (do not load lov_region_application_id and lov_region_code
634: -- again since they have already been loaded earlier)
635: --
636: if (p_attribute_label_length <> FND_API.G_MISS_NUM) then
637: l_attribute_label_length := p_attribute_label_length;
638: end if;
639:
640: if (p_attribute_value_length <> FND_API.G_MISS_NUM) then

Line 640: if (p_attribute_value_length <> FND_API.G_MISS_NUM) then

636: if (p_attribute_label_length <> FND_API.G_MISS_NUM) then
637: l_attribute_label_length := p_attribute_label_length;
638: end if;
639:
640: if (p_attribute_value_length <> FND_API.G_MISS_NUM) then
641: l_attribute_value_length := p_attribute_value_length;
642: end if;
643:
644: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) then

Line 644: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) then

640: if (p_attribute_value_length <> FND_API.G_MISS_NUM) then
641: l_attribute_value_length := p_attribute_value_length;
642: end if;
643:
644: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) then
645: l_upper_case_flag := p_upper_case_flag;
646: end if;
647:
648: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) then

Line 648: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) then

644: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) then
645: l_upper_case_flag := p_upper_case_flag;
646: end if;
647:
648: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) then
649: l_default_value_varchar2 := p_default_value_varchar2;
650: end if;
651:
652: if (p_default_value_number <> FND_API.G_MISS_NUM) then

Line 652: if (p_default_value_number <> FND_API.G_MISS_NUM) then

648: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) then
649: l_default_value_varchar2 := p_default_value_varchar2;
650: end if;
651:
652: if (p_default_value_number <> FND_API.G_MISS_NUM) then
653: l_default_value_number := p_default_value_number;
654: end if;
655:
656: if (p_default_value_date <> FND_API.G_MISS_DATE) then

Line 656: if (p_default_value_date <> FND_API.G_MISS_DATE) then

652: if (p_default_value_number <> FND_API.G_MISS_NUM) then
653: l_default_value_number := p_default_value_number;
654: end if;
655:
656: if (p_default_value_date <> FND_API.G_MISS_DATE) then
657: l_default_value_date := p_default_value_date;
658: end if;
659:
660: -- Load non-required JSP columns

Line 661: if (p_item_style <> FND_API.G_MISS_CHAR and p_item_style is not null) then

657: l_default_value_date := p_default_value_date;
658: end if;
659:
660: -- Load non-required JSP columns
661: if (p_item_style <> FND_API.G_MISS_CHAR and p_item_style is not null) then
662: l_item_style := p_item_style;
663: end if;
664:
665: if (p_display_height <> FND_API.G_MISS_NUM) then

Line 665: if (p_display_height <> FND_API.G_MISS_NUM) then

661: if (p_item_style <> FND_API.G_MISS_CHAR and p_item_style is not null) then
662: l_item_style := p_item_style;
663: end if;
664:
665: if (p_display_height <> FND_API.G_MISS_NUM) then
666: l_display_height := p_display_height;
667: end if;
668:
669: if (p_css_class_name <> FND_API.G_MISS_CHAR) then

Line 669: if (p_css_class_name <> FND_API.G_MISS_CHAR) then

665: if (p_display_height <> FND_API.G_MISS_NUM) then
666: l_display_height := p_display_height;
667: end if;
668:
669: if (p_css_class_name <> FND_API.G_MISS_CHAR) then
670: l_css_class_name := p_css_class_name;
671: end if;
672:
673: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) then

Line 673: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) then

669: if (p_css_class_name <> FND_API.G_MISS_CHAR) then
670: l_css_class_name := p_css_class_name;
671: end if;
672:
673: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) then
674: l_poplist_viewobject := p_poplist_viewobject;
675: end if;
676:
677: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) then

Line 677: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) then

673: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) then
674: l_poplist_viewobject := p_poplist_viewobject;
675: end if;
676:
677: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) then
678: l_poplist_display_attr := p_poplist_display_attr;
679: end if;
680:
681: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) then

Line 681: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) then

677: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) then
678: l_poplist_display_attr := p_poplist_display_attr;
679: end if;
680:
681: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) then
682: l_poplist_value_attr := p_poplist_value_attr;
683: end if;
684:
685: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) then

Line 685: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) then

681: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) then
682: l_poplist_value_attr := p_poplist_value_attr;
683: end if;
684:
685: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) then
686: l_css_label_class_name := p_css_label_class_name;
687: end if;
688:
689: if (p_precision <> FND_API.G_MISS_NUM) then

Line 689: if (p_precision <> FND_API.G_MISS_NUM) then

685: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) then
686: l_css_label_class_name := p_css_label_class_name;
687: end if;
688:
689: if (p_precision <> FND_API.G_MISS_NUM) then
690: l_precision := p_precision;
691: end if;
692:
693: if (p_expansion <> FND_API.G_MISS_NUM) then

Line 693: if (p_expansion <> FND_API.G_MISS_NUM) then

689: if (p_precision <> FND_API.G_MISS_NUM) then
690: l_precision := p_precision;
691: end if;
692:
693: if (p_expansion <> FND_API.G_MISS_NUM) then
694: l_expansion := p_expansion;
695: end if;
696:
697: if (p_als_max_length <> FND_API.G_MISS_NUM) then

Line 697: if (p_als_max_length <> FND_API.G_MISS_NUM) then

693: if (p_expansion <> FND_API.G_MISS_NUM) then
694: l_expansion := p_expansion;
695: end if;
696:
697: if (p_als_max_length <> FND_API.G_MISS_NUM) then
698: l_als_max_length := p_als_max_length;
699: end if;
700:
701: -- flex columns

Line 702: if (p_attribute_category <> FND_API.G_MISS_CHAR) then

698: l_als_max_length := p_als_max_length;
699: end if;
700:
701: -- flex columns
702: if (p_attribute_category <> FND_API.G_MISS_CHAR) then
703: l_attribute_category := p_attribute_category;
704: end if;
705:
706: if (p_attribute1 <> FND_API.G_MISS_CHAR) then

Line 706: if (p_attribute1 <> FND_API.G_MISS_CHAR) then

702: if (p_attribute_category <> FND_API.G_MISS_CHAR) then
703: l_attribute_category := p_attribute_category;
704: end if;
705:
706: if (p_attribute1 <> FND_API.G_MISS_CHAR) then
707: l_attribute1 := p_attribute1;
708: end if;
709:
710: if (p_attribute2 <> FND_API.G_MISS_CHAR) then

Line 710: if (p_attribute2 <> FND_API.G_MISS_CHAR) then

706: if (p_attribute1 <> FND_API.G_MISS_CHAR) then
707: l_attribute1 := p_attribute1;
708: end if;
709:
710: if (p_attribute2 <> FND_API.G_MISS_CHAR) then
711: l_attribute2 := p_attribute2;
712: end if;
713:
714: if (p_attribute3 <> FND_API.G_MISS_CHAR) then

Line 714: if (p_attribute3 <> FND_API.G_MISS_CHAR) then

710: if (p_attribute2 <> FND_API.G_MISS_CHAR) then
711: l_attribute2 := p_attribute2;
712: end if;
713:
714: if (p_attribute3 <> FND_API.G_MISS_CHAR) then
715: l_attribute3 := p_attribute3;
716: end if;
717:
718: if (p_attribute4 <> FND_API.G_MISS_CHAR) then

Line 718: if (p_attribute4 <> FND_API.G_MISS_CHAR) then

714: if (p_attribute3 <> FND_API.G_MISS_CHAR) then
715: l_attribute3 := p_attribute3;
716: end if;
717:
718: if (p_attribute4 <> FND_API.G_MISS_CHAR) then
719: l_attribute4 := p_attribute4;
720: end if;
721:
722: if (p_attribute5 <> FND_API.G_MISS_CHAR) then

Line 722: if (p_attribute5 <> FND_API.G_MISS_CHAR) then

718: if (p_attribute4 <> FND_API.G_MISS_CHAR) then
719: l_attribute4 := p_attribute4;
720: end if;
721:
722: if (p_attribute5 <> FND_API.G_MISS_CHAR) then
723: l_attribute5 := p_attribute5;
724: end if;
725:
726: if (p_attribute6 <> FND_API.G_MISS_CHAR) then

Line 726: if (p_attribute6 <> FND_API.G_MISS_CHAR) then

722: if (p_attribute5 <> FND_API.G_MISS_CHAR) then
723: l_attribute5 := p_attribute5;
724: end if;
725:
726: if (p_attribute6 <> FND_API.G_MISS_CHAR) then
727: l_attribute6 := p_attribute6;
728: end if;
729:
730: if (p_attribute7 <> FND_API.G_MISS_CHAR) then

Line 730: if (p_attribute7 <> FND_API.G_MISS_CHAR) then

726: if (p_attribute6 <> FND_API.G_MISS_CHAR) then
727: l_attribute6 := p_attribute6;
728: end if;
729:
730: if (p_attribute7 <> FND_API.G_MISS_CHAR) then
731: l_attribute7:= p_attribute7;
732: end if;
733:
734: if (p_attribute8 <> FND_API.G_MISS_CHAR) then

Line 734: if (p_attribute8 <> FND_API.G_MISS_CHAR) then

730: if (p_attribute7 <> FND_API.G_MISS_CHAR) then
731: l_attribute7:= p_attribute7;
732: end if;
733:
734: if (p_attribute8 <> FND_API.G_MISS_CHAR) then
735: l_attribute8 := p_attribute8;
736: end if;
737:
738: if (p_attribute9 <> FND_API.G_MISS_CHAR) then

Line 738: if (p_attribute9 <> FND_API.G_MISS_CHAR) then

734: if (p_attribute8 <> FND_API.G_MISS_CHAR) then
735: l_attribute8 := p_attribute8;
736: end if;
737:
738: if (p_attribute9 <> FND_API.G_MISS_CHAR) then
739: l_attribute9 := p_attribute9;
740: end if;
741:
742: if (p_attribute10 <> FND_API.G_MISS_CHAR) then

Line 742: if (p_attribute10 <> FND_API.G_MISS_CHAR) then

738: if (p_attribute9 <> FND_API.G_MISS_CHAR) then
739: l_attribute9 := p_attribute9;
740: end if;
741:
742: if (p_attribute10 <> FND_API.G_MISS_CHAR) then
743: l_attribute10 := p_attribute10;
744: end if;
745:
746: if (p_attribute11 <> FND_API.G_MISS_CHAR) then

Line 746: if (p_attribute11 <> FND_API.G_MISS_CHAR) then

742: if (p_attribute10 <> FND_API.G_MISS_CHAR) then
743: l_attribute10 := p_attribute10;
744: end if;
745:
746: if (p_attribute11 <> FND_API.G_MISS_CHAR) then
747: l_attribute11 := p_attribute11;
748: end if;
749:
750: if (p_attribute12 <> FND_API.G_MISS_CHAR) then

Line 750: if (p_attribute12 <> FND_API.G_MISS_CHAR) then

746: if (p_attribute11 <> FND_API.G_MISS_CHAR) then
747: l_attribute11 := p_attribute11;
748: end if;
749:
750: if (p_attribute12 <> FND_API.G_MISS_CHAR) then
751: l_attribute12 := p_attribute12;
752: end if;
753:
754: if (p_attribute13 <> FND_API.G_MISS_CHAR) then

Line 754: if (p_attribute13 <> FND_API.G_MISS_CHAR) then

750: if (p_attribute12 <> FND_API.G_MISS_CHAR) then
751: l_attribute12 := p_attribute12;
752: end if;
753:
754: if (p_attribute13 <> FND_API.G_MISS_CHAR) then
755: l_attribute13 := p_attribute13;
756: end if;
757:
758: if (p_attribute14 <> FND_API.G_MISS_CHAR) then

Line 758: if (p_attribute14 <> FND_API.G_MISS_CHAR) then

754: if (p_attribute13 <> FND_API.G_MISS_CHAR) then
755: l_attribute13 := p_attribute13;
756: end if;
757:
758: if (p_attribute14 <> FND_API.G_MISS_CHAR) then
759: l_attribute14 := p_attribute14;
760: end if;
761:
762: if (p_attribute15 <> FND_API.G_MISS_CHAR) then

Line 762: if (p_attribute15 <> FND_API.G_MISS_CHAR) then

758: if (p_attribute14 <> FND_API.G_MISS_CHAR) then
759: l_attribute14 := p_attribute14;
760: end if;
761:
762: if (p_attribute15 <> FND_API.G_MISS_CHAR) then
763: l_attribute15 := p_attribute15;
764: end if;
765:
766: if (p_description <> FND_API.G_MISS_CHAR) then

Line 766: if (p_description <> FND_API.G_MISS_CHAR) then

762: if (p_attribute15 <> FND_API.G_MISS_CHAR) then
763: l_attribute15 := p_attribute15;
764: end if;
765:
766: if (p_description <> FND_API.G_MISS_CHAR) then
767: l_description := p_description;
768: end if;
769:
770: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) then

Line 770: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) then

766: if (p_description <> FND_API.G_MISS_CHAR) then
767: l_description := p_description;
768: end if;
769:
770: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) then
771: l_attribute_label_long := p_attribute_label_long;
772: end if;
773:
774: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) then

Line 774: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) then

770: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) then
771: l_attribute_label_long := p_attribute_label_long;
772: end if;
773:
774: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) then
775: l_attribute_label_short := p_attribute_label_short;
776: end if;
777:
778: if (p_created_by <> FND_API.G_MISS_NUM) then

Line 778: if (p_created_by <> FND_API.G_MISS_NUM) then

774: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) then
775: l_attribute_label_short := p_attribute_label_short;
776: end if;
777:
778: if (p_created_by <> FND_API.G_MISS_NUM) then
779: l_created_by := p_created_by;
780: end if;
781:
782: if (p_creation_date <> FND_API.G_MISS_DATE) then

Line 782: if (p_creation_date <> FND_API.G_MISS_DATE) then

778: if (p_created_by <> FND_API.G_MISS_NUM) then
779: l_created_by := p_created_by;
780: end if;
781:
782: if (p_creation_date <> FND_API.G_MISS_DATE) then
783: l_creation_date := p_creation_date;
784: end if;
785:
786: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

Line 786: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

782: if (p_creation_date <> FND_API.G_MISS_DATE) then
783: l_creation_date := p_creation_date;
784: end if;
785:
786: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
787: l_last_updated_by := p_last_updated_by;
788: end if;
789:
790: if (p_last_update_date <> FND_API.G_MISS_DATE) then

Line 790: if (p_last_update_date <> FND_API.G_MISS_DATE) then

786: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
787: l_last_updated_by := p_last_updated_by;
788: end if;
789:
790: if (p_last_update_date <> FND_API.G_MISS_DATE) then
791: l_last_update_date := p_last_update_date;
792: end if;
793:
794: if (p_last_update_login <> FND_API.G_MISS_NUM) then

Line 794: if (p_last_update_login <> FND_API.G_MISS_NUM) then

790: if (p_last_update_date <> FND_API.G_MISS_DATE) then
791: l_last_update_date := p_last_update_date;
792: end if;
793:
794: if (p_last_update_login <> FND_API.G_MISS_NUM) then
795: l_last_update_login := p_last_update_login;
796: end if;
797:
798: --

Line 933: raise FND_API.G_EXC_ERROR;

929: FND_MESSAGE.SET_NAME('AK','AK_INSERT_ATTRIBUTE_FAILED');
930: FND_MESSAGE.SET_TOKEN('OBJECT','AK_LC_ATTRIBUTE',TRUE);
931: FND_MSG_PUB.Add;
932: end if;
933: raise FND_API.G_EXC_ERROR;
934: end if;
935:
936: insert into AK_ATTRIBUTES_TL (
937: ATTRIBUTE_APPLICATION_ID,

Line 983: p_return_status := FND_API.G_RET_STS_SUCCESS;

979: ' ' || p_attribute_code);
980: FND_MSG_PUB.Add;
981: end if;
982:
983: p_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: FND_MSG_PUB.Count_And_Get (
986: p_count => p_msg_count,
987: p_data => p_msg_data);

Line 1001: p_return_status := FND_API.G_RET_STS_ERROR;

997: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
998: ' ' || p_attribute_code);
999: FND_MSG_PUB.Add;
1000: end if;
1001: p_return_status := FND_API.G_RET_STS_ERROR;
1002: rollback to start_create_attribute;
1003: FND_MSG_PUB.Count_And_Get (
1004: p_count => p_msg_count,
1005: p_data => p_msg_data);

Line 1006: WHEN FND_API.G_EXC_ERROR THEN

1002: rollback to start_create_attribute;
1003: FND_MSG_PUB.Count_And_Get (
1004: p_count => p_msg_count,
1005: p_data => p_msg_data);
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1008: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_CREATED');
1009: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
1010: ' ' || p_attribute_code);

Line 1013: p_return_status := FND_API.G_RET_STS_ERROR;

1009: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
1010: ' ' || p_attribute_code);
1011: FND_MSG_PUB.Add;
1012: end if;
1013: p_return_status := FND_API.G_RET_STS_ERROR;
1014: rollback to start_create_attribute;
1015: FND_MSG_PUB.Count_And_Get (
1016: p_count => p_msg_count,
1017: p_data => p_msg_data);

Line 1082: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1078: p_pass => p_pass,
1079: p_copy_redo_flag => p_copy_redo_flag
1080: );
1081: else
1082: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: rollback to start_create_attribute;
1084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1085: SUBSTR (SQLERRM, 1, 240) );
1086: FND_MSG_PUB.Count_And_Get (

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

1115: -- Version Initial version number = 1.0
1116: -- History Current version number = 1.0
1117: --=======================================================
1118: procedure DELETE_ATTRIBUTE (
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: p_api_version_number IN NUMBER,
1121: p_init_msg_tbl IN BOOLEAN := FALSE,
1122: p_msg_count OUT NOCOPY NUMBER,
1123: p_msg_data OUT NOCOPY VARCHAR2,

Line 1150: IF NOT FND_API.Compatible_API_Call (

1146: l_region_code VARCHAR2(30);
1147: l_return_status varchar2(1);
1148: begin
1149:
1150: IF NOT FND_API.Compatible_API_Call (
1151: l_api_version_number, p_api_version_number, l_api_name,
1152: G_PKG_NAME) then
1153: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: return;

Line 1153: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1149:
1150: IF NOT FND_API.Compatible_API_Call (
1151: l_api_version_number, p_api_version_number, l_api_name,
1152: G_PKG_NAME) then
1153: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: return;
1155: END IF;
1156:
1157: -- Initialize the message table if requested.

Line 1177: raise FND_API.G_EXC_ERROR;

1173: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1174: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1175: FND_MSG_PUB.Add;
1176: end if;
1177: raise FND_API.G_EXC_ERROR;
1178: end if;
1179:
1180: if (p_delete_cascade = 'N') then
1181: --

Line 1196: raise FND_API.G_EXC_ERROR;

1192: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1193: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_OA');
1194: FND_MSG_PUB.Add;
1195: end if;
1196: raise FND_API.G_EXC_ERROR;
1197: end if;
1198: close l_get_obj_attr_csr;
1199: --
1200: -- AK_REGION_ITEMS

Line 1210: raise FND_API.G_EXC_ERROR;

1206: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1207: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_RI');
1208: FND_MSG_PUB.Add;
1209: end if;
1210: raise FND_API.G_EXC_ERROR;
1211: end if;
1212: close l_get_region_item_csr;
1213:
1214: else

Line 1235: if (l_return_status = FND_API.G_RET_STS_ERROR) or

1231: p_attribute_application_id => p_attribute_application_id,
1232: p_attribute_code => p_attribute_code,
1233: p_delete_cascade => p_delete_cascade
1234: );
1235: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1236: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1237: close l_get_obj_attr_csr;
1238: raise FND_API.G_EXC_ERROR;
1239: end if;

Line 1236: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1232: p_attribute_code => p_attribute_code,
1233: p_delete_cascade => p_delete_cascade
1234: );
1235: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1236: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1237: close l_get_obj_attr_csr;
1238: raise FND_API.G_EXC_ERROR;
1239: end if;
1240: end loop;

Line 1238: raise FND_API.G_EXC_ERROR;

1234: );
1235: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1236: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1237: close l_get_obj_attr_csr;
1238: raise FND_API.G_EXC_ERROR;
1239: end if;
1240: end loop;
1241: close l_get_obj_attr_csr;
1242: --

Line 1261: if (l_return_status = FND_API.G_RET_STS_ERROR) or

1257: p_attribute_application_id => p_attribute_application_id,
1258: p_attribute_code => p_attribute_code,
1259: p_delete_cascade => p_delete_cascade
1260: );
1261: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1262: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1263: close l_get_region_item_csr;
1264: raise FND_API.G_EXC_ERROR;
1265: end if;

Line 1262: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1258: p_attribute_code => p_attribute_code,
1259: p_delete_cascade => p_delete_cascade
1260: );
1261: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1262: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1263: close l_get_region_item_csr;
1264: raise FND_API.G_EXC_ERROR;
1265: end if;
1266: end loop;

Line 1264: raise FND_API.G_EXC_ERROR;

1260: );
1261: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1262: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1263: close l_get_region_item_csr;
1264: raise FND_API.G_EXC_ERROR;
1265: end if;
1266: end loop;
1267: close l_get_region_item_csr;
1268:

Line 1284: raise FND_API.G_EXC_ERROR;

1280: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1281: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1282: FND_MSG_PUB.Add;
1283: end if;
1284: raise FND_API.G_EXC_ERROR;
1285: end if;
1286:
1287: delete from ak_attributes_tl
1288: where attribute_application_id = p_attribute_application_id

Line 1296: raise FND_API.G_EXC_ERROR;

1292: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1293: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1294: FND_MSG_PUB.Add;
1295: end if;
1296: raise FND_API.G_EXC_ERROR;
1297: end if;
1298:
1299: --
1300: -- Load success message

Line 1309: p_return_status := FND_API.G_RET_STS_SUCCESS;

1305: ' ' || p_attribute_code);
1306: FND_MSG_PUB.Add;
1307: end if;
1308:
1309: p_return_status := FND_API.G_RET_STS_SUCCESS;
1310:
1311: FND_MSG_PUB.Count_And_Get (
1312: p_count => p_msg_count,
1313: p_data => p_msg_data);

Line 1316: WHEN FND_API.G_EXC_ERROR THEN

1312: p_count => p_msg_count,
1313: p_data => p_msg_data);
1314:
1315: EXCEPTION
1316: WHEN FND_API.G_EXC_ERROR THEN
1317: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1318: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DELETED');
1319: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
1320: ' ' || p_attribute_code);

Line 1323: p_return_status := FND_API.G_RET_STS_ERROR;

1319: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
1320: ' ' || p_attribute_code);
1321: FND_MSG_PUB.Add;
1322: end if;
1323: p_return_status := FND_API.G_RET_STS_ERROR;
1324: rollback to start_delete_attribute;
1325: FND_MSG_PUB.Count_And_Get (
1326: p_count => p_msg_count,
1327: p_data => p_msg_data);

Line 1329: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1325: FND_MSG_PUB.Count_And_Get (
1326: p_count => p_msg_count,
1327: p_data => p_msg_data);
1328: WHEN OTHERS THEN
1329: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1330: rollback to start_delete_attribute;
1331: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1332: SUBSTR (SQLERRM, 1, 240) );
1333: FND_MSG_PUB.Count_And_Get (

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

1353: -- * Success
1354: -- Parameters Attribute record and its TL record.
1355: --=======================================================
1356: procedure WRITE_TO_BUFFER (
1357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1358: p_return_status OUT NOCOPY VARCHAR2,
1359: p_attributes_rec IN ak_attributes%ROWTYPE,
1360: p_attributes_tl_rec IN ak_attributes_tl%ROWTYPE
1361: ) is

Line 1371: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then

1367: begin
1368: --
1369: -- Attribute must be validated before it is written to the file
1370: --
1371: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
1372: if not VALIDATE_ATTRIBUTE (
1373: p_validation_level => p_validation_level,
1374: p_api_version_number => 1.0,
1375: p_return_status => l_return_status,

Line 1401: raise FND_API.G_EXC_ERROR;

1397: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1398: then
1399: -- dbms_output.put_line('Attribute ' || p_attributes_rec.attribute_code
1400: -- || ' not downloaded due to validation error');
1401: raise FND_API.G_EXC_ERROR;
1402: end if;
1403: end if;
1404:
1405: --

Line 1418: (p_attributes_rec.attribute_label_length <> FND_API.G_MISS_NUM)) then

1414: --
1415: -- only write out columns that is not null
1416: --
1417: if ((p_attributes_rec.attribute_label_length IS NOT NULL) and
1418: (p_attributes_rec.attribute_label_length <> FND_API.G_MISS_NUM)) then
1419: l_index := l_index + 1;
1420: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_LENGTH = "' ||
1421: nvl(to_char(p_attributes_rec.attribute_label_length),'') || '"';
1422: end if;

Line 1424: (p_attributes_rec.attribute_value_length <> FND_API.G_MISS_NUM)) then

1420: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_LENGTH = "' ||
1421: nvl(to_char(p_attributes_rec.attribute_label_length),'') || '"';
1422: end if;
1423: if ((p_attributes_rec.attribute_value_length IS NOT NULL) and
1424: (p_attributes_rec.attribute_value_length <> FND_API.G_MISS_NUM)) then
1425: l_index := l_index + 1;
1426: l_databuffer_tbl(l_index) := ' ATTRIBUTE_VALUE_LENGTH = "' ||
1427: nvl(to_char(p_attributes_rec.attribute_value_length),'') || '"';
1428: end if;

Line 1430: (p_attributes_rec.bold <> FND_API.G_MISS_CHAR)) then

1426: l_databuffer_tbl(l_index) := ' ATTRIBUTE_VALUE_LENGTH = "' ||
1427: nvl(to_char(p_attributes_rec.attribute_value_length),'') || '"';
1428: end if;
1429: if ((p_attributes_rec.bold IS NOT NULL) and
1430: (p_attributes_rec.bold <> FND_API.G_MISS_CHAR)) then
1431: l_index := l_index + 1;
1432: l_databuffer_tbl(l_index) := ' BOLD = "' ||
1433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.bold) || '"';
1434: end if;

Line 1436: (p_attributes_rec.italic <> FND_API.G_MISS_CHAR)) then

1432: l_databuffer_tbl(l_index) := ' BOLD = "' ||
1433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.bold) || '"';
1434: end if;
1435: if ((p_attributes_rec.italic IS NOT NULL) and
1436: (p_attributes_rec.italic <> FND_API.G_MISS_CHAR)) then
1437: l_index := l_index + 1;
1438: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
1439: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.italic) || '"';
1440: end if;

Line 1442: (p_attributes_rec.vertical_alignment <> FND_API.G_MISS_CHAR)) then

1438: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
1439: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.italic) || '"';
1440: end if;
1441: if ((p_attributes_rec.vertical_alignment IS NOT NULL) and
1442: (p_attributes_rec.vertical_alignment <> FND_API.G_MISS_CHAR)) then
1443: l_index := l_index + 1;
1444: l_databuffer_tbl(l_index) := ' VERTICAL_ALIGNMENT = "' ||
1445: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.vertical_alignment)
1446: || '"';

Line 1449: (p_attributes_rec.horizontal_alignment <> FND_API.G_MISS_CHAR)) then

1445: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.vertical_alignment)
1446: || '"';
1447: end if;
1448: if ((p_attributes_rec.horizontal_alignment IS NOT NULL) and
1449: (p_attributes_rec.horizontal_alignment <> FND_API.G_MISS_CHAR)) then
1450: l_index := l_index + 1;
1451: l_databuffer_tbl(l_index) := ' HORIZONTAL_ALIGNMENT = "' ||
1452: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.horizontal_alignment)
1453: || '"';

Line 1456: (p_attributes_rec.data_type <> FND_API.G_MISS_CHAR)) then

1452: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.horizontal_alignment)
1453: || '"';
1454: end if;
1455: if ((p_attributes_rec.data_type IS NOT NULL) and
1456: (p_attributes_rec.data_type <> FND_API.G_MISS_CHAR)) then
1457: l_index := l_index + 1;
1458: l_databuffer_tbl(l_index) := ' DATA_TYPE = "' ||
1459: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.data_type) || '"';
1460: end if;

Line 1462: (p_attributes_rec.upper_case_flag <> FND_API.G_MISS_CHAR)) then

1458: l_databuffer_tbl(l_index) := ' DATA_TYPE = "' ||
1459: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.data_type) || '"';
1460: end if;
1461: if ((p_attributes_rec.upper_case_flag IS NOT NULL) and
1462: (p_attributes_rec.upper_case_flag <> FND_API.G_MISS_CHAR)) then
1463: l_index := l_index + 1;
1464: l_databuffer_tbl(l_index) := ' UPPER_CASE_FLAG = "' ||
1465: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.upper_case_flag)
1466: || '"';

Line 1469: (p_attributes_rec.default_value_varchar2 <> FND_API.G_MISS_CHAR)) then

1465: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.upper_case_flag)
1466: || '"';
1467: end if;
1468: if ((p_attributes_rec.default_value_varchar2 IS NOT NULL) and
1469: (p_attributes_rec.default_value_varchar2 <> FND_API.G_MISS_CHAR)) then
1470: l_index := l_index + 1;
1471: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_VARCHAR2 = "' ||
1472: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1473: p_attributes_rec.default_value_varchar2) || '"';

Line 1476: (p_attributes_rec.default_value_number <> FND_API.G_MISS_NUM)) then

1472: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1473: p_attributes_rec.default_value_varchar2) || '"';
1474: end if;
1475: if ((p_attributes_rec.default_value_number IS NOT NULL) and
1476: (p_attributes_rec.default_value_number <> FND_API.G_MISS_NUM)) then
1477: l_index := l_index + 1;
1478: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_NUMBER = "' ||
1479: nvl(to_char(p_attributes_rec.default_value_number),'') || '"';
1480: end if;

Line 1482: (p_attributes_rec.default_value_date <> FND_API.G_MISS_DATE)) then

1478: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_NUMBER = "' ||
1479: nvl(to_char(p_attributes_rec.default_value_number),'') || '"';
1480: end if;
1481: if ((p_attributes_rec.default_value_date IS NOT NULL) and
1482: (p_attributes_rec.default_value_date <> FND_API.G_MISS_DATE)) then
1483: l_index := l_index + 1;
1484: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_DATE = "' ||
1485: to_char(p_attributes_rec.default_value_date,
1486: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line 1489: (p_attributes_rec.lov_region_application_id <> FND_API.G_MISS_NUM) and

1485: to_char(p_attributes_rec.default_value_date,
1486: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1487: end if;
1488: if ((p_attributes_rec.lov_region_application_id IS NOT NULL) and
1489: (p_attributes_rec.lov_region_application_id <> FND_API.G_MISS_NUM) and
1490: (p_attributes_rec.lov_region_code IS NOT NULL) and
1491: (p_attributes_rec.lov_region_code <> FND_API.G_MISS_CHAR)) then
1492: l_index := l_index + 1;
1493: l_databuffer_tbl(l_index) := ' LOV_REGION = "' ||

Line 1491: (p_attributes_rec.lov_region_code <> FND_API.G_MISS_CHAR)) then

1487: end if;
1488: if ((p_attributes_rec.lov_region_application_id IS NOT NULL) and
1489: (p_attributes_rec.lov_region_application_id <> FND_API.G_MISS_NUM) and
1490: (p_attributes_rec.lov_region_code IS NOT NULL) and
1491: (p_attributes_rec.lov_region_code <> FND_API.G_MISS_CHAR)) then
1492: l_index := l_index + 1;
1493: l_databuffer_tbl(l_index) := ' LOV_REGION = "' ||
1494: nvl(to_char(p_attributes_rec.lov_region_application_id),'')||'" "'||
1495: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.lov_region_code) ||

Line 1500: (p_attributes_rec.item_style <> FND_API.G_MISS_CHAR)) then

1496: '"';
1497: end if;
1498: -- new columns for JSP renderer
1499: if ((p_attributes_rec.item_style IS NOT NULL) and
1500: (p_attributes_rec.item_style <> FND_API.G_MISS_CHAR)) then
1501: l_index := l_index + 1;
1502: l_databuffer_tbl(l_index) := ' ITEM_STYLE = "' ||
1503: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1504: p_attributes_rec.item_style) || '"';

Line 1507: (p_attributes_rec.display_height <> FND_API.G_MISS_NUM)) then

1503: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1504: p_attributes_rec.item_style) || '"';
1505: end if;
1506: if ((p_attributes_rec.display_height IS NOT NULL) and
1507: (p_attributes_rec.display_height <> FND_API.G_MISS_NUM)) then
1508: l_index := l_index + 1;
1509: l_databuffer_tbl(l_index) := ' DISPLAY_HEIGHT = "' ||
1510: nvl(to_char(p_attributes_rec.display_height),'') || '"';
1511: end if;

Line 1513: (p_attributes_rec.css_class_name <> FND_API.G_MISS_CHAR)) then

1509: l_databuffer_tbl(l_index) := ' DISPLAY_HEIGHT = "' ||
1510: nvl(to_char(p_attributes_rec.display_height),'') || '"';
1511: end if;
1512: if ((p_attributes_rec.css_class_name IS NOT NULL) and
1513: (p_attributes_rec.css_class_name <> FND_API.G_MISS_CHAR)) then
1514: l_index := l_index + 1;
1515: l_databuffer_tbl(l_index) := ' CSS_CLASS_NAME = "' ||
1516: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1517: p_attributes_rec.css_class_name) || '"';

Line 1520: (p_attributes_rec.poplist_viewobject <> FND_API.G_MISS_CHAR)) then

1516: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1517: p_attributes_rec.css_class_name) || '"';
1518: end if;
1519: if ((p_attributes_rec.poplist_viewobject IS NOT NULL) and
1520: (p_attributes_rec.poplist_viewobject <> FND_API.G_MISS_CHAR)) then
1521: l_index := l_index + 1;
1522: l_databuffer_tbl(l_index) := ' POPLIST_VIEWOBJECT = "' ||
1523: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1524: p_attributes_rec.poplist_viewobject) || '"';

Line 1527: (p_attributes_rec.poplist_display_attribute <> FND_API.G_MISS_CHAR)) then

1523: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1524: p_attributes_rec.poplist_viewobject) || '"';
1525: end if;
1526: if ((p_attributes_rec.poplist_display_attribute IS NOT NULL) and
1527: (p_attributes_rec.poplist_display_attribute <> FND_API.G_MISS_CHAR)) then
1528: l_index := l_index + 1;
1529: l_databuffer_tbl(l_index) := ' POPLIST_DISPLAY_ATTRIBUTE = "' ||
1530: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1531: p_attributes_rec.poplist_display_attribute) || '"';

Line 1534: (p_attributes_rec.poplist_value_attribute <> FND_API.G_MISS_CHAR)) then

1530: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1531: p_attributes_rec.poplist_display_attribute) || '"';
1532: end if;
1533: if ((p_attributes_rec.poplist_value_attribute IS NOT NULL) and
1534: (p_attributes_rec.poplist_value_attribute <> FND_API.G_MISS_CHAR)) then
1535: l_index := l_index + 1;
1536: l_databuffer_tbl(l_index) := ' POPLIST_VALUE_ATTRIBUTE = "' ||
1537: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1538: p_attributes_rec.poplist_value_attribute) || '"';

Line 1541: (p_attributes_rec.css_label_class_name <> FND_API.G_MISS_CHAR)) then

1537: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1538: p_attributes_rec.poplist_value_attribute) || '"';
1539: end if;
1540: if ((p_attributes_rec.css_label_class_name IS NOT NULL ) and
1541: (p_attributes_rec.css_label_class_name <> FND_API.G_MISS_CHAR)) then
1542: l_index := l_index + 1;
1543: l_databuffer_tbl(l_index) := ' CSS_LABEL_CLASS_NAME = "' ||
1544: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1545: p_attributes_rec.css_label_class_name) || '"';

Line 1548: (p_attributes_rec.precision <> FND_API.G_MISS_NUM)) then

1544: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1545: p_attributes_rec.css_label_class_name) || '"';
1546: end if;
1547: if ((p_attributes_rec.precision IS NOT NULL ) and
1548: (p_attributes_rec.precision <> FND_API.G_MISS_NUM)) then
1549: l_index := l_index + 1;
1550: l_databuffer_tbl(l_index) := ' PRECISION = "' ||
1551: nvl(to_char(p_attributes_rec.precision),'') || '"';
1552: end if;

Line 1554: (p_attributes_rec.expansion <> FND_API.G_MISS_NUM)) then

1550: l_databuffer_tbl(l_index) := ' PRECISION = "' ||
1551: nvl(to_char(p_attributes_rec.precision),'') || '"';
1552: end if;
1553: if ((p_attributes_rec.expansion IS NOT NULL ) and
1554: (p_attributes_rec.expansion <> FND_API.G_MISS_NUM)) then
1555: l_index := l_index + 1;
1556: l_databuffer_tbl(l_index) := ' EXPANSION = "' ||
1557: nvl(to_char(p_attributes_rec.expansion),'') || '"';
1558: end if;

Line 1560: (p_attributes_rec.als_max_length <> FND_API.G_MISS_NUM)) then

1556: l_databuffer_tbl(l_index) := ' EXPANSION = "' ||
1557: nvl(to_char(p_attributes_rec.expansion),'') || '"';
1558: end if;
1559: if ((p_attributes_rec.als_max_length IS NOT NULL ) and
1560: (p_attributes_rec.als_max_length <> FND_API.G_MISS_NUM)) then
1561: l_index := l_index + 1;
1562: l_databuffer_tbl(l_index) := ' ALS_MAX_LENGTH = "' ||
1563: nvl(to_char(p_attributes_rec.als_max_length),'') || '"';
1564: end if;

Line 1570: (p_attributes_rec.attribute_category <> FND_API.G_MISS_CHAR)) then

1566:
1567: -- Flex Fields
1568: --
1569: if ((p_attributes_rec.attribute_category IS NOT NULL) and
1570: (p_attributes_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
1571: l_index := l_index + 1;
1572: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
1573: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1574: p_attributes_rec.attribute_category) || '"';

Line 1577: (p_attributes_rec.attribute1 <> FND_API.G_MISS_CHAR)) then

1573: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1574: p_attributes_rec.attribute_category) || '"';
1575: end if;
1576: if ((p_attributes_rec.attribute1 IS NOT NULL) and
1577: (p_attributes_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1578: l_index := l_index + 1;
1579: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
1580: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1581: p_attributes_rec.attribute1) || '"';

Line 1584: (p_attributes_rec.attribute2 <> FND_API.G_MISS_CHAR)) then

1580: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1581: p_attributes_rec.attribute1) || '"';
1582: end if;
1583: if ((p_attributes_rec.attribute2 IS NOT NULL) and
1584: (p_attributes_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1585: l_index := l_index + 1;
1586: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
1587: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1588: p_attributes_rec.attribute2) || '"';

Line 1591: (p_attributes_rec.attribute3 <> FND_API.G_MISS_CHAR)) then

1587: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1588: p_attributes_rec.attribute2) || '"';
1589: end if;
1590: if ((p_attributes_rec.attribute3 IS NOT NULL) and
1591: (p_attributes_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1592: l_index := l_index + 1;
1593: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
1594: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1595: p_attributes_rec.attribute3) || '"';

Line 1598: (p_attributes_rec.attribute4 <> FND_API.G_MISS_CHAR)) then

1594: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1595: p_attributes_rec.attribute3) || '"';
1596: end if;
1597: if ((p_attributes_rec.attribute4 IS NOT NULL) and
1598: (p_attributes_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1599: l_index := l_index + 1;
1600: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
1601: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1602: p_attributes_rec.attribute4) || '"';

Line 1605: (p_attributes_rec.attribute5 <> FND_API.G_MISS_CHAR)) then

1601: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1602: p_attributes_rec.attribute4) || '"';
1603: end if;
1604: if ((p_attributes_rec.attribute5 IS NOT NULL) and
1605: (p_attributes_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1606: l_index := l_index + 1;
1607: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
1608: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1609: p_attributes_rec.attribute5) || '"';

Line 1612: (p_attributes_rec.attribute6 <> FND_API.G_MISS_CHAR)) then

1608: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1609: p_attributes_rec.attribute5) || '"';
1610: end if;
1611: if ((p_attributes_rec.attribute6 IS NOT NULL) and
1612: (p_attributes_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1613: l_index := l_index + 1;
1614: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
1615: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1616: p_attributes_rec.attribute6) || '"';

Line 1619: (p_attributes_rec.attribute7 <> FND_API.G_MISS_CHAR)) then

1615: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1616: p_attributes_rec.attribute6) || '"';
1617: end if;
1618: if ((p_attributes_rec.attribute7 IS NOT NULL) and
1619: (p_attributes_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1620: l_index := l_index + 1;
1621: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
1622: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1623: p_attributes_rec.attribute7) || '"';

Line 1626: (p_attributes_rec.attribute8 <> FND_API.G_MISS_CHAR)) then

1622: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1623: p_attributes_rec.attribute7) || '"';
1624: end if;
1625: if ((p_attributes_rec.attribute8 IS NOT NULL) and
1626: (p_attributes_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1627: l_index := l_index + 1;
1628: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
1629: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1630: p_attributes_rec.attribute8) || '"';

Line 1633: (p_attributes_rec.attribute9 <> FND_API.G_MISS_CHAR)) then

1629: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1630: p_attributes_rec.attribute8) || '"';
1631: end if;
1632: if ((p_attributes_rec.attribute9 IS NOT NULL) and
1633: (p_attributes_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1634: l_index := l_index + 1;
1635: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
1636: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1637: p_attributes_rec.attribute9) || '"';

Line 1640: (p_attributes_rec.attribute10 <> FND_API.G_MISS_CHAR)) then

1636: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1637: p_attributes_rec.attribute9) || '"';
1638: end if;
1639: if ((p_attributes_rec.attribute10 IS NOT NULL) and
1640: (p_attributes_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1641: l_index := l_index + 1;
1642: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
1643: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1644: p_attributes_rec.attribute10) || '"';

Line 1647: (p_attributes_rec.attribute11 <> FND_API.G_MISS_CHAR)) then

1643: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1644: p_attributes_rec.attribute10) || '"';
1645: end if;
1646: if ((p_attributes_rec.attribute11 IS NOT NULL) and
1647: (p_attributes_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1648: l_index := l_index + 1;
1649: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
1650: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1651: p_attributes_rec.attribute11) || '"';

Line 1654: (p_attributes_rec.attribute12 <> FND_API.G_MISS_CHAR)) then

1650: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1651: p_attributes_rec.attribute11) || '"';
1652: end if;
1653: if ((p_attributes_rec.attribute12 IS NOT NULL) and
1654: (p_attributes_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1655: l_index := l_index + 1;
1656: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
1657: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1658: p_attributes_rec.attribute12) || '"';

Line 1661: (p_attributes_rec.attribute13 <> FND_API.G_MISS_CHAR)) then

1657: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1658: p_attributes_rec.attribute12) || '"';
1659: end if;
1660: if ((p_attributes_rec.attribute13 IS NOT NULL) and
1661: (p_attributes_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1662: l_index := l_index + 1;
1663: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
1664: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1665: p_attributes_rec.attribute13) || '"';

Line 1668: (p_attributes_rec.attribute14 <> FND_API.G_MISS_CHAR)) then

1664: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1665: p_attributes_rec.attribute13) || '"';
1666: end if;
1667: if ((p_attributes_rec.attribute14 IS NOT NULL) and
1668: (p_attributes_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1669: l_index := l_index + 1;
1670: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
1671: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1672: p_attributes_rec.attribute14) || '"';

Line 1675: (p_attributes_rec.attribute15 <> FND_API.G_MISS_CHAR)) then

1671: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1672: p_attributes_rec.attribute14) || '"';
1673: end if;
1674: if ((p_attributes_rec.attribute15 IS NOT NULL) and
1675: (p_attributes_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1676: l_index := l_index + 1;
1677: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
1678: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1679: p_attributes_rec.attribute15) || '"';

Line 1705: (p_attributes_tl_rec.name <> FND_API.G_MISS_CHAR)) then

1701: nvl(to_char(p_attributes_rec.last_update_login),'') || '"';
1702: -- translation columns
1703: --
1704: if ((p_attributes_tl_rec.name IS NOT NULL) and
1705: (p_attributes_tl_rec.name <> FND_API.G_MISS_CHAR)) then
1706: l_index := l_index + 1;
1707: l_databuffer_tbl(l_index) := ' NAME = "' ||
1708: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.name) || '"';
1709: end if;

Line 1711: (p_attributes_tl_rec.attribute_label_long <> FND_API.G_MISS_CHAR)) then

1707: l_databuffer_tbl(l_index) := ' NAME = "' ||
1708: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.name) || '"';
1709: end if;
1710: if ((p_attributes_tl_rec.attribute_label_long IS NOT NULL) and
1711: (p_attributes_tl_rec.attribute_label_long <> FND_API.G_MISS_CHAR)) then
1712: l_index := l_index + 1;
1713: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_LONG = "' ||
1714: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_long)
1715: || '"';

Line 1718: (p_attributes_tl_rec.attribute_label_short <> FND_API.G_MISS_CHAR)) then

1714: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_long)
1715: || '"';
1716: end if;
1717: if ((p_attributes_tl_rec.attribute_label_short IS NOT NULL) and
1718: (p_attributes_tl_rec.attribute_label_short <> FND_API.G_MISS_CHAR)) then
1719: l_index := l_index + 1;
1720: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_SHORT = "' ||
1721: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_short)
1722: || '"';

Line 1725: (p_attributes_tl_rec.description <> FND_API.G_MISS_CHAR)) then

1721: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_short)
1722: || '"';
1723: end if;
1724: if ((p_attributes_tl_rec.description IS NOT NULL) and
1725: (p_attributes_tl_rec.description <> FND_API.G_MISS_CHAR)) then
1726: l_index := l_index + 1;
1727: l_databuffer_tbl(l_index) := ' DESCRIPTION = "' ||
1728: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.description) || '"';
1729: end if;

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

1744:
1745: --
1746: -- If API call returns with an error status...
1747: --
1748: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1749: (l_return_status = FND_API.G_RET_STS_ERROR) then
1750: RAISE FND_API.G_EXC_ERROR;
1751: end if;
1752:

Line 1749: (l_return_status = FND_API.G_RET_STS_ERROR) then

1745: --
1746: -- If API call returns with an error status...
1747: --
1748: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1749: (l_return_status = FND_API.G_RET_STS_ERROR) then
1750: RAISE FND_API.G_EXC_ERROR;
1751: end if;
1752:
1753: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1750: RAISE FND_API.G_EXC_ERROR;

1746: -- If API call returns with an error status...
1747: --
1748: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1749: (l_return_status = FND_API.G_RET_STS_ERROR) then
1750: RAISE FND_API.G_EXC_ERROR;
1751: end if;
1752:
1753: p_return_status := FND_API.G_RET_STS_SUCCESS;
1754:

Line 1753: p_return_status := FND_API.G_RET_STS_SUCCESS;

1749: (l_return_status = FND_API.G_RET_STS_ERROR) then
1750: RAISE FND_API.G_EXC_ERROR;
1751: end if;
1752:
1753: p_return_status := FND_API.G_RET_STS_SUCCESS;
1754:
1755: EXCEPTION
1756: WHEN VALUE_ERROR THEN
1757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1769: p_return_status := FND_API.G_RET_STS_ERROR;

1765: to_char(p_attributes_rec.attribute_application_id) ||
1766: ' ' || p_attributes_rec.attribute_code);
1767: FND_MSG_PUB.Add;
1768: end if;
1769: p_return_status := FND_API.G_RET_STS_ERROR;
1770: WHEN FND_API.G_EXC_ERROR THEN
1771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1772: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');
1773: FND_MESSAGE.SET_TOKEN('KEY',

Line 1770: WHEN FND_API.G_EXC_ERROR THEN

1766: ' ' || p_attributes_rec.attribute_code);
1767: FND_MSG_PUB.Add;
1768: end if;
1769: p_return_status := FND_API.G_RET_STS_ERROR;
1770: WHEN FND_API.G_EXC_ERROR THEN
1771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1772: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');
1773: FND_MESSAGE.SET_TOKEN('KEY',
1774: to_char(p_attributes_rec.attribute_application_id) ||

Line 1778: p_return_status := FND_API.G_RET_STS_ERROR;

1774: to_char(p_attributes_rec.attribute_application_id) ||
1775: ' ' || p_attributes_rec.attribute_code);
1776: FND_MSG_PUB.Add;
1777: end if;
1778: p_return_status := FND_API.G_RET_STS_ERROR;
1779: WHEN OTHERS THEN
1780: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1781: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1782: SUBSTR (SQLERRM, 1, 240) );

Line 1780: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1776: FND_MSG_PUB.Add;
1777: end if;
1778: p_return_status := FND_API.G_RET_STS_ERROR;
1779: WHEN OTHERS THEN
1780: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1781: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1782: SUBSTR (SQLERRM, 1, 240) );
1783: FND_MSG_PUB.Add;
1784: end WRITE_TO_BUFFER;

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

1820: -- Version Initial version number = 1.0
1821: -- History Current version number = 1.0
1822: --=======================================================
1823: procedure DOWNLOAD_ATTRIBUTE (
1824: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1825: p_api_version_number IN NUMBER,
1826: p_return_status OUT NOCOPY VARCHAR2,
1827: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1828: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type

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

1823: procedure DOWNLOAD_ATTRIBUTE (
1824: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1825: p_api_version_number IN NUMBER,
1826: p_return_status OUT NOCOPY VARCHAR2,
1827: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1828: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
1829: := AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL,
1830: p_nls_language IN VARCHAR2
1831: ) is

Line 1879: IF NOT FND_API.Compatible_API_Call (

1875: l_return_status varchar2(1);
1876: l_select_by_appl_id BOOLEAN;
1877: l_percent NUMBER;
1878: begin
1879: IF NOT FND_API.Compatible_API_Call (
1880: l_api_version_number, p_api_version_number, l_api_name,
1881: G_PKG_NAME) then
1882: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1883: return;

Line 1882: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1878: begin
1879: IF NOT FND_API.Compatible_API_Call (
1880: l_api_version_number, p_api_version_number, l_api_name,
1881: G_PKG_NAME) then
1882: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1883: return;
1884: END IF;
1885:
1886: --

Line 1894: if (p_application_id = FND_API.G_MISS_NUM) then

1890: -- p_attribute_pk_tbl, or
1891: -- - both p_application_id and p_attribute_pk_tbl if any
1892: -- p_attribute_application_id is missing in p_attribute_pk_tbl
1893: --
1894: if (p_application_id = FND_API.G_MISS_NUM) then
1895: if (p_attribute_pk_tbl.count = 0) then
1896: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1897: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1898: FND_MSG_PUB.Add;

Line 1900: raise FND_API.G_EXC_ERROR;

1896: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1897: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1898: FND_MSG_PUB.Add;
1899: end if;
1900: raise FND_API.G_EXC_ERROR;
1901: else
1902: --
1903: -- since no application ID is passed in thru p_application_id,
1904: -- none of the attribute_application_id or attribute_code

Line 1910: if (p_attribute_pk_tbl(i).attribute_appl_id = FND_API.G_MISS_NUM) or

1906: --
1907:
1908: for i in p_attribute_pk_tbl.FIRST .. p_attribute_pk_tbl.LAST LOOP
1909: if (p_attribute_pk_tbl.exists(i)) then
1910: if (p_attribute_pk_tbl(i).attribute_appl_id = FND_API.G_MISS_NUM) or
1911: (p_attribute_pk_tbl(i).attribute_code = FND_API.G_MISS_CHAR)
1912: then
1913: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1914: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');

Line 1911: (p_attribute_pk_tbl(i).attribute_code = FND_API.G_MISS_CHAR)

1907:
1908: for i in p_attribute_pk_tbl.FIRST .. p_attribute_pk_tbl.LAST LOOP
1909: if (p_attribute_pk_tbl.exists(i)) then
1910: if (p_attribute_pk_tbl(i).attribute_appl_id = FND_API.G_MISS_NUM) or
1911: (p_attribute_pk_tbl(i).attribute_code = FND_API.G_MISS_CHAR)
1912: then
1913: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1914: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');
1915: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));

Line 1918: raise FND_API.G_EXC_ERROR;

1914: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');
1915: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));
1916: FND_MSG_PUB.Add;
1917: end if;
1918: raise FND_API.G_EXC_ERROR;
1919: end if; /* if attribute_appl_id is null */
1920: end if; /* if exists */
1921: end LOOP;
1922:

Line 1964: if (l_return_status = FND_API.G_RET_STS_ERROR) then

1960: );
1961: --
1962: -- abort Download if validation has been failed
1963: --
1964: if (l_return_status = FND_API.G_RET_STS_ERROR) then
1965: raise FND_API.G_EXC_ERROR;
1966: end if;
1967: end loop;
1968: close l_get_attribute_1_csr;

Line 1965: raise FND_API.G_EXC_ERROR;

1961: --
1962: -- abort Download if validation has been failed
1963: --
1964: if (l_return_status = FND_API.G_RET_STS_ERROR) then
1965: raise FND_API.G_EXC_ERROR;
1966: end if;
1967: end loop;
1968: close l_get_attribute_1_csr;
1969:

Line 1982: if (p_attribute_pk_tbl(i).attribute_appl_id = FND_API.G_MISS_NUM) then

1978: if (p_attribute_pk_tbl.exists(i)) then
1979: --
1980: -- default application ID to p_application_id if not given
1981: --
1982: if (p_attribute_pk_tbl(i).attribute_appl_id = FND_API.G_MISS_NUM) then
1983: l_attribute_appl_id := p_application_id;
1984: else
1985: l_attribute_appl_id := p_attribute_pk_tbl(i).attribute_appl_id;
1986: end if;

Line 2016: if (l_return_status = FND_API.G_RET_STS_ERROR) then

2012: );
2013: --
2014: -- abort Download if validation has been failed
2015: --
2016: if (l_return_status = FND_API.G_RET_STS_ERROR) then
2017: raise FND_API.G_EXC_ERROR;
2018: end if;
2019: end loop;
2020: close l_get_attribute_2p_csr;

Line 2017: raise FND_API.G_EXC_ERROR;

2013: --
2014: -- abort Download if validation has been failed
2015: --
2016: if (l_return_status = FND_API.G_RET_STS_ERROR) then
2017: raise FND_API.G_EXC_ERROR;
2018: end if;
2019: end loop;
2020: close l_get_attribute_2p_csr;
2021: else

Line 2064: if (l_return_status = FND_API.G_RET_STS_ERROR) then

2060: );
2061: --
2062: -- abort Download if validation has been failed
2063: --
2064: if (l_return_status = FND_API.G_RET_STS_ERROR) then
2065: raise FND_API.G_EXC_ERROR;
2066: end if;
2067: end if; /* if l_attribute_found */
2068: end if; /* if l_percent */

Line 2065: raise FND_API.G_EXC_ERROR;

2061: --
2062: -- abort Download if validation has been failed
2063: --
2064: if (l_return_status = FND_API.G_RET_STS_ERROR) then
2065: raise FND_API.G_EXC_ERROR;
2066: end if;
2067: end if; /* if l_attribute_found */
2068: end if; /* if l_percent */
2069: close l_percent_check;

Line 2074: p_return_status := FND_API.G_RET_STS_SUCCESS;

2070: end if; /* if exists(i) */
2071: end loop;
2072: end if;
2073:
2074: p_return_status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2077: WHEN FND_API.G_EXC_ERROR THEN

2073:
2074: p_return_status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: p_return_status := FND_API.G_RET_STS_ERROR;
2079: WHEN OTHERS THEN
2080: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2081: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

Line 2078: p_return_status := FND_API.G_RET_STS_ERROR;

2074: p_return_status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: p_return_status := FND_API.G_RET_STS_ERROR;
2079: WHEN OTHERS THEN
2080: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2081: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2082: SUBSTR (SQLERRM, 1, 240) );

Line 2080: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: p_return_status := FND_API.G_RET_STS_ERROR;
2079: WHEN OTHERS THEN
2080: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2081: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2082: SUBSTR (SQLERRM, 1, 240) );
2083: end DOWNLOAD_ATTRIBUTE;
2084:

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

2130: -- Version Initial version number = 1.0
2131: -- History Current version number = 1.0
2132: --=======================================================
2133: procedure UPLOAD_ATTRIBUTE (
2134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2135: p_api_version_number IN NUMBER,
2136: p_return_status OUT NOCOPY VARCHAR2,
2137: p_index IN OUT NOCOPY NUMBER,
2138: p_loader_timestamp IN DATE,

Line 2139: p_line_num IN NUMBER := FND_API.G_MISS_NUM,

2135: p_api_version_number IN NUMBER,
2136: p_return_status OUT NOCOPY VARCHAR2,
2137: p_index IN OUT NOCOPY NUMBER,
2138: p_loader_timestamp IN DATE,
2139: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
2140: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
2141: p_line_num_out OUT NOCOPY NUMBER,
2142: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
2143: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

Line 2172: IF NOT FND_API.Compatible_API_Call (

2168: l_user_id2 NUMBER;
2169: l_update1 DATE;
2170: l_update2 DATE;
2171: begin
2172: IF NOT FND_API.Compatible_API_Call (
2173: l_api_version_number, p_api_version_number, l_api_name,
2174: G_PKG_NAME) then
2175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2176: return;

Line 2175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2171: begin
2172: IF NOT FND_API.Compatible_API_Call (
2173: l_api_version_number, p_api_version_number, l_api_name,
2174: G_PKG_NAME) then
2175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2176: return;
2177: END IF;
2178:
2179: --dbms_output.put_line('Started attribute upload: ' ||

Line 2195: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then

2191: -- the tokens 'BEGIN ATTRIBUTE' has already been parsed. Set initial
2192: -- buffer to 'BEGIN ATTRIBUTE' before reading the next line from the
2193: -- file. Otherwise, set initial buffer to null.
2194: --
2195: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
2196: l_buffer := 'BEGIN ATTRIBUTE ' || p_buffer;
2197: else
2198: l_buffer := null;
2199: end if;

Line 2201: if (p_line_num = FND_API.G_MISS_NUM) then

2197: else
2198: l_buffer := null;
2199: end if;
2200:
2201: if (p_line_num = FND_API.G_MISS_NUM) then
2202: l_line_num := 0;
2203: else
2204: l_line_num := p_line_num;
2205: end if;

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

2212: p_lines_read => l_lines_read,
2213: p_eof_flag => l_eof_flag,
2214: p_upl_loader_cur => p_upl_loader_cur
2215: );
2216: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2217: (l_return_status = FND_API.G_RET_STS_ERROR) then
2218: RAISE FND_API.G_EXC_ERROR;
2219: end if;
2220: --dbms_output.put_line('READ_LINE gets l_buffer = '||l_buffer);

Line 2217: (l_return_status = FND_API.G_RET_STS_ERROR) then

2213: p_eof_flag => l_eof_flag,
2214: p_upl_loader_cur => p_upl_loader_cur
2215: );
2216: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2217: (l_return_status = FND_API.G_RET_STS_ERROR) then
2218: RAISE FND_API.G_EXC_ERROR;
2219: end if;
2220: --dbms_output.put_line('READ_LINE gets l_buffer = '||l_buffer);
2221:

Line 2218: RAISE FND_API.G_EXC_ERROR;

2214: p_upl_loader_cur => p_upl_loader_cur
2215: );
2216: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2217: (l_return_status = FND_API.G_RET_STS_ERROR) then
2218: RAISE FND_API.G_EXC_ERROR;
2219: end if;
2220: --dbms_output.put_line('READ_LINE gets l_buffer = '||l_buffer);
2221:
2222: l_line_num := l_line_num + l_lines_read;

Line 2240: raise FND_API.G_EXC_ERROR;

2236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2237: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
2238: FND_MSG_PUB.Add;
2239: end if;
2240: raise FND_API.G_EXC_ERROR;
2241: end if;
2242:
2243: --
2244: -- Read tokens from file, one at a time

Line 2258: if (l_return_status = FND_API.G_RET_STS_ERROR) or

2254:
2255: --dbms_output.put_line(' State:' || l_state || 'Token:' || l_token);
2256: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2257:
2258: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2259: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2261: -- dbms_output.put_line('State '||l_state||' Token '||l_token|| 'l_buffer '||l_buffer);
2262: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');

Line 2259: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

2255: --dbms_output.put_line(' State:' || l_state || 'Token:' || l_token);
2256: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2257:
2258: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2259: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2261: -- dbms_output.put_line('State '||l_state||' Token '||l_token|| 'l_buffer '||l_buffer);
2262: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2263: FND_MSG_PUB.Add;

Line 2266: raise FND_API.G_EXC_ERROR;

2262: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2263: FND_MSG_PUB.Add;
2264: end if;
2265: -- dbms_output.put_line('Error parsing buffer');
2266: raise FND_API.G_EXC_ERROR;
2267: end if;
2268:
2269: if (l_state = 0) then
2270: if (l_token = 'BEGIN') then

Line 2283: raise FND_API.G_EXC_ERROR;

2279: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2280: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2281: FND_MSG_PUB.Add;
2282: end if;
2283: raise FND_API.G_EXC_ERROR;
2284: end if;
2285: elsif (l_state = 1) then
2286: if (l_token = 'ATTRIBUTE') then
2287: l_state := 2;

Line 2308: raise FND_API.G_EXC_ERROR;

2304: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');
2305: FND_MSG_PUB.Add;
2306: end if;
2307: -- dbms_output.put_line('Expecting attribute application ID');
2308: raise FND_API.G_EXC_ERROR;
2309: end if;
2310: elsif (l_state = 3) then
2311: if (l_token is not null) then
2312: l_attribute_rec.attribute_code := l_token;

Line 2324: raise FND_API.G_EXC_ERROR;

2320: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');
2321: FND_MSG_PUB.Add;
2322: end if;
2323: --dbms_output.put_line('Expecting attribute code');
2324: raise FND_API.G_EXC_ERROR;
2325: end if;
2326: elsif (l_state = 10) then
2327: if (l_token = 'END') then
2328: l_state := 19;

Line 2407: raise FND_API.G_EXC_ERROR;

2403: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');
2404: FND_MSG_PUB.Add;
2405: end if;
2406: -- dbms_output.put_line('Expecting attribute field or END');
2407: raise FND_API.G_EXC_ERROR;
2408: end if;
2409: end if;
2410: elsif (l_state = 11) then
2411: if (l_token = '=') then

Line 2421: raise FND_API.G_EXC_ERROR;

2417: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2418: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2419: FND_MSG_PUB.Add;
2420: end if;
2421: raise FND_API.G_EXC_ERROR;
2422: end if;
2423: elsif (l_state = 12) then
2424: l_value_count := 1;
2425: if (l_column = 'ATTRIBUTE_LABEL_LENGTH') then

Line 2581: raise FND_API.G_EXC_ERROR;

2577: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);
2578: FND_MSG_PUB.Add;
2579: end if;
2580: --dbms_output.put_line('Expecting ' || l_column || ' value');
2581: raise FND_API.G_EXC_ERROR;
2582: end if;
2583: elsif (l_state = 14) then
2584: if (l_column = 'LOV_REGION') then
2585: l_attribute_rec.lov_region_code := l_token;

Line 2596: raise FND_API.G_EXC_ERROR;

2592: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);
2593: FND_MSG_PUB.Add;
2594: end if;
2595: --dbms_output.put_line('Expecting ' || l_column || ' value');
2596: raise FND_API.G_EXC_ERROR;
2597: end if;
2598: elsif (l_state = 19) then
2599: if (l_token = 'ATTRIBUTE') then
2600: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

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

2837: );
2838: end if; -- /* if ATTRIBUTE_EXISTS */
2839: --
2840: -- If API call returns with an error status, upload aborts
2841: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2842: (l_return_status = FND_API.G_RET_STS_ERROR) then
2843: RAISE FND_API.G_EXC_ERROR;
2844: end if; -- /* if l_return_status */
2845: --

Line 2842: (l_return_status = FND_API.G_RET_STS_ERROR) then

2838: end if; -- /* if ATTRIBUTE_EXISTS */
2839: --
2840: -- If API call returns with an error status, upload aborts
2841: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2842: (l_return_status = FND_API.G_RET_STS_ERROR) then
2843: RAISE FND_API.G_EXC_ERROR;
2844: end if; -- /* if l_return_status */
2845: --
2846: -- if validation fails, then this record should go to second pass

Line 2843: RAISE FND_API.G_EXC_ERROR;

2839: --
2840: -- If API call returns with an error status, upload aborts
2841: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2842: (l_return_status = FND_API.G_RET_STS_ERROR) then
2843: RAISE FND_API.G_EXC_ERROR;
2844: end if; -- /* if l_return_status */
2845: --
2846: -- if validation fails, then this record should go to second pass
2847: if (l_copy_redo_flag) then

Line 2862: raise FND_API.G_EXC_ERROR;

2858: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2859: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');
2860: FND_MSG_PUB.Add;
2861: end if;
2862: raise FND_API.G_EXC_ERROR;
2863: end if;
2864: end if;
2865:
2866: --

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

2882: p_eof_flag => l_eof_flag,
2883: p_upl_loader_cur => p_upl_loader_cur
2884: );
2885:
2886: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2887: (l_return_status = FND_API.G_RET_STS_ERROR) then
2888: RAISE FND_API.G_EXC_ERROR;
2889: end if;
2890: l_line_num := l_line_num + l_lines_read;

Line 2887: (l_return_status = FND_API.G_RET_STS_ERROR) then

2883: p_upl_loader_cur => p_upl_loader_cur
2884: );
2885:
2886: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2887: (l_return_status = FND_API.G_RET_STS_ERROR) then
2888: RAISE FND_API.G_EXC_ERROR;
2889: end if;
2890: l_line_num := l_line_num + l_lines_read;
2891: --

Line 2888: RAISE FND_API.G_EXC_ERROR;

2884: );
2885:
2886: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2887: (l_return_status = FND_API.G_RET_STS_ERROR) then
2888: RAISE FND_API.G_EXC_ERROR;
2889: end if;
2890: l_line_num := l_line_num + l_lines_read;
2891: --
2892: -- trim leading spaces and discard comment lines

Line 2916: raise FND_API.G_EXC_ERROR;

2912: FND_MSG_PUB.Add;
2913: end if;
2914: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
2915: -- to_char(l_state));
2916: raise FND_API.G_EXC_ERROR;
2917: end if;
2918:
2919: --
2920: -- Load line number of the last file line processed

Line 2924: p_return_status := FND_API.G_RET_STS_SUCCESS;

2920: -- Load line number of the last file line processed
2921: --
2922: p_line_num_out := l_line_num;
2923:
2924: p_return_status := FND_API.G_RET_STS_SUCCESS;
2925:
2926: -- dbms_output.put_line('Leaving attribute upload: ' ||
2927: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2928:

Line 2930: WHEN FND_API.G_EXC_ERROR THEN

2926: -- dbms_output.put_line('Leaving attribute upload: ' ||
2927: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2928:
2929: EXCEPTION
2930: WHEN FND_API.G_EXC_ERROR THEN
2931: p_return_status := FND_API.G_RET_STS_ERROR;
2932: WHEN VALUE_ERROR THEN
2933: p_return_status := FND_API.G_RET_STS_ERROR;
2934: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');

Line 2931: p_return_status := FND_API.G_RET_STS_ERROR;

2927: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2928:
2929: EXCEPTION
2930: WHEN FND_API.G_EXC_ERROR THEN
2931: p_return_status := FND_API.G_RET_STS_ERROR;
2932: WHEN VALUE_ERROR THEN
2933: p_return_status := FND_API.G_RET_STS_ERROR;
2934: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
2935: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_attribute_rec.attribute_application_id) ||

Line 2933: p_return_status := FND_API.G_RET_STS_ERROR;

2929: EXCEPTION
2930: WHEN FND_API.G_EXC_ERROR THEN
2931: p_return_status := FND_API.G_RET_STS_ERROR;
2932: WHEN VALUE_ERROR THEN
2933: p_return_status := FND_API.G_RET_STS_ERROR;
2934: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
2935: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_attribute_rec.attribute_application_id) ||
2936: ' ' || l_attribute_rec.attribute_code);
2937: FND_MSG_PUB.Add;

Line 2942: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2938: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2939: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
2940: FND_MSG_PUB.Add;
2941: WHEN OTHERS THEN
2942: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2943: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2944: SUBSTR (SQLERRM, 1, 240) );
2945: FND_MSG_PUB.Add;
2946: end UPLOAD_ATTRIBUTE;

Line 3018: WHEN FND_API.G_EXC_ERROR THEN

3014: p_attribute_pk_tbl(l_index).attribute_appl_id := p_attribute_application_id;
3015: p_attribute_pk_tbl(l_index).attribute_code := p_attribute_code;
3016:
3017: EXCEPTION
3018: WHEN FND_API.G_EXC_ERROR THEN
3019: p_return_status := FND_API.G_RET_STS_ERROR;
3020: WHEN OTHERS THEN
3021: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3022: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 3019: p_return_status := FND_API.G_RET_STS_ERROR;

3015: p_attribute_pk_tbl(l_index).attribute_code := p_attribute_code;
3016:
3017: EXCEPTION
3018: WHEN FND_API.G_EXC_ERROR THEN
3019: p_return_status := FND_API.G_RET_STS_ERROR;
3020: WHEN OTHERS THEN
3021: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3022: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3023: SUBSTR (SQLERRM, 1, 240) );

Line 3021: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3017: EXCEPTION
3018: WHEN FND_API.G_EXC_ERROR THEN
3019: p_return_status := FND_API.G_RET_STS_ERROR;
3020: WHEN OTHERS THEN
3021: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3022: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3023: SUBSTR (SQLERRM, 1, 240) );
3024: FND_MSG_PUB.Add;
3025: end INSERT_ATTRIBUTE_PK_TABLE;

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

3051: -- Version Initial version number = 1.0
3052: -- History Current version number = 1.0
3053: --=======================================================
3054: procedure UPDATE_ATTRIBUTE (
3055: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3056: p_api_version_number IN NUMBER,
3057: p_init_msg_tbl IN BOOLEAN := FALSE,
3058: p_msg_count OUT NOCOPY NUMBER,
3059: p_msg_data OUT NOCOPY VARCHAR2,

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

3059: p_msg_data OUT NOCOPY VARCHAR2,
3060: p_return_status OUT NOCOPY VARCHAR2,
3061: p_attribute_application_id IN NUMBER,
3062: p_attribute_code IN VARCHAR2,
3063: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3064: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3065: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3066: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3060: p_return_status OUT NOCOPY VARCHAR2,
3061: p_attribute_application_id IN NUMBER,
3062: p_attribute_code IN VARCHAR2,
3063: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3064: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3065: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3066: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3061: p_attribute_application_id IN NUMBER,
3062: p_attribute_code IN VARCHAR2,
3063: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3064: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3065: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3066: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3062: p_attribute_code IN VARCHAR2,
3063: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3064: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3065: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3066: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3063: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3064: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3065: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3066: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3064: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3065: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3066: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

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

3065: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3066: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

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

3066: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

3067: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3068: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3069: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

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

3070: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3071: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

3072: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3073: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3074: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3075: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,

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

3076: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

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

3077: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

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

3078: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3079: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3080: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3081: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

3082: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3083: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3084: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3085: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3086: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3087: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3088: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3089: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3090: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3091: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3092: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3093: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3094: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3095: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3096: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

3097: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3098: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

3099: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

3100: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

3101: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

3102: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,

3103: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3111: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

3104: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3111: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3112: p_pass IN NUMBER,

Line 3109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

3105: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3111: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3112: p_pass IN NUMBER,
3113: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 3110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

3106: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3111: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3112: p_pass IN NUMBER,
3113: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
3114: ) is

Line 3111: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

3107: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3108: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3109: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3110: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3111: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3112: p_pass IN NUMBER,
3113: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
3114: ) is
3115: cursor l_get_row_csr is

Line 3159: IF NOT FND_API.Compatible_API_Call (

3155: l_return_status varchar2(1);
3156: l_item_style varchar2(30) := 'TEXT';
3157: l_file_version number;
3158: begin
3159: IF NOT FND_API.Compatible_API_Call (
3160: l_api_version_number, p_api_version_number, l_api_name,
3161: G_PKG_NAME) then
3162: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3163: return;

Line 3162: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3158: begin
3159: IF NOT FND_API.Compatible_API_Call (
3160: l_api_version_number, p_api_version_number, l_api_name,
3161: G_PKG_NAME) then
3162: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3163: return;
3164: END IF;
3165:
3166: -- Initialize the message table if requested.

Line 3188: raise FND_API.G_EXC_ERROR;

3184: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
3185: FND_MSG_PUB.Add;
3186: end if;
3187: close l_get_row_csr;
3188: raise FND_API.G_EXC_ERROR;
3189: end if;
3190: close l_get_row_csr;
3191:
3192: --

Line 3204: raise FND_API.G_EXC_ERROR;

3200: FND_MSG_PUB.Add;
3201: end if;
3202: -- dbms_output.put_line('Error - TL Row does not exist');
3203: close l_get_tl_row_csr;
3204: raise FND_API.G_EXC_ERROR;
3205: end if;
3206: close l_get_tl_row_csr;
3207:
3208: --

Line 3211: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) then

3207:
3208: --
3209: -- validate table columns passed in
3210: --
3211: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) then
3212: if not VALIDATE_ATTRIBUTE (
3213: p_validation_level => p_validation_level,
3214: p_api_version_number => 1.0,
3215: p_return_status => l_return_status,

Line 3241: raise FND_API.G_EXC_ERROR;

3237: ) then
3238: if (p_pass = 1) then
3239: p_copy_redo_flag := TRUE;
3240: else
3241: raise FND_API.G_EXC_ERROR;
3242: end if; --/* if p_pass */
3243: end if;
3244: end if;
3245:

Line 3251: if ((p_data_type is not null) and (p_data_type <> FND_API.G_MISS_CHAR) and

3247:
3248: -- - Cannot change data_type if there are attribute navigation,
3249: -- attribute value, or page region item data for this attribute
3250:
3251: if ((p_data_type is not null) and (p_data_type <> FND_API.G_MISS_CHAR) and
3252: (p_data_type <> l_attributes_rec.data_type)) then
3253:
3254: if (l_attributes_rec.data_type = 'URL') then
3255: /* see if any 'To URL attribute' in ak_flow_page_region_items */

Line 3267: raise FND_API.G_EXC_ERROR;

3263: FND_MESSAGE.SET_TOKEN('FORM','AK_PAGE_REGION_LINKS', TRUE);
3264: FND_MSG_PUB.Add;
3265: end if;
3266: -- dbms_output.put_line(l_api_name || ' Cannot change data type');
3267: raise FND_API.G_EXC_ERROR;
3268: end if;
3269: close l_check_page_region_item_csr;
3270: else
3271: /* see if there are any attribute navigation for this non-URL type */

Line 3283: raise FND_API.G_EXC_ERROR;

3279: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_NAVIGATION', TRUE);
3280: FND_MSG_PUB.Add;
3281: end if;
3282: -- dbms_output.put_line(l_api_name || ' Cannot change data type');
3283: raise FND_API.G_EXC_ERROR;
3284: end if;
3285: close l_check_navigation_csr;
3286:
3287: /* see if there are any attribute values for this non-URL type */

Line 3298: raise FND_API.G_EXC_ERROR;

3294: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3295: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_VALUE', TRUE);
3296: FND_MSG_PUB.Add;
3297: end if;
3298: raise FND_API.G_EXC_ERROR;
3299: end if;
3300: close l_check_attr_value_csr;
3301: end if;
3302: end if;

Line 3308: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) or

3304: --
3305: -- Load record to be updated to the database
3306: -- - first load nullable columns
3307: --
3308: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) or
3309: (p_upper_case_flag is null) then
3310: l_attributes_rec.upper_case_flag := p_upper_case_flag;
3311: end if;
3312: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or

Line 3312: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or

3308: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) or
3309: (p_upper_case_flag is null) then
3310: l_attributes_rec.upper_case_flag := p_upper_case_flag;
3311: end if;
3312: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or
3313: (p_default_value_varchar2 is null) then
3314: l_attributes_rec.default_value_varchar2 := p_default_value_varchar2;
3315: end if;
3316: if (p_default_value_number <> FND_API.G_MISS_NUM) or

Line 3316: if (p_default_value_number <> FND_API.G_MISS_NUM) or

3312: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or
3313: (p_default_value_varchar2 is null) then
3314: l_attributes_rec.default_value_varchar2 := p_default_value_varchar2;
3315: end if;
3316: if (p_default_value_number <> FND_API.G_MISS_NUM) or
3317: (p_default_value_number is null) then
3318: l_attributes_rec.default_value_number := p_default_value_number;
3319: end if;
3320: if (p_default_value_date <> FND_API.G_MISS_DATE) or

Line 3320: if (p_default_value_date <> FND_API.G_MISS_DATE) or

3316: if (p_default_value_number <> FND_API.G_MISS_NUM) or
3317: (p_default_value_number is null) then
3318: l_attributes_rec.default_value_number := p_default_value_number;
3319: end if;
3320: if (p_default_value_date <> FND_API.G_MISS_DATE) or
3321: (p_default_value_date is null) then
3322: l_attributes_rec.default_value_date := p_default_value_date;
3323: end if;
3324: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or

Line 3324: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or

3320: if (p_default_value_date <> FND_API.G_MISS_DATE) or
3321: (p_default_value_date is null) then
3322: l_attributes_rec.default_value_date := p_default_value_date;
3323: end if;
3324: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or
3325: (p_lov_region_application_id is null) then
3326: l_attributes_rec.lov_region_application_id := p_lov_region_application_id;
3327: end if;
3328: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or

Line 3328: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or

3324: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or
3325: (p_lov_region_application_id is null) then
3326: l_attributes_rec.lov_region_application_id := p_lov_region_application_id;
3327: end if;
3328: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or
3329: (p_lov_region_code is null) then
3330: l_attributes_rec.lov_region_code := p_lov_region_code;
3331: end if;
3332: -- JSP new columns

Line 3333: if (p_item_style <> FND_API.G_MISS_CHAR) and

3329: (p_lov_region_code is null) then
3330: l_attributes_rec.lov_region_code := p_lov_region_code;
3331: end if;
3332: -- JSP new columns
3333: if (p_item_style <> FND_API.G_MISS_CHAR) and
3334: (p_item_style is not null) then
3335: l_attributes_rec.item_style := p_item_style;
3336: else
3337: l_attributes_rec.item_style := l_item_style;

Line 3339: if (p_display_height <> FND_API.G_MISS_NUM) or

3335: l_attributes_rec.item_style := p_item_style;
3336: else
3337: l_attributes_rec.item_style := l_item_style;
3338: end if;
3339: if (p_display_height <> FND_API.G_MISS_NUM) or
3340: (p_display_height is null) then
3341: l_attributes_rec.display_height := p_display_height;
3342: end if;
3343: if (p_css_class_name <> FND_API.G_MISS_CHAR) or

Line 3343: if (p_css_class_name <> FND_API.G_MISS_CHAR) or

3339: if (p_display_height <> FND_API.G_MISS_NUM) or
3340: (p_display_height is null) then
3341: l_attributes_rec.display_height := p_display_height;
3342: end if;
3343: if (p_css_class_name <> FND_API.G_MISS_CHAR) or
3344: (p_css_class_name is null) then
3345: l_attributes_rec.css_class_name := p_css_class_name;
3346: end if;
3347: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) or

Line 3347: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) or

3343: if (p_css_class_name <> FND_API.G_MISS_CHAR) or
3344: (p_css_class_name is null) then
3345: l_attributes_rec.css_class_name := p_css_class_name;
3346: end if;
3347: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) or
3348: (p_poplist_viewobject is null) then
3349: l_attributes_rec.poplist_viewobject := p_poplist_viewobject;
3350: end if;
3351: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) or

Line 3351: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) or

3347: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) or
3348: (p_poplist_viewobject is null) then
3349: l_attributes_rec.poplist_viewobject := p_poplist_viewobject;
3350: end if;
3351: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) or
3352: (p_poplist_display_attr is null) then
3353: l_attributes_rec.poplist_display_attribute := p_poplist_display_attr;
3354: end if;
3355: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) or

Line 3355: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) or

3351: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) or
3352: (p_poplist_display_attr is null) then
3353: l_attributes_rec.poplist_display_attribute := p_poplist_display_attr;
3354: end if;
3355: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) or
3356: (p_poplist_value_attr is null) then
3357: l_attributes_rec.poplist_value_attribute := p_poplist_value_attr;
3358: end if;
3359: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) or

Line 3359: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) or

3355: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) or
3356: (p_poplist_value_attr is null) then
3357: l_attributes_rec.poplist_value_attribute := p_poplist_value_attr;
3358: end if;
3359: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) or
3360: (p_css_label_class_name is null) then
3361: l_attributes_rec.css_label_class_name := p_css_label_class_name;
3362: end if;
3363: if (p_precision <> FND_API.G_MISS_NUM) or

Line 3363: if (p_precision <> FND_API.G_MISS_NUM) or

3359: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) or
3360: (p_css_label_class_name is null) then
3361: l_attributes_rec.css_label_class_name := p_css_label_class_name;
3362: end if;
3363: if (p_precision <> FND_API.G_MISS_NUM) or
3364: (p_precision is null) then
3365: l_attributes_rec.precision := p_precision;
3366: end if;
3367: if (p_expansion <> FND_API.G_MISS_NUM) or

Line 3367: if (p_expansion <> FND_API.G_MISS_NUM) or

3363: if (p_precision <> FND_API.G_MISS_NUM) or
3364: (p_precision is null) then
3365: l_attributes_rec.precision := p_precision;
3366: end if;
3367: if (p_expansion <> FND_API.G_MISS_NUM) or
3368: (p_expansion is null) then
3369: l_attributes_rec.expansion := p_expansion;
3370: end if;
3371: if (p_als_max_length <> FND_API.G_MISS_NUM) or

Line 3371: if (p_als_max_length <> FND_API.G_MISS_NUM) or

3367: if (p_expansion <> FND_API.G_MISS_NUM) or
3368: (p_expansion is null) then
3369: l_attributes_rec.expansion := p_expansion;
3370: end if;
3371: if (p_als_max_length <> FND_API.G_MISS_NUM) or
3372: (p_als_max_length is null) then
3373: l_attributes_rec.als_max_length := p_als_max_length;
3374: end if;
3375:

Line 3376: if (p_attribute_category <> FND_API.G_MISS_CHAR) or

3372: (p_als_max_length is null) then
3373: l_attributes_rec.als_max_length := p_als_max_length;
3374: end if;
3375:
3376: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
3377: (p_attribute_category is null) then
3378: l_attributes_rec.attribute_category := p_attribute_category;
3379: end if;
3380: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

Line 3380: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

3376: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
3377: (p_attribute_category is null) then
3378: l_attributes_rec.attribute_category := p_attribute_category;
3379: end if;
3380: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
3381: (p_attribute1 is null) then
3382: l_attributes_rec.attribute1 := p_attribute1;
3383: end if;
3384: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

Line 3384: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

3380: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
3381: (p_attribute1 is null) then
3382: l_attributes_rec.attribute1 := p_attribute1;
3383: end if;
3384: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
3385: (p_attribute2 is null) then
3386: l_attributes_rec.attribute2 := p_attribute2;
3387: end if;
3388: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

Line 3388: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

3384: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
3385: (p_attribute2 is null) then
3386: l_attributes_rec.attribute2 := p_attribute2;
3387: end if;
3388: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
3389: (p_attribute3 is null) then
3390: l_attributes_rec.attribute3 := p_attribute3;
3391: end if;
3392: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

Line 3392: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

3388: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
3389: (p_attribute3 is null) then
3390: l_attributes_rec.attribute3 := p_attribute3;
3391: end if;
3392: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
3393: (p_attribute4 is null) then
3394: l_attributes_rec.attribute4 := p_attribute4;
3395: end if;
3396: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

Line 3396: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

3392: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
3393: (p_attribute4 is null) then
3394: l_attributes_rec.attribute4 := p_attribute4;
3395: end if;
3396: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
3397: (p_attribute5 is null) then
3398: l_attributes_rec.attribute5 := p_attribute5;
3399: end if;
3400: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

Line 3400: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

3396: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
3397: (p_attribute5 is null) then
3398: l_attributes_rec.attribute5 := p_attribute5;
3399: end if;
3400: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
3401: (p_attribute6 is null) then
3402: l_attributes_rec.attribute6 := p_attribute6;
3403: end if;
3404: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

Line 3404: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

3400: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
3401: (p_attribute6 is null) then
3402: l_attributes_rec.attribute6 := p_attribute6;
3403: end if;
3404: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
3405: (p_attribute7 is null) then
3406: l_attributes_rec.attribute7 := p_attribute7;
3407: end if;
3408: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

Line 3408: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

3404: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
3405: (p_attribute7 is null) then
3406: l_attributes_rec.attribute7 := p_attribute7;
3407: end if;
3408: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
3409: (p_attribute8 is null) then
3410: l_attributes_rec.attribute8 := p_attribute8;
3411: end if;
3412: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

Line 3412: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

3408: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
3409: (p_attribute8 is null) then
3410: l_attributes_rec.attribute8 := p_attribute8;
3411: end if;
3412: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
3413: (p_attribute9 is null) then
3414: l_attributes_rec.attribute9 := p_attribute9;
3415: end if;
3416: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

Line 3416: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

3412: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
3413: (p_attribute9 is null) then
3414: l_attributes_rec.attribute9 := p_attribute9;
3415: end if;
3416: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
3417: (p_attribute10 is null) then
3418: l_attributes_rec.attribute10 := p_attribute10;
3419: end if;
3420: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

Line 3420: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

3416: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
3417: (p_attribute10 is null) then
3418: l_attributes_rec.attribute10 := p_attribute10;
3419: end if;
3420: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
3421: (p_attribute11 is null) then
3422: l_attributes_rec.attribute11 := p_attribute11;
3423: end if;
3424: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

Line 3424: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

3420: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
3421: (p_attribute11 is null) then
3422: l_attributes_rec.attribute11 := p_attribute11;
3423: end if;
3424: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
3425: (p_attribute12 is null) then
3426: l_attributes_rec.attribute12 := p_attribute12;
3427: end if;
3428: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

Line 3428: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

3424: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
3425: (p_attribute12 is null) then
3426: l_attributes_rec.attribute12 := p_attribute12;
3427: end if;
3428: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
3429: (p_attribute13 is null) then
3430: l_attributes_rec.attribute13 := p_attribute13;
3431: end if;
3432: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

Line 3432: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

3428: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
3429: (p_attribute13 is null) then
3430: l_attributes_rec.attribute13 := p_attribute13;
3431: end if;
3432: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
3433: (p_attribute14 is null) then
3434: l_attributes_rec.attribute14 := p_attribute14;
3435: end if;
3436: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

Line 3436: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

3432: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
3433: (p_attribute14 is null) then
3434: l_attributes_rec.attribute14 := p_attribute14;
3435: end if;
3436: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
3437: (p_attribute15 is null) then
3438: l_attributes_rec.attribute15 := p_attribute15;
3439: end if;
3440: if (p_attribute_label_length <> FND_API.G_MISS_NUM) or

Line 3440: if (p_attribute_label_length <> FND_API.G_MISS_NUM) or

3436: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
3437: (p_attribute15 is null) then
3438: l_attributes_rec.attribute15 := p_attribute15;
3439: end if;
3440: if (p_attribute_label_length <> FND_API.G_MISS_NUM) or
3441: (p_attribute_label_length is null) then
3442: l_attributes_rec.attribute_label_length := p_attribute_label_length;
3443: end if;
3444: if (p_attribute_value_length <> FND_API.G_MISS_NUM) or

Line 3444: if (p_attribute_value_length <> FND_API.G_MISS_NUM) or

3440: if (p_attribute_label_length <> FND_API.G_MISS_NUM) or
3441: (p_attribute_label_length is null) then
3442: l_attributes_rec.attribute_label_length := p_attribute_label_length;
3443: end if;
3444: if (p_attribute_value_length <> FND_API.G_MISS_NUM) or
3445: (p_attribute_value_length is null) then
3446: l_attributes_rec.attribute_value_length := p_attribute_value_length;
3447: end if;
3448: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or

Line 3448: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or

3444: if (p_attribute_value_length <> FND_API.G_MISS_NUM) or
3445: (p_attribute_value_length is null) then
3446: l_attributes_rec.attribute_value_length := p_attribute_value_length;
3447: end if;
3448: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or
3449: (p_attribute_label_long is null) then
3450: l_attributes_tl_rec.attribute_label_long := p_attribute_label_long;
3451: end if;
3452: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or

Line 3452: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or

3448: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or
3449: (p_attribute_label_long is null) then
3450: l_attributes_tl_rec.attribute_label_long := p_attribute_label_long;
3451: end if;
3452: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or
3453: (p_attribute_label_short is null) then
3454: l_attributes_tl_rec.attribute_label_short := p_attribute_label_short;
3455: end if;
3456: if (p_description <> FND_API.G_MISS_CHAR) or

Line 3456: if (p_description <> FND_API.G_MISS_CHAR) or

3452: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or
3453: (p_attribute_label_short is null) then
3454: l_attributes_tl_rec.attribute_label_short := p_attribute_label_short;
3455: end if;
3456: if (p_description <> FND_API.G_MISS_CHAR) or
3457: (p_description is null) then
3458: l_attributes_tl_rec.description := p_description;
3459: end if;
3460:

Line 3464: if (p_bold <> FND_API.G_MISS_CHAR) then

3460:
3461: --
3462: -- - next, load non-null columns
3463: --
3464: if (p_bold <> FND_API.G_MISS_CHAR) then
3465: l_attributes_rec.bold := p_bold;
3466: end if;
3467: if (p_italic <> FND_API.G_MISS_CHAR) then
3468: l_attributes_rec.italic := p_italic;

Line 3467: if (p_italic <> FND_API.G_MISS_CHAR) then

3463: --
3464: if (p_bold <> FND_API.G_MISS_CHAR) then
3465: l_attributes_rec.bold := p_bold;
3466: end if;
3467: if (p_italic <> FND_API.G_MISS_CHAR) then
3468: l_attributes_rec.italic := p_italic;
3469: end if;
3470: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
3471: l_attributes_rec.vertical_alignment := p_vertical_alignment;

Line 3470: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then

3466: end if;
3467: if (p_italic <> FND_API.G_MISS_CHAR) then
3468: l_attributes_rec.italic := p_italic;
3469: end if;
3470: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
3471: l_attributes_rec.vertical_alignment := p_vertical_alignment;
3472: end if;
3473: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
3474: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;

Line 3473: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then

3469: end if;
3470: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
3471: l_attributes_rec.vertical_alignment := p_vertical_alignment;
3472: end if;
3473: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
3474: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;
3475: end if;
3476: if (p_data_type <> FND_API.G_MISS_CHAR) then
3477: l_attributes_rec.data_type := p_data_type;

Line 3476: if (p_data_type <> FND_API.G_MISS_CHAR) then

3472: end if;
3473: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
3474: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;
3475: end if;
3476: if (p_data_type <> FND_API.G_MISS_CHAR) then
3477: l_attributes_rec.data_type := p_data_type;
3478: end if;
3479: if (p_name <> FND_API.G_MISS_CHAR) then
3480: l_attributes_tl_rec.name := p_name;

Line 3479: if (p_name <> FND_API.G_MISS_CHAR) then

3475: end if;
3476: if (p_data_type <> FND_API.G_MISS_CHAR) then
3477: l_attributes_rec.data_type := p_data_type;
3478: end if;
3479: if (p_name <> FND_API.G_MISS_CHAR) then
3480: l_attributes_tl_rec.name := p_name;
3481: end if;
3482: if (p_created_by <> FND_API.G_MISS_NUM) then
3483: l_created_by := p_created_by;

Line 3482: if (p_created_by <> FND_API.G_MISS_NUM) then

3478: end if;
3479: if (p_name <> FND_API.G_MISS_CHAR) then
3480: l_attributes_tl_rec.name := p_name;
3481: end if;
3482: if (p_created_by <> FND_API.G_MISS_NUM) then
3483: l_created_by := p_created_by;
3484: end if;
3485: if (p_creation_date <> FND_API.G_MISS_DATE) then
3486: l_creation_date := p_creation_date;

Line 3485: if (p_creation_date <> FND_API.G_MISS_DATE) then

3481: end if;
3482: if (p_created_by <> FND_API.G_MISS_NUM) then
3483: l_created_by := p_created_by;
3484: end if;
3485: if (p_creation_date <> FND_API.G_MISS_DATE) then
3486: l_creation_date := p_creation_date;
3487: end if;
3488: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
3489: l_last_updated_by := p_last_updated_by;

Line 3488: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

3484: end if;
3485: if (p_creation_date <> FND_API.G_MISS_DATE) then
3486: l_creation_date := p_creation_date;
3487: end if;
3488: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
3489: l_last_updated_by := p_last_updated_by;
3490: end if;
3491: if (p_last_update_date <> FND_API.G_MISS_DATE) then
3492: l_last_update_date := p_last_update_date;

Line 3491: if (p_last_update_date <> FND_API.G_MISS_DATE) then

3487: end if;
3488: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
3489: l_last_updated_by := p_last_updated_by;
3490: end if;
3491: if (p_last_update_date <> FND_API.G_MISS_DATE) then
3492: l_last_update_date := p_last_update_date;
3493: end if;
3494: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3495: l_last_update_login := p_last_update_login;

Line 3494: if (p_last_update_login <> FND_API.G_MISS_NUM) then

3490: end if;
3491: if (p_last_update_date <> FND_API.G_MISS_DATE) then
3492: l_last_update_date := p_last_update_date;
3493: end if;
3494: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3495: l_last_update_login := p_last_update_login;
3496: end if;
3497:
3498: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

Line 3559: raise FND_API.G_EXC_ERROR;

3555: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3556: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');
3557: FND_MSG_PUB.Add;
3558: end if;
3559: raise FND_API.G_EXC_ERROR;
3560: end if;
3561:
3562: update AK_ATTRIBUTES_TL set
3563: NAME = l_attributes_tl_rec.name,

Line 3580: raise FND_API.G_EXC_ERROR;

3576: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');
3577: FND_MSG_PUB.Add;
3578: end if;
3579: -- dbms_output.put_line('TL Row does not exist during update');
3580: raise FND_API.G_EXC_ERROR;
3581: end if;
3582:
3583: -- /** commit the update **/
3584: commit;

Line 3594: p_return_status := FND_API.G_RET_STS_SUCCESS;

3590: FND_MSG_PUB.Add;
3591: end if;
3592:
3593: end if;
3594: p_return_status := FND_API.G_RET_STS_SUCCESS;
3595:
3596: FND_MSG_PUB.Count_And_Get (
3597: p_count => p_msg_count,
3598: p_data => p_msg_data);

Line 3613: p_return_status := FND_API.G_RET_STS_ERROR;

3609: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3610: ' ' || p_attribute_code);
3611: FND_MSG_PUB.Add;
3612: end if;
3613: p_return_status := FND_API.G_RET_STS_ERROR;
3614: rollback to start_update_attribute;
3615: FND_MSG_PUB.Count_And_Get (
3616: p_count => p_msg_count,
3617: p_data => p_msg_data);

Line 3618: WHEN FND_API.G_EXC_ERROR THEN

3614: rollback to start_update_attribute;
3615: FND_MSG_PUB.Count_And_Get (
3616: p_count => p_msg_count,
3617: p_data => p_msg_data);
3618: WHEN FND_API.G_EXC_ERROR THEN
3619: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3620: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');
3621: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3622: ' ' || p_attribute_code);

Line 3625: p_return_status := FND_API.G_RET_STS_ERROR;

3621: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3622: ' ' || p_attribute_code);
3623: FND_MSG_PUB.Add;
3624: end if;
3625: p_return_status := FND_API.G_RET_STS_ERROR;
3626: rollback to start_update_attribute;
3627: FND_MSG_PUB.Count_And_Get (
3628: p_count => p_msg_count,
3629: p_data => p_msg_data);

Line 3631: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3627: FND_MSG_PUB.Count_And_Get (
3628: p_count => p_msg_count,
3629: p_data => p_msg_data);
3630: WHEN OTHERS THEN
3631: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3632: rollback to start_update_attribute;
3633: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3634: SUBSTR (SQLERRM, 1, 240) );
3635: FND_MSG_PUB.Count_And_Get (

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

3664: -- Version Initial version number = 1.0
3665: -- History Current version number = 1.0
3666: --=======================================================
3667: procedure UPLOAD_ATTRIBUTE_SECOND (
3668: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3669: p_return_status OUT NOCOPY VARCHAR2,
3670: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3671: p_pass IN NUMBER := 2
3672: ) is

Line 3670: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

3666: --=======================================================
3667: procedure UPLOAD_ATTRIBUTE_SECOND (
3668: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3669: p_return_status OUT NOCOPY VARCHAR2,
3670: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3671: p_pass IN NUMBER := 2
3672: ) is
3673: l_api_name CONSTANT varchar2(30) := 'Upload_Attribute_Second';
3674: l_rec_index NUMBER;

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

3812: );
3813: end if; -- /* if ATTRIBUTE_EXISTS */
3814: --
3815: -- If API call returns with an error status, upload aborts
3816: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3817: (l_return_status = FND_API.G_RET_STS_ERROR) then
3818: RAISE FND_API.G_EXC_ERROR;
3819: end if; -- /* if l_return_status */
3820: end if; -- /* if G_ATTRIBUTE_REDO_TBL.exists */

Line 3817: (l_return_status = FND_API.G_RET_STS_ERROR) then

3813: end if; -- /* if ATTRIBUTE_EXISTS */
3814: --
3815: -- If API call returns with an error status, upload aborts
3816: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3817: (l_return_status = FND_API.G_RET_STS_ERROR) then
3818: RAISE FND_API.G_EXC_ERROR;
3819: end if; -- /* if l_return_status */
3820: end if; -- /* if G_ATTRIBUTE_REDO_TBL.exists */
3821: end loop; --/* for loop */

Line 3818: RAISE FND_API.G_EXC_ERROR;

3814: --
3815: -- If API call returns with an error status, upload aborts
3816: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3817: (l_return_status = FND_API.G_RET_STS_ERROR) then
3818: RAISE FND_API.G_EXC_ERROR;
3819: end if; -- /* if l_return_status */
3820: end if; -- /* if G_ATTRIBUTE_REDO_TBL.exists */
3821: end loop; --/* for loop */
3822: end if; -- /* if G_ATTRIBUTE_REDO_TBL.count */

Line 3824: p_return_status := FND_API.G_RET_STS_SUCCESS;

3820: end if; -- /* if G_ATTRIBUTE_REDO_TBL.exists */
3821: end loop; --/* for loop */
3822: end if; -- /* if G_ATTRIBUTE_REDO_TBL.count */
3823:
3824: p_return_status := FND_API.G_RET_STS_SUCCESS;
3825:
3826: EXCEPTION
3827: WHEN FND_API.G_EXC_ERROR THEN
3828: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3827: WHEN FND_API.G_EXC_ERROR THEN

3823:
3824: p_return_status := FND_API.G_RET_STS_SUCCESS;
3825:
3826: EXCEPTION
3827: WHEN FND_API.G_EXC_ERROR THEN
3828: p_return_status := FND_API.G_RET_STS_ERROR;
3829: FND_MSG_PUB.Count_And_Get (
3830: p_count => l_msg_count,
3831: p_data => l_msg_data);

Line 3828: p_return_status := FND_API.G_RET_STS_ERROR;

3824: p_return_status := FND_API.G_RET_STS_SUCCESS;
3825:
3826: EXCEPTION
3827: WHEN FND_API.G_EXC_ERROR THEN
3828: p_return_status := FND_API.G_RET_STS_ERROR;
3829: FND_MSG_PUB.Count_And_Get (
3830: p_count => l_msg_count,
3831: p_data => l_msg_data);
3832: WHEN OTHERS THEN

Line 3833: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3829: FND_MSG_PUB.Count_And_Get (
3830: p_count => l_msg_count,
3831: p_data => l_msg_data);
3832: WHEN OTHERS THEN
3833: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3834: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3835: SUBSTR (SQLERRM, 1, 240) );
3836: FND_MSG_PUB.Count_And_Get (
3837: p_count => l_msg_count,