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_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 931: FND_MESSAGE.SET_NAME('AK','AK_INSERT_ATTRIBUTE_FAILED');

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

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

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

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

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

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

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

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

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

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

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

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

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');
1001: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
1002: ' ' || p_attribute_code);
1003: FND_MSG_PUB.Add;
1004: end if;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1763: FND_MESSAGE.SET_TOKEN('KEY',

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

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

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

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

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

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

Line 1777: FND_MESSAGE.SET_TOKEN('KEY',

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

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

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

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

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

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

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

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

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

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

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

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

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;
2037: end if;
2038: l_attribute_found := FALSE;

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

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

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

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

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

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

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

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

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

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

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

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');
2285: FND_MSG_PUB.Add;
2286: end if;
2287: raise FND_API.G_EXC_ERROR;

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

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');
2285: FND_MSG_PUB.Add;
2286: end if;
2287: raise FND_API.G_EXC_ERROR;
2288: end if;

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

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

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

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

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

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

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

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');
2309: FND_MSG_PUB.Add;
2310: end if;
2311: -- dbms_output.put_line('Expecting attribute application ID');
2312: raise FND_API.G_EXC_ERROR;

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

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

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

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

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

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');
2325: FND_MSG_PUB.Add;
2326: end if;
2327: --dbms_output.put_line('Expecting attribute code');

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

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');
2325: FND_MSG_PUB.Add;
2326: end if;
2327: --dbms_output.put_line('Expecting attribute code');
2328: raise FND_API.G_EXC_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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','=');
2423: FND_MSG_PUB.Add;
2424: end if;
2425: raise FND_API.G_EXC_ERROR;

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

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','=');
2423: FND_MSG_PUB.Add;
2424: end if;
2425: raise FND_API.G_EXC_ERROR;
2426: end if;

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

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

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

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

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

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);
2582: FND_MSG_PUB.Add;
2583: end if;
2584: --dbms_output.put_line('Expecting ' || l_column || ' value');

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

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);
2582: FND_MSG_PUB.Add;
2583: end if;
2584: --dbms_output.put_line('Expecting ' || l_column || ' value');
2585: raise FND_API.G_EXC_ERROR;

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

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

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

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

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

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);
2597: FND_MSG_PUB.Add;
2598: end if;
2599: --dbms_output.put_line('Expecting ' || l_column || ' value');

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

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);
2597: FND_MSG_PUB.Add;
2598: end if;
2599: --dbms_output.put_line('Expecting ' || l_column || ' value');
2600: raise FND_API.G_EXC_ERROR;

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

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

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

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

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

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');
2864: FND_MSG_PUB.Add;
2865: end if;
2866: raise FND_API.G_EXC_ERROR;

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

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');
2864: FND_MSG_PUB.Add;
2865: end if;
2866: raise FND_API.G_EXC_ERROR;
2867: end if;

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

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

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

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

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

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

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

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);
2916: FND_MSG_PUB.Add;
2917: end if;
2918: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
2919: -- to_char(l_state));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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