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_CMP_EXTRACT_PKG dependencies on XLA_CMP_EXTRACT_PKG

Line 1: PACKAGE BODY xla_cmp_extract_pkg AS

1: PACKAGE BODY xla_cmp_extract_pkg AS
2: /* $Header: xlacpext.pkb 120.60.12000000.2 2007/10/12 06:09:08 samejain ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_cmp_extract_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +============================================================================+
8: | PACKAGE NAME |
9: | xla_cmp_extract_pkg |
10: | |
11: | DESCRIPTION |
12: | This is a XLA private package, which contains all the logic required |
13: | to generate header and line cursors from AMB specifcations |

Line 717: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_extract_pkg';

713: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
714: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
715:
716: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
717: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_extract_pkg';
718:
719: g_log_level NUMBER;
720: g_log_enabled BOOLEAN;
721:

Line 742: (p_location => 'xla_cmp_extract_pkg.trace');

738: WHEN xla_exceptions_pkg.application_exception THEN
739: RAISE;
740: WHEN OTHERS THEN
741: xla_exceptions_pkg.raise_message
742: (p_location => 'xla_cmp_extract_pkg.trace');
743: END trace;
744:
745:
746: --+==========================================================================+

Line 954: (p_location => 'xla_cmp_extract_pkg.InitSourceArrays ');

950: WHEN xla_exceptions_pkg.application_exception THEN
951: RAISE;
952: WHEN OTHERS THEN
953: xla_exceptions_pkg.raise_message
954: (p_location => 'xla_cmp_extract_pkg.InitSourceArrays ');
955: END InitSourceArrays;
956: --
957: --+==========================================================================+
958: --| |

Line 1180: (p_location => 'xla_cmp_extract_pkg.InsertSourcesIntoGtTable ');

1176: WHEN xla_exceptions_pkg.application_exception THEN
1177: RAISE;
1178: WHEN OTHERS THEN
1179: xla_exceptions_pkg.raise_message
1180: (p_location => 'xla_cmp_extract_pkg.InsertSourcesIntoGtTable ');
1181: END InsertSourcesIntoGtTable;
1182: --
1183: --
1184: --+==========================================================================+

Line 1286: (p_location => 'xla_cmp_extract_pkg.GetSourceLevels ');

1282: WHEN xla_exceptions_pkg.application_exception THEN
1283: RAISE;
1284: WHEN OTHERS THEN
1285: xla_exceptions_pkg.raise_message
1286: (p_location => 'xla_cmp_extract_pkg.GetSourceLevels ');
1287: END GetSourceLevels;
1288: --
1289: --
1290: --+==========================================================================+

Line 1507: (p_location => 'xla_cmp_extract_pkg.GetExtractObjects ');

1503: WHEN xla_exceptions_pkg.application_exception THEN
1504: RAISE;
1505: WHEN OTHERS THEN
1506: xla_exceptions_pkg.raise_message
1507: (p_location => 'xla_cmp_extract_pkg.GetExtractObjects ');
1508: END GetExtractObjects;
1509: --
1510: --
1511: --+==========================================================================+

Line 1694: (p_location => 'xla_cmp_extract_pkg.GetSourcesWithExtractObject ');

1690: WHEN xla_exceptions_pkg.application_exception THEN
1691: RAISE;
1692: WHEN OTHERS THEN
1693: xla_exceptions_pkg.raise_message
1694: (p_location => 'xla_cmp_extract_pkg.GetSourcesWithExtractObject ');
1695: END GetSourcesWithExtractObject;
1696:
1697: --
1698: --

Line 2216: (p_location => 'xla_cmp_extract_pkg.CallExtractIntegrityChecker ');

2212: WHEN xla_exceptions_pkg.application_exception THEN
2213: RETURN FALSE;
2214: WHEN OTHERS THEN
2215: xla_exceptions_pkg.raise_message
2216: (p_location => 'xla_cmp_extract_pkg.CallExtractIntegrityChecker ');
2217: END CallExtractIntegrityChecker;
2218: --
2219: --
2220: --+==========================================================================+

Line 2370: (p_location => 'xla_cmp_extract_pkg.GenerateLineStructure ');

2366: WHEN xla_exceptions_pkg.application_exception THEN
2367: RETURN NULL;
2368: WHEN OTHERS THEN
2369: xla_exceptions_pkg.raise_message
2370: (p_location => 'xla_cmp_extract_pkg.GenerateLineStructure ');
2371: END GenerateLineStructure;
2372: --
2373: --
2374: --+==========================================================================+

Line 2468: (p_location => 'xla_cmp_extract_pkg.GenerateHdrVariables ');

2464: WHEN xla_exceptions_pkg.application_exception THEN
2465: RETURN NULL;
2466: WHEN OTHERS THEN
2467: xla_exceptions_pkg.raise_message
2468: (p_location => 'xla_cmp_extract_pkg.GenerateHdrVariables ');
2469: END GenerateHdrVariables;
2470: --
2471: --
2472: --+==========================================================================+

Line 2580: (p_location => 'xla_cmp_extract_pkg.GenerateFetchHeaderCursor ');

2576: WHEN xla_exceptions_pkg.application_exception THEN
2577: RETURN NULL;
2578: WHEN OTHERS THEN
2579: xla_exceptions_pkg.raise_message
2580: (p_location => 'xla_cmp_extract_pkg.GenerateFetchHeaderCursor ');
2581: END GenerateFetchHeaderCursor;
2582: --
2583: --
2584: --+==========================================================================+

Line 2702: (p_location => 'xla_cmp_extract_pkg.GenerateLineVariables ');

2698: WHEN xla_exceptions_pkg.application_exception THEN
2699: RETURN NULL;
2700: WHEN OTHERS THEN
2701: xla_exceptions_pkg.raise_message
2702: (p_location => 'xla_cmp_extract_pkg.GenerateLineVariables ');
2703: END GenerateLineVariables;
2704: --
2705: --
2706: --+==========================================================================+

Line 2823: (p_location => 'xla_cmp_extract_pkg.GenerateFetchLineCursor ');

2819: WHEN xla_exceptions_pkg.application_exception THEN
2820: RETURN NULL;
2821: WHEN OTHERS THEN
2822: xla_exceptions_pkg.raise_message
2823: (p_location => 'xla_cmp_extract_pkg.GenerateFetchLineCursor ');
2824: END GenerateFetchLineCursor;
2825: --
2826: --+==========================================================================+
2827: --| |

Line 2895: (p_location => 'xla_cmp_extract_pkg.GetUsedExtractObject ');

2891: WHEN xla_exceptions_pkg.application_exception THEN
2892: RAISE;
2893: WHEN OTHERS THEN
2894: xla_exceptions_pkg.raise_message
2895: (p_location => 'xla_cmp_extract_pkg.GetUsedExtractObject ');
2896: END GetUsedExtractObject;
2897: --
2898: --
2899: --+==========================================================================+

Line 2995: (p_location => 'xla_cmp_extract_pkg.GenerateExtractColumns ');

2991: WHEN xla_exceptions_pkg.application_exception THEN
2992: RETURN NULL;
2993: WHEN OTHERS THEN
2994: xla_exceptions_pkg.raise_message
2995: (p_location => 'xla_cmp_extract_pkg.GenerateExtractColumns ');
2996: END GenerateExtractColumns;
2997: --
2998: --+==========================================================================+
2999: --| |

Line 3073: (p_location => 'xla_cmp_extract_pkg.GenerateLookupTables ');

3069: WHEN xla_exceptions_pkg.application_exception THEN
3070: RETURN NULL;
3071: WHEN OTHERS THEN
3072: xla_exceptions_pkg.raise_message
3073: (p_location => 'xla_cmp_extract_pkg.GenerateLookupTables ');
3074: END GenerateLookupTables;
3075: --
3076: --
3077: --+==========================================================================+

Line 3168: (p_location => 'xla_cmp_extract_pkg.GenerateLookupClauses ');

3164: WHEN xla_exceptions_pkg.application_exception THEN
3165: RETURN NULL;
3166: WHEN OTHERS THEN
3167: xla_exceptions_pkg.raise_message
3168: (p_location => 'xla_cmp_extract_pkg.GenerateLookupClauses ');
3169: END GenerateLookupClauses;
3170: --
3171: --+==========================================================================+
3172: --| |

Line 3238: (p_location => 'xla_cmp_extract_pkg.GetAnAlwaysPopulatedObject ');

3234: WHEN xla_exceptions_pkg.application_exception THEN
3235: RAISE;
3236: WHEN OTHERS THEN
3237: xla_exceptions_pkg.raise_message
3238: (p_location => 'xla_cmp_extract_pkg.GetAnAlwaysPopulatedObject ');
3239: END GetAnAlwaysPopulatedObject;
3240:
3241: --+==========================================================================+
3242: --| |

Line 3625: (p_location => 'xla_cmp_extract_pkg.GenerateHeaderCursor');

3621: WHEN xla_exceptions_pkg.application_exception THEN
3622: RETURN NULL;
3623: WHEN OTHERS THEN
3624: xla_exceptions_pkg.raise_message
3625: (p_location => 'xla_cmp_extract_pkg.GenerateHeaderCursor');
3626: END GenerateHeaderCursor;
3627: --
3628: --+==========================================================================+
3629: --| |

Line 4099: (p_location => 'xla_cmp_extract_pkg.GenerateLineCursor ');

4095: WHEN xla_exceptions_pkg.application_exception THEN
4096: RETURN NULL;
4097: WHEN OTHERS THEN
4098: xla_exceptions_pkg.raise_message
4099: (p_location => 'xla_cmp_extract_pkg.GenerateLineCursor ');
4100: END GenerateLineCursor;
4101: --
4102: --
4103: --+==========================================================================+

Line 4186: (p_location => 'xla_cmp_extract_pkg.GenerateHdrStructure ');

4182: WHEN xla_exceptions_pkg.application_exception THEN
4183: RETURN NULL;
4184: WHEN OTHERS THEN
4185: xla_exceptions_pkg.raise_message
4186: (p_location => 'xla_cmp_extract_pkg.GenerateHdrStructure ');
4187: END GenerateHdrStructure;
4188: --
4189: --
4190: --+==========================================================================+

Line 4311: (p_location => 'xla_cmp_extract_pkg.GenerateCacheHdrSources');

4307: WHEN xla_exceptions_pkg.application_exception THEN
4308: RETURN NULL;
4309: WHEN OTHERS THEN
4310: xla_exceptions_pkg.raise_message
4311: (p_location => 'xla_cmp_extract_pkg.GenerateCacheHdrSources');
4312: END GenerateCacheHdrSources;
4313: --
4314: --===========================================================================
4315: --

Line 4526: (p_location => 'xla_cmp_extract_pkg.GenerateFromHdrTabs ');

4522: WHEN xla_exceptions_pkg.application_exception THEN
4523: RETURN NULL;
4524: WHEN OTHERS THEN
4525: xla_exceptions_pkg.raise_message
4526: (p_location => 'xla_cmp_extract_pkg.GenerateFromHdrTabs ');
4527: END GenerateFromHdrTabs;
4528: --
4529: --
4530: --+==========================================================================+

Line 4880: (p_location => 'xla_cmp_extract_pkg.GenerateHdrWhereClause ');

4876: WHEN xla_exceptions_pkg.application_exception THEN
4877: RETURN NULL;
4878: WHEN OTHERS THEN
4879: xla_exceptions_pkg.raise_message
4880: (p_location => 'xla_cmp_extract_pkg.GenerateHdrWhereClause ');
4881: END GenerateHdrWhereClause;
4882: --
4883: --+==========================================================================+
4884: --| |

Line 5060: (p_location => 'xla_cmp_extract_pkg.GenerateFromLineTabs ');

5056: WHEN xla_exceptions_pkg.application_exception THEN
5057: RETURN NULL;
5058: WHEN OTHERS THEN
5059: xla_exceptions_pkg.raise_message
5060: (p_location => 'xla_cmp_extract_pkg.GenerateFromLineTabs ');
5061: END GenerateFromLineTabs;
5062: --
5063: --+==========================================================================+
5064: --| |

Line 5440: (p_location => 'xla_cmp_extract_pkg.GenerateLineWhereClause ');

5436: WHEN xla_exceptions_pkg.application_exception THEN
5437: RETURN NULL;
5438: WHEN OTHERS THEN
5439: xla_exceptions_pkg.raise_message
5440: (p_location => 'xla_cmp_extract_pkg.GenerateLineWhereClause ');
5441: END GenerateLineWhereClause;
5442: --
5443: --
5444: --+==========================================================================+

Line 5728: (p_location => 'xla_cmp_extract_pkg.GenerateInsertStm ');

5724: WHEN xla_exceptions_pkg.application_exception THEN
5725: RETURN NULL;
5726: WHEN OTHERS THEN
5727: xla_exceptions_pkg.raise_message
5728: (p_location => 'xla_cmp_extract_pkg.GenerateInsertStm ');
5729: END GenerateInsertStm;
5730: --
5731: --+==========================================================================+
5732: --| |

Line 5930: (p_location => 'xla_cmp_extract_pkg.GenerateInsertHdrSources ');

5926: WHEN xla_exceptions_pkg.application_exception THEN
5927: RAISE;
5928: WHEN OTHERS THEN
5929: xla_exceptions_pkg.raise_message
5930: (p_location => 'xla_cmp_extract_pkg.GenerateInsertHdrSources ');
5931: END GenerateInsertHdrSources;
5932:
5933: --+==========================================================================+
5934: --| |

Line 6125: (p_location => 'xla_cmp_extract_pkg.GenerateInsertLineSources ');

6121: WHEN xla_exceptions_pkg.application_exception THEN
6122: RAISE;
6123: WHEN OTHERS THEN
6124: xla_exceptions_pkg.raise_message
6125: (p_location => 'xla_cmp_extract_pkg.GenerateInsertLineSources ');
6126: END GenerateInsertLineSources;
6127:
6128:
6129:

Line 6172: END xla_cmp_extract_pkg;

6168: IF NOT g_log_enabled THEN
6169: g_log_level := C_LEVEL_LOG_DISABLED;
6170: END IF;
6171: --
6172: END xla_cmp_extract_pkg;