DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on XLA_TRANSFER_PKG

Line 1: PACKAGE BODY XLA_TRANSFER_PKG AS

1: PACKAGE BODY XLA_TRANSFER_PKG AS
2: /* $Header: xlaaptrn.pkb 120.63.12010000.9 2009/01/15 13:23:42 nmsubram ship $ */
3: /*==========================================================================+
4: | Copyright (c) 2003 Oracle Corporation Belmont, California, USA |
5: | ALL rights reserved. |

Line 88: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_transfer_pkg';

84: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
85: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
86: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
87: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
88: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_transfer_pkg';
89:
90: -- PLSQL Data Types
91:
92: TYPE t_array_ids IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 297: (p_location => 'xla_transfer_pkg.get_gllezl_status');

293: WHEN xla_exceptions_pkg.application_exception THEN
294: RAISE;
295: WHEN OTHERS THEN
296: xla_exceptions_pkg.raise_message
297: (p_location => 'xla_transfer_pkg.get_gllezl_status');
298: END get_gllezl_status;
299:
300:
301:

Line 363: (p_location => 'xla_transfer_pkg.get_gllezl_status');

359: RAISE;
360: WHEN OTHERS THEN
361: trace('Insert into the GL_INTERFACE_CONTROL failed',C_LEVEL_UNEXPECTED,l_Log_module);
362: xla_exceptions_pkg.raise_message
363: (p_location => 'xla_transfer_pkg.get_gllezl_status');
364:
365: END insert_interface_control;
366: /*===========================================================================+
367: PROCEDURE

Line 446: (p_location => 'xla_transfer_pkg.insert_transfer_log');

442: WHEN xla_exceptions_pkg.application_exception THEN
443: RAISE;
444: WHEN OTHERS THEN
445: xla_exceptions_pkg.raise_message
446: (p_location => 'xla_transfer_pkg.insert_transfer_log');
447: END insert_transfer_log;
448:
449:
450: /*===========================================================================+

Line 564: (p_location => 'xla_transfer_pkg.submit_journal_import');

560: WHEN xla_exceptions_pkg.application_exception THEN
561: RAISE;
562: WHEN OTHERS THEN
563: xla_exceptions_pkg.raise_message
564: (p_location => 'xla_transfer_pkg.submit_journal_import');
565: END submit_journal_import;
566:
567:
568: /*====================================================================

Line 690: (p_location => 'xla_transfer_pkg.get_ledgers');

686: WHEN xla_exceptions_pkg.application_exception THEN
687: RAISE;
688: WHEN OTHERS THEN
689: xla_exceptions_pkg.raise_message
690: (p_location => 'xla_transfer_pkg.get_ledgers');
691: END get_ledgers;
692:
693: /*===========================================================================+
694: | PROCEDURE |

Line 791: (p_location => 'xla_transfer_pkg.get_ledger_options');

787: EXCEPTION
788: WHEN OTHERS THEN
789: trace('Error deriving subledger options for the ledger',C_LEVEL_UNEXPECTED,l_Log_module);
790: xla_exceptions_pkg.raise_message
791: (p_location => 'xla_transfer_pkg.get_ledger_options');
792: END get_ledger_options;
793:
794: /*====================================================================
795: Populate ALC ledgers

Line 823: (p_location => 'xla_transfer_pkg.get_alc_ledgers');

819: IF (C_LEVEL_UNEXPECTED >= g_log_level) THEN
820: trace('Error assigning ALC ledgers',C_LEVEL_UNEXPECTED,l_Log_module);
821: END IF;
822: xla_exceptions_pkg.raise_message
823: (p_location => 'xla_transfer_pkg.get_alc_ledgers');
824: END get_alc_ledgers;
825:
826: /*===========================================================================+
827: | PROCEDURE |

Line 930: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'

926: xla_exceptions_pkg.raise_message
927: (p_appli_s_name => 'XLA'
928: ,p_msg_name => 'XLA_COMMON_ERROR'
929: ,p_token_1 => 'LOCATION'
930: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'
931: ,p_token_2 => 'ERROR'
932: ,p_value_2 => 'Transfer mode must be either Standalone or Combined');
933:
934: WHEN g_caller IN (C_TP_MERGE,C_MPA_COMPLETE)

Line 945: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'

941: xla_exceptions_pkg.raise_message
942: (p_appli_s_name => 'XLA'
943: ,p_msg_name => 'XLA_COMMON_ERROR'
944: ,p_token_1 => 'LOCATION'
945: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'
946: ,p_token_2 => 'ERROR'
947: ,p_value_2 => 'Accounting batch identifier must be specified.');
948:
949: WHEN g_caller IN (C_ACCTPROG_DOCUMENT)

Line 960: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'

956: xla_exceptions_pkg.raise_message
957: (p_appli_s_name => 'XLA'
958: ,p_msg_name => 'XLA_COMMON_ERROR'
959: ,p_token_1 => 'LOCATION'
960: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'
961: ,p_token_2 => 'ERROR'
962: ,p_value_2 => 'Entity identifier must be specified.');
963:
964: WHEN g_transfer_mode = 'STANDALONE'

Line 975: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'

971: xla_exceptions_pkg.raise_message
972: (p_appli_s_name => 'XLA'
973: ,p_msg_name => 'XLA_COMMON_ERROR'
974: ,p_token_1 => 'LOCATION'
975: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'
976: ,p_token_2 => 'ERROR'
977: ,p_value_2 => 'End date must be specified for batch accounting in Standalone mode');
978:
979: ELSE

Line 991: (p_location => 'xla_transfer_pkg.validate_input_parameters');

987: WHEN xla_exceptions_pkg.application_exception THEN
988: RAISE;
989: WHEN OTHERS THEN
990: xla_exceptions_pkg.raise_message
991: (p_location => 'xla_transfer_pkg.validate_input_parameters');
992: END validate_input_parameters;
993:
994:
995: /*===========================================================================+

Line 1133: (p_location => 'xla_transfer_pkg.recover_batch');

1129: END IF;
1130: RAISE;
1131: WHEN OTHERS THEN
1132: xla_exceptions_pkg.raise_message
1133: (p_location => 'xla_transfer_pkg.recover_batch');
1134: END recover_batch;
1135:
1136: /*====================================================================
1137: * Perform period VALIDATION IF GL IS Installed AND THE transfer IS *

Line 1850: (p_location => 'xla_transfer_pkg.select_journal_entries');

1846: END IF;
1847: RAISE;
1848: WHEN OTHERS THEN
1849: xla_exceptions_pkg.raise_message
1850: (p_location => 'xla_transfer_pkg.select_journal_entries');
1851: END select_journal_entries;
1852:
1853: /*===========================================================================+
1854: | PROCEDURE |

Line 1905: (p_location => 'xla_transfer_pkg.set_application_info');

1901: WHEN xla_exceptions_pkg.application_exception THEN
1902: RAISE;
1903: WHEN OTHERS THEN
1904: xla_exceptions_pkg.raise_message
1905: (p_location => 'xla_transfer_pkg.set_application_info');
1906: END set_application_info;
1907:
1908: /*===========================================================================+
1909: PROCEDURE

Line 2118: (p_location => 'xla_transfer_pkg.gl_interface_insert');

2114: WHEN xla_exceptions_pkg.application_exception THEN
2115: RAISE;
2116: WHEN OTHERS THEN
2117: xla_exceptions_pkg.raise_message
2118: (p_location => 'xla_transfer_pkg.gl_interface_insert');
2119: END insert_gl_interface;
2120:
2121: /*===========================================================================+
2122: PROCEDURE

Line 2283: (p_location => 'xla_transfer_pkg.wait_for_gllezl');

2279: WHEN xla_exceptions_pkg.application_exception THEN
2280: RAISE;
2281: WHEN OTHERS THEN
2282: xla_exceptions_pkg.raise_message
2283: (p_location => 'xla_transfer_pkg.wait_for_gllezl');
2284: END wait_for_gllezl;
2285:
2286: /*===========================================================================+
2287: | PROCEDURE |

Line 2333: (p_location => 'xla_transfer_pkg.set_transfer_status');

2329: END IF;
2330: EXCEPTION
2331: WHEN OTHERS THEN
2332: xla_exceptions_pkg.raise_message
2333: (p_location => 'xla_transfer_pkg.set_transfer_status');
2334: END set_transfer_status;
2335:
2336: /*===========================================================================+
2337: | PROCEDURE |

Line 2380: (p_location => 'xla_transfer_pkg.delete_transfer_log');

2376: END IF;
2377: EXCEPTION
2378: WHEN OTHERS THEN
2379: xla_exceptions_pkg.raise_message
2380: (p_location => 'xla_transfer_pkg.delete_transfer_log');
2381: END delete_transfer_log;
2382:
2383: /*===========================================================================+
2384: | PROCEDURE |

Line 2445: (p_location => 'xla_transfer_pkg.insert_secondary_ledgers');

2441: );
2442: EXCEPTION
2443: WHEN OTHERS THEN
2444: xla_exceptions_pkg.raise_message
2445: (p_location => 'xla_transfer_pkg.insert_secondary_ledgers');
2446: END insert_secondary_ledgers;
2447:
2448: /*===========================================================================+
2449: | PROCEDURE |

Line 2546: (p_location => 'xla_transfer_pkg.complete_batch');

2542: WHEN xla_exceptions_pkg.application_exception THEN
2543: RAISE;
2544: WHEN OTHERS THEN
2545: xla_exceptions_pkg.raise_message
2546: (p_location => 'xla_transfer_pkg.complete_batch');
2547: END complete_batch;
2548:
2549: /*===========================================================================+
2550: | FUNCTION |

Line 2647: (p_location => 'xla_transfer_pkg.is_report_defn_found');

2643: WHEN xla_exceptions_pkg.application_exception THEN
2644: RAISE;
2645: WHEN OTHERS THEN
2646: xla_exceptions_pkg.raise_message
2647: (p_location => 'xla_transfer_pkg.is_report_defn_found');
2648: END is_report_defn_found;
2649:
2650: /*===========================================================================+
2651: | PROCEDURE |

Line 3054: (p_location => 'xla_transfer_pkg.gl_transfer_main');

3050: WHEN xla_exceptions_pkg.application_exception THEN
3051: RAISE;
3052: WHEN OTHERS THEN
3053: xla_exceptions_pkg.raise_message
3054: (p_location => 'xla_transfer_pkg.gl_transfer_main');
3055: END GL_TRANSFER_MAIN;
3056:
3057: BEGIN
3058: -- l_log_module := C_DEFAULT_MODULE;

Line 3067: END XLA_TRANSFER_PKG;

3063:
3064: IF NOT g_log_enabled THEN
3065: g_log_level := C_LEVEL_LOG_DISABLED;
3066: END IF;
3067: END XLA_TRANSFER_PKG;