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.IEC_RECORD_FILTER_PVT dependencies on FND_API

Line 56: RAISE fnd_api.g_exc_unexpected_error;

52: , 'Get_AppsSchemaName'
53: , 'MAIN'
54: , SQLCODE
55: , SQLERRM);
56: RAISE fnd_api.g_exc_unexpected_error;
57:
58: END Get_AppsSchemaName;
59:
60: -----------------------------++++++-------------------------------

Line 170: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

166: l_return_code VARCHAR2(1);
167:
168: BEGIN
169:
170: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
171: X_VIEW_EXISTS := 'N';
172:
173: L_VIEW_NAME := 'IEC_REC_FILTER_' || p_record_filter_id || '_V';
174: l_view_owner := Get_AppsSchemaName;

Line 192: x_return_code := FND_API.G_RET_STS_ERROR;

188: -- TODO: Need to log that this record filter has invalid criteria.
189: -- Might want to attempt to rebuild the view to make
190: -- sure the lates changes have been built into the view
191: -- prior to making this assertion.
192: x_return_code := FND_API.G_RET_STS_ERROR;
193: ELSE
194: x_view_exists := 'Y';
195: END IF;
196:

Line 204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

200: WHEN NO_DATA_FOUND THEN
201: x_view_exists := 'N';
202: x_view_name := l_view_name;
203: WHEN OTHERS THEN
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205: END;
206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN

Line 208: WHEN FND_API.G_EXC_ERROR THEN

204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205: END;
206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: X_RETURN_CODE := 'E';
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: X_RETURN_CODE := 'U';
212: WHEN OTHERS THEN

Line 210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: X_RETURN_CODE := 'E';
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: X_RETURN_CODE := 'U';
212: WHEN OTHERS THEN
213: X_RETURN_CODE := 'U';
214:

Line 284: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

280: l_status_code VARCHAR2(1);
281:
282: BEGIN
283:
284: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
285:
286: l_create_statement(1) := l_create_start_str
287: || p_view_name
288: || l_create_as_str

Line 299: IF l_status_code = FND_API.G_RET_STS_SUCCESS THEN

295: , p_source_type_view_name
296: , l_create_statement
297: , l_status_code);
298:
299: IF l_status_code = FND_API.G_RET_STS_SUCCESS THEN
300: l_work_cursor := DBMS_SQL.OPEN_CURSOR;
301:
302: DBMS_SQL.PARSE( c => l_work_cursor
303: , statement => l_create_statement

Line 331: WHEN FND_API.G_EXC_ERROR THEN

327:
328: COMMIT;
329:
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: IF DBMS_SQL.IS_OPEN(l_work_cursor)
333: THEN
334: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
335: END IF;

Line 338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

334: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
335: END IF;
336: ROLLBACK;
337: X_RETURN_CODE := 'E';
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: IF DBMS_SQL.IS_OPEN(l_work_cursor)
340: THEN
341: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
342: END IF;

Line 385: x_return_code := FND_API.G_RET_STS_SUCCESS;

381: l_ignore NUMBER;
382:
383: BEGIN
384:
385: x_return_code := FND_API.G_RET_STS_SUCCESS;
386:
387: -- DROP VIEW IEC_REC_FILTER__V
388:
389: l_view_name := 'IEC_REC_FILTER_' || p_record_filter_id || '_V';

Line 405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

401: EXCEPTION
402: WHEN NO_DATA_FOUND THEN
403: NULL;
404: WHEN OTHERS THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END;
407:
408: COMMIT;
409: EXCEPTION

Line 410: WHEN FND_API.G_EXC_ERROR THEN

406: END;
407:
408: COMMIT;
409: EXCEPTION
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK;
412: X_RETURN_CODE := 'E';
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK;

Line 413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

409: EXCEPTION
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK;
412: X_RETURN_CODE := 'E';
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK;
415: X_RETURN_CODE := 'U';
416: WHEN OTHERS THEN
417: ROLLBACK;

Line 453: l_return_code := FND_API.G_RET_STS_SUCCESS;

449: l_return_code VARCHAR2(1);
450: l_view_exists VARCHAR2(1);
451:
452: BEGIN
453: l_return_code := FND_API.G_RET_STS_SUCCESS;
454: l_view_exists := 'N';
455: ----------------------------------------------------------------
456: -- Initialize the return code.
457: ----------------------------------------------------------------

Line 458: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

454: l_view_exists := 'N';
455: ----------------------------------------------------------------
456: -- Initialize the return code.
457: ----------------------------------------------------------------
458: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
459:
460: ----------------------------------------------------------------
461: -- Create save point for this procedure.
462: ----------------------------------------------------------------

Line 473: IF (l_return_code = FND_API.G_RET_STS_SUCCESS AND l_view_exists = 'N')

469: , x_view_exists => l_view_exists
470: , x_return_code => l_return_code
471: );
472:
473: IF (l_return_code = FND_API.G_RET_STS_SUCCESS AND l_view_exists = 'N')
474: THEN
475: Create_RecordFilterView ( p_record_filter_id => p_record_filter_id
476: , p_view_name => l_view_name
477: , p_source_type_view_name => p_source_type_view_name

Line 481: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN

477: , p_source_type_view_name => p_source_type_view_name
478: , x_return_code => l_return_code
479: );
480:
481: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
482: IF (l_return_code = 'N')
483: THEN
484: l_view_name := NULL;
485: ELSE

Line 486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

482: IF (l_return_code = 'N')
483: THEN
484: l_view_name := NULL;
485: ELSE
486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
487: END IF;
488: END IF;
489:
490: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN

Line 490: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN

486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
487: END IF;
488: END IF;
489:
490: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: RETURN l_view_name;

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487: END IF;
488: END IF;
489:
490: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: RETURN l_view_name;
495:

Line 499: X_RETURN_CODE := FND_API.G_RET_STS_UNEXP_ERROR;

495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: ROLLBACK TO GET_RECORD_FILTER_VIEW_SP;
499: X_RETURN_CODE := FND_API.G_RET_STS_UNEXP_ERROR;
500:
501: END Get_RecordFilterView;
502:
503: -----------------------------++++++-------------------------------

Line 597: l_return_code := FND_API.G_RET_STS_SUCCESS;

593: l_view_exists := 'N';
594: ----------------------------------------------------------------
595: -- Initialize the return code.
596: ----------------------------------------------------------------
597: l_return_code := FND_API.G_RET_STS_SUCCESS;
598:
599: x_record_filter_view_name := 'ERROR';
600:
601: ----------------------------------------------------------------

Line 627: IF (l_return_code = FND_API.G_RET_STS_SUCCESS AND l_view_exists = 'Y')

623:
624: ----------------------------------------------------------------
625: -- If the view already exists then drop the view.
626: ----------------------------------------------------------------
627: IF (l_return_code = FND_API.G_RET_STS_SUCCESS AND l_view_exists = 'Y')
628: THEN
629: Drop_RecordFilterView ( p_record_filter_id => p_record_filter_id
630: , x_return_code => l_return_code);
631:

Line 632: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS)

628: THEN
629: Drop_RecordFilterView ( p_record_filter_id => p_record_filter_id
630: , x_return_code => l_return_code);
631:
632: ELSIF (l_return_code <> FND_API.G_RET_STS_SUCCESS)
633: THEN
634: g_error_msg := SUBSTR( 'Verifying view for record filter: ' || p_record_filter_id
635: || ' SLQCODE: ' || SQLCODE || ':' || SQLERRM
636: , 1

Line 638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

634: g_error_msg := SUBSTR( 'Verifying view for record filter: ' || p_record_filter_id
635: || ' SLQCODE: ' || SQLCODE || ':' || SQLERRM
636: , 1
637: , 2048);
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639:
640: END IF;
641:
642: ----------------------------------------------------------------

Line 646: IF (l_return_code = FND_API.G_RET_STS_SUCCESS)

642: ----------------------------------------------------------------
643: -- If everything was successful up to this point then we
644: -- create the record filter view.
645: ----------------------------------------------------------------
646: IF (l_return_code = FND_API.G_RET_STS_SUCCESS)
647: THEN
648: Create_RecordFilterView ( p_record_filter_id => p_record_filter_id
649: , p_view_name => l_view_name
650: , p_source_type_view_name => l_source_type_view_name

Line 654: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN

650: , p_source_type_view_name => l_source_type_view_name
651: , x_return_code => l_return_code
652: );
653:
654: IF (l_return_code <> FND_API.G_RET_STS_SUCCESS) THEN
655:
656: IF (l_return_code = 'N')
657: THEN
658: g_error_msg := SUBSTR( 'Creating view for record filter: ' || p_record_filter_id

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

658: g_error_msg := SUBSTR( 'Creating view for record filter: ' || p_record_filter_id
659: || ' SLQCODE: ' || SQLCODE || ':' || SQLERRM
660: , 1
661: , 2048);
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END IF;
664: END IF;
665:
666: x_record_filter_view_name := l_view_name;

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

669: g_error_msg := SUBSTR( 'Dropping view for record filter: ' || p_record_filter_id
670: || ' SLQCODE: ' || SQLCODE || ':' || SQLERRM
671: , 1
672: , 2048);
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676: EXCEPTION
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676: EXCEPTION
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
678: THEN
679: ROLLBACK TO RECREATE_RECORD_FILTER_VIEW_SP;
680: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
681: WHEN OTHERS THEN