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.XLA_EXTRACT_INTEGRITY_PKG dependencies on XLA_EXTRACT_INTEGRITY_PKG

Line 1: PACKAGE BODY XLA_EXTRACT_INTEGRITY_PKG AS

1: PACKAGE BODY XLA_EXTRACT_INTEGRITY_PKG AS
2: /* $Header: xlaamext.pkb 120.44 2006/08/25 20:45:48 weshen ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_extract_integrity_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +============================================================================+
8: | PACKAGE NAME |
9: | xla_extract_integrity_pkg |
10: | |
11: | DESCRIPTION |
12: | This is the body of the package that checks the extract integrity |
13: | for an event class and creates sources and source assignments for the |

Line 89: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_extract_integrity_pkg';

85: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
86: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
87: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
88:
89: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_extract_integrity_pkg';
90:
91: g_trace_label VARCHAR2(240);
92: g_log_level NUMBER;
93: g_log_enabled BOOLEAN;

Line 124: (p_location => 'xla_extract_integrity_pkg.trace');

120: WHEN xla_exceptions_pkg.application_exception THEN
121: RAISE;
122: WHEN OTHERS THEN
123: xla_exceptions_pkg.raise_message
124: (p_location => 'xla_extract_integrity_pkg.trace');
125: END trace;
126:
127: --=============================================================================
128: -- *********** public procedures and functions **********

Line 225: xla_extract_integrity_pkg.set_extract_object_owner

221: -- Initialize the error package
222: Xla_amb_setup_err_pkg.initialize;
223:
224: -- Get the extract object owner and store in GT table.
225: xla_extract_integrity_pkg.set_extract_object_owner
226: (p_application_id => l_application_id
227: ,p_entity_code => l_entity_code
228: ,p_event_class_code => l_event_class_code
229: );

Line 232: IF NOT Xla_extract_integrity_pkg.validate_extract_objects

228: ,p_event_class_code => l_event_class_code
229: );
230:
231: -- Validate extract objects
232: IF NOT Xla_extract_integrity_pkg.validate_extract_objects
233: (p_application_id => l_application_id
234: ,p_entity_code => l_entity_code
235: ,p_event_class_code => l_event_class_code) THEN
236:

Line 267: IF NOT Xla_extract_integrity_pkg.Validate_sources

263:
264: ELSIF p_processing_mode = 'VALIDATE' THEN
265:
266: -- Validate sources with the extract objects
267: IF NOT Xla_extract_integrity_pkg.Validate_sources
268: (p_application_id => l_application_id
269: ,p_entity_code => l_entity_code
270: ,p_event_class_code => l_event_class_code) THEN
271: l_return := FALSE;

Line 300: (p_location => 'xla_extract_integrity_pkg.check_extract_integrity');

296: WHEN xla_exceptions_pkg.application_exception THEN
297: RAISE;
298: WHEN OTHERS THEN
299: xla_exceptions_pkg.raise_message
300: (p_location => 'xla_extract_integrity_pkg.check_extract_integrity');
301: END Check_extract_integrity; -- end of function
302:
303: /*======================================================================+
304: | |

Line 617: (p_location => 'xla_extract_integrity_pkg.validate_extract_objects');

613: WHEN xla_exceptions_pkg.application_exception THEN
614: RAISE;
615: WHEN OTHERS THEN
616: xla_exceptions_pkg.raise_message
617: (p_location => 'xla_extract_integrity_pkg.validate_extract_objects');
618: END validate_extract_objects; -- end of function
619:
620: /*======================================================================+
621: | |

Line 724: IF NOT Xla_extract_integrity_pkg.validate_sources_with_extract

720: INTO l_exist;
721: IF c_gt_sources%found THEN
722:
723: -- Call the function to validate all sources in the GT table
724: IF NOT Xla_extract_integrity_pkg.validate_sources_with_extract
725: (p_application_id => l_application_id
726: ,p_entity_code => l_entity_code
727: ,p_event_class_code => l_event_class_code) THEN
728: l_return := FALSE;

Line 747: (p_location => 'xla_extract_integrity_pkg.validate_sources');

743: WHEN xla_exceptions_pkg.application_exception THEN
744: RAISE;
745: WHEN OTHERS THEN
746: xla_exceptions_pkg.raise_message
747: (p_location => 'xla_extract_integrity_pkg.validate_sources');
748: END Validate_sources; -- end of function
749:
750: /*======================================================================+
751: | |

Line 1385: (p_location => 'xla_extract_integrity_pkg.validate_sources_with_extract');

1381: WHEN xla_exceptions_pkg.application_exception THEN
1382: RAISE;
1383: WHEN OTHERS THEN
1384: xla_exceptions_pkg.raise_message
1385: (p_location => 'xla_extract_integrity_pkg.validate_sources_with_extract');
1386: END validate_sources_with_extract; -- end of function
1387:
1388: /*======================================================================+
1389: | |

Line 1725: (p_location => 'xla_extract_integrity_pkg.set_extract_object_owner');

1721: WHEN xla_exceptions_pkg.application_exception THEN
1722: RAISE;
1723: WHEN OTHERS THEN
1724: xla_exceptions_pkg.raise_message
1725: (p_location => 'xla_extract_integrity_pkg.set_extract_object_owner');
1726: END Set_extract_object_owner; -- end of procedure
1727:
1728:
1729: --=============================================================================

Line 2234: (p_location => 'xla_extract_integrity_pkg.Chk_primary_keys_exist');

2230: WHEN xla_exceptions_pkg.application_exception THEN
2231: RAISE;
2232: WHEN OTHERS THEN
2233: xla_exceptions_pkg.raise_message
2234: (p_location => 'xla_extract_integrity_pkg.Chk_primary_keys_exist');
2235: END Chk_primary_keys_exist; -- end of function
2236:
2237: /*======================================================================+
2238: | |

Line 2804: (p_location => 'xla_extract_integrity_pkg.validate_accounting_sources');

2800: WHEN xla_exceptions_pkg.application_exception THEN
2801: RAISE;
2802: WHEN OTHERS THEN
2803: xla_exceptions_pkg.raise_message
2804: (p_location => 'xla_extract_integrity_pkg.validate_accounting_sources');
2805: END Validate_accounting_sources; -- end of function
2806:
2807: /*======================================================================+
2808: | |

Line 3305: (p_location => 'xla_extract_integrity_pkg.Create_sources');

3301: WHEN xla_exceptions_pkg.application_exception THEN
3302: RAISE;
3303: WHEN OTHERS THEN
3304: xla_exceptions_pkg.raise_message
3305: (p_location => 'xla_extract_integrity_pkg.Create_sources');
3306: END Create_sources; -- end of procedure
3307:
3308: /*======================================================================+
3309: | |

Line 3775: (p_location => 'xla_extract_integrity_pkg.Assign_sources');

3771: WHEN xla_exceptions_pkg.application_exception THEN
3772: RAISE;
3773: WHEN OTHERS THEN
3774: xla_exceptions_pkg.raise_message
3775: (p_location => 'xla_extract_integrity_pkg.Assign_sources');
3776: END Assign_sources; -- end of procedure
3777:
3778: END xla_extract_integrity_pkg;

Line 3778: END xla_extract_integrity_pkg;

3774: xla_exceptions_pkg.raise_message
3775: (p_location => 'xla_extract_integrity_pkg.Assign_sources');
3776: END Assign_sources; -- end of procedure
3777:
3778: END xla_extract_integrity_pkg;