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_MSG_PUB

Line 88: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
91: FND_MSG_PUB.Add;
92: end if;

Line 91: FND_MSG_PUB.Add;

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');
91: FND_MSG_PUB.Add;
92: end if;
93: end if;
94:
95: if ((p_attribute_code is null) or

Line 98: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
101: FND_MSG_PUB.Add;
102: end if;

Line 101: FND_MSG_PUB.Add;

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');
101: FND_MSG_PUB.Add;
102: end if;
103: end if;
104:
105: /*** check that required columns are not null and, unless calling ***/

Line 111: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
113: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
114: FND_MSG_PUB.Add;
115: end if;

Line 114: FND_MSG_PUB.Add;

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');
113: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
114: FND_MSG_PUB.Add;
115: end if;
116: end if;
117:
118: if ((p_italic is null) or

Line 122: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');
125: FND_MSG_PUB.Add;
126: end if;

Line 125: FND_MSG_PUB.Add;

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');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');
125: FND_MSG_PUB.Add;
126: end if;
127: end if;
128:
129: if ((p_vertical_alignment is null) or

Line 134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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
135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
137: FND_MSG_PUB.Add;
138: end if;

Line 137: FND_MSG_PUB.Add;

133: l_error := TRUE;
134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
137: FND_MSG_PUB.Add;
138: end if;
139: end if;
140:
141: if ((p_horizontal_alignment is null) or

Line 146: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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
147: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
148: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
149: FND_MSG_PUB.Add;
150: end if;

Line 149: FND_MSG_PUB.Add;

145: l_error := TRUE;
146: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
147: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
148: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
149: FND_MSG_PUB.Add;
150: end if;
151: end if;
152:
153: if ((p_data_type is null) or

Line 157: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
159: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_TYPE');
160: FND_MSG_PUB.Add;
161: end if;

Line 160: FND_MSG_PUB.Add;

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');
159: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_TYPE');
160: FND_MSG_PUB.Add;
161: end if;
162: end if;
163:
164: if ((p_name is null) or

Line 168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
170: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
171: FND_MSG_PUB.Add;
172: end if;

Line 171: FND_MSG_PUB.Add;

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');
170: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
171: FND_MSG_PUB.Add;
172: end if;
173: end if;
174:
175: --*** Validate columns ***

Line 185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

181: p_return_status => l_return_status,
182: p_application_id => p_attribute_application_id)
183: ) then
184: l_error := TRUE;
185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
186: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
187: FND_MESSAGE.SET_TOKEN('COLUMN','ATTRIBUTE_APPLICATION_ID');
188: FND_MSG_PUB.Add;
189: end if;

Line 188: FND_MSG_PUB.Add;

184: l_error := TRUE;
185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
186: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
187: FND_MESSAGE.SET_TOKEN('COLUMN','ATTRIBUTE_APPLICATION_ID');
188: FND_MSG_PUB.Add;
189: end if;
190: end if;
191: end if;
192:

Line 201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

197: p_return_status => l_return_status,
198: p_lookup_type => 'DATA_TYPE',
199: p_lookup_code => p_data_type) ) then
200: l_error := TRUE;
201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
202: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
203: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_TYPE');
204: FND_MSG_PUB.Add;
205: end if;

Line 204: FND_MSG_PUB.Add;

200: l_error := TRUE;
201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
202: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
203: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_TYPE');
204: FND_MSG_PUB.Add;
205: end if;
206: end if;
207: end if;
208:

Line 213: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
215: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
216: FND_MSG_PUB.Add;
217: end if;

Line 216: FND_MSG_PUB.Add;

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');
215: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
216: FND_MSG_PUB.Add;
217: end if;
218: end if;
219: end if;
220:

Line 225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
227: FND_MESSAGE.SET_TOKEN('COLUMN','UPPER_CASE_FLAG');
228: FND_MSG_PUB.Add;
229: end if;

Line 228: FND_MSG_PUB.Add;

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');
227: FND_MESSAGE.SET_TOKEN('COLUMN','UPPER_CASE_FLAG');
228: FND_MSG_PUB.Add;
229: end if;
230: end if;
231: end if;
232:

Line 237: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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');
239: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
240: FND_MSG_PUB.Add;
241: end if;

Line 240: FND_MSG_PUB.Add;

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');
239: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
240: FND_MSG_PUB.Add;
241: end if;
242: end if;
243: end if;
244:

Line 253: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

249: p_return_status => l_return_status,
250: p_lookup_type => 'VERTICAL_ALIGNMENT',
251: p_lookup_code => p_vertical_alignment)) then
252: l_error := TRUE;
253: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
254: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
255: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');
256: FND_MSG_PUB.Add;
257: end if;

Line 256: FND_MSG_PUB.Add;

252: l_error := TRUE;
253: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
254: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
255: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');
256: FND_MSG_PUB.Add;
257: end if;
258: end if;
259: end if;
260:

Line 269: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

265: p_return_status => l_return_status,
266: p_lookup_type => 'HORIZONTAL_ALIGNMENT',
267: p_lookup_code => p_horizontal_alignment)) then
268: l_error := TRUE;
269: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
270: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
271: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');
272: FND_MSG_PUB.Add;
273: end if;

Line 272: FND_MSG_PUB.Add;

268: l_error := TRUE;
269: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
270: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
271: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');
272: FND_MSG_PUB.Add;
273: end if;
274: -- dbms_output.put_line('Invalid Horizontal Alignment value');
275: end if;
276: end if;

Line 289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

285: p_return_status => l_return_status,
286: p_region_application_id => p_lov_region_application_id,
287: p_region_code => p_lov_region_code)) then
288: l_error := TRUE;
289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
290: FND_MESSAGE.SET_NAME('AK','AK_LOV_REG_DOES_NOT_EXIST');
291: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_lov_region_application_id)||' '||p_lov_region_code);
292: FND_MSG_PUB.Add;
293: end if;

Line 292: FND_MSG_PUB.Add;

288: l_error := TRUE;
289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
290: FND_MESSAGE.SET_NAME('AK','AK_LOV_REG_DOES_NOT_EXIST');
291: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_lov_region_application_id)||' '||p_lov_region_code);
292: FND_MSG_PUB.Add;
293: end if;
294: end if;
295: end if;
296:

Line 307: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 309: FND_MSG_PUB.Add;

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;
311:
312: end VALIDATE_ATTRIBUTE;
313:

Line 377: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 379: FND_MSG_PUB.Add;

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;
381:
382: end ATTRIBUTE_EXISTS;
383:

Line 532: FND_MSG_PUB.initialize;

528:
529: -- Initialize the message table if requested.
530:
531: if p_init_msg_tbl then
532: FND_MSG_PUB.initialize;
533: end if;
534:
535: savepoint start_create_attribute;
536:

Line 547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

543: p_api_version_number => 1.0,
544: p_return_status => l_return_status,
545: p_attribute_application_id => p_attribute_application_id,
546: p_attribute_code => p_attribute_code) then
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;

Line 549: FND_MSG_PUB.Add;

545: p_attribute_application_id => p_attribute_application_id,
546: p_attribute_code => p_attribute_code) then
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:

Line 928: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

924: p_api_version_number => 1.0,
925: p_return_status => l_return_status,
926: p_attribute_application_id => p_attribute_application_id,
927: p_attribute_code => p_attribute_code) then
928: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
929: FND_MESSAGE.SET_NAME('AK','AK_INSERT_ATTRIBUTE_FAILED');
930: FND_MESSAGE.SET_TOKEN('OBJECT','AK_LC_ATTRIBUTE',TRUE);
931: FND_MSG_PUB.Add;
932: end if;

Line 931: FND_MSG_PUB.Add;

927: p_attribute_code => p_attribute_code) then
928: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
929: FND_MESSAGE.SET_NAME('AK','AK_INSERT_ATTRIBUTE_FAILED');
930: FND_MESSAGE.SET_TOKEN('OBJECT','AK_LC_ATTRIBUTE',TRUE);
931: FND_MSG_PUB.Add;
932: end if;
933: raise FND_API.G_EXC_ERROR;
934: end if;
935:

Line 976: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

972:
973: -- /** commit the insert **/
974: commit;
975:
976: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
977: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_CREATED');
978: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
979: ' ' || p_attribute_code);
980: FND_MSG_PUB.Add;

Line 980: FND_MSG_PUB.Add;

976: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
977: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_CREATED');
978: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
979: ' ' || p_attribute_code);
980: FND_MSG_PUB.Add;
981: end if;
982:
983: p_return_status := FND_API.G_RET_STS_SUCCESS;
984:

Line 985: FND_MSG_PUB.Count_And_Get (

981: end if;
982:
983: p_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: FND_MSG_PUB.Count_And_Get (
986: p_count => p_msg_count,
987: p_data => p_msg_data);
988:
989:

Line 992: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

988:
989:
990: EXCEPTION
991: WHEN VALUE_ERROR THEN
992: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
993: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
994: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
995: ' ' || p_attribute_code);
996: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_CREATED');

Line 999: FND_MSG_PUB.Add;

995: ' ' || p_attribute_code);
996: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_CREATED');
997: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
998: ' ' || p_attribute_code);
999: FND_MSG_PUB.Add;
1000: end if;
1001: p_return_status := FND_API.G_RET_STS_ERROR;
1002: rollback to start_create_attribute;
1003: FND_MSG_PUB.Count_And_Get (

Line 1003: FND_MSG_PUB.Count_And_Get (

999: FND_MSG_PUB.Add;
1000: end if;
1001: p_return_status := FND_API.G_RET_STS_ERROR;
1002: rollback to start_create_attribute;
1003: FND_MSG_PUB.Count_And_Get (
1004: p_count => p_msg_count,
1005: p_data => p_msg_data);
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1007: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 1011: FND_MSG_PUB.Add;

1007: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1008: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_CREATED');
1009: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
1010: ' ' || p_attribute_code);
1011: FND_MSG_PUB.Add;
1012: end if;
1013: p_return_status := FND_API.G_RET_STS_ERROR;
1014: rollback to start_create_attribute;
1015: FND_MSG_PUB.Count_And_Get (

Line 1015: FND_MSG_PUB.Count_And_Get (

1011: FND_MSG_PUB.Add;
1012: end if;
1013: p_return_status := FND_API.G_RET_STS_ERROR;
1014: rollback to start_create_attribute;
1015: FND_MSG_PUB.Count_And_Get (
1016: p_count => p_msg_count,
1017: p_data => p_msg_data);
1018: WHEN OTHERS THEN
1019: if (SQLCODE = -1) then

Line 1084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

1080: );
1081: else
1082: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: rollback to start_create_attribute;
1084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1085: SUBSTR (SQLERRM, 1, 240) );
1086: FND_MSG_PUB.Count_And_Get (
1087: p_count => p_msg_count,
1088: p_data => p_msg_data);

Line 1086: FND_MSG_PUB.Count_And_Get (

1082: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: rollback to start_create_attribute;
1084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1085: SUBSTR (SQLERRM, 1, 240) );
1086: FND_MSG_PUB.Count_And_Get (
1087: p_count => p_msg_count,
1088: p_data => p_msg_data);
1089: end if;
1090: end CREATE_ATTRIBUTE;

Line 1160: FND_MSG_PUB.initialize;

1156:
1157: -- Initialize the message table if requested.
1158:
1159: if p_init_msg_tbl then
1160: FND_MSG_PUB.initialize;
1161: end if;
1162:
1163: savepoint start_delete_attribute;
1164:

Line 1173: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1169: p_api_version_number => 1.0,
1170: p_return_status => l_return_status,
1171: p_attribute_application_id => p_attribute_application_id,
1172: p_attribute_code => p_attribute_code) then
1173: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1174: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1175: FND_MSG_PUB.Add;
1176: end if;
1177: raise FND_API.G_EXC_ERROR;

Line 1175: FND_MSG_PUB.Add;

1171: p_attribute_application_id => p_attribute_application_id,
1172: p_attribute_code => p_attribute_code) then
1173: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1174: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1175: FND_MSG_PUB.Add;
1176: end if;
1177: raise FND_API.G_EXC_ERROR;
1178: end if;
1179:

Line 1192: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1188: open l_get_obj_attr_csr;
1189: fetch l_get_obj_attr_csr into l_database_object_name;
1190: if l_get_obj_attr_csr%found then
1191: close l_get_obj_attr_csr;
1192: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1193: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_OA');
1194: FND_MSG_PUB.Add;
1195: end if;
1196: raise FND_API.G_EXC_ERROR;

Line 1194: FND_MSG_PUB.Add;

1190: if l_get_obj_attr_csr%found then
1191: close l_get_obj_attr_csr;
1192: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1193: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_OA');
1194: FND_MSG_PUB.Add;
1195: end if;
1196: raise FND_API.G_EXC_ERROR;
1197: end if;
1198: close l_get_obj_attr_csr;

Line 1206: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1202: open l_get_region_item_csr;
1203: fetch l_get_region_item_csr into l_region_application_id, l_region_code;
1204: if l_get_region_item_csr%found then
1205: close l_get_region_item_csr;
1206: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1207: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_RI');
1208: FND_MSG_PUB.Add;
1209: end if;
1210: raise FND_API.G_EXC_ERROR;

Line 1208: FND_MSG_PUB.Add;

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

Line 1280: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1276: where attribute_application_id = p_attribute_application_id
1277: and attribute_code = p_attribute_code;
1278:
1279: if (sql%notfound) then
1280: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1281: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1282: FND_MSG_PUB.Add;
1283: end if;
1284: raise FND_API.G_EXC_ERROR;

Line 1282: FND_MSG_PUB.Add;

1278:
1279: if (sql%notfound) then
1280: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1281: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1282: FND_MSG_PUB.Add;
1283: end if;
1284: raise FND_API.G_EXC_ERROR;
1285: end if;
1286:

Line 1292: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1288: where attribute_application_id = p_attribute_application_id
1289: and attribute_code = p_attribute_code;
1290:
1291: if (sql%notfound) then
1292: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1293: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1294: FND_MSG_PUB.Add;
1295: end if;
1296: raise FND_API.G_EXC_ERROR;

Line 1294: FND_MSG_PUB.Add;

1290:
1291: if (sql%notfound) then
1292: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1293: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
1294: FND_MSG_PUB.Add;
1295: end if;
1296: raise FND_API.G_EXC_ERROR;
1297: end if;
1298:

Line 1302: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then

1298:
1299: --
1300: -- Load success message
1301: --
1302: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
1303: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DELETED');
1304: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
1305: ' ' || p_attribute_code);
1306: FND_MSG_PUB.Add;

Line 1306: FND_MSG_PUB.Add;

1302: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
1303: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DELETED');
1304: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
1305: ' ' || p_attribute_code);
1306: FND_MSG_PUB.Add;
1307: end if;
1308:
1309: p_return_status := FND_API.G_RET_STS_SUCCESS;
1310:

Line 1311: FND_MSG_PUB.Count_And_Get (

1307: end if;
1308:
1309: p_return_status := FND_API.G_RET_STS_SUCCESS;
1310:
1311: FND_MSG_PUB.Count_And_Get (
1312: p_count => p_msg_count,
1313: p_data => p_msg_data);
1314:
1315: EXCEPTION

Line 1317: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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

Line 1321: FND_MSG_PUB.Add;

1317: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1318: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DELETED');
1319: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
1320: ' ' || p_attribute_code);
1321: FND_MSG_PUB.Add;
1322: end if;
1323: p_return_status := FND_API.G_RET_STS_ERROR;
1324: rollback to start_delete_attribute;
1325: FND_MSG_PUB.Count_And_Get (

Line 1325: FND_MSG_PUB.Count_And_Get (

1321: FND_MSG_PUB.Add;
1322: end if;
1323: p_return_status := FND_API.G_RET_STS_ERROR;
1324: rollback to start_delete_attribute;
1325: FND_MSG_PUB.Count_And_Get (
1326: p_count => p_msg_count,
1327: p_data => p_msg_data);
1328: WHEN OTHERS THEN
1329: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1331: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 1333: FND_MSG_PUB.Count_And_Get (

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

Line 1757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1753: p_return_status := FND_API.G_RET_STS_SUCCESS;
1754:
1755: EXCEPTION
1756: WHEN VALUE_ERROR THEN
1757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1758: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
1759: FND_MESSAGE.SET_TOKEN('KEY',
1760: to_char(p_attributes_rec.attribute_application_id) ||
1761: ' ' || p_attributes_rec.attribute_code);

Line 1762: FND_MSG_PUB.Add;

1758: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
1759: FND_MESSAGE.SET_TOKEN('KEY',
1760: to_char(p_attributes_rec.attribute_application_id) ||
1761: ' ' || p_attributes_rec.attribute_code);
1762: FND_MSG_PUB.Add;
1763: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');
1764: FND_MESSAGE.SET_TOKEN('KEY',
1765: to_char(p_attributes_rec.attribute_application_id) ||
1766: ' ' || p_attributes_rec.attribute_code);

Line 1767: FND_MSG_PUB.Add;

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

Line 1771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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

Line 1776: FND_MSG_PUB.Add;

1772: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');
1773: FND_MESSAGE.SET_TOKEN('KEY',
1774: to_char(p_attributes_rec.attribute_application_id) ||
1775: ' ' || p_attributes_rec.attribute_code);
1776: FND_MSG_PUB.Add;
1777: end if;
1778: p_return_status := FND_API.G_RET_STS_ERROR;
1779: WHEN OTHERS THEN
1780: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1781: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 1783: FND_MSG_PUB.Add;

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

Line 1896: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1892: -- p_attribute_application_id is missing in p_attribute_pk_tbl
1893: --
1894: if (p_application_id = FND_API.G_MISS_NUM) then
1895: if (p_attribute_pk_tbl.count = 0) then
1896: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1897: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1898: FND_MSG_PUB.Add;
1899: end if;
1900: raise FND_API.G_EXC_ERROR;

Line 1898: FND_MSG_PUB.Add;

1894: if (p_application_id = FND_API.G_MISS_NUM) then
1895: if (p_attribute_pk_tbl.count = 0) then
1896: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1897: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1898: FND_MSG_PUB.Add;
1899: end if;
1900: raise FND_API.G_EXC_ERROR;
1901: else
1902: --

Line 1913: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1909: if (p_attribute_pk_tbl.exists(i)) then
1910: if (p_attribute_pk_tbl(i).attribute_appl_id = FND_API.G_MISS_NUM) or
1911: (p_attribute_pk_tbl(i).attribute_code = FND_API.G_MISS_CHAR)
1912: then
1913: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1914: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');
1915: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));
1916: FND_MSG_PUB.Add;
1917: end if;

Line 1916: FND_MSG_PUB.Add;

1912: then
1913: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1914: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');
1915: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));
1916: FND_MSG_PUB.Add;
1917: end if;
1918: raise FND_API.G_EXC_ERROR;
1919: end if; /* if attribute_appl_id is null */
1920: end if; /* if exists */

Line 2026: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2022: open l_get_attribute_2_csr(l_attribute_appl_id,
2023: p_attribute_pk_tbl(i).attribute_code);
2024: fetch l_get_attribute_2_csr into l_attributes_rec;
2025: if (l_get_attribute_2_csr%notfound) then
2026: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2027: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
2028: FND_MSG_PUB.Add;
2029: FND_MESSAGE.SET_NAME('AK','AK_ATTR_NOT_DOWNLOADED');
2030: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_attribute_appl_id) ||

Line 2028: FND_MSG_PUB.Add;

2024: fetch l_get_attribute_2_csr into l_attributes_rec;
2025: if (l_get_attribute_2_csr%notfound) then
2026: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2027: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
2028: FND_MSG_PUB.Add;
2029: FND_MESSAGE.SET_NAME('AK','AK_ATTR_NOT_DOWNLOADED');
2030: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_attribute_appl_id) ||
2031: ' ' || p_attribute_pk_tbl(i).attribute_code);
2032: FND_MSG_PUB.Add;

Line 2032: FND_MSG_PUB.Add;

2028: FND_MSG_PUB.Add;
2029: FND_MESSAGE.SET_NAME('AK','AK_ATTR_NOT_DOWNLOADED');
2030: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_attribute_appl_id) ||
2031: ' ' || p_attribute_pk_tbl(i).attribute_code);
2032: FND_MSG_PUB.Add;
2033: end if;
2034: l_attribute_found := FALSE;
2035: else
2036: open l_get_tl_csr (l_attributes_rec.attribute_application_id,

Line 2041: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2037: l_attributes_rec.attribute_code,
2038: p_nls_language);
2039: fetch l_get_tl_csr into l_attributes_tl_rec;
2040: if ( l_get_tl_csr%notfound) then
2041: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2042: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
2043: FND_MSG_PUB.Add;
2044: end if;
2045: l_attribute_found := FALSE;

Line 2043: FND_MSG_PUB.Add;

2039: fetch l_get_tl_csr into l_attributes_tl_rec;
2040: if ( l_get_tl_csr%notfound) then
2041: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2042: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
2043: FND_MSG_PUB.Add;
2044: end if;
2045: l_attribute_found := FALSE;
2046: end if;
2047: close l_get_tl_csr;

Line 2081: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 2236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2232: --
2233: -- Error if there is nothing to be read from the file
2234: --
2235: if (l_buffer is null and l_eof_flag = 'Y') then
2236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2237: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
2238: FND_MSG_PUB.Add;
2239: end if;
2240: raise FND_API.G_EXC_ERROR;

Line 2238: FND_MSG_PUB.Add;

2234: --
2235: if (l_buffer is null and l_eof_flag = 'Y') then
2236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2237: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
2238: FND_MSG_PUB.Add;
2239: end if;
2240: raise FND_API.G_EXC_ERROR;
2241: end if;
2242:

Line 2260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 2263: FND_MSG_PUB.Add;

2259: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2261: -- dbms_output.put_line('State '||l_state||' Token '||l_token|| 'l_buffer '||l_buffer);
2262: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2263: FND_MSG_PUB.Add;
2264: end if;
2265: -- dbms_output.put_line('Error parsing buffer');
2266: raise FND_API.G_EXC_ERROR;
2267: end if;

Line 2276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2272: l_attribute_rec := l_empty_attribute_rec;
2273: l_attribute_tl_rec := l_empty_attribute_tl_rec;
2274: l_state := 1;
2275: else
2276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2278: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2279: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2280: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

Line 2281: FND_MSG_PUB.Add;

2277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2278: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2279: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2280: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2281: FND_MSG_PUB.Add;
2282: end if;
2283: raise FND_API.G_EXC_ERROR;
2284: end if;
2285: elsif (l_state = 1) then

Line 2300: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2296: if (l_token is not null) then
2297: l_attribute_rec.attribute_application_id := to_number(l_token);
2298: l_state := 3;
2299: else
2300: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2301: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2302: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2303: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2304: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');

Line 2305: FND_MSG_PUB.Add;

2301: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2302: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2303: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2304: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');
2305: FND_MSG_PUB.Add;
2306: end if;
2307: -- dbms_output.put_line('Expecting attribute application ID');
2308: raise FND_API.G_EXC_ERROR;
2309: end if;

Line 2316: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2312: l_attribute_rec.attribute_code := l_token;
2313: l_value_count := null;
2314: l_state := 10;
2315: else
2316: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2317: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2318: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2319: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2320: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');

Line 2321: FND_MSG_PUB.Add;

2317: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2318: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2319: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2320: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');
2321: FND_MSG_PUB.Add;
2322: end if;
2323: --dbms_output.put_line('Expecting attribute code');
2324: raise FND_API.G_EXC_ERROR;
2325: end if;

Line 2395: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2391: l_saved_token := l_token;
2392: end if;
2393: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2394: (l_value_count is null) then
2395: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2396: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2397: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2398: if (l_value_count is null) then
2399: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 2404: FND_MSG_PUB.Add;

2400: else
2401: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2402: end if;
2403: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');
2404: FND_MSG_PUB.Add;
2405: end if;
2406: -- dbms_output.put_line('Expecting attribute field or END');
2407: raise FND_API.G_EXC_ERROR;
2408: end if;

Line 2414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2410: elsif (l_state = 11) then
2411: if (l_token = '=') then
2412: l_state := 12;
2413: else
2414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2415: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2416: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2417: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2418: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

Line 2419: FND_MSG_PUB.Add;

2415: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2416: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2417: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2418: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2419: FND_MSG_PUB.Add;
2420: end if;
2421: raise FND_API.G_EXC_ERROR;
2422: end if;
2423: elsif (l_state = 12) then

Line 2573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2569: elsif (l_column = 'DESCRIPTION') then
2570: l_attribute_tl_rec.description := l_token;
2571: l_state := 10;
2572: else
2573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2577: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

Line 2578: FND_MSG_PUB.Add;

2574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2577: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);
2578: FND_MSG_PUB.Add;
2579: end if;
2580: --dbms_output.put_line('Expecting ' || l_column || ' value');
2581: raise FND_API.G_EXC_ERROR;
2582: end if;

Line 2588: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2584: if (l_column = 'LOV_REGION') then
2585: l_attribute_rec.lov_region_code := l_token;
2586: l_state := 10;
2587: else
2588: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2589: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2590: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2591: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2592: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

Line 2593: FND_MSG_PUB.Add;

2589: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2590: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2591: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2592: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);
2593: FND_MSG_PUB.Add;
2594: end if;
2595: --dbms_output.put_line('Expecting ' || l_column || ' value');
2596: raise FND_API.G_EXC_ERROR;
2597: end if;

Line 2855: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2851: l_copy_redo_flag := FALSE;
2852: end if; --/* if l_copy_redo_flag */
2853: l_state := 0;
2854: else
2855: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2856: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2857: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2858: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2859: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');

Line 2860: FND_MSG_PUB.Add;

2856: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2857: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2858: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2859: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');
2860: FND_MSG_PUB.Add;
2861: end if;
2862: raise FND_API.G_EXC_ERROR;
2863: end if;
2864: end if;

Line 2907: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2903: -- (state 0) or when the beginning of another business object was
2904: -- detected, then the file must have ended prematurely, which is an error
2905: --
2906: if (l_state <> 0) and (l_more_attr) then
2907: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2908: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2909: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2910: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
2911: FND_MESSAGE.SET_TOKEN('EXPECTED',null);

Line 2912: FND_MSG_PUB.Add;

2908: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2909: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2910: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
2911: FND_MESSAGE.SET_TOKEN('EXPECTED',null);
2912: FND_MSG_PUB.Add;
2913: end if;
2914: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
2915: -- to_char(l_state));
2916: raise FND_API.G_EXC_ERROR;

Line 2937: FND_MSG_PUB.Add;

2933: p_return_status := FND_API.G_RET_STS_ERROR;
2934: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
2935: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_attribute_rec.attribute_application_id) ||
2936: ' ' || l_attribute_rec.attribute_code);
2937: FND_MSG_PUB.Add;
2938: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2939: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
2940: FND_MSG_PUB.Add;
2941: WHEN OTHERS THEN

Line 2938: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2934: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
2935: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_attribute_rec.attribute_application_id) ||
2936: ' ' || l_attribute_rec.attribute_code);
2937: FND_MSG_PUB.Add;
2938: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2939: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
2940: FND_MSG_PUB.Add;
2941: WHEN OTHERS THEN
2942: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2940: FND_MSG_PUB.Add;

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

Line 2943: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 2945: FND_MSG_PUB.Add;

2941: WHEN OTHERS THEN
2942: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2943: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2944: SUBSTR (SQLERRM, 1, 240) );
2945: FND_MSG_PUB.Add;
2946: end UPLOAD_ATTRIBUTE;
2947:
2948: --=======================================================
2949: -- Procedure INSERT_ATTRIBUTE_PK_TABLE

Line 3022: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 3024: FND_MSG_PUB.Add;

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

Line 3169: FND_MSG_PUB.initialize;

3165:
3166: -- Initialize the message table if requested.
3167:
3168: if p_init_msg_tbl then
3169: FND_MSG_PUB.initialize;
3170: end if;
3171:
3172: savepoint start_update_attribute;
3173:

Line 3183: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3179: --
3180: open l_get_row_csr;
3181: fetch l_get_row_csr into l_attributes_rec;
3182: if (l_get_row_csr%notfound) then
3183: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3184: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
3185: FND_MSG_PUB.Add;
3186: end if;
3187: close l_get_row_csr;

Line 3185: FND_MSG_PUB.Add;

3181: fetch l_get_row_csr into l_attributes_rec;
3182: if (l_get_row_csr%notfound) then
3183: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3184: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
3185: FND_MSG_PUB.Add;
3186: end if;
3187: close l_get_row_csr;
3188: raise FND_API.G_EXC_ERROR;
3189: end if;

Line 3198: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3194: --
3195: open l_get_tl_row_csr(l_lang);
3196: fetch l_get_tl_row_csr into l_attributes_tl_rec;
3197: if (l_get_tl_row_csr%notfound) then
3198: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3199: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
3200: FND_MSG_PUB.Add;
3201: end if;
3202: -- dbms_output.put_line('Error - TL Row does not exist');

Line 3200: FND_MSG_PUB.Add;

3196: fetch l_get_tl_row_csr into l_attributes_tl_rec;
3197: if (l_get_tl_row_csr%notfound) then
3198: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3199: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
3200: FND_MSG_PUB.Add;
3201: end if;
3202: -- dbms_output.put_line('Error - TL Row does not exist');
3203: close l_get_tl_row_csr;
3204: raise FND_API.G_EXC_ERROR;

Line 3261: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3257: open l_check_page_region_item_csr;
3258: fetch l_check_page_region_item_csr into l_dummy;
3259: if (l_check_page_region_item_csr%found) then
3260: close l_check_page_region_item_csr;
3261: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3262: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3263: FND_MESSAGE.SET_TOKEN('FORM','AK_PAGE_REGION_LINKS', TRUE);
3264: FND_MSG_PUB.Add;
3265: end if;

Line 3264: FND_MSG_PUB.Add;

3260: close l_check_page_region_item_csr;
3261: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3262: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3263: FND_MESSAGE.SET_TOKEN('FORM','AK_PAGE_REGION_LINKS', TRUE);
3264: FND_MSG_PUB.Add;
3265: end if;
3266: -- dbms_output.put_line(l_api_name || ' Cannot change data type');
3267: raise FND_API.G_EXC_ERROR;
3268: end if;

Line 3277: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3273: open l_check_navigation_csr;
3274: fetch l_check_navigation_csr into l_dummy;
3275: if (l_check_navigation_csr%found) then
3276: close l_check_navigation_csr;
3277: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3278: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3279: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_NAVIGATION', TRUE);
3280: FND_MSG_PUB.Add;
3281: end if;

Line 3280: FND_MSG_PUB.Add;

3276: close l_check_navigation_csr;
3277: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3278: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3279: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_NAVIGATION', TRUE);
3280: FND_MSG_PUB.Add;
3281: end if;
3282: -- dbms_output.put_line(l_api_name || ' Cannot change data type');
3283: raise FND_API.G_EXC_ERROR;
3284: end if;

Line 3293: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3289: open l_check_attr_value_csr;
3290: fetch l_check_attr_value_csr into l_dummy;
3291: if (l_check_attr_value_csr%found) then
3292: close l_check_attr_value_csr;
3293: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3294: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3295: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_VALUE', TRUE);
3296: FND_MSG_PUB.Add;
3297: end if;

Line 3296: FND_MSG_PUB.Add;

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

Line 3555: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3551: LAST_UPDATE_LOGIN = l_last_update_login
3552: where attribute_application_id = p_attribute_application_id
3553: and attribute_code = p_attribute_code;
3554: if (sql%notfound) then
3555: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3556: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');
3557: FND_MSG_PUB.Add;
3558: end if;
3559: raise FND_API.G_EXC_ERROR;

Line 3557: FND_MSG_PUB.Add;

3553: and attribute_code = p_attribute_code;
3554: if (sql%notfound) then
3555: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3556: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');
3557: FND_MSG_PUB.Add;
3558: end if;
3559: raise FND_API.G_EXC_ERROR;
3560: end if;
3561:

Line 3575: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3571: where attribute_application_id = p_attribute_application_id
3572: and attribute_code = p_attribute_code
3573: and l_lang in (LANGUAGE, SOURCE_LANG);
3574: if (sql%notfound) then
3575: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3576: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');
3577: FND_MSG_PUB.Add;
3578: end if;
3579: -- dbms_output.put_line('TL Row does not exist during update');

Line 3577: FND_MSG_PUB.Add;

3573: and l_lang in (LANGUAGE, SOURCE_LANG);
3574: if (sql%notfound) then
3575: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3576: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');
3577: FND_MSG_PUB.Add;
3578: end if;
3579: -- dbms_output.put_line('TL Row does not exist during update');
3580: raise FND_API.G_EXC_ERROR;
3581: end if;

Line 3586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

3582:
3583: -- /** commit the update **/
3584: commit;
3585:
3586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3587: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATED');
3588: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3589: ' ' || p_attribute_code);
3590: FND_MSG_PUB.Add;

Line 3590: FND_MSG_PUB.Add;

3586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3587: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATED');
3588: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3589: ' ' || p_attribute_code);
3590: FND_MSG_PUB.Add;
3591: end if;
3592:
3593: end if;
3594: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3596: FND_MSG_PUB.Count_And_Get (

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

Line 3603: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3599:
3600:
3601: EXCEPTION
3602: WHEN VALUE_ERROR THEN
3603: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3604: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
3605: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3606: ' ' || p_attribute_code);
3607: FND_MSG_PUB.Add;

Line 3607: FND_MSG_PUB.Add;

3603: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3604: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
3605: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3606: ' ' || p_attribute_code);
3607: FND_MSG_PUB.Add;
3608: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');
3609: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3610: ' ' || p_attribute_code);
3611: FND_MSG_PUB.Add;

Line 3611: FND_MSG_PUB.Add;

3607: FND_MSG_PUB.Add;
3608: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');
3609: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3610: ' ' || p_attribute_code);
3611: FND_MSG_PUB.Add;
3612: end if;
3613: p_return_status := FND_API.G_RET_STS_ERROR;
3614: rollback to start_update_attribute;
3615: FND_MSG_PUB.Count_And_Get (

Line 3615: FND_MSG_PUB.Count_And_Get (

3611: FND_MSG_PUB.Add;
3612: end if;
3613: p_return_status := FND_API.G_RET_STS_ERROR;
3614: rollback to start_update_attribute;
3615: FND_MSG_PUB.Count_And_Get (
3616: p_count => p_msg_count,
3617: p_data => p_msg_data);
3618: WHEN FND_API.G_EXC_ERROR THEN
3619: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3619: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 3623: FND_MSG_PUB.Add;

3619: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3620: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');
3621: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3622: ' ' || p_attribute_code);
3623: FND_MSG_PUB.Add;
3624: end if;
3625: p_return_status := FND_API.G_RET_STS_ERROR;
3626: rollback to start_update_attribute;
3627: FND_MSG_PUB.Count_And_Get (

Line 3627: FND_MSG_PUB.Count_And_Get (

3623: FND_MSG_PUB.Add;
3624: end if;
3625: p_return_status := FND_API.G_RET_STS_ERROR;
3626: rollback to start_update_attribute;
3627: FND_MSG_PUB.Count_And_Get (
3628: p_count => p_msg_count,
3629: p_data => p_msg_data);
3630: WHEN OTHERS THEN
3631: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3633: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 3635: FND_MSG_PUB.Count_And_Get (

3631: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3632: rollback to start_update_attribute;
3633: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3634: SUBSTR (SQLERRM, 1, 240) );
3635: FND_MSG_PUB.Count_And_Get (
3636: p_count => p_msg_count,
3637: p_data => p_msg_data);
3638: end UPDATE_ATTRIBUTE;
3639:

Line 3829: FND_MSG_PUB.Count_And_Get (

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

Line 3834: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 3836: FND_MSG_PUB.Count_And_Get (

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