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_QUERYOBJ_PVT dependencies on FND_MSG_PUB

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

64: p_return_status => l_return_status,
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;

Line 71: FND_MSG_PUB.Add;

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

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

152: end loop;
153: close l_get_lines_csr;
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;

Line 159: FND_MSG_PUB.Add;

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

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

165: p_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 172: FND_MSG_PUB.Add;

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

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

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

Line 179: FND_MSG_PUB.Add;

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
183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 184: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

180: end if;
181: p_return_status := FND_API.G_RET_STS_ERROR;
182: WHEN OTHERS THEN
183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
185: SUBSTR (SQLERRM, 1, 240) );
186: FND_MSG_PUB.Add;
187: end WRITE_LINES_TO_BUFFER;
188:

Line 186: FND_MSG_PUB.Add;

182: WHEN OTHERS THEN
183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
185: SUBSTR (SQLERRM, 1, 240) );
186: FND_MSG_PUB.Add;
187: end WRITE_LINES_TO_BUFFER;
188:
189: --=======================================================
190: -- Procedure WRITE_TO_BUFFER (local procedure)

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

236: open l_get_queryobj_csr;
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);

Line 242: FND_MSG_PUB.Add;

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

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

325: p_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 332: FND_MSG_PUB.Add;

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

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

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

Line 339: FND_MSG_PUB.Add;

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
343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 344: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

340: end if;
341: p_return_status := FND_API.G_RET_STS_ERROR;
342: WHEN OTHERS THEN
343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
345: SUBSTR (SQLERRM, 1, 240) );
346: FND_MSG_PUB.Add;
347: end WRITE_TO_BUFFER;
348:

Line 346: FND_MSG_PUB.Add;

342: WHEN OTHERS THEN
343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
345: SUBSTR (SQLERRM, 1, 240) );
346: FND_MSG_PUB.Add;
347: end WRITE_TO_BUFFER;
348:
349: --=======================================================
350: -- Procedure DOWNLOAD_QUERY_OBJECT

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

423: -- - query codes in p_queryobj_PK_tbl
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;

Line 429: FND_MSG_PUB.Add;

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

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

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

Line 439: FND_MSG_PUB.Add;

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

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

496: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
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.');

Line 502: FND_MSG_PUB.Add;

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;
506: WHEN FND_API.G_EXC_ERROR THEN

Line 510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

506: WHEN FND_API.G_EXC_ERROR THEN
507: p_return_status := FND_API.G_RET_STS_ERROR;
508: WHEN OTHERS THEN
509: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
511: SUBSTR (SQLERRM, 1, 240) );
512: end DOWNLOAD_QUERY_OBJECT;
513:
514:

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

543: open l_chk_seq_num_csr (p_query_code, p_seq_num);
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;

Line 550: FND_MSG_PUB.Add;

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;
554: return true;

Line 559: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

555:
556: EXCEPTION
557: WHEN OTHERS THEN
558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
560: SUBSTR (SQLERRM, 1, 240) );
561: FND_MSG_PUB.Add;
562:
563: END VALIDATE_LINE;

Line 561: FND_MSG_PUB.Add;

557: WHEN OTHERS THEN
558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
560: SUBSTR (SQLERRM, 1, 240) );
561: FND_MSG_PUB.Add;
562:
563: END VALIDATE_LINE;
564:
565: --=======================================================

Line 614: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

610: p_return_status := FND_API.G_RET_STS_ERROR;
611: return FALSE;
612: WHEN OTHERS THEN
613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
615: SUBSTR (SQLERRM, 1, 240) );
616: FND_MSG_PUB.Add;
617: return FALSE;
618: END QUERY_OBJECT_EXISTS;

Line 616: FND_MSG_PUB.Add;

612: WHEN OTHERS THEN
613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
615: SUBSTR (SQLERRM, 1, 240) );
616: FND_MSG_PUB.Add;
617: return FALSE;
618: END QUERY_OBJECT_EXISTS;
619:
620:

Line 670: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

666: p_return_status := FND_API.G_RET_STS_ERROR;
667: return FALSE;
668: WHEN OTHERS THEN
669: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
671: SUBSTR (SQLERRM, 1, 240) );
672: FND_MSG_PUB.Add;
673: return FALSE;
674: END LINE_EXISTS;

Line 672: FND_MSG_PUB.Add;

668: WHEN OTHERS THEN
669: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
671: SUBSTR (SQLERRM, 1, 240) );
672: FND_MSG_PUB.Add;
673: return FALSE;
674: END LINE_EXISTS;
675:
676: --=======================================================

Line 735: FND_MSG_PUB.initialize;

731:
732: -- Initialize the message table if requested.
733:
734: if p_init_msg_tbl then
735: FND_MSG_PUB.initialize;
736: end if;
737:
738: savepoint start_create_queryobj;
739:

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

742: p_api_version_number => 1.0,
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');

Line 748: FND_MSG_PUB.Add;

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

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

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

Line 816: FND_MSG_PUB.Add;

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

Line 821: FND_MSG_PUB.Count_And_Get (

817: end if;
818:
819: p_return_status := FND_API.G_RET_STS_SUCCESS;
820:
821: FND_MSG_PUB.Count_And_Get (
822: p_count => p_msg_count,
823: p_data => p_msg_data);
824:
825: EXCEPTION

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

823: p_data => p_msg_data);
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;

Line 830: FND_MSG_PUB.Add;

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;
834: FND_MSG_PUB.Count_And_Get (

Line 834: FND_MSG_PUB.Count_And_Get (

830: FND_MSG_PUB.Add;
831: end if;
832: p_return_status := FND_API.G_RET_STS_ERROR;
833: rollback to start_create_queryobj;
834: FND_MSG_PUB.Count_And_Get (
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

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

834: FND_MSG_PUB.Count_And_Get (
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;

Line 841: FND_MSG_PUB.Add;

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;
845: FND_MSG_PUB.Count_And_Get (

Line 845: FND_MSG_PUB.Count_And_Get (

841: FND_MSG_PUB.Add;
842: end if;
843: p_return_status := FND_API.G_RET_STS_ERROR;
844: rollback to start_create_queryobj;
845: FND_MSG_PUB.Count_And_Get (
846: p_count => p_msg_count,
847: p_data => p_msg_data);
848: WHEN OTHERS THEN
849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 851: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

847: p_data => p_msg_data);
848: WHEN OTHERS THEN
849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: rollback to start_create_queryobj;
851: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
852: SUBSTR (SQLERRM, 1, 240) );
853: FND_MSG_PUB.Add;
854: FND_MSG_PUB.Count_And_Get (
855: p_count => p_msg_count,

Line 853: FND_MSG_PUB.Add;

849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: rollback to start_create_queryobj;
851: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
852: SUBSTR (SQLERRM, 1, 240) );
853: FND_MSG_PUB.Add;
854: FND_MSG_PUB.Count_And_Get (
855: p_count => p_msg_count,
856: p_data => p_msg_data);
857:

Line 854: FND_MSG_PUB.Count_And_Get (

850: rollback to start_create_queryobj;
851: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
852: SUBSTR (SQLERRM, 1, 240) );
853: FND_MSG_PUB.Add;
854: FND_MSG_PUB.Count_And_Get (
855: p_count => p_msg_count,
856: p_data => p_msg_data);
857:
858: END CREATE_QUERY_OBJECT;

Line 922: FND_MSG_PUB.initialize;

918:
919: -- Initialize the message table if requested.
920:
921: if p_init_msg_tbl then
922: FND_MSG_PUB.initialize;
923: end if;
924:
925: savepoint start_create_line;
926:

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

929: p_api_version_number => 1.0,
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');

Line 935: FND_MSG_PUB.Add;

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

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

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

Line 1009: FND_MSG_PUB.Add;

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

Line 1014: FND_MSG_PUB.Count_And_Get (

1010: end if;
1011:
1012: p_return_status := FND_API.G_RET_STS_SUCCESS;
1013:
1014: FND_MSG_PUB.Count_And_Get (
1015: p_count => p_msg_count,
1016: p_data => p_msg_data);
1017:
1018: EXCEPTION

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

1016: p_data => p_msg_data);
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;

Line 1023: FND_MSG_PUB.Add;

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;
1027: FND_MSG_PUB.Count_And_Get (

Line 1027: FND_MSG_PUB.Count_And_Get (

1023: FND_MSG_PUB.Add;
1024: end if;
1025: p_return_status := FND_API.G_RET_STS_ERROR;
1026: rollback to start_create_line;
1027: FND_MSG_PUB.Count_And_Get (
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

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

1027: FND_MSG_PUB.Count_And_Get (
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;

Line 1034: FND_MSG_PUB.Add;

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;
1038: FND_MSG_PUB.Count_And_Get (

Line 1038: FND_MSG_PUB.Count_And_Get (

1034: FND_MSG_PUB.Add;
1035: end if;
1036: p_return_status := FND_API.G_RET_STS_ERROR;
1037: rollback to start_create_line;
1038: FND_MSG_PUB.Count_And_Get (
1039: p_count => p_msg_count,
1040: p_data => p_msg_data);
1041: WHEN OTHERS THEN
1042: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1044: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1040: p_data => p_msg_data);
1041: WHEN OTHERS THEN
1042: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: rollback to start_create_line;
1044: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1045: SUBSTR (SQLERRM, 1, 240) );
1046: FND_MSG_PUB.Add;
1047: FND_MSG_PUB.Count_And_Get (
1048: p_count => p_msg_count,

Line 1046: FND_MSG_PUB.Add;

1042: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: rollback to start_create_line;
1044: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1045: SUBSTR (SQLERRM, 1, 240) );
1046: FND_MSG_PUB.Add;
1047: FND_MSG_PUB.Count_And_Get (
1048: p_count => p_msg_count,
1049: p_data => p_msg_data);
1050:

Line 1047: FND_MSG_PUB.Count_And_Get (

1043: rollback to start_create_line;
1044: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1045: SUBSTR (SQLERRM, 1, 240) );
1046: FND_MSG_PUB.Add;
1047: FND_MSG_PUB.Count_And_Get (
1048: p_count => p_msg_count,
1049: p_data => p_msg_data);
1050:
1051: END CREATE_QUERY_OBJECT_LINE;

Line 1118: FND_MSG_PUB.initialize;

1114:
1115: -- Initialize the message table if requested.
1116:
1117: if p_init_msg_tbl then
1118: FND_MSG_PUB.initialize;
1119: end if;
1120:
1121: savepoint start_update_queryobj;
1122:

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

1123: --** retrieve ak_regions row if it exists **
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');

Line 1129: FND_MSG_PUB.Add;

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

Line 1143: FND_MSG_PUB.Add;

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:
1147: l_queryobj_rec.application_id := p_application_id;

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

1188: LAST_UPDATE_LOGIN = l_last_update_login
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;

Line 1194: FND_MSG_PUB.Add;

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

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

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

Line 1205: FND_MSG_PUB.Add;

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

Line 1210: FND_MSG_PUB.Count_And_Get (

1206: end if;
1207:
1208: p_return_status := FND_API.G_RET_STS_SUCCESS;
1209:
1210: FND_MSG_PUB.Count_And_Get (
1211: p_count => p_msg_count,
1212: p_data => p_msg_data);
1213:
1214: EXCEPTION

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

1212: p_data => p_msg_data);
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;

Line 1219: FND_MSG_PUB.Add;

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;
1223: FND_MSG_PUB.Count_And_Get (

Line 1223: FND_MSG_PUB.Count_And_Get (

1219: FND_MSG_PUB.Add;
1220: end if;
1221: rollback to start_update_queryobj;
1222: p_return_status := FND_API.G_RET_STS_ERROR;
1223: FND_MSG_PUB.Count_And_Get (
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

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

1223: FND_MSG_PUB.Count_And_Get (
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;

Line 1230: FND_MSG_PUB.Add;

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;
1234: FND_MSG_PUB.Count_And_Get (

Line 1234: FND_MSG_PUB.Count_And_Get (

1230: FND_MSG_PUB.Add;
1231: end if;
1232: p_return_status := FND_API.G_RET_STS_ERROR;
1233: rollback to start_update_queryobj;
1234: FND_MSG_PUB.Count_And_Get (
1235: p_count => p_msg_count,
1236: p_data => p_msg_data);
1237: WHEN OTHERS THEN
1238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1240: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1236: p_data => p_msg_data);
1237: WHEN OTHERS THEN
1238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1239: rollback to start_update_queryobj;
1240: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1241: SUBSTR (SQLERRM, 1, 240) );
1242: FND_MSG_PUB.Add;
1243: FND_MSG_PUB.Count_And_Get (
1244: p_count => p_msg_count,

Line 1242: FND_MSG_PUB.Add;

1238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1239: rollback to start_update_queryobj;
1240: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1241: SUBSTR (SQLERRM, 1, 240) );
1242: FND_MSG_PUB.Add;
1243: FND_MSG_PUB.Count_And_Get (
1244: p_count => p_msg_count,
1245: p_data => p_msg_data);
1246: FND_MSG_PUB.Count_And_Get (

Line 1243: FND_MSG_PUB.Count_And_Get (

1239: rollback to start_update_queryobj;
1240: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1241: SUBSTR (SQLERRM, 1, 240) );
1242: FND_MSG_PUB.Add;
1243: FND_MSG_PUB.Count_And_Get (
1244: p_count => p_msg_count,
1245: p_data => p_msg_data);
1246: FND_MSG_PUB.Count_And_Get (
1247: p_count => p_msg_count,

Line 1246: FND_MSG_PUB.Count_And_Get (

1242: FND_MSG_PUB.Add;
1243: FND_MSG_PUB.Count_And_Get (
1244: p_count => p_msg_count,
1245: p_data => p_msg_data);
1246: FND_MSG_PUB.Count_And_Get (
1247: p_count => p_msg_count,
1248: p_data => p_msg_data);
1249:
1250: END UPDATE_QUERY_OBJECT;

Line 1299: FND_MSG_PUB.initialize;

1295:
1296: -- Initialize the message table if requested.
1297:
1298: if p_init_msg_tbl then
1299: FND_MSG_PUB.initialize;
1300: end if;
1301:
1302: savepoint start_update_query_line;
1303:

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

1304: --** retrieve ak_query_object_lines row if it exists **
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');

Line 1310: FND_MSG_PUB.Add;

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

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

1375: where query_code = p_query_code
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;

Line 1381: FND_MSG_PUB.Add;

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

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

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

Line 1392: FND_MSG_PUB.Add;

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

Line 1397: FND_MSG_PUB.Count_And_Get (

1393: end if;
1394:
1395: p_return_status := FND_API.G_RET_STS_SUCCESS;
1396:
1397: FND_MSG_PUB.Count_And_Get (
1398: p_count => p_msg_count,
1399: p_data => p_msg_data);
1400:
1401: EXCEPTION

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

1399: p_data => p_msg_data);
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;

Line 1406: FND_MSG_PUB.Add;

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;
1410: FND_MSG_PUB.Count_And_Get (

Line 1410: FND_MSG_PUB.Count_And_Get (

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;
1410: FND_MSG_PUB.Count_And_Get (
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

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

1410: FND_MSG_PUB.Count_And_Get (
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;

Line 1417: FND_MSG_PUB.Add;

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;
1421: FND_MSG_PUB.Count_And_Get (

Line 1421: FND_MSG_PUB.Count_And_Get (

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;
1421: FND_MSG_PUB.Count_And_Get (
1422: p_count => p_msg_count,
1423: p_data => p_msg_data);
1424: WHEN OTHERS THEN
1425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1427: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1423: p_data => p_msg_data);
1424: WHEN OTHERS THEN
1425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: rollback to start_update_query_line;
1427: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1428: SUBSTR (SQLERRM, 1, 240) );
1429: FND_MSG_PUB.Add;
1430: FND_MSG_PUB.Count_And_Get (
1431: p_count => p_msg_count,

Line 1429: FND_MSG_PUB.Add;

1425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: rollback to start_update_query_line;
1427: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1428: SUBSTR (SQLERRM, 1, 240) );
1429: FND_MSG_PUB.Add;
1430: FND_MSG_PUB.Count_And_Get (
1431: p_count => p_msg_count,
1432: p_data => p_msg_data);
1433: FND_MSG_PUB.Count_And_Get (

Line 1430: FND_MSG_PUB.Count_And_Get (

1426: rollback to start_update_query_line;
1427: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1428: SUBSTR (SQLERRM, 1, 240) );
1429: FND_MSG_PUB.Add;
1430: FND_MSG_PUB.Count_And_Get (
1431: p_count => p_msg_count,
1432: p_data => p_msg_data);
1433: FND_MSG_PUB.Count_And_Get (
1434: p_count => p_msg_count,

Line 1433: FND_MSG_PUB.Count_And_Get (

1429: FND_MSG_PUB.Add;
1430: FND_MSG_PUB.Count_And_Get (
1431: p_count => p_msg_count,
1432: p_data => p_msg_data);
1433: FND_MSG_PUB.Count_And_Get (
1434: p_count => p_msg_count,
1435: p_data => p_msg_data);
1436:
1437: END UPDATE_QUERY_OBJECT_LINE;

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

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

Line 1592: FND_MSG_PUB.Add;

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

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

1608: --dbms_output.put_line(' State:' || l_state || 'Token:' || l_token);
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');

Line 1614: FND_MSG_PUB.Add;

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

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

1624: if (l_state = 0) then
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');

Line 1633: FND_MSG_PUB.Add;

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;
1637: elsif (l_state = 1) then

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

1652: l_value_count := null;
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');

Line 1661: FND_MSG_PUB.Add;

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;
1665: elsif (l_state = 10) then

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

1691: l_saved_token := l_token;
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);

Line 1704: FND_MSG_PUB.Add;

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

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

1710: elsif (l_state = 11) then
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','=');

Line 1719: FND_MSG_PUB.Add;

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;
1723: elsif (l_state = 12) then

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

1745: elsif (l_column = 'LAST_UPDATE_LOGIN') then
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);

Line 1754: FND_MSG_PUB.Add;

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;
1758: l_state := 10;

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

1763: l_line_rec := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_LINE_REC;
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');

Line 1772: FND_MSG_PUB.Add;

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;
1776: elsif (l_state = 19) then

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

1778: l_state := 0;
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');

Line 1787: FND_MSG_PUB.Add;

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

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

1797: l_line_rec.seq_num := to_number(l_token);
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');

Line 1806: FND_MSG_PUB.Add;

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;
1810: elsif (l_state = 30) then

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

1836: l_saved_token := l_token;
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);

Line 1849: FND_MSG_PUB.Add;

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

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

1854: elsif (l_state = 31) then
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', '=');

Line 1863: FND_MSG_PUB.Add;

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;
1867: elsif (l_state = 32) then

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

1895: elsif (l_column = 'LAST_UPDATE_LOGIN') then
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');

Line 1904: FND_MSG_PUB.Add;

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;
1908: elsif (l_state = 39) then

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

1912: l_state := 10;
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');

Line 1921: FND_MSG_PUB.Add;

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

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

1959: -- If the loops end in a state other then at the end of a region
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);

Line 1968: FND_MSG_PUB.Add;

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

Line 2218: FND_MSG_PUB.Add;

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 );
2221: FND_MSG_PUB.Add;
2222: WHEN OTHERS THEN

Line 2219: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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 );
2221: FND_MSG_PUB.Add;
2222: WHEN OTHERS THEN
2223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2221: FND_MSG_PUB.Add;

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 );
2221: FND_MSG_PUB.Add;
2222: WHEN OTHERS THEN
2223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: rollback to Start_Upload;
2225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 2225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2221: FND_MSG_PUB.Add;
2222: WHEN OTHERS THEN
2223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: rollback to Start_Upload;
2225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2226: SUBSTR (SQLERRM, 1, 240) );
2227: FND_MSG_PUB.Add;
2228: end UPLOAD_QUERY_OBJECT;
2229:

Line 2227: FND_MSG_PUB.Add;

2223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: rollback to Start_Upload;
2225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2226: SUBSTR (SQLERRM, 1, 240) );
2227: FND_MSG_PUB.Add;
2228: end UPLOAD_QUERY_OBJECT;
2229:
2230: end AK_QUERYOBJ_PVT;