DBA Data[Home] [Help]

APPS.AK_QUERYOBJ_PVT dependencies on FND_MESSAGE

Line 69: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');

65: p_query_code => l_queryobj_lines_rec.seq_num,
66: )
67: then
68: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
69: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
70: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
71: FND_MSG_PUB.Add;
72: end if;
73: close l_get_lines_csr;

Line 70: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

66: )
67: then
68: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
69: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
70: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
71: FND_MSG_PUB.Add;
72: end if;
73: close l_get_lines_csr;
74: raise FND_API.G_EXC_ERROR;

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

154:
155: if (l_line_count = 0) then
156: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
157: -- dbms_output.put_line('cannot find query '||p_query_code);
158: FND_MESSAGE.SET_NAME('AK','AK_QUERY_OBJ_DOES_NOT_EXIST');
159: FND_MSG_PUB.Add;
160: end if;
161: -- dbms_output.put_line('Cannot find query object '||p_query_code);
162: RAISE FND_API.G_EXC_ERROR;

Line 170: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');

166:
167: EXCEPTION
168: WHEN VALUE_ERROR THEN
169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
170: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
171: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
172: FND_MSG_PUB.Add;
173: end if;
174: p_return_status := FND_API.G_RET_STS_ERROR;

Line 171: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

167: EXCEPTION
168: WHEN VALUE_ERROR THEN
169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
170: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
171: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
172: FND_MSG_PUB.Add;
173: end if;
174: p_return_status := FND_API.G_RET_STS_ERROR;
175: WHEN FND_API.G_EXC_ERROR THEN

Line 177: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');

173: end if;
174: p_return_status := FND_API.G_RET_STS_ERROR;
175: WHEN FND_API.G_EXC_ERROR THEN
176: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
177: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
178: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
179: FND_MSG_PUB.Add;
180: end if;
181: p_return_status := FND_API.G_RET_STS_ERROR;

Line 178: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

174: p_return_status := FND_API.G_RET_STS_ERROR;
175: WHEN FND_API.G_EXC_ERROR THEN
176: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
177: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
178: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
179: FND_MSG_PUB.Add;
180: end if;
181: p_return_status := FND_API.G_RET_STS_ERROR;
182: WHEN OTHERS THEN

Line 241: FND_MESSAGE.SET_NAME('AK','AK_QUERY_OBJ_DOES_NOT_EXIST');

237: fetch l_get_queryobj_csr into l_queryobj_rec;
238: if (l_get_queryobj_csr%notfound) then
239: close l_get_queryobj_csr;
240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
241: FND_MESSAGE.SET_NAME('AK','AK_QUERY_OBJ_DOES_NOT_EXIST');
242: FND_MSG_PUB.Add;
243: end if;
244: -- dbms_output.put_line('Cannot find query object '||p_query_code);
245: RAISE FND_API.G_EXC_ERROR;

Line 330: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');

326:
327: EXCEPTION
328: WHEN VALUE_ERROR THEN
329: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
330: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
331: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
332: FND_MSG_PUB.Add;
333: end if;
334: p_return_status := FND_API.G_RET_STS_ERROR;

Line 331: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

327: EXCEPTION
328: WHEN VALUE_ERROR THEN
329: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
330: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
331: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
332: FND_MSG_PUB.Add;
333: end if;
334: p_return_status := FND_API.G_RET_STS_ERROR;
335: WHEN FND_API.G_EXC_ERROR THEN

Line 337: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');

333: end if;
334: p_return_status := FND_API.G_RET_STS_ERROR;
335: WHEN FND_API.G_EXC_ERROR THEN
336: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
337: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
338: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
339: FND_MSG_PUB.Add;
340: end if;
341: p_return_status := FND_API.G_RET_STS_ERROR;

Line 338: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

334: p_return_status := FND_API.G_RET_STS_ERROR;
335: WHEN FND_API.G_EXC_ERROR THEN
336: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
337: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
338: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
339: FND_MSG_PUB.Add;
340: end if;
341: p_return_status := FND_API.G_RET_STS_ERROR;
342: WHEN OTHERS THEN

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

424:
425: if (p_application_id = FND_API.G_MISS_NUM) or (p_application_id is null) then
426: if (p_queryobj_pk_tbl.count = 0) then
427: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
428: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
429: FND_MSG_PUB.Add;
430: end if;
431: raise FND_API.G_EXC_ERROR;
432: end if;

Line 438: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');

434: if (p_queryobj_PK_tbl.count > 0) then
435: -- both application ID and a list of objects to be extracted are
436: -- given, issue a warning that we will ignore the application ID
437: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
438: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
439: FND_MSG_PUB.Add;
440: end if;
441: end if;
442: end if;

Line 501: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_PK_VALUE_ERROR');

497:
498: EXCEPTION
499: WHEN VALUE_ERROR THEN
500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
501: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_PK_VALUE_ERROR');
502: FND_MSG_PUB.Add;
503: end if;
504: -- dbms_output.put_line('Value error occurred in download- check your object list.');
505: p_return_status := FND_API.G_RET_STS_ERROR;

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

544: fetch l_chk_seq_num_csr into l_line_rec;
545: if (l_chk_seq_num_csr%notfound) then
546: l_error := TRUE;
547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
548: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REFERENCE');
549: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
550: FND_MSG_PUB.Add;
551: end if;
552: end if;

Line 549: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

545: if (l_chk_seq_num_csr%notfound) then
546: l_error := TRUE;
547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
548: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REFERENCE');
549: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
550: FND_MSG_PUB.Add;
551: end if;
552: end if;
553: close l_chk_seq_num_csr;

Line 747: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_EXISTS');

743: p_return_status => l_return_status,
744: p_query_code => p_query_code,
745: p_application_id => p_application_id) then
746: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
747: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_EXISTS');
748: FND_MSG_PUB.Add;
749: end if;
750: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
751: raise FND_API.G_EXC_ERROR;

Line 814: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_CREATED');

810: -- /** commit the insert **/
811: -- commit;
812:
813: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
814: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_CREATED');
815: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
816: FND_MSG_PUB.Add;
817: end if;
818:

Line 815: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

811: -- commit;
812:
813: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
814: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_CREATED');
815: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
816: FND_MSG_PUB.Add;
817: end if;
818:
819: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 828: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_VALUE_ERROR');

824:
825: EXCEPTION
826: WHEN VALUE_ERROR THEN
827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_VALUE_ERROR');
829: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
830: FND_MSG_PUB.Add;
831: end if;
832: p_return_status := FND_API.G_RET_STS_ERROR;

Line 829: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

825: EXCEPTION
826: WHEN VALUE_ERROR THEN
827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_VALUE_ERROR');
829: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
830: FND_MSG_PUB.Add;
831: end if;
832: p_return_status := FND_API.G_RET_STS_ERROR;
833: rollback to start_create_queryobj;

Line 839: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_CREATED');

835: p_count => p_msg_count,
836: p_data => p_msg_data);
837: WHEN FND_API.G_EXC_ERROR THEN
838: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
839: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_CREATED');
840: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
841: FND_MSG_PUB.Add;
842: end if;
843: p_return_status := FND_API.G_RET_STS_ERROR;

Line 840: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

836: p_data => p_msg_data);
837: WHEN FND_API.G_EXC_ERROR THEN
838: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
839: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_CREATED');
840: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
841: FND_MSG_PUB.Add;
842: end if;
843: p_return_status := FND_API.G_RET_STS_ERROR;
844: rollback to start_create_queryobj;

Line 934: FND_MESSAGE.SET_NAME('AK','AK_LINE_EXISTS');

930: p_return_status => l_return_status,
931: p_query_code => p_query_code,
932: p_seq_num => p_seq_num) then
933: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
934: FND_MESSAGE.SET_NAME('AK','AK_LINE_EXISTS');
935: FND_MSG_PUB.Add;
936: end if;
937: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
938: raise FND_API.G_EXC_ERROR;

Line 1007: FND_MESSAGE.SET_NAME('AK','AK_LINE_CREATED');

1003: -- /** commit the insert **/
1004: -- commit;
1005:
1006: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1007: FND_MESSAGE.SET_NAME('AK','AK_LINE_CREATED');
1008: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));
1009: FND_MSG_PUB.Add;
1010: end if;
1011:

Line 1008: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));

1004: -- commit;
1005:
1006: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1007: FND_MESSAGE.SET_NAME('AK','AK_LINE_CREATED');
1008: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));
1009: FND_MSG_PUB.Add;
1010: end if;
1011:
1012: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1021: FND_MESSAGE.SET_NAME('AK','AK_LINE_VALUE_ERROR');

1017:
1018: EXCEPTION
1019: WHEN VALUE_ERROR THEN
1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.SET_NAME('AK','AK_LINE_VALUE_ERROR');
1022: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));
1023: FND_MSG_PUB.Add;
1024: end if;
1025: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1022: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));

1018: EXCEPTION
1019: WHEN VALUE_ERROR THEN
1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.SET_NAME('AK','AK_LINE_VALUE_ERROR');
1022: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));
1023: FND_MSG_PUB.Add;
1024: end if;
1025: p_return_status := FND_API.G_RET_STS_ERROR;
1026: rollback to start_create_line;

Line 1032: FND_MESSAGE.SET_NAME('AK','AK_LINE_NOT_CREATED');

1028: p_count => p_msg_count,
1029: p_data => p_msg_data);
1030: WHEN FND_API.G_EXC_ERROR THEN
1031: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1032: FND_MESSAGE.SET_NAME('AK','AK_LINE_NOT_CREATED');
1033: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));
1034: FND_MSG_PUB.Add;
1035: end if;
1036: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1033: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));

1029: p_data => p_msg_data);
1030: WHEN FND_API.G_EXC_ERROR THEN
1031: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1032: FND_MESSAGE.SET_NAME('AK','AK_LINE_NOT_CREATED');
1033: FND_MESSAGE.SET_TOKEN('KEY', p_query_code||' '||to_char(p_seq_num));
1034: FND_MSG_PUB.Add;
1035: end if;
1036: p_return_status := FND_API.G_RET_STS_ERROR;
1037: rollback to start_create_line;

Line 1128: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_DOES_NOT_EXIST');

1124: open l_get_query_csr;
1125: fetch l_get_query_csr into l_queryobj_rec;
1126: if (l_get_query_csr%notfound) then
1127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1128: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_DOES_NOT_EXIST');
1129: FND_MSG_PUB.Add;
1130: end if;
1131: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1132: close l_get_query_csr;

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

1137: if ( NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
1138: p_api_version_number => 1.0,
1139: p_return_status => l_return_status,
1140: p_application_id => p_application_id) ) then
1141: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1142: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
1143: FND_MSG_PUB.Add;
1144: raise FND_API.G_EXC_ERROR;
1145: end if;

Line 1142: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');

1138: p_api_version_number => 1.0,
1139: p_return_status => l_return_status,
1140: p_application_id => p_application_id) ) then
1141: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1142: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
1143: FND_MSG_PUB.Add;
1144: raise FND_API.G_EXC_ERROR;
1145: end if;
1146:

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

1189: where query_code = p_query_code;
1190:
1191: if (sql%notfound) then
1192: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1193: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATE_FAILED');
1194: FND_MSG_PUB.Add;
1195: end if;
1196: raise FND_API.G_EXC_ERROR;
1197: end if;

Line 1203: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATED');

1199: -- /** commit the update **/
1200: -- commit;
1201:
1202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1203: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATED');
1204: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
1205: FND_MSG_PUB.Add;
1206: end if;
1207:

Line 1204: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

1200: -- commit;
1201:
1202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1203: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATED');
1204: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
1205: FND_MSG_PUB.Add;
1206: end if;
1207:
1208: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1217: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_VALUE_ERROR');

1213:
1214: EXCEPTION
1215: WHEN VALUE_ERROR THEN
1216: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1217: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_VALUE_ERROR');
1218: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
1219: FND_MSG_PUB.Add;
1220: end if;
1221: rollback to start_update_queryobj;

Line 1218: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

1214: EXCEPTION
1215: WHEN VALUE_ERROR THEN
1216: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1217: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_VALUE_ERROR');
1218: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
1219: FND_MSG_PUB.Add;
1220: end if;
1221: rollback to start_update_queryobj;
1222: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1228: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_UPDATED');

1224: p_count => p_msg_count,
1225: p_data => p_msg_data);
1226: WHEN FND_API.G_EXC_ERROR THEN
1227: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1228: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_UPDATED');
1229: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
1230: FND_MSG_PUB.Add;
1231: end if;
1232: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1229: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

1225: p_data => p_msg_data);
1226: WHEN FND_API.G_EXC_ERROR THEN
1227: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1228: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_UPDATED');
1229: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
1230: FND_MSG_PUB.Add;
1231: end if;
1232: p_return_status := FND_API.G_RET_STS_ERROR;
1233: rollback to start_update_queryobj;

Line 1309: FND_MESSAGE.SET_NAME('AK','AK_LINE_DOES_NOT_EXIST');

1305: open l_get_query_line_csr;
1306: fetch l_get_query_line_csr into l_line_rec;
1307: if (l_get_query_line_csr%notfound) then
1308: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1309: FND_MESSAGE.SET_NAME('AK','AK_LINE_DOES_NOT_EXIST');
1310: FND_MSG_PUB.Add;
1311: end if;
1312: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1313: close l_get_query_line_csr;

Line 1380: FND_MESSAGE.SET_NAME('AK','AK_LINE_UPDATE_FAILED');

1376: and seq_num = p_seq_num;
1377:
1378: if (sql%notfound) then
1379: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1380: FND_MESSAGE.SET_NAME('AK','AK_LINE_UPDATE_FAILED');
1381: FND_MSG_PUB.Add;
1382: end if;
1383: raise FND_API.G_EXC_ERROR;
1384: end if;

Line 1390: FND_MESSAGE.SET_NAME('AK','AK_LINE_UPDATED');

1386: -- /** commit the update **/
1387: -- commit;
1388:
1389: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1390: FND_MESSAGE.SET_NAME('AK','AK_LINE_UPDATED');
1391: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num) );
1392: FND_MSG_PUB.Add;
1393: end if;
1394:

Line 1391: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num) );

1387: -- commit;
1388:
1389: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1390: FND_MESSAGE.SET_NAME('AK','AK_LINE_UPDATED');
1391: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num) );
1392: FND_MSG_PUB.Add;
1393: end if;
1394:
1395: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1404: FND_MESSAGE.SET_NAME('AK','AK_LINE_VALUE_ERROR');

1400:
1401: EXCEPTION
1402: WHEN VALUE_ERROR THEN
1403: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1404: FND_MESSAGE.SET_NAME('AK','AK_LINE_VALUE_ERROR');
1405: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num) );
1406: FND_MSG_PUB.Add;
1407: end if;
1408: rollback to start_update_query_line;

Line 1405: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num) );

1401: EXCEPTION
1402: WHEN VALUE_ERROR THEN
1403: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1404: FND_MESSAGE.SET_NAME('AK','AK_LINE_VALUE_ERROR');
1405: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num) );
1406: FND_MSG_PUB.Add;
1407: end if;
1408: rollback to start_update_query_line;
1409: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1415: FND_MESSAGE.SET_NAME('AK','AK_LINE_NOT_UPDATED');

1411: p_count => p_msg_count,
1412: p_data => p_msg_data);
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1415: FND_MESSAGE.SET_NAME('AK','AK_LINE_NOT_UPDATED');
1416: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num));
1417: FND_MSG_PUB.Add;
1418: end if;
1419: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1416: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num));

1412: p_data => p_msg_data);
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1415: FND_MESSAGE.SET_NAME('AK','AK_LINE_NOT_UPDATED');
1416: FND_MESSAGE.SET_TOKEN('KEY', p_query_code || to_char(p_seq_num));
1417: FND_MSG_PUB.Add;
1418: end if;
1419: p_return_status := FND_API.G_RET_STS_ERROR;
1420: rollback to start_update_query_line;

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

1587: -- Error if there is nothing to be read from the file
1588: --
1589: if (l_buffer is null and l_eof_flag = 'Y') then
1590: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1591: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
1592: FND_MSG_PUB.Add;
1593: end if;
1594: raise FND_API.G_EXC_ERROR;
1595: end if;

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

1609:
1610: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1611: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1612: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1613: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
1614: FND_MSG_PUB.Add;
1615: end if;
1616: --dbms_output.put_line(l_api_name || ' Error parsing buffer');
1617: raise FND_API.G_EXC_ERROR;

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

1625: if (l_token = 'BEGIN') then
1626: l_state := 1;
1627: else
1628: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1629: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1630: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1631: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1632: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
1633: FND_MSG_PUB.Add;

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

1626: l_state := 1;
1627: else
1628: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1629: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1630: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1631: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1632: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
1633: FND_MSG_PUB.Add;
1634: end if;

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

1627: else
1628: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1629: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1630: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1631: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1632: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
1633: FND_MSG_PUB.Add;
1634: end if;
1635: raise FND_API.G_EXC_ERROR;

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

1628: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1629: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1630: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1631: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1632: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
1633: FND_MSG_PUB.Add;
1634: end if;
1635: raise FND_API.G_EXC_ERROR;
1636: end if;

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

1653: l_state := 10;
1654: else
1655: --dbms_output.put_line('Expecting region application ID');
1656: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1657: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1658: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1659: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1660: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_CODE');
1661: FND_MSG_PUB.Add;

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

1654: else
1655: --dbms_output.put_line('Expecting region application ID');
1656: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1657: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1658: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1659: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1660: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_CODE');
1661: FND_MSG_PUB.Add;
1662: end if;

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

1655: --dbms_output.put_line('Expecting region application ID');
1656: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1657: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1658: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1659: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1660: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_CODE');
1661: FND_MSG_PUB.Add;
1662: end if;
1663: raise FND_API.G_EXC_ERROR;

Line 1660: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_CODE');

1656: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1657: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1658: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1659: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1660: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_CODE');
1661: FND_MSG_PUB.Add;
1662: end if;
1663: raise FND_API.G_EXC_ERROR;
1664: end if;

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

1692: end if;
1693: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1694: (l_value_count is null) then
1695: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1696: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1697: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1698: if (l_value_count is null) then
1699: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1700: else

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

1693: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1694: (l_value_count is null) then
1695: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1696: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1697: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1698: if (l_value_count is null) then
1699: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1700: else
1701: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

1695: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1696: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1697: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1698: if (l_value_count is null) then
1699: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1700: else
1701: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1702: end if;
1703: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_OBJECT');

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

1697: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1698: if (l_value_count is null) then
1699: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1700: else
1701: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1702: end if;
1703: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_OBJECT');
1704: FND_MSG_PUB.Add;
1705: end if;

Line 1703: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_OBJECT');

1699: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1700: else
1701: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1702: end if;
1703: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_OBJECT');
1704: FND_MSG_PUB.Add;
1705: end if;
1706: -- dbms_output.put_line('Expecting region field, BEGIN, or END');
1707: raise FND_API.G_EXC_ERROR;

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

1711: if (l_token = '=') then
1712: l_state := 12;
1713: else
1714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1716: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1717: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1718: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
1719: FND_MSG_PUB.Add;

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

1712: l_state := 12;
1713: else
1714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1716: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1717: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1718: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
1719: FND_MSG_PUB.Add;
1720: end if;

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

1713: else
1714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1716: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1717: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1718: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
1719: FND_MSG_PUB.Add;
1720: end if;
1721: raise FND_API.G_EXC_ERROR;

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

1714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1716: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1717: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1718: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
1719: FND_MSG_PUB.Add;
1720: end if;
1721: raise FND_API.G_EXC_ERROR;
1722: end if;

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

1746: l_query_rec.last_update_login := to_number(l_token);
1747: l_state := 10;
1748: else
1749: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1750: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1751: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1752: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1753: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1754: FND_MSG_PUB.Add;

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

1747: l_state := 10;
1748: else
1749: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1750: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1751: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1752: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1753: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1754: FND_MSG_PUB.Add;
1755: end if;

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

1748: else
1749: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1750: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1751: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1752: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1753: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1754: FND_MSG_PUB.Add;
1755: end if;
1756: raise FND_API.G_EXC_ERROR;

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

1749: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1750: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1751: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1752: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1753: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1754: FND_MSG_PUB.Add;
1755: end if;
1756: raise FND_API.G_EXC_ERROR;
1757: end if;

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

1764: l_line_rec.query_code := l_query_rec.query_code;
1765: l_state := 20;
1766: else
1767: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1768: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1769: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1770: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1771: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');
1772: FND_MSG_PUB.Add;

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

1765: l_state := 20;
1766: else
1767: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1768: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1769: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1770: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1771: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');
1772: FND_MSG_PUB.Add;
1773: end if;

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

1766: else
1767: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1768: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1769: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1770: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1771: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');
1772: FND_MSG_PUB.Add;
1773: end if;
1774: raise FND_API.G_EXC_ERROR;

Line 1771: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');

1767: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1768: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1769: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1770: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1771: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');
1772: FND_MSG_PUB.Add;
1773: end if;
1774: raise FND_API.G_EXC_ERROR;
1775: end if;

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

1779: l_query_index := l_query_index + 1;
1780: l_query_tbl(l_query_index) := l_query_rec;
1781: else
1782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1784: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1785: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1786: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
1787: FND_MSG_PUB.Add;

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

1780: l_query_tbl(l_query_index) := l_query_rec;
1781: else
1782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1784: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1785: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1786: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
1787: FND_MSG_PUB.Add;
1788: end if;

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

1781: else
1782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1784: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1785: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1786: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
1787: FND_MSG_PUB.Add;
1788: end if;
1789: raise FND_API.G_EXC_ERROR;

Line 1786: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');

1782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1784: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1785: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1786: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
1787: FND_MSG_PUB.Add;
1788: end if;
1789: raise FND_API.G_EXC_ERROR;
1790: end if;

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

1798: l_state := 30;
1799: l_value_count := null;
1800: else
1801: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1802: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1803: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1804: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1805: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQ_NUM');
1806: FND_MSG_PUB.Add;

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

1799: l_value_count := null;
1800: else
1801: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1802: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1803: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1804: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1805: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQ_NUM');
1806: FND_MSG_PUB.Add;
1807: end if;

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

1800: else
1801: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1802: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1803: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1804: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1805: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQ_NUM');
1806: FND_MSG_PUB.Add;
1807: end if;
1808: raise FND_API.G_EXC_ERROR;

Line 1805: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQ_NUM');

1801: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1802: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1803: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1804: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1805: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQ_NUM');
1806: FND_MSG_PUB.Add;
1807: end if;
1808: raise FND_API.G_EXC_ERROR;
1809: end if;

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

1837: end if;
1838: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1839: (l_value_count is null) then
1840: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1841: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1842: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1843: if (l_value_count is null) then
1844: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1845: else

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

1838: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1839: (l_value_count is null) then
1840: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1841: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1842: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1843: if (l_value_count is null) then
1844: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1845: else
1846: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

1840: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1841: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1842: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1843: if (l_value_count is null) then
1844: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1845: else
1846: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1847: end if;
1848: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_OBJECT_LINE');

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

1842: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1843: if (l_value_count is null) then
1844: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1845: else
1846: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1847: end if;
1848: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_OBJECT_LINE');
1849: FND_MSG_PUB.Add;
1850: end if;

Line 1848: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_OBJECT_LINE');

1844: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1845: else
1846: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1847: end if;
1848: FND_MESSAGE.SET_TOKEN('EXPECTED','QUERY_OBJECT_LINE');
1849: FND_MSG_PUB.Add;
1850: end if;
1851: raise FND_API.G_EXC_ERROR;
1852: end if;

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

1855: if (l_token = '=') then
1856: l_state := 32;
1857: else
1858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1859: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1860: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1861: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1862: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1863: FND_MSG_PUB.Add;

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

1856: l_state := 32;
1857: else
1858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1859: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1860: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1861: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1862: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1863: FND_MSG_PUB.Add;
1864: end if;

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

1857: else
1858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1859: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1860: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1861: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1862: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1863: FND_MSG_PUB.Add;
1864: end if;
1865: raise FND_API.G_EXC_ERROR;

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

1858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1859: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1860: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1861: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1862: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1863: FND_MSG_PUB.Add;
1864: end if;
1865: raise FND_API.G_EXC_ERROR;
1866: end if;

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

1896: l_line_rec.last_update_login := to_number(l_token);
1897: l_state := 30;
1898: else
1899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1900: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1901: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1902: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1903: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1904: FND_MSG_PUB.Add;

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

1897: l_state := 30;
1898: else
1899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1900: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1901: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1902: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1903: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1904: FND_MSG_PUB.Add;
1905: end if;

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

1898: else
1899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1900: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1901: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1902: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1903: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1904: FND_MSG_PUB.Add;
1905: end if;
1906: raise FND_API.G_EXC_ERROR;

Line 1903: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

1899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1900: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1901: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1902: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1903: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1904: FND_MSG_PUB.Add;
1905: end if;
1906: raise FND_API.G_EXC_ERROR;
1907: end if;

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

1913: l_line_index := l_line_index + 1;
1914: l_line_tbl(l_line_index) := l_line_rec;
1915: else
1916: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1917: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1918: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1919: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1920: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');
1921: FND_MSG_PUB.Add;

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

1914: l_line_tbl(l_line_index) := l_line_rec;
1915: else
1916: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1917: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1918: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1919: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1920: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');
1921: FND_MSG_PUB.Add;
1922: end if;

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

1915: else
1916: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1917: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1918: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1919: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1920: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');
1921: FND_MSG_PUB.Add;
1922: end if;
1923: raise FND_API.G_EXC_ERROR;

Line 1920: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');

1916: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1917: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1918: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1919: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1920: FND_MESSAGE.SET_TOKEN('EXPECTED', 'QUERY_OBJECT_LINE');
1921: FND_MSG_PUB.Add;
1922: end if;
1923: raise FND_API.G_EXC_ERROR;
1924: end if;

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

1960: -- (state 0) or when the beginning of another business object was
1961: -- detected, then the file must have ended prematurely, which is an error
1962: if (l_state <> 0) and (l_more_queryobj) then
1963: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1964: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1965: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1966: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1967: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1968: FND_MSG_PUB.Add;

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

1961: -- detected, then the file must have ended prematurely, which is an error
1962: if (l_state <> 0) and (l_more_queryobj) then
1963: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1964: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1965: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1966: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1967: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1968: FND_MSG_PUB.Add;
1969: end if;

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

1962: if (l_state <> 0) and (l_more_queryobj) then
1963: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1964: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1965: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1966: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1967: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1968: FND_MSG_PUB.Add;
1969: end if;
1970: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||

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

1963: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1964: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1965: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1966: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1967: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1968: FND_MSG_PUB.Add;
1969: end if;
1970: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
1971: -- to_char(l_state));

Line 2215: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');

2211: p_return_status := FND_API.G_RET_STS_ERROR;
2212: rollback to Start_Upload;
2213: WHEN VALUE_ERROR THEN
2214: p_return_status := FND_API.G_RET_STS_ERROR;
2215: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
2216: FND_MESSAGE.SET_TOKEN('KEY',l_query_rec.query_code||' '||
2217: to_char(l_query_rec.application_id));
2218: FND_MSG_PUB.Add;
2219: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 2216: FND_MESSAGE.SET_TOKEN('KEY',l_query_rec.query_code||' '||

2212: rollback to Start_Upload;
2213: WHEN VALUE_ERROR THEN
2214: p_return_status := FND_API.G_RET_STS_ERROR;
2215: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
2216: FND_MESSAGE.SET_TOKEN('KEY',l_query_rec.query_code||' '||
2217: to_char(l_query_rec.application_id));
2218: FND_MSG_PUB.Add;
2219: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2220: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );