APPS.AK_QUERYOBJ_PVT dependencies on FND_API

Line 31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

27: -- The NLS langauge that should be used when
28: -- extracting data from the TL table
29: --=======================================================
30: procedure WRITE_LINES_TO_BUFFER (
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_return_status OUT NOCOPY VARCHAR2,
33: p_query_code IN VARCHAR2,
34: p_nls_language IN VARCHAR2
35: ) is

Line 60: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then

56: l_line_count := l_line_count + 1;
57:
58: -- query Object line must be validated before it is written to the file
59: /* nothing to validate yet
60: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
61: if not AK_QUERY_OBJECT_PVT.VALIDATE_LINE (
62: p_validation_level => p_validation_level,
63: p_api_version_number => 1.0,
64: p_return_status => l_return_status,

Line 74: raise FND_API.G_EXC_ERROR;

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;
76: end if;
77: */
78: -- Write object into buffer

Line 125: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

121: p_buffer_tbl => l_databuffer_tbl,
122: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
123: );
124: -- If API call returns with an error status...
125: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
126: (l_return_status = FND_API.G_RET_STS_ERROR) then
127: close l_get_lines_csr;
128: RAISE FND_API.G_EXC_ERROR;
129: end if;

Line 126: (l_return_status = FND_API.G_RET_STS_ERROR) then

122: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
123: );
124: -- If API call returns with an error status...
125: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
126: (l_return_status = FND_API.G_RET_STS_ERROR) then
127: close l_get_lines_csr;
128: RAISE FND_API.G_EXC_ERROR;
129: end if;
130:

Line 128: RAISE FND_API.G_EXC_ERROR;

124: -- If API call returns with an error status...
125: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
126: (l_return_status = FND_API.G_RET_STS_ERROR) then
127: close l_get_lines_csr;
128: RAISE FND_API.G_EXC_ERROR;
129: end if;
130:
131: l_databuffer_tbl.delete;
132:

Line 133: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

129: end if;
130:
131: l_databuffer_tbl.delete;
132:
133: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
134: (l_return_status = FND_API.G_RET_STS_ERROR) then
135: close l_get_lines_csr;
136: RAISE FND_API.G_EXC_ERROR;
137: end if;

Line 134: (l_return_status = FND_API.G_RET_STS_ERROR) then

130:
131: l_databuffer_tbl.delete;
132:
133: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
134: (l_return_status = FND_API.G_RET_STS_ERROR) then
135: close l_get_lines_csr;
136: RAISE FND_API.G_EXC_ERROR;
137: end if;
138:

Line 136: RAISE FND_API.G_EXC_ERROR;

132:
133: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
134: (l_return_status = FND_API.G_RET_STS_ERROR) then
135: close l_get_lines_csr;
136: RAISE FND_API.G_EXC_ERROR;
137: end if;
138:
139: -- - Finish up writing object data out to the specified file
140: AK_ON_OBJECTS_PVT.WRITE_FILE (

Line 147: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

143: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
144: );
145:
146: -- If API call returns with an error status...
147: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
148: (l_return_status = FND_API.G_RET_STS_ERROR) then
149: close l_get_lines_csr;
150: RAISE FND_API.G_EXC_ERROR;
151: end if;

Line 148: (l_return_status = FND_API.G_RET_STS_ERROR) then

144: );
145:
146: -- If API call returns with an error status...
147: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
148: (l_return_status = FND_API.G_RET_STS_ERROR) then
149: close l_get_lines_csr;
150: RAISE FND_API.G_EXC_ERROR;
151: end if;
152: end loop;

Line 150: RAISE FND_API.G_EXC_ERROR;

146: -- If API call returns with an error status...
147: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
148: (l_return_status = FND_API.G_RET_STS_ERROR) then
149: close l_get_lines_csr;
150: RAISE FND_API.G_EXC_ERROR;
151: end if;
152: end loop;
153: close l_get_lines_csr;
154:

Line 162: RAISE FND_API.G_EXC_ERROR;

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

Line 165: p_return_status := FND_API.G_RET_STS_SUCCESS;

161: -- dbms_output.put_line('Cannot find query object '||p_query_code);
162: RAISE FND_API.G_EXC_ERROR;
163: end if;
164:
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

Line 174: p_return_status := FND_API.G_RET_STS_ERROR;

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
177: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
178: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

Line 175: WHEN FND_API.G_EXC_ERROR THEN

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
177: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
178: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
179: FND_MSG_PUB.Add;

Line 181: p_return_status := FND_API.G_RET_STS_ERROR;

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;
184: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
185: SUBSTR (SQLERRM, 1, 240) );

Line 183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

212: -- The NLS langauge that should be used when
213: -- extracting data from the TL table
214: --=======================================================
215: procedure WRITE_TO_BUFFER (
216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217: p_return_status OUT NOCOPY VARCHAR2,
218: p_query_code IN VARCHAR2,
219: p_nls_language IN VARCHAR2
220: ) is

Line 245: RAISE FND_API.G_EXC_ERROR;

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;
247: close l_get_queryobj_csr;
248:
249: -- Write object into buffer

Line 289: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

285: p_buffer_tbl => l_databuffer_tbl,
286: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
287: );
288: -- If API call returns with an error status...
289: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
290: (l_return_status = FND_API.G_RET_STS_ERROR) then
291: RAISE FND_API.G_EXC_ERROR;
292: end if;
293:

Line 290: (l_return_status = FND_API.G_RET_STS_ERROR) then

286: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
287: );
288: -- If API call returns with an error status...
289: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
290: (l_return_status = FND_API.G_RET_STS_ERROR) then
291: RAISE FND_API.G_EXC_ERROR;
292: end if;
293:
294: l_databuffer_tbl.delete;

Line 291: RAISE FND_API.G_EXC_ERROR;

287: );
288: -- If API call returns with an error status...
289: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
290: (l_return_status = FND_API.G_RET_STS_ERROR) then
291: RAISE FND_API.G_EXC_ERROR;
292: end if;
293:
294: l_databuffer_tbl.delete;
295:

Line 302: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

298: p_return_status => l_return_status,
299: p_query_code => p_query_code,
300: p_nls_language => p_nls_language
301: );
302: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
303: (l_return_status = FND_API.G_RET_STS_ERROR) then
304: RAISE FND_API.G_EXC_ERROR;
305: end if;
306:

Line 303: (l_return_status = FND_API.G_RET_STS_ERROR) then

299: p_query_code => p_query_code,
300: p_nls_language => p_nls_language
301: );
302: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
303: (l_return_status = FND_API.G_RET_STS_ERROR) then
304: RAISE FND_API.G_EXC_ERROR;
305: end if;
306:
307: l_index := 1;

Line 304: RAISE FND_API.G_EXC_ERROR;

300: p_nls_language => p_nls_language
301: );
302: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
303: (l_return_status = FND_API.G_RET_STS_ERROR) then
304: RAISE FND_API.G_EXC_ERROR;
305: end if;
306:
307: l_index := 1;
308: l_databuffer_tbl(l_index) := 'END QUERY_OBJECT';

Line 320: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

316: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
317: );
318:
319: -- If API call returns with an error status...
320: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
321: (l_return_status = FND_API.G_RET_STS_ERROR) then
322: RAISE FND_API.G_EXC_ERROR;
323: end if;
324:

Line 321: (l_return_status = FND_API.G_RET_STS_ERROR) then

317: );
318:
319: -- If API call returns with an error status...
320: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
321: (l_return_status = FND_API.G_RET_STS_ERROR) then
322: RAISE FND_API.G_EXC_ERROR;
323: end if;
324:
325: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 322: RAISE FND_API.G_EXC_ERROR;

318:
319: -- If API call returns with an error status...
320: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
321: (l_return_status = FND_API.G_RET_STS_ERROR) then
322: RAISE FND_API.G_EXC_ERROR;
323: end if;
324:
325: p_return_status := FND_API.G_RET_STS_SUCCESS;
326:

Line 325: p_return_status := FND_API.G_RET_STS_SUCCESS;

321: (l_return_status = FND_API.G_RET_STS_ERROR) then
322: RAISE FND_API.G_EXC_ERROR;
323: end if;
324:
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

Line 334: p_return_status := FND_API.G_RET_STS_ERROR;

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
337: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
338: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);

Line 335: WHEN FND_API.G_EXC_ERROR THEN

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
337: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
338: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
339: FND_MSG_PUB.Add;

Line 341: p_return_status := FND_API.G_RET_STS_ERROR;

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;
344: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
345: SUBSTR (SQLERRM, 1, 240) );

Line 343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

386: -- Version Initial version number = 1.0
387: -- History Current version number = 1.0
388: --=======================================================
389: procedure DOWNLOAD_QUERY_OBJECT (
390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: p_api_version_number IN NUMBER,
392: p_return_status OUT NOCOPY VARCHAR2,
393: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
394: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryObj_PK_Tbl_Type

Line 393: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

389: procedure DOWNLOAD_QUERY_OBJECT (
390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: p_api_version_number IN NUMBER,
392: p_return_status OUT NOCOPY VARCHAR2,
393: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
394: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryObj_PK_Tbl_Type
395: := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_PK_TBL,
396: p_nls_language IN VARCHAR2
397: ) is

Line 413: IF NOT FND_API.Compatible_API_Call (

409: l_msg_data VARCHAR2(2000);
410: l_queryobj_pk_tbl AK_QUERYOBJ_PUB.Queryobj_PK_Tbl_Type;
411: l_return_status varchar2(1);
412: begin
413: IF NOT FND_API.Compatible_API_Call (
414: l_api_version_number, p_api_version_number, l_api_name,
415: G_PKG_NAME) then
416: -- dbms_output.put_line('API error in AK_OBJECTS2_PVT');
417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

413: IF NOT FND_API.Compatible_API_Call (
414: l_api_version_number, p_api_version_number, l_api_name,
415: G_PKG_NAME) then
416: -- dbms_output.put_line('API error in AK_OBJECTS2_PVT');
417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: return;
419: END IF;
420:
421: -- Check that one of the following selection criteria is given:

Line 425: if (p_application_id = FND_API.G_MISS_NUM) or (p_application_id is null) then

421: -- Check that one of the following selection criteria is given:
422: -- - p_application_id alone, or
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;

Line 431: raise FND_API.G_EXC_ERROR;

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
434: if (p_queryobj_PK_tbl.count > 0) then
435: -- both application ID and a list of objects to be extracted are

Line 482: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

478: p_nls_language => p_nls_language
479: );
480: -- Download aborts if any of the validation fails
481: --
482: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
483: (l_return_status = FND_API.G_RET_STS_ERROR) then
484: -- dbms_output.put_line('error throwing from WRITE_TO_BUFFER');
485: RAISE FND_API.G_EXC_ERROR;
486: end if;

Line 483: (l_return_status = FND_API.G_RET_STS_ERROR) then

479: );
480: -- Download aborts if any of the validation fails
481: --
482: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
483: (l_return_status = FND_API.G_RET_STS_ERROR) then
484: -- dbms_output.put_line('error throwing from WRITE_TO_BUFFER');
485: RAISE FND_API.G_EXC_ERROR;
486: end if;
487:

Line 485: RAISE FND_API.G_EXC_ERROR;

481: --
482: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
483: (l_return_status = FND_API.G_RET_STS_ERROR) then
484: -- dbms_output.put_line('error throwing from WRITE_TO_BUFFER');
485: RAISE FND_API.G_EXC_ERROR;
486: end if;
487:
488: -- Ready to download the next object in the list
489: l_index := l_queryobj_pk_tbl.NEXT(l_index);

Line 493: p_return_status := FND_API.G_RET_STS_SUCCESS;

489: l_index := l_queryobj_pk_tbl.NEXT(l_index);
490:
491: end loop;
492:
493: p_return_status := FND_API.G_RET_STS_SUCCESS;
494:
495: -- dbms_output.put_line('returning from ak_object_pvt.download_query_object: ' ||
496: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
497:

Line 505: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 506: WHEN FND_API.G_EXC_ERROR THEN

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

Line 507: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 509: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: p_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 521: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

517: -- not being used yet
518: --=======================================================
519:
520: FUNCTION VALIDATE_LINE (
521: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: p_api_version_number IN NUMBER,
523: p_return_status OUT NOCOPY VARCHAR2,
524: p_query_code IN VARCHAR2,
525: p_seq_num IN NUMBER,

Line 558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 589: IF NOT FND_API.Compatible_API_Call (

585: l_dummy number;
586: l_api_name constant varchar2(30) := 'QUERY_OBJECT_EXISTS';
587: l_api_version_number CONSTANT number := 1.0;
588: BEGIN
589: IF NOT FND_API.Compatible_API_Call (
590: l_api_version_number, p_api_version_number, l_api_name,
591: G_PKG_NAME) then
592: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: return FALSE;

Line 592: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

588: BEGIN
589: IF NOT FND_API.Compatible_API_Call (
590: l_api_version_number, p_api_version_number, l_api_name,
591: G_PKG_NAME) then
592: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: return FALSE;
594: END IF;
595:
596: open l_chk_qobj_exists_csr(p_query_code, p_application_id);

Line 600: p_return_status := FND_API.G_RET_STS_SUCCESS;

596: open l_chk_qobj_exists_csr(p_query_code, p_application_id);
597: fetch l_chk_qobj_exists_csr into l_dummy;
598: if (l_chk_qobj_exists_csr%notfound) then
599: close l_chk_qobj_exists_csr;
600: p_return_status := FND_API.G_RET_STS_SUCCESS;
601: return FALSE;
602: else
603: close l_chk_qobj_exists_csr;
604: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 604: p_return_status := FND_API.G_RET_STS_SUCCESS;

600: p_return_status := FND_API.G_RET_STS_SUCCESS;
601: return FALSE;
602: else
603: close l_chk_qobj_exists_csr;
604: p_return_status := FND_API.G_RET_STS_SUCCESS;
605: return TRUE;
606: end if;
607:
608: EXCEPTION

Line 609: WHEN FND_API.G_EXC_ERROR THEN

605: return TRUE;
606: end if;
607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 610: p_return_status := FND_API.G_RET_STS_ERROR;

606: end if;
607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
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,

Line 613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 645: IF NOT FND_API.Compatible_API_Call (

641: l_dummy number;
642: l_api_name constant varchar2(30) := 'LINE_EXISTS';
643: l_api_version_number CONSTANT number := 1.0;
644: BEGIN
645: IF NOT FND_API.Compatible_API_Call (
646: l_api_version_number, p_api_version_number, l_api_name,
647: G_PKG_NAME) then
648: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: return FALSE;

Line 648: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

644: BEGIN
645: IF NOT FND_API.Compatible_API_Call (
646: l_api_version_number, p_api_version_number, l_api_name,
647: G_PKG_NAME) then
648: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: return FALSE;
650: END IF;
651:
652: open l_chk_line_exists_csr(p_query_code, p_seq_num);

Line 656: p_return_status := FND_API.G_RET_STS_SUCCESS;

652: open l_chk_line_exists_csr(p_query_code, p_seq_num);
653: fetch l_chk_line_exists_csr into l_dummy;
654: if (l_chk_line_exists_csr%notfound) then
655: close l_chk_line_exists_csr;
656: p_return_status := FND_API.G_RET_STS_SUCCESS;
657: return FALSE;
658: else
659: close l_chk_line_exists_csr;
660: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 660: p_return_status := FND_API.G_RET_STS_SUCCESS;

656: p_return_status := FND_API.G_RET_STS_SUCCESS;
657: return FALSE;
658: else
659: close l_chk_line_exists_csr;
660: p_return_status := FND_API.G_RET_STS_SUCCESS;
661: return TRUE;
662: end if;
663:
664: EXCEPTION

Line 665: WHEN FND_API.G_EXC_ERROR THEN

661: return TRUE;
662: end if;
663:
664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 666: p_return_status := FND_API.G_RET_STS_ERROR;

662: end if;
663:
664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN
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,

Line 669: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 700: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

696: -- should call with this parameter loaded.
697: --=======================================================
698:
699: PROCEDURE CREATE_QUERY_OBJECT(
700: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
701: p_api_version_number IN NUMBER,
702: p_init_msg_tbl IN BOOLEAN := FALSE,
703: p_msg_count OUT NOCOPY NUMBER,
704: p_msg_data OUT NOCOPY VARCHAR2,

Line 708: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

704: p_msg_data OUT NOCOPY VARCHAR2,
705: p_return_status OUT NOCOPY VARCHAR2,
706: p_query_code IN VARCHAR2,
707: p_application_id IN NUMBER,
708: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
709: p_creation_date IN DATE := FND_API.G_MISS_DATE,
710: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
711: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
712: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 709: p_creation_date IN DATE := FND_API.G_MISS_DATE,

705: p_return_status OUT NOCOPY VARCHAR2,
706: p_query_code IN VARCHAR2,
707: p_application_id IN NUMBER,
708: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
709: p_creation_date IN DATE := FND_API.G_MISS_DATE,
710: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
711: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
712: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
713: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 710: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

706: p_query_code IN VARCHAR2,
707: p_application_id IN NUMBER,
708: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
709: p_creation_date IN DATE := FND_API.G_MISS_DATE,
710: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
711: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
712: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
713: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
714: p_pass IN NUMBER := 2

Line 711: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

707: p_application_id IN NUMBER,
708: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
709: p_creation_date IN DATE := FND_API.G_MISS_DATE,
710: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
711: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
712: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
713: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
714: p_pass IN NUMBER := 2
715: ) IS

Line 712: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

708: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
709: p_creation_date IN DATE := FND_API.G_MISS_DATE,
710: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
711: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
712: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
713: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
714: p_pass IN NUMBER := 2
715: ) IS
716: l_api_version_number CONSTANT number := 1.0;

Line 713: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

709: p_creation_date IN DATE := FND_API.G_MISS_DATE,
710: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
711: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
712: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
713: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
714: p_pass IN NUMBER := 2
715: ) IS
716: l_api_version_number CONSTANT number := 1.0;
717: l_api_name constant varchar2(30) := 'CREATE_QUERY_OBJECT';

Line 725: IF NOT FND_API.Compatible_API_Call (

721: l_last_update_date date;
722: l_last_update_login number;
723: l_last_updated_by number;
724: BEGIN
725: IF NOT FND_API.Compatible_API_Call (
726: l_api_version_number, p_api_version_number, l_api_name,
727: G_PKG_NAME) then
728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: return;

Line 728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

724: BEGIN
725: IF NOT FND_API.Compatible_API_Call (
726: l_api_version_number, p_api_version_number, l_api_name,
727: G_PKG_NAME) then
728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: return;
730: END IF;
731:
732: -- Initialize the message table if requested.

Line 751: raise FND_API.G_EXC_ERROR;

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;
753:
754: if (p_created_by <> FND_API.G_MISS_NUM) then
755: l_created_by := p_created_by;

Line 754: if (p_created_by <> FND_API.G_MISS_NUM) then

750: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
751: raise FND_API.G_EXC_ERROR;
752: end if;
753:
754: if (p_created_by <> FND_API.G_MISS_NUM) then
755: l_created_by := p_created_by;
756: end if;
757:
758: if (p_creation_date <> FND_API.G_MISS_DATE) then

Line 758: if (p_creation_date <> FND_API.G_MISS_DATE) then

754: if (p_created_by <> FND_API.G_MISS_NUM) then
755: l_created_by := p_created_by;
756: end if;
757:
758: if (p_creation_date <> FND_API.G_MISS_DATE) then
759: l_creation_date := p_creation_date;
760: end if;
761:
762: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

Line 762: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

758: if (p_creation_date <> FND_API.G_MISS_DATE) then
759: l_creation_date := p_creation_date;
760: end if;
761:
762: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
763: l_last_updated_by := p_last_updated_by;
764: end if;
765:
766: if (p_last_update_date <> FND_API.G_MISS_DATE) then

Line 766: if (p_last_update_date <> FND_API.G_MISS_DATE) then

762: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
763: l_last_updated_by := p_last_updated_by;
764: end if;
765:
766: if (p_last_update_date <> FND_API.G_MISS_DATE) then
767: l_last_update_date := p_last_update_date;
768: end if;
769:
770: if (p_last_update_login <> FND_API.G_MISS_NUM) then

Line 770: if (p_last_update_login <> FND_API.G_MISS_NUM) then

766: if (p_last_update_date <> FND_API.G_MISS_DATE) then
767: l_last_update_date := p_last_update_date;
768: end if;
769:
770: if (p_last_update_login <> FND_API.G_MISS_NUM) then
771: l_last_update_login := p_last_update_login;
772: end if;
773:
774: -- Create record if no validation error was found

Line 819: p_return_status := FND_API.G_RET_STS_SUCCESS;

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:
821: FND_MSG_PUB.Count_And_Get (
822: p_count => p_msg_count,
823: p_data => p_msg_data);

Line 832: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 837: WHEN FND_API.G_EXC_ERROR THEN

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
839: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_CREATED');
840: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
841: FND_MSG_PUB.Add;

Line 843: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 884: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

880: -- should call with this parameter loaded.
881: --=======================================================
882:
883: PROCEDURE CREATE_QUERY_OBJECT_LINE(
884: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
885: p_api_version_number IN NUMBER,
886: p_init_msg_tbl IN BOOLEAN := FALSE,
887: p_msg_count OUT NOCOPY NUMBER,
888: p_msg_data OUT NOCOPY VARCHAR2,

Line 893: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,

889: p_return_status OUT NOCOPY VARCHAR2,
890: p_query_code IN VARCHAR2,
891: p_seq_num IN NUMBER,
892: p_query_line_type IN VARCHAR2,
893: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
896: p_creation_date IN DATE := FND_API.G_MISS_DATE,
897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 894: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,

890: p_query_code IN VARCHAR2,
891: p_seq_num IN NUMBER,
892: p_query_line_type IN VARCHAR2,
893: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
896: p_creation_date IN DATE := FND_API.G_MISS_DATE,
897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
898: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 895: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

891: p_seq_num IN NUMBER,
892: p_query_line_type IN VARCHAR2,
893: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
896: p_creation_date IN DATE := FND_API.G_MISS_DATE,
897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
898: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
899: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 896: p_creation_date IN DATE := FND_API.G_MISS_DATE,

892: p_query_line_type IN VARCHAR2,
893: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
896: p_creation_date IN DATE := FND_API.G_MISS_DATE,
897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
898: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
899: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
900: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

893: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
896: p_creation_date IN DATE := FND_API.G_MISS_DATE,
897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
898: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
899: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
900: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
901: p_pass IN NUMBER := 2

Line 898: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

894: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
896: p_creation_date IN DATE := FND_API.G_MISS_DATE,
897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
898: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
899: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
900: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
901: p_pass IN NUMBER := 2
902: ) IS

Line 899: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

895: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
896: p_creation_date IN DATE := FND_API.G_MISS_DATE,
897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
898: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
899: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
900: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
901: p_pass IN NUMBER := 2
902: ) IS
903: l_api_name constant varchar2(30) := 'CREATE_QUERY_OBJECT_LINE';

Line 900: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

896: p_creation_date IN DATE := FND_API.G_MISS_DATE,
897: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
898: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
899: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
900: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
901: p_pass IN NUMBER := 2
902: ) IS
903: l_api_name constant varchar2(30) := 'CREATE_QUERY_OBJECT_LINE';
904: l_api_version_number CONSTANT number := 1.0;

Line 912: IF NOT FND_API.Compatible_API_Call (

908: l_last_update_date date;
909: l_last_update_login number;
910: l_last_updated_by number;
911: BEGIN
912: IF NOT FND_API.Compatible_API_Call (
913: l_api_version_number, p_api_version_number, l_api_name,
914: G_PKG_NAME) then
915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: return;

Line 915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

911: BEGIN
912: IF NOT FND_API.Compatible_API_Call (
913: l_api_version_number, p_api_version_number, l_api_name,
914: G_PKG_NAME) then
915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: return;
917: END IF;
918:
919: -- Initialize the message table if requested.

Line 938: raise FND_API.G_EXC_ERROR;

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;
940:
941: if (p_created_by <> FND_API.G_MISS_NUM) then
942: l_created_by := p_created_by;

Line 941: if (p_created_by <> FND_API.G_MISS_NUM) then

937: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
938: raise FND_API.G_EXC_ERROR;
939: end if;
940:
941: if (p_created_by <> FND_API.G_MISS_NUM) then
942: l_created_by := p_created_by;
943: end if;
944:
945: if (p_creation_date <> FND_API.G_MISS_DATE) then

Line 945: if (p_creation_date <> FND_API.G_MISS_DATE) then

941: if (p_created_by <> FND_API.G_MISS_NUM) then
942: l_created_by := p_created_by;
943: end if;
944:
945: if (p_creation_date <> FND_API.G_MISS_DATE) then
946: l_creation_date := p_creation_date;
947: end if;
948:
949: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

Line 949: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

945: if (p_creation_date <> FND_API.G_MISS_DATE) then
946: l_creation_date := p_creation_date;
947: end if;
948:
949: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
950: l_last_updated_by := p_last_updated_by;
951: end if;
952:
953: if (p_last_update_date <> FND_API.G_MISS_DATE) then

Line 953: if (p_last_update_date <> FND_API.G_MISS_DATE) then

949: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
950: l_last_updated_by := p_last_updated_by;
951: end if;
952:
953: if (p_last_update_date <> FND_API.G_MISS_DATE) then
954: l_last_update_date := p_last_update_date;
955: end if;
956:
957: if (p_last_update_login <> FND_API.G_MISS_NUM) then

Line 957: if (p_last_update_login <> FND_API.G_MISS_NUM) then

953: if (p_last_update_date <> FND_API.G_MISS_DATE) then
954: l_last_update_date := p_last_update_date;
955: end if;
956:
957: if (p_last_update_login <> FND_API.G_MISS_NUM) then
958: l_last_update_login := p_last_update_login;
959: end if;
960:
961: -- Create record if no validation error was found

Line 1012: p_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1014: FND_MSG_PUB.Count_And_Get (
1015: p_count => p_msg_count,
1016: p_data => p_msg_data);

Line 1025: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1030: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1036: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1042: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1077: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1073: -- Version Initial version number = 1.0
1074: -- History Current version number = 1.0
1075: --=======================================================
1076: PROCEDURE UPDATE_QUERY_OBJECT(
1077: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1078: p_api_version_number IN NUMBER,
1079: p_init_msg_tbl IN BOOLEAN := FALSE,
1080: p_msg_count OUT NOCOPY NUMBER,
1081: p_msg_data OUT NOCOPY VARCHAR2,

Line 1085: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

1081: p_msg_data OUT NOCOPY VARCHAR2,
1082: p_return_status OUT NOCOPY VARCHAR2,
1083: p_query_code IN VARCHAR2,
1084: p_application_id IN NUMBER,
1085: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1086: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1087: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1088: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1089: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 1086: p_creation_date IN DATE := FND_API.G_MISS_DATE,

1082: p_return_status OUT NOCOPY VARCHAR2,
1083: p_query_code IN VARCHAR2,
1084: p_application_id IN NUMBER,
1085: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1086: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1087: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1088: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1089: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1090: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 1087: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

1083: p_query_code IN VARCHAR2,
1084: p_application_id IN NUMBER,
1085: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1086: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1087: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1088: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1089: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1090: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1091: p_pass IN NUMBER := 2

Line 1088: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

1084: p_application_id IN NUMBER,
1085: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1086: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1087: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1088: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1089: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1090: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1091: p_pass IN NUMBER := 2
1092: ) IS

Line 1089: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

1085: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1086: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1087: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1088: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1089: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1090: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1091: p_pass IN NUMBER := 2
1092: ) IS
1093: cursor l_get_query_csr is

Line 1090: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

1086: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1087: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1088: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1089: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1090: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1091: p_pass IN NUMBER := 2
1092: ) IS
1093: cursor l_get_query_csr is
1094: select *

Line 1108: IF NOT FND_API.Compatible_API_Call (

1104: l_last_update_login number;
1105: l_last_updated_by number;
1106: l_return_status varchar2(1);
1107: BEGIN
1108: IF NOT FND_API.Compatible_API_Call (
1109: l_api_version_number, p_api_version_number, l_api_name,
1110: G_PKG_NAME) then
1111: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: return;

Line 1111: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1107: BEGIN
1108: IF NOT FND_API.Compatible_API_Call (
1109: l_api_version_number, p_api_version_number, l_api_name,
1110: G_PKG_NAME) then
1111: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: return;
1113: END IF;
1114:
1115: -- Initialize the message table if requested.

Line 1133: raise FND_API.G_EXC_ERROR;

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;
1134: end if;
1135: close l_get_query_csr;
1136:
1137: if ( NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (

Line 1144: raise FND_API.G_EXC_ERROR;

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

Line 1149: if (p_created_by <> FND_API.G_MISS_NUM) then

1145: end if;
1146:
1147: l_queryobj_rec.application_id := p_application_id;
1148:
1149: if (p_created_by <> FND_API.G_MISS_NUM) then
1150: l_created_by := p_created_by;
1151: end if;
1152:
1153: if (p_creation_date <> FND_API.G_MISS_DATE) then

Line 1153: if (p_creation_date <> FND_API.G_MISS_DATE) then

1149: if (p_created_by <> FND_API.G_MISS_NUM) then
1150: l_created_by := p_created_by;
1151: end if;
1152:
1153: if (p_creation_date <> FND_API.G_MISS_DATE) then
1154: l_creation_date := p_creation_date;
1155: end if;
1156:
1157: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

Line 1157: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

1153: if (p_creation_date <> FND_API.G_MISS_DATE) then
1154: l_creation_date := p_creation_date;
1155: end if;
1156:
1157: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
1158: l_last_updated_by := p_last_updated_by;
1159: end if;
1160:
1161: if (p_last_update_date <> FND_API.G_MISS_DATE) then

Line 1161: if (p_last_update_date <> FND_API.G_MISS_DATE) then

1157: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
1158: l_last_updated_by := p_last_updated_by;
1159: end if;
1160:
1161: if (p_last_update_date <> FND_API.G_MISS_DATE) then
1162: l_last_update_date := p_last_update_date;
1163: end if;
1164:
1165: if (p_last_update_login <> FND_API.G_MISS_NUM) then

Line 1165: if (p_last_update_login <> FND_API.G_MISS_NUM) then

1161: if (p_last_update_date <> FND_API.G_MISS_DATE) then
1162: l_last_update_date := p_last_update_date;
1163: end if;
1164:
1165: if (p_last_update_login <> FND_API.G_MISS_NUM) then
1166: l_last_update_login := p_last_update_login;
1167: end if;
1168:
1169: -- THIS UPDATES NO MATTER WHAT - CALLING IS_UPDATEABLE BECAUSE STILL

Line 1196: raise FND_API.G_EXC_ERROR;

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:
1199: -- /** commit the update **/
1200: -- commit;

Line 1208: p_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1210: FND_MSG_PUB.Count_And_Get (
1211: p_count => p_msg_count,
1212: p_data => p_msg_data);

Line 1222: p_return_status := FND_API.G_RET_STS_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 (
1224: p_count => p_msg_count,
1225: p_data => p_msg_data);
1226: WHEN FND_API.G_EXC_ERROR THEN

Line 1226: WHEN FND_API.G_EXC_ERROR THEN

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
1228: FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_UPDATED');
1229: FND_MESSAGE.SET_TOKEN('KEY', p_query_code);
1230: FND_MSG_PUB.Add;

Line 1232: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1249:
1250: END UPDATE_QUERY_OBJECT;
1251:
1252: PROCEDURE UPDATE_QUERY_OBJECT_LINE(
1253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1254: p_api_version_number IN NUMBER,
1255: p_init_msg_tbl IN BOOLEAN := FALSE,
1256: p_msg_count OUT NOCOPY NUMBER,
1257: p_msg_data OUT NOCOPY VARCHAR2,

Line 1261: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

1257: p_msg_data OUT NOCOPY VARCHAR2,
1258: p_return_status OUT NOCOPY VARCHAR2,
1259: p_query_code IN VARCHAR2,
1260: p_seq_num IN NUMBER,
1261: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1262: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 1262: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,

1258: p_return_status OUT NOCOPY VARCHAR2,
1259: p_query_code IN VARCHAR2,
1260: p_seq_num IN NUMBER,
1261: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1262: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1263: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,

1259: p_query_code IN VARCHAR2,
1260: p_seq_num IN NUMBER,
1261: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1262: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1267: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

1260: p_seq_num IN NUMBER,
1261: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1262: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1267: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1268: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,

1261: p_query_line_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1262: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1267: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1268: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1269: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

1262: p_query_line IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1267: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1268: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1269: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1270: p_pass IN NUMBER := 2

Line 1267: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

1263: p_linked_parameter IN VARCHAR2 := FND_API.G_MISS_CHAR,
1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1267: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1268: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1269: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1270: p_pass IN NUMBER := 2
1271: ) IS

Line 1268: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

1264: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1267: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1268: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1269: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1270: p_pass IN NUMBER := 2
1271: ) IS
1272:

Line 1269: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

1265: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1266: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1267: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1268: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1269: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1270: p_pass IN NUMBER := 2
1271: ) IS
1272:
1273: cursor l_get_query_line_csr is

Line 1289: IF NOT FND_API.Compatible_API_Call (

1285: l_last_update_login number;
1286: l_last_updated_by number;
1287: l_return_status varchar2(1);
1288: BEGIN
1289: IF NOT FND_API.Compatible_API_Call (
1290: l_api_version_number, p_api_version_number, l_api_name,
1291: G_PKG_NAME) then
1292: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: return;

Line 1292: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1288: BEGIN
1289: IF NOT FND_API.Compatible_API_Call (
1290: l_api_version_number, p_api_version_number, l_api_name,
1291: G_PKG_NAME) then
1292: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: return;
1294: END IF;
1295:
1296: -- Initialize the message table if requested.

Line 1314: raise FND_API.G_EXC_ERROR;

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;
1315: end if;
1316: close l_get_query_line_csr;
1317:
1318: --** Load record to be updated to the database **

Line 1320: if (p_query_line_type <> FND_API.G_MISS_CHAR) or

1316: close l_get_query_line_csr;
1317:
1318: --** Load record to be updated to the database **
1319:
1320: if (p_query_line_type <> FND_API.G_MISS_CHAR) or
1321: (p_query_line_type is null) then
1322: l_line_rec.query_line_type := p_query_line_type;
1323: end if;
1324: if (p_query_line <> FND_API.G_MISS_CHAR) or

Line 1324: if (p_query_line <> FND_API.G_MISS_CHAR) or

1320: if (p_query_line_type <> FND_API.G_MISS_CHAR) or
1321: (p_query_line_type is null) then
1322: l_line_rec.query_line_type := p_query_line_type;
1323: end if;
1324: if (p_query_line <> FND_API.G_MISS_CHAR) or
1325: (p_query_line is null) then
1326: l_line_rec.query_line := p_query_line;
1327: end if;
1328: if (p_linked_parameter <> FND_API.G_MISS_CHAR) or

Line 1328: if (p_linked_parameter <> FND_API.G_MISS_CHAR) or

1324: if (p_query_line <> FND_API.G_MISS_CHAR) or
1325: (p_query_line is null) then
1326: l_line_rec.query_line := p_query_line;
1327: end if;
1328: if (p_linked_parameter <> FND_API.G_MISS_CHAR) or
1329: (p_linked_parameter is null) then
1330: l_line_rec.linked_parameter := p_linked_parameter;
1331: end if;
1332:

Line 1333: if (p_created_by <> FND_API.G_MISS_NUM) then

1329: (p_linked_parameter is null) then
1330: l_line_rec.linked_parameter := p_linked_parameter;
1331: end if;
1332:
1333: if (p_created_by <> FND_API.G_MISS_NUM) then
1334: l_created_by := p_created_by;
1335: end if;
1336:
1337: if (p_creation_date <> FND_API.G_MISS_DATE) then

Line 1337: if (p_creation_date <> FND_API.G_MISS_DATE) then

1333: if (p_created_by <> FND_API.G_MISS_NUM) then
1334: l_created_by := p_created_by;
1335: end if;
1336:
1337: if (p_creation_date <> FND_API.G_MISS_DATE) then
1338: l_creation_date := p_creation_date;
1339: end if;
1340:
1341: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

Line 1341: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

1337: if (p_creation_date <> FND_API.G_MISS_DATE) then
1338: l_creation_date := p_creation_date;
1339: end if;
1340:
1341: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
1342: l_last_updated_by := p_last_updated_by;
1343: end if;
1344:
1345: if (p_last_update_date <> FND_API.G_MISS_DATE) then

Line 1345: if (p_last_update_date <> FND_API.G_MISS_DATE) then

1341: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
1342: l_last_updated_by := p_last_updated_by;
1343: end if;
1344:
1345: if (p_last_update_date <> FND_API.G_MISS_DATE) then
1346: l_last_update_date := p_last_update_date;
1347: end if;
1348:
1349: if (p_last_update_login <> FND_API.G_MISS_NUM) then

Line 1349: if (p_last_update_login <> FND_API.G_MISS_NUM) then

1345: if (p_last_update_date <> FND_API.G_MISS_DATE) then
1346: l_last_update_date := p_last_update_date;
1347: end if;
1348:
1349: if (p_last_update_login <> FND_API.G_MISS_NUM) then
1350: l_last_update_login := p_last_update_login;
1351: end if;
1352:
1353: -- THIS UPDATES NO MATTER WHAT - CALLING IS_UPDATEABLE BECAUSE STILL

Line 1383: raise FND_API.G_EXC_ERROR;

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:
1386: -- /** commit the update **/
1387: -- commit;

Line 1395: p_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1397: FND_MSG_PUB.Count_And_Get (
1398: p_count => p_msg_count,
1399: p_data => p_msg_data);

Line 1409: p_return_status := FND_API.G_RET_STS_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 (
1411: p_count => p_msg_count,
1412: p_data => p_msg_data);
1413: WHEN FND_API.G_EXC_ERROR THEN

Line 1413: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1419: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1489: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1485: -- Version Initial version number = 1.0
1486: -- History Current version number = 1.0
1487: --=======================================================
1488: procedure UPLOAD_QUERY_OBJECT (
1489: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1490: p_api_version_number IN NUMBER,
1491: p_return_status OUT NOCOPY VARCHAR2,
1492: p_index IN OUT NOCOPY NUMBER,
1493: p_loader_timestamp IN DATE,

Line 1494: p_line_num IN NUMBER := FND_API.G_MISS_NUM,

1490: p_api_version_number IN NUMBER,
1491: p_return_status OUT NOCOPY VARCHAR2,
1492: p_index IN OUT NOCOPY NUMBER,
1493: p_loader_timestamp IN DATE,
1494: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1495: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1496: p_line_num_out OUT NOCOPY NUMBER,
1497: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1498: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

Line 1533: IF NOT FND_API.Compatible_API_Call (

1529: begin
1530: --dbms_output.put_line('Started query upload: ' ||
1531: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
1532:
1533: IF NOT FND_API.Compatible_API_Call (
1534: l_api_version_number, p_api_version_number, l_api_name,
1535: G_PKG_NAME) then
1536: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: return;

Line 1536: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1532:
1533: IF NOT FND_API.Compatible_API_Call (
1534: l_api_version_number, p_api_version_number, l_api_name,
1535: G_PKG_NAME) then
1536: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: return;
1538: END IF;
1539:
1540: SAVEPOINT Start_Upload;

Line 1551: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then

1547: -- the tokens 'BEGIN QUERY_OBJECT' has already been parsed. Set initial
1548: -- buffer to 'BEGIN QUERY_OBJECT' before reading the next line from the
1549: -- file. Otherwise, set initial buffer to null.
1550: --
1551: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
1552: l_buffer := 'BEGIN QUERY_OBJECT ' || p_buffer;
1553: else
1554: l_buffer := null;
1555: end if;

Line 1557: if (p_line_num = FND_API.G_MISS_NUM) then

1553: else
1554: l_buffer := null;
1555: end if;
1556:
1557: if (p_line_num = FND_API.G_MISS_NUM) then
1558: l_line_num := 0;
1559: else
1560: l_line_num := p_line_num;
1561: end if;

Line 1572: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1568: p_lines_read => l_lines_read,
1569: p_eof_flag => l_eof_flag,
1570: p_upl_loader_cur => p_upl_loader_cur
1571: );
1572: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1573: (l_return_status = FND_API.G_RET_STS_ERROR) then
1574: RAISE FND_API.G_EXC_ERROR;
1575: end if;
1576: l_line_num := l_line_num + l_lines_read;

Line 1573: (l_return_status = FND_API.G_RET_STS_ERROR) then

1569: p_eof_flag => l_eof_flag,
1570: p_upl_loader_cur => p_upl_loader_cur
1571: );
1572: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1573: (l_return_status = FND_API.G_RET_STS_ERROR) then
1574: RAISE FND_API.G_EXC_ERROR;
1575: end if;
1576: l_line_num := l_line_num + l_lines_read;
1577: --

Line 1574: RAISE FND_API.G_EXC_ERROR;

1570: p_upl_loader_cur => p_upl_loader_cur
1571: );
1572: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1573: (l_return_status = FND_API.G_RET_STS_ERROR) then
1574: RAISE FND_API.G_EXC_ERROR;
1575: end if;
1576: l_line_num := l_line_num + l_lines_read;
1577: --
1578: -- trim leading spaces and discard comment lines

Line 1594: raise FND_API.G_EXC_ERROR;

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:
1597: -- Read tokens from file, one at a time
1598:

Line 1610: if (l_return_status = FND_API.G_RET_STS_ERROR) or

1606: );
1607:
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;

Line 1611: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

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

Line 1617: raise FND_API.G_EXC_ERROR;

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;
1619:
1620:
1621: --

Line 1635: raise FND_API.G_EXC_ERROR;

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
1638: if (l_token = 'QUERY_OBJECT') then
1639: --== Clear out previous column data ==--

Line 1663: raise FND_API.G_EXC_ERROR;

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
1666: if (l_token = 'BEGIN') then
1667: l_state := 13;

Line 1707: raise FND_API.G_EXC_ERROR;

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;
1709: end if;
1710: elsif (l_state = 11) then
1711: if (l_token = '=') then

Line 1721: raise FND_API.G_EXC_ERROR;

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
1724: l_value_count := 1;
1725: if (l_column = 'APPLICATION_ID') then

Line 1756: raise FND_API.G_EXC_ERROR;

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;
1759: elsif (l_state = 13) then
1760: if (l_token = 'QUERY_OBJECT_LINE') then

Line 1774: raise FND_API.G_EXC_ERROR;

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
1777: if (l_token = 'QUERY_OBJECT') then
1778: l_state := 0;

Line 1789: raise FND_API.G_EXC_ERROR;

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:
1792: --
1793: -- QUERY_OBJECT_LINE (states 20 - 39)

Line 1808: raise FND_API.G_EXC_ERROR;

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
1811: if (l_token = 'END') then
1812: l_state := 39;

Line 1851: raise FND_API.G_EXC_ERROR;

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

Line 1865: raise FND_API.G_EXC_ERROR;

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
1868: l_value_count := 1;
1869: if (l_column = 'QUERY_LINE_TYPE') then

Line 1906: raise FND_API.G_EXC_ERROR;

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
1909: -- end of query_object_line
1910: if (l_token = 'QUERY_OBJECT_LINE') then

Line 1923: raise FND_API.G_EXC_ERROR;

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:
1926: end if; -- if l_state = ...
1927:

Line 1943: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1939: p_lines_read => l_lines_read,
1940: p_eof_flag => l_eof_flag,
1941: p_upl_loader_cur => p_upl_loader_cur
1942: );
1943: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1944: (l_return_status = FND_API.G_RET_STS_ERROR) then
1945: RAISE FND_API.G_EXC_ERROR;
1946: end if;
1947: l_line_num := l_line_num + l_lines_read;

Line 1944: (l_return_status = FND_API.G_RET_STS_ERROR) then

1940: p_eof_flag => l_eof_flag,
1941: p_upl_loader_cur => p_upl_loader_cur
1942: );
1943: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1944: (l_return_status = FND_API.G_RET_STS_ERROR) then
1945: RAISE FND_API.G_EXC_ERROR;
1946: end if;
1947: l_line_num := l_line_num + l_lines_read;
1948: --

Line 1945: RAISE FND_API.G_EXC_ERROR;

1941: p_upl_loader_cur => p_upl_loader_cur
1942: );
1943: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1944: (l_return_status = FND_API.G_RET_STS_ERROR) then
1945: RAISE FND_API.G_EXC_ERROR;
1946: end if;
1947: l_line_num := l_line_num + l_lines_read;
1948: --
1949: -- trim leading spaces and discard comment lines

Line 1972: raise FND_API.G_EXC_ERROR;

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;
1973: end if;
1974:
1975: --
1976: -- create or update all regions to the database

Line 2065: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

2061: );
2062: end if; -- /* if QUERY_OBJECT_EXISTS */
2063: --
2064: -- If API call returns with an error status, upload aborts
2065: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2066: (l_return_status = FND_API.G_RET_STS_ERROR) then
2067: RAISE FND_API.G_EXC_ERROR;
2068: end if; -- /* if l_return_status */
2069: /******* below piece of code is not actually being used because

Line 2066: (l_return_status = FND_API.G_RET_STS_ERROR) then

2062: end if; -- /* if QUERY_OBJECT_EXISTS */
2063: --
2064: -- If API call returns with an error status, upload aborts
2065: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2066: (l_return_status = FND_API.G_RET_STS_ERROR) then
2067: RAISE FND_API.G_EXC_ERROR;
2068: end if; -- /* if l_return_status */
2069: /******* below piece of code is not actually being used because
2070: ******* query objects do not need 2 passes, but I am saving

Line 2067: RAISE FND_API.G_EXC_ERROR;

2063: --
2064: -- If API call returns with an error status, upload aborts
2065: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2066: (l_return_status = FND_API.G_RET_STS_ERROR) then
2067: RAISE FND_API.G_EXC_ERROR;
2068: end if; -- /* if l_return_status */
2069: /******* below piece of code is not actually being used because
2070: ******* query objects do not need 2 passes, but I am saving
2071: ******* the code here for future use

Line 2182: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

2178: );
2179: end if; -- /* if LINE_EXISTS */
2180: --
2181: -- If API call returns with an error status, upload aborts
2182: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2183: (l_return_status = FND_API.G_RET_STS_ERROR) then
2184: RAISE FND_API.G_EXC_ERROR;
2185: end if; -- /* if l_return_status */
2186:

Line 2183: (l_return_status = FND_API.G_RET_STS_ERROR) then

2179: end if; -- /* if LINE_EXISTS */
2180: --
2181: -- If API call returns with an error status, upload aborts
2182: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2183: (l_return_status = FND_API.G_RET_STS_ERROR) then
2184: RAISE FND_API.G_EXC_ERROR;
2185: end if; -- /* if l_return_status */
2186:
2187: /*** below code is not being used right now ******/

Line 2184: RAISE FND_API.G_EXC_ERROR;

2180: --
2181: -- If API call returns with an error status, upload aborts
2182: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2183: (l_return_status = FND_API.G_RET_STS_ERROR) then
2184: RAISE FND_API.G_EXC_ERROR;
2185: end if; -- /* if l_return_status */
2186:
2187: /*** below code is not being used right now ******/
2188: --

Line 2204: p_return_status := FND_API.G_RET_STS_SUCCESS;

2200: -- Load line number of the last file line processed
2201: --
2202: p_line_num_out := l_line_num;
2203:
2204: p_return_status := FND_API.G_RET_STS_SUCCESS;
2205:
2206: --dbms_output.put_line('Leaving query object upload: ' ||
2207: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2208:

Line 2210: WHEN FND_API.G_EXC_ERROR THEN

2206: --dbms_output.put_line('Leaving query object upload: ' ||
2207: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2208:
2209: EXCEPTION
2210: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 2211: p_return_status := FND_API.G_RET_STS_ERROR;

2207: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2208:
2209: EXCEPTION
2210: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 2214: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
2226: SUBSTR (SQLERRM, 1, 240) );
2227: FND_MSG_PUB.Add;