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 638: if (p_attribute_label_length <> FND_API.G_MISS_NUM) then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 935: raise FND_API.G_EXC_ERROR;

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

Line 987: p_return_status := FND_API.G_RET_STS_SUCCESS;

983: end if;
984:
985: end if; -- /* if not p_copy_redo_flag */
986:
987: p_return_status := FND_API.G_RET_STS_SUCCESS;
988:
989: FND_MSG_PUB.Count_And_Get (
990: p_count => p_msg_count,
991: p_data => p_msg_data);

Line 1005: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1010: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1017: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1082: p_pass => p_pass,
1083: p_copy_redo_flag => p_copy_redo_flag
1084: );
1085: else
1086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: rollback to start_create_attribute;
1088: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1089: SUBSTR (SQLERRM, 1, 240) );
1090: FND_MSG_PUB.Count_And_Get (

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

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

Line 1154: IF NOT FND_API.Compatible_API_Call (

1150: l_region_code VARCHAR2(30);
1151: l_return_status varchar2(1);
1152: begin
1153:
1154: IF NOT FND_API.Compatible_API_Call (
1155: l_api_version_number, p_api_version_number, l_api_name,
1156: G_PKG_NAME) then
1157: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158: return;

Line 1157: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1181: raise FND_API.G_EXC_ERROR;

1177: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1178: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1179: FND_MSG_PUB.Add;
1180: end if;
1181: raise FND_API.G_EXC_ERROR;
1182: end if;
1183:
1184: if (p_delete_cascade = 'N') then
1185: --

Line 1200: raise FND_API.G_EXC_ERROR;

1196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1197: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_OA');
1198: FND_MSG_PUB.Add;
1199: end if;
1200: raise FND_API.G_EXC_ERROR;
1201: end if;
1202: close l_get_obj_attr_csr;
1203: --
1204: -- AK_REGION_ITEMS

Line 1214: raise FND_API.G_EXC_ERROR;

1210: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1211: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_RI');
1212: FND_MSG_PUB.Add;
1213: end if;
1214: raise FND_API.G_EXC_ERROR;
1215: end if;
1216: close l_get_region_item_csr;
1217:
1218: else

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

1235: p_attribute_application_id => p_attribute_application_id,
1236: p_attribute_code => p_attribute_code,
1237: p_delete_cascade => p_delete_cascade
1238: );
1239: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1240: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1241: close l_get_obj_attr_csr;
1242: raise FND_API.G_EXC_ERROR;
1243: end if;

Line 1240: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1236: p_attribute_code => p_attribute_code,
1237: p_delete_cascade => p_delete_cascade
1238: );
1239: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1240: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1241: close l_get_obj_attr_csr;
1242: raise FND_API.G_EXC_ERROR;
1243: end if;
1244: end loop;

Line 1242: raise FND_API.G_EXC_ERROR;

1238: );
1239: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1240: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1241: close l_get_obj_attr_csr;
1242: raise FND_API.G_EXC_ERROR;
1243: end if;
1244: end loop;
1245: close l_get_obj_attr_csr;
1246: --

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

1261: p_attribute_application_id => p_attribute_application_id,
1262: p_attribute_code => p_attribute_code,
1263: p_delete_cascade => p_delete_cascade
1264: );
1265: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1266: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1267: close l_get_region_item_csr;
1268: raise FND_API.G_EXC_ERROR;
1269: end if;

Line 1266: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1262: p_attribute_code => p_attribute_code,
1263: p_delete_cascade => p_delete_cascade
1264: );
1265: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1266: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1267: close l_get_region_item_csr;
1268: raise FND_API.G_EXC_ERROR;
1269: end if;
1270: end loop;

Line 1268: raise FND_API.G_EXC_ERROR;

1264: );
1265: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1266: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1267: close l_get_region_item_csr;
1268: raise FND_API.G_EXC_ERROR;
1269: end if;
1270: end loop;
1271: close l_get_region_item_csr;
1272:

Line 1288: raise FND_API.G_EXC_ERROR;

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

Line 1300: raise FND_API.G_EXC_ERROR;

1296: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1297: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1298: FND_MSG_PUB.Add;
1299: end if;
1300: raise FND_API.G_EXC_ERROR;
1301: end if;
1302:
1303: --
1304: -- Load success message

Line 1313: p_return_status := FND_API.G_RET_STS_SUCCESS;

1309: ' ' || p_attribute_code);
1310: FND_MSG_PUB.Add;
1311: end if;
1312:
1313: p_return_status := FND_API.G_RET_STS_SUCCESS;
1314:
1315: FND_MSG_PUB.Count_And_Get (
1316: p_count => p_msg_count,
1317: p_data => p_msg_data);

Line 1320: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1327: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1333: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 1375: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then

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

Line 1405: raise FND_API.G_EXC_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1753: (l_return_status = FND_API.G_RET_STS_ERROR) then

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

Line 1754: RAISE FND_API.G_EXC_ERROR;

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

Line 1757: p_return_status := FND_API.G_RET_STS_SUCCESS;

1753: (l_return_status = FND_API.G_RET_STS_ERROR) then
1754: RAISE FND_API.G_EXC_ERROR;
1755: end if;
1756:
1757: p_return_status := FND_API.G_RET_STS_SUCCESS;
1758:
1759: EXCEPTION
1760: WHEN VALUE_ERROR THEN
1761: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1773: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1774: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1782: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1784: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1780: FND_MSG_PUB.Add;
1781: end if;
1782: p_return_status := FND_API.G_RET_STS_ERROR;
1783: WHEN OTHERS THEN
1784: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1785: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1786: SUBSTR (SQLERRM, 1, 240) );
1787: FND_MSG_PUB.Add;
1788: end WRITE_TO_BUFFER;

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

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

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

1827: procedure DOWNLOAD_ATTRIBUTE (
1828: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1829: p_api_version_number IN NUMBER,
1830: p_return_status OUT NOCOPY VARCHAR2,
1831: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1832: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
1833: := AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL,
1834: p_nls_language IN VARCHAR2
1835: ) is

Line 1883: IF NOT FND_API.Compatible_API_Call (

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

Line 1886: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1882: begin
1883: IF NOT FND_API.Compatible_API_Call (
1884: l_api_version_number, p_api_version_number, l_api_name,
1885: G_PKG_NAME) then
1886: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1887: return;
1888: END IF;
1889:
1890: --

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

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

Line 1904: raise FND_API.G_EXC_ERROR;

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

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

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

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

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

Line 1922: raise FND_API.G_EXC_ERROR;

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

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

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

Line 1969: raise FND_API.G_EXC_ERROR;

1965: --
1966: -- abort Download if validation has been failed
1967: --
1968: if (l_return_status = FND_API.G_RET_STS_ERROR) then
1969: raise FND_API.G_EXC_ERROR;
1970: end if;
1971: end loop;
1972: close l_get_attribute_1_csr;
1973:

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

1982: if (p_attribute_pk_tbl.exists(i)) then
1983: --
1984: -- default application ID to p_application_id if not given
1985: --
1986: if (p_attribute_pk_tbl(i).attribute_appl_id = FND_API.G_MISS_NUM) then
1987: l_attribute_appl_id := p_application_id;
1988: else
1989: l_attribute_appl_id := p_attribute_pk_tbl(i).attribute_appl_id;
1990: end if;

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

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

Line 2021: raise FND_API.G_EXC_ERROR;

2017: --
2018: -- abort Download if validation has been failed
2019: --
2020: if (l_return_status = FND_API.G_RET_STS_ERROR) then
2021: raise FND_API.G_EXC_ERROR;
2022: end if;
2023: end loop;
2024: close l_get_attribute_2p_csr;
2025: else

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

2064: );
2065: --
2066: -- abort Download if validation has been failed
2067: --
2068: if (l_return_status = FND_API.G_RET_STS_ERROR) then
2069: raise FND_API.G_EXC_ERROR;
2070: end if;
2071: end if; /* if l_attribute_found */
2072: end if; /* if l_percent */

Line 2069: raise FND_API.G_EXC_ERROR;

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

Line 2078: p_return_status := FND_API.G_RET_STS_SUCCESS;

2074: end if; /* if exists(i) */
2075: end loop;
2076: end if;
2077:
2078: p_return_status := FND_API.G_RET_STS_SUCCESS;
2079:
2080: EXCEPTION
2081: WHEN FND_API.G_EXC_ERROR THEN
2082: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2081: WHEN FND_API.G_EXC_ERROR THEN

2077:
2078: p_return_status := FND_API.G_RET_STS_SUCCESS;
2079:
2080: EXCEPTION
2081: WHEN FND_API.G_EXC_ERROR THEN
2082: p_return_status := FND_API.G_RET_STS_ERROR;
2083: WHEN OTHERS THEN
2084: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

Line 2082: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2084: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2080: EXCEPTION
2081: WHEN FND_API.G_EXC_ERROR THEN
2082: p_return_status := FND_API.G_RET_STS_ERROR;
2083: WHEN OTHERS THEN
2084: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2086: SUBSTR (SQLERRM, 1, 240) );
2087: end DOWNLOAD_ATTRIBUTE;
2088:

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

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

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

2139: p_api_version_number IN NUMBER,
2140: p_return_status OUT NOCOPY VARCHAR2,
2141: p_index IN OUT NOCOPY NUMBER,
2142: p_loader_timestamp IN DATE,
2143: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
2144: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
2145: p_line_num_out OUT NOCOPY NUMBER,
2146: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
2147: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

Line 2176: IF NOT FND_API.Compatible_API_Call (

2172: l_user_id2 NUMBER;
2173: l_update1 DATE;
2174: l_update2 DATE;
2175: begin
2176: IF NOT FND_API.Compatible_API_Call (
2177: l_api_version_number, p_api_version_number, l_api_name,
2178: G_PKG_NAME) then
2179: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2180: return;

Line 2179: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

2201: else
2202: l_buffer := null;
2203: end if;
2204:
2205: if (p_line_num = FND_API.G_MISS_NUM) then
2206: l_line_num := 0;
2207: else
2208: l_line_num := p_line_num;
2209: end if;

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

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

Line 2221: (l_return_status = FND_API.G_RET_STS_ERROR) then

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

Line 2222: RAISE FND_API.G_EXC_ERROR;

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

Line 2244: raise FND_API.G_EXC_ERROR;

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

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

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

Line 2263: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

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

Line 2270: raise FND_API.G_EXC_ERROR;

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

Line 2287: raise FND_API.G_EXC_ERROR;

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

Line 2312: raise FND_API.G_EXC_ERROR;

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

Line 2328: raise FND_API.G_EXC_ERROR;

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

Line 2411: raise FND_API.G_EXC_ERROR;

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

Line 2425: raise FND_API.G_EXC_ERROR;

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

Line 2585: raise FND_API.G_EXC_ERROR;

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

Line 2600: raise FND_API.G_EXC_ERROR;

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

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

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

Line 2846: (l_return_status = FND_API.G_RET_STS_ERROR) then

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

Line 2847: RAISE FND_API.G_EXC_ERROR;

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

Line 2866: raise FND_API.G_EXC_ERROR;

2862: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2863: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');
2864: FND_MSG_PUB.Add;
2865: end if;
2866: raise FND_API.G_EXC_ERROR;
2867: end if;
2868: end if;
2869:
2870: --

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

2886: p_eof_flag => l_eof_flag,
2887: p_upl_loader_cur => p_upl_loader_cur
2888: );
2889:
2890: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2891: (l_return_status = FND_API.G_RET_STS_ERROR) then
2892: RAISE FND_API.G_EXC_ERROR;
2893: end if;
2894: l_line_num := l_line_num + l_lines_read;

Line 2891: (l_return_status = FND_API.G_RET_STS_ERROR) then

2887: p_upl_loader_cur => p_upl_loader_cur
2888: );
2889:
2890: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2891: (l_return_status = FND_API.G_RET_STS_ERROR) then
2892: RAISE FND_API.G_EXC_ERROR;
2893: end if;
2894: l_line_num := l_line_num + l_lines_read;
2895: --

Line 2892: RAISE FND_API.G_EXC_ERROR;

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

Line 2920: raise FND_API.G_EXC_ERROR;

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

Line 2928: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2934: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2935: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2937: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2946: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3022: WHEN FND_API.G_EXC_ERROR THEN

3018: p_attribute_pk_tbl(l_index).attribute_appl_id := p_attribute_application_id;
3019: p_attribute_pk_tbl(l_index).attribute_code := p_attribute_code;
3020:
3021: EXCEPTION
3022: WHEN FND_API.G_EXC_ERROR THEN
3023: p_return_status := FND_API.G_RET_STS_ERROR;
3024: WHEN OTHERS THEN
3025: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3026: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 3023: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3025: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

3063: p_msg_data OUT NOCOPY VARCHAR2,
3064: p_return_status OUT NOCOPY VARCHAR2,
3065: p_attribute_application_id IN NUMBER,
3066: p_attribute_code IN VARCHAR2,
3067: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3068: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3069: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3064: p_return_status OUT NOCOPY VARCHAR2,
3065: p_attribute_application_id IN NUMBER,
3066: p_attribute_code IN VARCHAR2,
3067: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3068: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3069: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3065: p_attribute_application_id IN NUMBER,
3066: p_attribute_code IN VARCHAR2,
3067: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3068: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3069: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3066: p_attribute_code IN VARCHAR2,
3067: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3068: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3069: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3067: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
3068: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3069: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3068: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
3069: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

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

3069: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
3070: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

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

3070: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

3071: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3072: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3073: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

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

3074: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3075: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3076: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3077: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3078: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3079: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,

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

3080: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

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

3081: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

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

3082: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3083: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3084: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3085: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3086: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3087: p_precision IN NUMBER := FND_API.G_MISS_NUM,
3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3088: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3089: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3090: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3091: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3092: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3093: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3094: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3095: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3096: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3097: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3098: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3099: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3100: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3101: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3102: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

3103: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

3104: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3112: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

3105: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3112: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3113: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

3106: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3112: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3113: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3114: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

3107: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3112: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3113: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3114: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3115: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

3108: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3112: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3113: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3114: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3115: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3116: p_pass IN NUMBER,

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

3109: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3112: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3113: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3114: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3115: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3116: p_pass IN NUMBER,
3117: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

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

3110: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3112: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3113: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3114: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3115: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3116: p_pass IN NUMBER,
3117: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
3118: ) is

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

3111: p_creation_date IN DATE := FND_API.G_MISS_DATE,
3112: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
3113: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
3114: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
3115: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3116: p_pass IN NUMBER,
3117: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
3118: ) is
3119: cursor l_get_row_csr is

Line 3163: IF NOT FND_API.Compatible_API_Call (

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

Line 3166: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3192: raise FND_API.G_EXC_ERROR;

3188: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
3189: FND_MSG_PUB.Add;
3190: end if;
3191: close l_get_row_csr;
3192: raise FND_API.G_EXC_ERROR;
3193: end if;
3194: close l_get_row_csr;
3195:
3196: --

Line 3208: raise FND_API.G_EXC_ERROR;

3204: FND_MSG_PUB.Add;
3205: end if;
3206: -- dbms_output.put_line('Error - TL Row does not exist');
3207: close l_get_tl_row_csr;
3208: raise FND_API.G_EXC_ERROR;
3209: end if;
3210: close l_get_tl_row_csr;
3211:
3212: --

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

3211:
3212: --
3213: -- validate table columns passed in
3214: --
3215: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) then
3216: if not VALIDATE_ATTRIBUTE (
3217: p_validation_level => p_validation_level,
3218: p_api_version_number => 1.0,
3219: p_return_status => l_return_status,

Line 3245: raise FND_API.G_EXC_ERROR;

3241: ) then
3242: if (p_pass = 1) then
3243: p_copy_redo_flag := TRUE;
3244: else
3245: raise FND_API.G_EXC_ERROR;
3246: end if; --/* if p_pass */
3247: end if;
3248: end if;
3249:

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

3254:
3255: -- - Cannot change data_type if there are attribute navigation,
3256: -- attribute value, or page region item data for this attribute
3257:
3258: if ((p_data_type is not null) and (p_data_type <> FND_API.G_MISS_CHAR) and
3259: (p_data_type <> l_attributes_rec.data_type)) then
3260:
3261: if (l_attributes_rec.data_type = 'URL') then
3262: /* see if any 'To URL attribute' in ak_flow_page_region_items */

Line 3274: raise FND_API.G_EXC_ERROR;

3270: FND_MESSAGE.SET_TOKEN('FORM','AK_PAGE_REGION_LINKS', TRUE);
3271: FND_MSG_PUB.Add;
3272: end if;
3273: -- dbms_output.put_line(l_api_name || ' Cannot change data type');
3274: raise FND_API.G_EXC_ERROR;
3275: end if;
3276: close l_check_page_region_item_csr;
3277: else
3278: /* see if there are any attribute navigation for this non-URL type */

Line 3290: raise FND_API.G_EXC_ERROR;

3286: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_NAVIGATION', TRUE);
3287: FND_MSG_PUB.Add;
3288: end if;
3289: -- dbms_output.put_line(l_api_name || ' Cannot change data type');
3290: raise FND_API.G_EXC_ERROR;
3291: end if;
3292: close l_check_navigation_csr;
3293:
3294: /* see if there are any attribute values for this non-URL type */

Line 3305: raise FND_API.G_EXC_ERROR;

3301: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3302: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_VALUE', TRUE);
3303: FND_MSG_PUB.Add;
3304: end if;
3305: raise FND_API.G_EXC_ERROR;
3306: end if;
3307: close l_check_attr_value_csr;
3308: end if;
3309: end if;

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

3311: --
3312: -- Load record to be updated to the database
3313: -- - first load nullable columns
3314: --
3315: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) or
3316: (p_upper_case_flag is null) then
3317: l_attributes_rec.upper_case_flag := p_upper_case_flag;
3318: end if;
3319: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or

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

3315: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) or
3316: (p_upper_case_flag is null) then
3317: l_attributes_rec.upper_case_flag := p_upper_case_flag;
3318: end if;
3319: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or
3320: (p_default_value_varchar2 is null) then
3321: l_attributes_rec.default_value_varchar2 := p_default_value_varchar2;
3322: end if;
3323: if (p_default_value_number <> FND_API.G_MISS_NUM) or

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

3319: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or
3320: (p_default_value_varchar2 is null) then
3321: l_attributes_rec.default_value_varchar2 := p_default_value_varchar2;
3322: end if;
3323: if (p_default_value_number <> FND_API.G_MISS_NUM) or
3324: (p_default_value_number is null) then
3325: l_attributes_rec.default_value_number := p_default_value_number;
3326: end if;
3327: if (p_default_value_date <> FND_API.G_MISS_DATE) or

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

3323: if (p_default_value_number <> FND_API.G_MISS_NUM) or
3324: (p_default_value_number is null) then
3325: l_attributes_rec.default_value_number := p_default_value_number;
3326: end if;
3327: if (p_default_value_date <> FND_API.G_MISS_DATE) or
3328: (p_default_value_date is null) then
3329: l_attributes_rec.default_value_date := p_default_value_date;
3330: end if;
3331: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or

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

3327: if (p_default_value_date <> FND_API.G_MISS_DATE) or
3328: (p_default_value_date is null) then
3329: l_attributes_rec.default_value_date := p_default_value_date;
3330: end if;
3331: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or
3332: (p_lov_region_application_id is null) then
3333: l_attributes_rec.lov_region_application_id := p_lov_region_application_id;
3334: end if;
3335: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or

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

3331: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or
3332: (p_lov_region_application_id is null) then
3333: l_attributes_rec.lov_region_application_id := p_lov_region_application_id;
3334: end if;
3335: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or
3336: (p_lov_region_code is null) then
3337: l_attributes_rec.lov_region_code := p_lov_region_code;
3338: end if;
3339: -- JSP new columns

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

3336: (p_lov_region_code is null) then
3337: l_attributes_rec.lov_region_code := p_lov_region_code;
3338: end if;
3339: -- JSP new columns
3340: if (p_item_style <> FND_API.G_MISS_CHAR) and
3341: (p_item_style is not null) then
3342: l_attributes_rec.item_style := p_item_style;
3343: else
3344: l_attributes_rec.item_style := l_item_style;

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

3342: l_attributes_rec.item_style := p_item_style;
3343: else
3344: l_attributes_rec.item_style := l_item_style;
3345: end if;
3346: if (p_display_height <> FND_API.G_MISS_NUM) or
3347: (p_display_height is null) then
3348: l_attributes_rec.display_height := p_display_height;
3349: end if;
3350: if (p_css_class_name <> FND_API.G_MISS_CHAR) or

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

3346: if (p_display_height <> FND_API.G_MISS_NUM) or
3347: (p_display_height is null) then
3348: l_attributes_rec.display_height := p_display_height;
3349: end if;
3350: if (p_css_class_name <> FND_API.G_MISS_CHAR) or
3351: (p_css_class_name is null) then
3352: l_attributes_rec.css_class_name := p_css_class_name;
3353: end if;
3354: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) or

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

3350: if (p_css_class_name <> FND_API.G_MISS_CHAR) or
3351: (p_css_class_name is null) then
3352: l_attributes_rec.css_class_name := p_css_class_name;
3353: end if;
3354: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) or
3355: (p_poplist_viewobject is null) then
3356: l_attributes_rec.poplist_viewobject := p_poplist_viewobject;
3357: end if;
3358: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) or

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

3354: if (p_poplist_viewobject <> FND_API.G_MISS_CHAR) or
3355: (p_poplist_viewobject is null) then
3356: l_attributes_rec.poplist_viewobject := p_poplist_viewobject;
3357: end if;
3358: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) or
3359: (p_poplist_display_attr is null) then
3360: l_attributes_rec.poplist_display_attribute := p_poplist_display_attr;
3361: end if;
3362: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) or

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

3358: if (p_poplist_display_attr <> FND_API.G_MISS_CHAR) or
3359: (p_poplist_display_attr is null) then
3360: l_attributes_rec.poplist_display_attribute := p_poplist_display_attr;
3361: end if;
3362: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) or
3363: (p_poplist_value_attr is null) then
3364: l_attributes_rec.poplist_value_attribute := p_poplist_value_attr;
3365: end if;
3366: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) or

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

3362: if (p_poplist_value_attr <> FND_API.G_MISS_CHAR) or
3363: (p_poplist_value_attr is null) then
3364: l_attributes_rec.poplist_value_attribute := p_poplist_value_attr;
3365: end if;
3366: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) or
3367: (p_css_label_class_name is null) then
3368: l_attributes_rec.css_label_class_name := p_css_label_class_name;
3369: end if;
3370: if (p_precision <> FND_API.G_MISS_NUM) or

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

3366: if (p_css_label_class_name <> FND_API.G_MISS_CHAR) or
3367: (p_css_label_class_name is null) then
3368: l_attributes_rec.css_label_class_name := p_css_label_class_name;
3369: end if;
3370: if (p_precision <> FND_API.G_MISS_NUM) or
3371: (p_precision is null) then
3372: l_attributes_rec.precision := p_precision;
3373: end if;
3374: if (p_expansion <> FND_API.G_MISS_NUM) or

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

3370: if (p_precision <> FND_API.G_MISS_NUM) or
3371: (p_precision is null) then
3372: l_attributes_rec.precision := p_precision;
3373: end if;
3374: if (p_expansion <> FND_API.G_MISS_NUM) or
3375: (p_expansion is null) then
3376: l_attributes_rec.expansion := p_expansion;
3377: end if;
3378: if (p_als_max_length <> FND_API.G_MISS_NUM) or

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

3374: if (p_expansion <> FND_API.G_MISS_NUM) or
3375: (p_expansion is null) then
3376: l_attributes_rec.expansion := p_expansion;
3377: end if;
3378: if (p_als_max_length <> FND_API.G_MISS_NUM) or
3379: (p_als_max_length is null) then
3380: l_attributes_rec.als_max_length := p_als_max_length;
3381: end if;
3382:

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

3379: (p_als_max_length is null) then
3380: l_attributes_rec.als_max_length := p_als_max_length;
3381: end if;
3382:
3383: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
3384: (p_attribute_category is null) then
3385: l_attributes_rec.attribute_category := p_attribute_category;
3386: end if;
3387: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

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

3383: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
3384: (p_attribute_category is null) then
3385: l_attributes_rec.attribute_category := p_attribute_category;
3386: end if;
3387: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
3388: (p_attribute1 is null) then
3389: l_attributes_rec.attribute1 := p_attribute1;
3390: end if;
3391: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

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

3387: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
3388: (p_attribute1 is null) then
3389: l_attributes_rec.attribute1 := p_attribute1;
3390: end if;
3391: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
3392: (p_attribute2 is null) then
3393: l_attributes_rec.attribute2 := p_attribute2;
3394: end if;
3395: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

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

3391: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
3392: (p_attribute2 is null) then
3393: l_attributes_rec.attribute2 := p_attribute2;
3394: end if;
3395: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
3396: (p_attribute3 is null) then
3397: l_attributes_rec.attribute3 := p_attribute3;
3398: end if;
3399: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

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

3395: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
3396: (p_attribute3 is null) then
3397: l_attributes_rec.attribute3 := p_attribute3;
3398: end if;
3399: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
3400: (p_attribute4 is null) then
3401: l_attributes_rec.attribute4 := p_attribute4;
3402: end if;
3403: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

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

3399: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
3400: (p_attribute4 is null) then
3401: l_attributes_rec.attribute4 := p_attribute4;
3402: end if;
3403: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
3404: (p_attribute5 is null) then
3405: l_attributes_rec.attribute5 := p_attribute5;
3406: end if;
3407: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

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

3403: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
3404: (p_attribute5 is null) then
3405: l_attributes_rec.attribute5 := p_attribute5;
3406: end if;
3407: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
3408: (p_attribute6 is null) then
3409: l_attributes_rec.attribute6 := p_attribute6;
3410: end if;
3411: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

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

3407: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
3408: (p_attribute6 is null) then
3409: l_attributes_rec.attribute6 := p_attribute6;
3410: end if;
3411: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
3412: (p_attribute7 is null) then
3413: l_attributes_rec.attribute7 := p_attribute7;
3414: end if;
3415: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

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

3411: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
3412: (p_attribute7 is null) then
3413: l_attributes_rec.attribute7 := p_attribute7;
3414: end if;
3415: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
3416: (p_attribute8 is null) then
3417: l_attributes_rec.attribute8 := p_attribute8;
3418: end if;
3419: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

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

3415: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
3416: (p_attribute8 is null) then
3417: l_attributes_rec.attribute8 := p_attribute8;
3418: end if;
3419: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
3420: (p_attribute9 is null) then
3421: l_attributes_rec.attribute9 := p_attribute9;
3422: end if;
3423: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

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

3419: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
3420: (p_attribute9 is null) then
3421: l_attributes_rec.attribute9 := p_attribute9;
3422: end if;
3423: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
3424: (p_attribute10 is null) then
3425: l_attributes_rec.attribute10 := p_attribute10;
3426: end if;
3427: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

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

3423: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
3424: (p_attribute10 is null) then
3425: l_attributes_rec.attribute10 := p_attribute10;
3426: end if;
3427: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
3428: (p_attribute11 is null) then
3429: l_attributes_rec.attribute11 := p_attribute11;
3430: end if;
3431: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

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

3427: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
3428: (p_attribute11 is null) then
3429: l_attributes_rec.attribute11 := p_attribute11;
3430: end if;
3431: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
3432: (p_attribute12 is null) then
3433: l_attributes_rec.attribute12 := p_attribute12;
3434: end if;
3435: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

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

3431: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
3432: (p_attribute12 is null) then
3433: l_attributes_rec.attribute12 := p_attribute12;
3434: end if;
3435: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
3436: (p_attribute13 is null) then
3437: l_attributes_rec.attribute13 := p_attribute13;
3438: end if;
3439: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

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

3435: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
3436: (p_attribute13 is null) then
3437: l_attributes_rec.attribute13 := p_attribute13;
3438: end if;
3439: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
3440: (p_attribute14 is null) then
3441: l_attributes_rec.attribute14 := p_attribute14;
3442: end if;
3443: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

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

3439: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
3440: (p_attribute14 is null) then
3441: l_attributes_rec.attribute14 := p_attribute14;
3442: end if;
3443: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
3444: (p_attribute15 is null) then
3445: l_attributes_rec.attribute15 := p_attribute15;
3446: end if;
3447: if (p_attribute_label_length <> FND_API.G_MISS_NUM) or

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

3443: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
3444: (p_attribute15 is null) then
3445: l_attributes_rec.attribute15 := p_attribute15;
3446: end if;
3447: if (p_attribute_label_length <> FND_API.G_MISS_NUM) or
3448: (p_attribute_label_length is null) then
3449: l_attributes_rec.attribute_label_length := p_attribute_label_length;
3450: end if;
3451: if (p_attribute_value_length <> FND_API.G_MISS_NUM) or

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

3447: if (p_attribute_label_length <> FND_API.G_MISS_NUM) or
3448: (p_attribute_label_length is null) then
3449: l_attributes_rec.attribute_label_length := p_attribute_label_length;
3450: end if;
3451: if (p_attribute_value_length <> FND_API.G_MISS_NUM) or
3452: (p_attribute_value_length is null) then
3453: l_attributes_rec.attribute_value_length := p_attribute_value_length;
3454: end if;
3455: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or

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

3451: if (p_attribute_value_length <> FND_API.G_MISS_NUM) or
3452: (p_attribute_value_length is null) then
3453: l_attributes_rec.attribute_value_length := p_attribute_value_length;
3454: end if;
3455: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or
3456: (p_attribute_label_long is null) then
3457: l_attributes_tl_rec.attribute_label_long := p_attribute_label_long;
3458: end if;
3459: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or

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

3455: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or
3456: (p_attribute_label_long is null) then
3457: l_attributes_tl_rec.attribute_label_long := p_attribute_label_long;
3458: end if;
3459: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or
3460: (p_attribute_label_short is null) then
3461: l_attributes_tl_rec.attribute_label_short := p_attribute_label_short;
3462: end if;
3463: if (p_description <> FND_API.G_MISS_CHAR) or

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

3459: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or
3460: (p_attribute_label_short is null) then
3461: l_attributes_tl_rec.attribute_label_short := p_attribute_label_short;
3462: end if;
3463: if (p_description <> FND_API.G_MISS_CHAR) or
3464: (p_description is null) then
3465: l_attributes_tl_rec.description := p_description;
3466: end if;
3467:

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

3467:
3468: --
3469: -- - next, load non-null columns
3470: --
3471: if (p_bold <> FND_API.G_MISS_CHAR) then
3472: l_attributes_rec.bold := p_bold;
3473: end if;
3474: if (p_italic <> FND_API.G_MISS_CHAR) then
3475: l_attributes_rec.italic := p_italic;

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

3470: --
3471: if (p_bold <> FND_API.G_MISS_CHAR) then
3472: l_attributes_rec.bold := p_bold;
3473: end if;
3474: if (p_italic <> FND_API.G_MISS_CHAR) then
3475: l_attributes_rec.italic := p_italic;
3476: end if;
3477: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
3478: l_attributes_rec.vertical_alignment := p_vertical_alignment;

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

3473: end if;
3474: if (p_italic <> FND_API.G_MISS_CHAR) then
3475: l_attributes_rec.italic := p_italic;
3476: end if;
3477: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
3478: l_attributes_rec.vertical_alignment := p_vertical_alignment;
3479: end if;
3480: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
3481: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;

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

3476: end if;
3477: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
3478: l_attributes_rec.vertical_alignment := p_vertical_alignment;
3479: end if;
3480: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
3481: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;
3482: end if;
3483: if (p_data_type <> FND_API.G_MISS_CHAR) then
3484: l_attributes_rec.data_type := p_data_type;

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

3479: end if;
3480: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
3481: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;
3482: end if;
3483: if (p_data_type <> FND_API.G_MISS_CHAR) then
3484: l_attributes_rec.data_type := p_data_type;
3485: end if;
3486: if (p_name <> FND_API.G_MISS_CHAR) then
3487: l_attributes_tl_rec.name := p_name;

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

3482: end if;
3483: if (p_data_type <> FND_API.G_MISS_CHAR) then
3484: l_attributes_rec.data_type := p_data_type;
3485: end if;
3486: if (p_name <> FND_API.G_MISS_CHAR) then
3487: l_attributes_tl_rec.name := p_name;
3488: end if;
3489: if (p_created_by <> FND_API.G_MISS_NUM) then
3490: l_created_by := p_created_by;

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

3485: end if;
3486: if (p_name <> FND_API.G_MISS_CHAR) then
3487: l_attributes_tl_rec.name := p_name;
3488: end if;
3489: if (p_created_by <> FND_API.G_MISS_NUM) then
3490: l_created_by := p_created_by;
3491: end if;
3492: if (p_creation_date <> FND_API.G_MISS_DATE) then
3493: l_creation_date := p_creation_date;

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

3488: end if;
3489: if (p_created_by <> FND_API.G_MISS_NUM) then
3490: l_created_by := p_created_by;
3491: end if;
3492: if (p_creation_date <> FND_API.G_MISS_DATE) then
3493: l_creation_date := p_creation_date;
3494: end if;
3495: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
3496: l_last_updated_by := p_last_updated_by;

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

3491: end if;
3492: if (p_creation_date <> FND_API.G_MISS_DATE) then
3493: l_creation_date := p_creation_date;
3494: end if;
3495: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
3496: l_last_updated_by := p_last_updated_by;
3497: end if;
3498: if (p_last_update_date <> FND_API.G_MISS_DATE) then
3499: l_last_update_date := p_last_update_date;

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

3494: end if;
3495: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
3496: l_last_updated_by := p_last_updated_by;
3497: end if;
3498: if (p_last_update_date <> FND_API.G_MISS_DATE) then
3499: l_last_update_date := p_last_update_date;
3500: end if;
3501: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3502: l_last_update_login := p_last_update_login;

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

3497: end if;
3498: if (p_last_update_date <> FND_API.G_MISS_DATE) then
3499: l_last_update_date := p_last_update_date;
3500: end if;
3501: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3502: l_last_update_login := p_last_update_login;
3503: end if;
3504:
3505: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

Line 3566: raise FND_API.G_EXC_ERROR;

3562: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3563: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');
3564: FND_MSG_PUB.Add;
3565: end if;
3566: raise FND_API.G_EXC_ERROR;
3567: end if;
3568:
3569: update AK_ATTRIBUTES_TL set
3570: NAME = l_attributes_tl_rec.name,

Line 3587: raise FND_API.G_EXC_ERROR;

3583: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');
3584: FND_MSG_PUB.Add;
3585: end if;
3586: -- dbms_output.put_line('TL Row does not exist during update');
3587: raise FND_API.G_EXC_ERROR;
3588: end if;
3589:
3590: -- /** commit the update **/
3591: commit;

Line 3604: p_return_status := FND_API.G_RET_STS_SUCCESS;

3600: end if;
3601:
3602: end if; -- /* if not p_copy_redo_flag */
3603:
3604: p_return_status := FND_API.G_RET_STS_SUCCESS;
3605:
3606: FND_MSG_PUB.Count_And_Get (
3607: p_count => p_msg_count,
3608: p_data => p_msg_data);

Line 3623: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3628: WHEN FND_API.G_EXC_ERROR THEN

3624: rollback to start_update_attribute;
3625: FND_MSG_PUB.Count_And_Get (
3626: p_count => p_msg_count,
3627: p_data => p_msg_data);
3628: WHEN FND_API.G_EXC_ERROR THEN
3629: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3630: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');
3631: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3632: ' ' || p_attribute_code);

Line 3635: p_return_status := FND_API.G_RET_STS_ERROR;

3631: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3632: ' ' || p_attribute_code);
3633: FND_MSG_PUB.Add;
3634: end if;
3635: p_return_status := FND_API.G_RET_STS_ERROR;
3636: rollback to start_update_attribute;
3637: FND_MSG_PUB.Count_And_Get (
3638: p_count => p_msg_count,
3639: p_data => p_msg_data);

Line 3641: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3637: FND_MSG_PUB.Count_And_Get (
3638: p_count => p_msg_count,
3639: p_data => p_msg_data);
3640: WHEN OTHERS THEN
3641: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3642: rollback to start_update_attribute;
3643: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3644: SUBSTR (SQLERRM, 1, 240) );
3645: FND_MSG_PUB.Count_And_Get (

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

3674: -- Version Initial version number = 1.0
3675: -- History Current version number = 1.0
3676: --=======================================================
3677: procedure UPLOAD_ATTRIBUTE_SECOND (
3678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3679: p_return_status OUT NOCOPY VARCHAR2,
3680: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3681: p_pass IN NUMBER := 2
3682: ) is

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

3676: --=======================================================
3677: procedure UPLOAD_ATTRIBUTE_SECOND (
3678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3679: p_return_status OUT NOCOPY VARCHAR2,
3680: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
3681: p_pass IN NUMBER := 2
3682: ) is
3683: l_api_name CONSTANT varchar2(30) := 'Upload_Attribute_Second';
3684: l_rec_index NUMBER;

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

3822: );
3823: end if; -- /* if ATTRIBUTE_EXISTS */
3824: --
3825: -- If API call returns with an error status, upload aborts
3826: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3827: (l_return_status = FND_API.G_RET_STS_ERROR) then
3828: RAISE FND_API.G_EXC_ERROR;
3829: end if; -- /* if l_return_status */
3830: end if; -- /* if G_ATTRIBUTE_REDO_TBL.exists */

Line 3827: (l_return_status = FND_API.G_RET_STS_ERROR) then

3823: end if; -- /* if ATTRIBUTE_EXISTS */
3824: --
3825: -- If API call returns with an error status, upload aborts
3826: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3827: (l_return_status = FND_API.G_RET_STS_ERROR) then
3828: RAISE FND_API.G_EXC_ERROR;
3829: end if; -- /* if l_return_status */
3830: end if; -- /* if G_ATTRIBUTE_REDO_TBL.exists */
3831: end loop; --/* for loop */

Line 3828: RAISE FND_API.G_EXC_ERROR;

3824: --
3825: -- If API call returns with an error status, upload aborts
3826: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3827: (l_return_status = FND_API.G_RET_STS_ERROR) then
3828: RAISE FND_API.G_EXC_ERROR;
3829: end if; -- /* if l_return_status */
3830: end if; -- /* if G_ATTRIBUTE_REDO_TBL.exists */
3831: end loop; --/* for loop */
3832: G_ATTRIBUTE_REDO_TBL.DELETE;

Line 3835: p_return_status := FND_API.G_RET_STS_SUCCESS;

3831: end loop; --/* for loop */
3832: G_ATTRIBUTE_REDO_TBL.DELETE;
3833: end if; -- /* if G_ATTRIBUTE_REDO_TBL.count */
3834:
3835: p_return_status := FND_API.G_RET_STS_SUCCESS;
3836:
3837: EXCEPTION
3838: WHEN FND_API.G_EXC_ERROR THEN
3839: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3838: WHEN FND_API.G_EXC_ERROR THEN

3834:
3835: p_return_status := FND_API.G_RET_STS_SUCCESS;
3836:
3837: EXCEPTION
3838: WHEN FND_API.G_EXC_ERROR THEN
3839: p_return_status := FND_API.G_RET_STS_ERROR;
3840: FND_MSG_PUB.Count_And_Get (
3841: p_count => l_msg_count,
3842: p_data => l_msg_data);

Line 3839: p_return_status := FND_API.G_RET_STS_ERROR;

3835: p_return_status := FND_API.G_RET_STS_SUCCESS;
3836:
3837: EXCEPTION
3838: WHEN FND_API.G_EXC_ERROR THEN
3839: p_return_status := FND_API.G_RET_STS_ERROR;
3840: FND_MSG_PUB.Count_And_Get (
3841: p_count => l_msg_count,
3842: p_data => l_msg_data);
3843: G_ATTRIBUTE_REDO_TBL.DELETE;

Line 3845: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3841: p_count => l_msg_count,
3842: p_data => l_msg_data);
3843: G_ATTRIBUTE_REDO_TBL.DELETE;
3844: WHEN OTHERS THEN
3845: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3846: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3847: SUBSTR (SQLERRM, 1, 240) );
3848: FND_MSG_PUB.Count_And_Get (
3849: p_count => l_msg_count,