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 930: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

926: p_api_version_number => 1.0,
927: p_return_status => l_return_status,
928: p_attribute_application_id => p_attribute_application_id,
929: p_attribute_code => p_attribute_code) then
930: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 933: FND_MSG_PUB.Add;

929: p_attribute_code => p_attribute_code) then
930: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

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

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

Line 982: FND_MSG_PUB.Add;

978: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
979: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_CREATED');
980: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
981: ' ' || p_attribute_code);
982: FND_MSG_PUB.Add;
983: end if;
984:
985: end if; -- /* if not p_copy_redo_flag */
986:

Line 989: FND_MSG_PUB.Count_And_Get (

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);
992:
993:

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

992:
993:
994: EXCEPTION
995: WHEN VALUE_ERROR THEN
996: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
997: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
998: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
999: ' ' || p_attribute_code);
1000: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_CREATED');

Line 1003: FND_MSG_PUB.Add;

999: ' ' || p_attribute_code);
1000: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_CREATED');
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 (

Line 1007: FND_MSG_PUB.Count_And_Get (

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);
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

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);
1015: FND_MSG_PUB.Add;

Line 1015: FND_MSG_PUB.Add;

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);
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 (

Line 1019: FND_MSG_PUB.Count_And_Get (

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);
1022: WHEN OTHERS THEN
1023: if (SQLCODE = -1) then

Line 1088: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

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 (
1091: p_count => p_msg_count,
1092: p_data => p_msg_data);

Line 1090: FND_MSG_PUB.Count_And_Get (

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 (
1091: p_count => p_msg_count,
1092: p_data => p_msg_data);
1093: end if;
1094: end CREATE_ATTRIBUTE;

Line 1164: FND_MSG_PUB.initialize;

1160:
1161: -- Initialize the message table if requested.
1162:
1163: if p_init_msg_tbl then
1164: FND_MSG_PUB.initialize;
1165: end if;
1166:
1167: savepoint start_delete_attribute;
1168:

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

1173: p_api_version_number => 1.0,
1174: p_return_status => l_return_status,
1175: p_attribute_application_id => p_attribute_application_id,
1176: p_attribute_code => p_attribute_code) then
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;

Line 1179: FND_MSG_PUB.Add;

1175: p_attribute_application_id => p_attribute_application_id,
1176: p_attribute_code => p_attribute_code) then
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:

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

1192: open l_get_obj_attr_csr;
1193: fetch l_get_obj_attr_csr into l_database_object_name;
1194: if l_get_obj_attr_csr%found then
1195: close l_get_obj_attr_csr;
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;

Line 1198: FND_MSG_PUB.Add;

1194: if l_get_obj_attr_csr%found then
1195: close l_get_obj_attr_csr;
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;

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

1206: open l_get_region_item_csr;
1207: fetch l_get_region_item_csr into l_region_application_id, l_region_code;
1208: if l_get_region_item_csr%found then
1209: close l_get_region_item_csr;
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;

Line 1212: FND_MSG_PUB.Add;

1208: if l_get_region_item_csr%found then
1209: close l_get_region_item_csr;
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;

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

1280: where attribute_application_id = p_attribute_application_id
1281: and attribute_code = p_attribute_code;
1282:
1283: if (sql%notfound) then
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;

Line 1286: FND_MSG_PUB.Add;

1282:
1283: if (sql%notfound) then
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:

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

1292: where attribute_application_id = p_attribute_application_id
1293: and attribute_code = p_attribute_code;
1294:
1295: if (sql%notfound) then
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;

Line 1298: FND_MSG_PUB.Add;

1294:
1295: if (sql%notfound) then
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:

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

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

Line 1310: FND_MSG_PUB.Add;

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

Line 1315: FND_MSG_PUB.Count_And_Get (

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);
1318:
1319: EXCEPTION

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

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);
1325: FND_MSG_PUB.Add;

Line 1325: FND_MSG_PUB.Add;

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);
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 (

Line 1329: FND_MSG_PUB.Count_And_Get (

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);
1332: WHEN OTHERS THEN
1333: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1335: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

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 (
1338: p_count => p_msg_count,
1339: p_data => p_msg_data);

Line 1337: FND_MSG_PUB.Count_And_Get (

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 (
1338: p_count => p_msg_count,
1339: p_data => p_msg_data);
1340: end DELETE_ATTRIBUTE;
1341:

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

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
1762: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
1763: FND_MESSAGE.SET_TOKEN('KEY',
1764: to_char(p_attributes_rec.attribute_application_id) ||
1765: ' ' || p_attributes_rec.attribute_code);

Line 1766: FND_MSG_PUB.Add;

1762: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
1763: FND_MESSAGE.SET_TOKEN('KEY',
1764: to_char(p_attributes_rec.attribute_application_id) ||
1765: ' ' || p_attributes_rec.attribute_code);
1766: FND_MSG_PUB.Add;
1767: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');
1768: FND_MESSAGE.SET_TOKEN('KEY',
1769: to_char(p_attributes_rec.attribute_application_id) ||
1770: ' ' || p_attributes_rec.attribute_code);

Line 1771: FND_MSG_PUB.Add;

1767: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');
1768: FND_MESSAGE.SET_TOKEN('KEY',
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

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

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) ||
1779: ' ' || p_attributes_rec.attribute_code);

Line 1780: FND_MSG_PUB.Add;

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) ||
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;

Line 1785: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 1787: FND_MSG_PUB.Add;

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;
1789:
1790: --=======================================================
1791: -- Procedure DOWNLOAD_ATTRIBUTE

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

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;
1903: end if;
1904: raise FND_API.G_EXC_ERROR;

Line 1902: FND_MSG_PUB.Add;

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;
1903: end if;
1904: raise FND_API.G_EXC_ERROR;
1905: else
1906: --

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

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));
1920: FND_MSG_PUB.Add;
1921: end if;

Line 1920: FND_MSG_PUB.Add;

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));
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 */

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

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

Line 2032: FND_MSG_PUB.Add;

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

Line 2036: FND_MSG_PUB.Add;

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

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

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

Line 2047: FND_MSG_PUB.Add;

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

Line 2085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

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:
2089: --=======================================================

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

2236: --
2237: -- Error if there is nothing to be read from the file
2238: --
2239: if (l_buffer is null and l_eof_flag = 'Y') then
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;

Line 2242: FND_MSG_PUB.Add;

2238: --
2239: if (l_buffer is null and l_eof_flag = 'Y') then
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:

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

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;
2268: end if;

Line 2267: FND_MSG_PUB.Add;

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;
2268: end if;
2269: -- dbms_output.put_line('Error parsing buffer');
2270: raise FND_API.G_EXC_ERROR;
2271: end if;

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

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

Line 2285: FND_MSG_PUB.Add;

2281: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2282: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
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

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

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

Line 2309: FND_MSG_PUB.Add;

2305: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2306: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2307: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
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;

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

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

Line 2325: FND_MSG_PUB.Add;

2321: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2322: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2323: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
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;

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

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

Line 2408: FND_MSG_PUB.Add;

2404: else
2405: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2406: end if;
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;

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

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

Line 2423: FND_MSG_PUB.Add;

2419: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2420: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
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

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

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

Line 2582: FND_MSG_PUB.Add;

2578: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2579: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2580: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
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;

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

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

Line 2597: FND_MSG_PUB.Add;

2593: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2594: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2595: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
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;

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

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

Line 2864: FND_MSG_PUB.Add;

2860: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2861: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
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;

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

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

Line 2916: FND_MSG_PUB.Add;

2912: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2913: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2914: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
2915: FND_MESSAGE.SET_TOKEN('EXPECTED',null);
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;

Line 2941: FND_MSG_PUB.Add;

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

Line 2942: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 2944: FND_MSG_PUB.Add;

2940: ' ' || l_attribute_rec.attribute_code);
2941: FND_MSG_PUB.Add;
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) );

Line 2947: 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;
2951:

Line 2949: 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;
2951:
2952: --=======================================================
2953: -- Procedure INSERT_ATTRIBUTE_PK_TABLE

Line 3026: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

Line 3028: FND_MSG_PUB.Add;

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;
3030:
3031: --=======================================================
3032: -- Procedure UPDATE_ATTRIBUTE

Line 3173: FND_MSG_PUB.initialize;

3169:
3170: -- Initialize the message table if requested.
3171:
3172: if p_init_msg_tbl then
3173: FND_MSG_PUB.initialize;
3174: end if;
3175:
3176: savepoint start_update_attribute;
3177:

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

3183: --
3184: open l_get_row_csr;
3185: fetch l_get_row_csr into l_attributes_rec;
3186: if (l_get_row_csr%notfound) then
3187: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
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;

Line 3189: FND_MSG_PUB.Add;

3185: fetch l_get_row_csr into l_attributes_rec;
3186: if (l_get_row_csr%notfound) then
3187: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
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;

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

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

Line 3204: FND_MSG_PUB.Add;

3200: fetch l_get_tl_row_csr into l_attributes_tl_rec;
3201: if (l_get_tl_row_csr%notfound) then
3202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3203: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');
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;

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

3264: open l_check_page_region_item_csr;
3265: fetch l_check_page_region_item_csr into l_dummy;
3266: if (l_check_page_region_item_csr%found) then
3267: close l_check_page_region_item_csr;
3268: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3269: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3270: FND_MESSAGE.SET_TOKEN('FORM','AK_PAGE_REGION_LINKS', TRUE);
3271: FND_MSG_PUB.Add;
3272: end if;

Line 3271: FND_MSG_PUB.Add;

3267: close l_check_page_region_item_csr;
3268: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3269: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
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;

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

3280: open l_check_navigation_csr;
3281: fetch l_check_navigation_csr into l_dummy;
3282: if (l_check_navigation_csr%found) then
3283: close l_check_navigation_csr;
3284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3285: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
3286: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_NAVIGATION', TRUE);
3287: FND_MSG_PUB.Add;
3288: end if;

Line 3287: FND_MSG_PUB.Add;

3283: close l_check_navigation_csr;
3284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3285: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');
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;

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

3296: open l_check_attr_value_csr;
3297: fetch l_check_attr_value_csr into l_dummy;
3298: if (l_check_attr_value_csr%found) then
3299: close l_check_attr_value_csr;
3300: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 3303: FND_MSG_PUB.Add;

3299: close l_check_attr_value_csr;
3300: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

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

3558: LAST_UPDATE_LOGIN = l_last_update_login
3559: where attribute_application_id = p_attribute_application_id
3560: and attribute_code = p_attribute_code;
3561: if (sql%notfound) then
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;

Line 3564: FND_MSG_PUB.Add;

3560: and attribute_code = p_attribute_code;
3561: if (sql%notfound) then
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:

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

3578: where attribute_application_id = p_attribute_application_id
3579: and attribute_code = p_attribute_code
3580: and l_lang in (LANGUAGE, SOURCE_LANG);
3581: if (sql%notfound) then
3582: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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');

Line 3584: FND_MSG_PUB.Add;

3580: and l_lang in (LANGUAGE, SOURCE_LANG);
3581: if (sql%notfound) then
3582: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

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

3589:
3590: -- /** commit the update **/
3591: commit;
3592:
3593: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3594: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATED');
3595: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3596: ' ' || p_attribute_code);
3597: FND_MSG_PUB.Add;

Line 3597: FND_MSG_PUB.Add;

3593: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3594: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATED');
3595: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3596: ' ' || p_attribute_code);
3597: FND_MSG_PUB.Add;
3598: end if;
3599:
3600: end if;
3601:

Line 3606: FND_MSG_PUB.Count_And_Get (

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);
3609:
3610:

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

3609:
3610:
3611: EXCEPTION
3612: WHEN VALUE_ERROR THEN
3613: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3614: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
3615: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3616: ' ' || p_attribute_code);
3617: FND_MSG_PUB.Add;

Line 3617: FND_MSG_PUB.Add;

3613: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3614: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');
3615: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3616: ' ' || p_attribute_code);
3617: FND_MSG_PUB.Add;
3618: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');
3619: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
3620: ' ' || p_attribute_code);
3621: FND_MSG_PUB.Add;

Line 3621: FND_MSG_PUB.Add;

3617: FND_MSG_PUB.Add;
3618: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');
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 (

Line 3625: FND_MSG_PUB.Count_And_Get (

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);
3628: WHEN FND_API.G_EXC_ERROR THEN
3629: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

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);
3633: FND_MSG_PUB.Add;

Line 3633: FND_MSG_PUB.Add;

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);
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 (

Line 3637: FND_MSG_PUB.Count_And_Get (

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);
3640: WHEN OTHERS THEN
3641: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3643: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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 (
3646: p_count => p_msg_count,
3647: p_data => p_msg_data);

Line 3645: FND_MSG_PUB.Count_And_Get (

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 (
3646: p_count => p_msg_count,
3647: p_data => p_msg_data);
3648: end UPDATE_ATTRIBUTE;
3649:

Line 3840: FND_MSG_PUB.Count_And_Get (

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;
3844: WHEN OTHERS THEN

Line 3846: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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,
3850: p_data => l_msg_data);

Line 3848: FND_MSG_PUB.Count_And_Get (

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,
3850: p_data => l_msg_data);
3851: G_ATTRIBUTE_REDO_TBL.DELETE;
3852: end UPLOAD_ATTRIBUTE_SECOND;