DBA Data[Home] [Help]

APPS.AK_ATTRIBUTE_PVT dependencies on FND_MESSAGE

Line 89: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 90: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

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

Line 99: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 100: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

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

Line 112: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 113: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');

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

Line 123: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');

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

Line 135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 136: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');

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

Line 147: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 148: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');

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

Line 158: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 159: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_TYPE');

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

Line 169: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 170: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

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

Line 186: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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

Line 187: FND_MESSAGE.SET_TOKEN('COLUMN','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;
190: end if;
191: end if;

Line 202: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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

Line 203: FND_MESSAGE.SET_TOKEN('COLUMN','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;
206: end if;
207: end if;

Line 214: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

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

Line 215: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');

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

Line 226: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

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

Line 227: FND_MESSAGE.SET_TOKEN('COLUMN','UPPER_CASE_FLAG');

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

Line 238: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

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

Line 239: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');

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

Line 254: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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

Line 255: FND_MESSAGE.SET_TOKEN('COLUMN','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;
258: end if;
259: end if;

Line 270: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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;
274: -- dbms_output.put_line('Invalid Horizontal Alignment value');

Line 271: FND_MESSAGE.SET_TOKEN('COLUMN','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;
274: -- dbms_output.put_line('Invalid Horizontal Alignment value');
275: end if;

Line 290: FND_MESSAGE.SET_NAME('AK','AK_LOV_REG_DOES_NOT_EXIST');

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

Line 291: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_lov_region_application_id)||' '||p_lov_region_code);

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

Line 548: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_EXISTS');

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;
552: end if; */

Line 929: FND_MESSAGE.SET_NAME('AK','AK_INSERT_ATTRIBUTE_FAILED');

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;
933: raise FND_API.G_EXC_ERROR;

Line 930: FND_MESSAGE.SET_TOKEN('OBJECT','AK_LC_ATTRIBUTE',TRUE);

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

Line 977: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_CREATED');

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

Line 978: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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

Line 993: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');

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');
997: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

Line 994: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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');
997: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
998: ' ' || p_attribute_code);

Line 996: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_CREATED');

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');
997: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
998: ' ' || p_attribute_code);
999: FND_MSG_PUB.Add;
1000: end if;

Line 997: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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

Line 1008: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_CREATED');

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

Line 1009: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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;
1012: end if;
1013: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1174: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');

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

Line 1193: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_OA');

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

Line 1207: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_ATTR_RI');

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

Line 1281: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');

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

Line 1293: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');

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

Line 1303: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DELETED');

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

Line 1304: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||

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

Line 1318: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DELETED');

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

Line 1319: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||

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;
1322: end if;
1323: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1758: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');

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

Line 1759: FND_MESSAGE.SET_TOKEN('KEY',

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);
1762: FND_MSG_PUB.Add;
1763: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');

Line 1763: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');

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

Line 1764: 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);
1767: FND_MSG_PUB.Add;
1768: end if;

Line 1772: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DOWNLOADED');

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

Line 1773: FND_MESSAGE.SET_TOKEN('KEY',

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

Line 1897: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

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;
1901: else

Line 1914: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');

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;
1918: raise FND_API.G_EXC_ERROR;

Line 1915: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));

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;
1918: raise FND_API.G_EXC_ERROR;
1919: end if; /* if attribute_appl_id is null */

Line 2027: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');

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) ||
2031: ' ' || p_attribute_pk_tbl(i).attribute_code);

Line 2029: FND_MESSAGE.SET_NAME('AK','AK_ATTR_NOT_DOWNLOADED');

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

Line 2030: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_attribute_appl_id) ||

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;
2033: end if;
2034: l_attribute_found := FALSE;

Line 2042: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');

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

Line 2237: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');

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

Line 2262: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');

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;
2265: -- dbms_output.put_line('Error parsing buffer');
2266: raise FND_API.G_EXC_ERROR;

Line 2277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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

Line 2278: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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

Line 2279: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
2281: FND_MSG_PUB.Add;
2282: end if;
2283: raise FND_API.G_EXC_ERROR;

Line 2280: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

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');
2281: FND_MSG_PUB.Add;
2282: end if;
2283: raise FND_API.G_EXC_ERROR;
2284: end if;

Line 2301: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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

Line 2302: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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

Line 2303: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
2305: FND_MSG_PUB.Add;
2306: end if;
2307: -- dbms_output.put_line('Expecting attribute application ID');

Line 2304: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');

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');
2305: FND_MSG_PUB.Add;
2306: end if;
2307: -- dbms_output.put_line('Expecting attribute application ID');
2308: raise FND_API.G_EXC_ERROR;

Line 2317: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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

Line 2318: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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

Line 2319: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
2321: FND_MSG_PUB.Add;
2322: end if;
2323: --dbms_output.put_line('Expecting attribute code');

Line 2320: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');

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');
2321: FND_MSG_PUB.Add;
2322: end if;
2323: --dbms_output.put_line('Expecting attribute code');
2324: raise FND_API.G_EXC_ERROR;

Line 2396: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

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);
2400: else

Line 2397: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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);
2400: else
2401: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 2399: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

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);
2400: else
2401: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2402: end if;
2403: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');

Line 2401: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

Line 2403: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');

2399: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
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;

Line 2415: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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','=');
2419: FND_MSG_PUB.Add;

Line 2416: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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','=');
2419: FND_MSG_PUB.Add;
2420: end if;

Line 2417: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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','=');
2419: FND_MSG_PUB.Add;
2420: end if;
2421: raise FND_API.G_EXC_ERROR;

Line 2418: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

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','=');
2419: FND_MSG_PUB.Add;
2420: end if;
2421: raise FND_API.G_EXC_ERROR;
2422: end if;

Line 2574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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

Line 2575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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

Line 2576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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);
2578: FND_MSG_PUB.Add;
2579: end if;
2580: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 2577: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

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);
2578: FND_MSG_PUB.Add;
2579: end if;
2580: --dbms_output.put_line('Expecting ' || l_column || ' value');
2581: raise FND_API.G_EXC_ERROR;

Line 2589: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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

Line 2590: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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

Line 2591: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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);
2593: FND_MSG_PUB.Add;
2594: end if;
2595: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 2592: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

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);
2593: FND_MSG_PUB.Add;
2594: end if;
2595: --dbms_output.put_line('Expecting ' || l_column || ' value');
2596: raise FND_API.G_EXC_ERROR;

Line 2856: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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

Line 2857: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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

Line 2858: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
2860: FND_MSG_PUB.Add;
2861: end if;
2862: raise FND_API.G_EXC_ERROR;

Line 2859: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');

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');
2860: FND_MSG_PUB.Add;
2861: end if;
2862: raise FND_API.G_EXC_ERROR;
2863: end if;

Line 2908: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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

Line 2909: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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

Line 2910: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');

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);
2912: FND_MSG_PUB.Add;
2913: end if;
2914: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||

Line 2911: FND_MESSAGE.SET_TOKEN('EXPECTED',null);

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);
2912: FND_MSG_PUB.Add;
2913: end if;
2914: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
2915: -- to_char(l_state));

Line 2934: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');

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

Line 2935: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_attribute_rec.attribute_application_id) ||

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

Line 3184: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');

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;
3188: raise FND_API.G_EXC_ERROR;

Line 3199: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DOES_NOT_EXIST');

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');
3203: close l_get_tl_row_csr;

Line 3262: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');

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;
3266: -- dbms_output.put_line(l_api_name || ' Cannot change data type');

Line 3263: FND_MESSAGE.SET_TOKEN('FORM','AK_PAGE_REGION_LINKS', TRUE);

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;
3266: -- dbms_output.put_line(l_api_name || ' Cannot change data type');
3267: raise FND_API.G_EXC_ERROR;

Line 3278: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');

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;
3282: -- dbms_output.put_line(l_api_name || ' Cannot change data type');

Line 3279: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_NAVIGATION', TRUE);

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;
3282: -- dbms_output.put_line(l_api_name || ' Cannot change data type');
3283: raise FND_API.G_EXC_ERROR;

Line 3294: FND_MESSAGE.SET_NAME('AK','AK_CHANGE_DATA_TYPE');

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;
3298: raise FND_API.G_EXC_ERROR;

Line 3295: FND_MESSAGE.SET_TOKEN('FORM','AK_ATTRIBUTE_VALUE', TRUE);

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

Line 3556: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');

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

Line 3576: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');

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');
3580: raise FND_API.G_EXC_ERROR;

Line 3587: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATED');

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

Line 3588: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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

Line 3604: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_VALUE_ERROR');

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;
3608: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');

Line 3605: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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;
3608: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');
3609: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

Line 3608: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');

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

Line 3609: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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;
3612: end if;
3613: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3620: FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');

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

Line 3621: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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;
3624: end if;
3625: p_return_status := FND_API.G_RET_STS_ERROR;