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.92.12020000.2 2012/08/16 05:37:25 sragadde ship $ */
3: /*==========================================================================+
4: | Copyright (c) 2003 Oracle Corporation Belmont, California, USA |
5: | ALL rights reserved. |

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

101: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
102: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
103: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
104: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
105: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_transfer_pkg';
106:
107: --Added for bug 11855000 Start
108: -------------------------------------------------------------------------------
109: -- forward declarion of private procedures and functions

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

367: WHEN xla_exceptions_pkg.application_exception THEN
368: RAISE;
369: WHEN OTHERS THEN
370: xla_exceptions_pkg.raise_message
371: (p_location => 'xla_transfer_pkg.get_gllezl_status');
372: END get_gllezl_status;
373:
374: --Added for bug 11855000 Start
375: /*----------------------------------------------------------------------

Line 727: (p_location => 'xla_transfer_pkg.reserve_funds');

723: END IF;
724: RAISE;
725: WHEN OTHERS THEN
726: xla_exceptions_pkg.raise_message
727: (p_location => 'xla_transfer_pkg.reserve_funds');
728: END reserve_funds;
729:
730: --Added for bug 11855000 End
731:

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

795: RAISE;
796: WHEN OTHERS THEN
797: trace('Insert into the GL_INTERFACE_CONTROL failed',C_LEVEL_UNEXPECTED,l_Log_module);
798: xla_exceptions_pkg.raise_message
799: (p_location => 'xla_transfer_pkg.get_gllezl_status');
800:
801: END insert_interface_control;
802: /*===========================================================================+
803: PROCEDURE

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

878: WHEN xla_exceptions_pkg.application_exception THEN
879: RAISE;
880: WHEN OTHERS THEN
881: xla_exceptions_pkg.raise_message
882: (p_location => 'xla_transfer_pkg.insert_transfer_log');
883: END insert_transfer_log;
884:
885:
886: /*===========================================================================+

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

996: WHEN xla_exceptions_pkg.application_exception THEN
997: RAISE;
998: WHEN OTHERS THEN
999: xla_exceptions_pkg.raise_message
1000: (p_location => 'xla_transfer_pkg.submit_journal_import');
1001: END submit_journal_import;
1002:
1003:
1004: /*====================================================================

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

1122: WHEN xla_exceptions_pkg.application_exception THEN
1123: RAISE;
1124: WHEN OTHERS THEN
1125: xla_exceptions_pkg.raise_message
1126: (p_location => 'xla_transfer_pkg.get_ledgers');
1127: END get_ledgers;
1128:
1129: /*===========================================================================+
1130: | PROCEDURE |

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

1231: EXCEPTION
1232: WHEN OTHERS THEN
1233: trace('Error deriving subledger options for the ledger',C_LEVEL_UNEXPECTED,l_Log_module);
1234: xla_exceptions_pkg.raise_message
1235: (p_location => 'xla_transfer_pkg.get_ledger_options');
1236: END get_ledger_options;
1237:
1238: /*====================================================================
1239: Populate ALC ledgers

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

1263: IF (C_LEVEL_UNEXPECTED >= g_log_level) THEN
1264: trace('Error assigning ALC ledgers',C_LEVEL_UNEXPECTED,l_Log_module);
1265: END IF;
1266: xla_exceptions_pkg.raise_message
1267: (p_location => 'xla_transfer_pkg.get_alc_ledgers');
1268: END get_alc_ledgers;
1269:
1270: /*===========================================================================+
1271: | PROCEDURE |

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

1380: xla_exceptions_pkg.raise_message
1381: (p_appli_s_name => 'XLA'
1382: ,p_msg_name => 'XLA_COMMON_ERROR'
1383: ,p_token_1 => 'LOCATION'
1384: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'
1385: ,p_token_2 => 'ERROR'
1386: ,p_value_2 => 'Transfer mode must be either Standalone or Combined');
1387:
1388: WHEN g_caller IN (C_TP_MERGE,C_MPA_COMPLETE)

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

1395: xla_exceptions_pkg.raise_message
1396: (p_appli_s_name => 'XLA'
1397: ,p_msg_name => 'XLA_COMMON_ERROR'
1398: ,p_token_1 => 'LOCATION'
1399: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'
1400: ,p_token_2 => 'ERROR'
1401: ,p_value_2 => 'Accounting batch identifier must be specified.');
1402:
1403: WHEN g_caller IN (C_ACCTPROG_DOCUMENT)

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

1410: xla_exceptions_pkg.raise_message
1411: (p_appli_s_name => 'XLA'
1412: ,p_msg_name => 'XLA_COMMON_ERROR'
1413: ,p_token_1 => 'LOCATION'
1414: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'
1415: ,p_token_2 => 'ERROR'
1416: ,p_value_2 => 'Entity identifier must be specified.');
1417:
1418: WHEN g_transfer_mode = 'STANDALONE'

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

1425: xla_exceptions_pkg.raise_message
1426: (p_appli_s_name => 'XLA'
1427: ,p_msg_name => 'XLA_COMMON_ERROR'
1428: ,p_token_1 => 'LOCATION'
1429: ,p_value_1 => 'xla_transfer_pkg.validate_input_parameters'
1430: ,p_token_2 => 'ERROR'
1431: ,p_value_2 => 'End date must be specified for batch accounting in Standalone mode');
1432:
1433: ELSE

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

1441: WHEN xla_exceptions_pkg.application_exception THEN
1442: RAISE;
1443: WHEN OTHERS THEN
1444: xla_exceptions_pkg.raise_message
1445: (p_location => 'xla_transfer_pkg.validate_input_parameters');
1446: END validate_input_parameters;
1447:
1448:
1449: /*===========================================================================+

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

1666: END IF;
1667: RAISE;
1668: WHEN OTHERS THEN
1669: xla_exceptions_pkg.raise_message
1670: (p_location => 'xla_transfer_pkg.recover_batch');
1671: END recover_batch;
1672:
1673: /*====================================================================
1674: * Perform period VALIDATION IF GL IS Installed AND THE transfer IS *

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

2485: END IF;
2486: RAISE;
2487: WHEN OTHERS THEN
2488: xla_exceptions_pkg.raise_message
2489: (p_location => 'xla_transfer_pkg.select_journal_entries');
2490: END select_journal_entries;
2491:
2492: /*===========================================================================+
2493: | PROCEDURE |

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

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

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

2786: WHEN xla_exceptions_pkg.application_exception THEN
2787: RAISE;
2788: WHEN OTHERS THEN
2789: xla_exceptions_pkg.raise_message
2790: (p_location => 'xla_transfer_pkg.gl_interface_insert');
2791: END insert_gl_interface;
2792:
2793: /*===========================================================================+
2794: PROCEDURE

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

2983: WHEN xla_exceptions_pkg.application_exception THEN
2984: RAISE;
2985: WHEN OTHERS THEN
2986: xla_exceptions_pkg.raise_message
2987: (p_location => 'xla_transfer_pkg.wait_for_gllezl');
2988: END wait_for_gllezl;
2989:
2990: /*===========================================================================+
2991: | PROCEDURE |

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

3036: END IF;
3037: EXCEPTION
3038: WHEN OTHERS THEN
3039: xla_exceptions_pkg.raise_message
3040: (p_location => 'xla_transfer_pkg.set_transfer_status');
3041: END set_transfer_status;
3042:
3043: /*===========================================================================+
3044: | PROCEDURE |

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

3083: END IF;
3084: EXCEPTION
3085: WHEN OTHERS THEN
3086: xla_exceptions_pkg.raise_message
3087: (p_location => 'xla_transfer_pkg.delete_transfer_log');
3088: END delete_transfer_log;
3089:
3090: /*===========================================================================+
3091: | PROCEDURE |

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

3148: );
3149: EXCEPTION
3150: WHEN OTHERS THEN
3151: xla_exceptions_pkg.raise_message
3152: (p_location => 'xla_transfer_pkg.insert_secondary_ledgers');
3153: END insert_secondary_ledgers;
3154:
3155: /*===========================================================================+
3156: | PROCEDURE |

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

3282: WHEN xla_exceptions_pkg.application_exception THEN
3283: RAISE;
3284: WHEN OTHERS THEN
3285: xla_exceptions_pkg.raise_message
3286: (p_location => 'xla_transfer_pkg.complete_batch');
3287: END complete_batch;
3288:
3289: /*===========================================================================+
3290: | FUNCTION |

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

3383: WHEN xla_exceptions_pkg.application_exception THEN
3384: RAISE;
3385: WHEN OTHERS THEN
3386: xla_exceptions_pkg.raise_message
3387: (p_location => 'xla_transfer_pkg.is_report_defn_found');
3388: END is_report_defn_found;
3389:
3390: /*===========================================================================+
3391: | PROCEDURE |

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

3937: WHEN xla_exceptions_pkg.application_exception THEN
3938: RAISE;
3939: WHEN OTHERS THEN
3940: xla_exceptions_pkg.raise_message
3941: (p_location => 'xla_transfer_pkg.gl_transfer_main');
3942: END GL_TRANSFER_MAIN;
3943:
3944: BEGIN
3945: -- l_log_module := C_DEFAULT_MODULE;

Line 3954: END XLA_TRANSFER_PKG;

3950:
3951: IF NOT g_log_enabled THEN
3952: g_log_level := C_LEVEL_LOG_DISABLED;
3953: END IF;
3954: END XLA_TRANSFER_PKG;