[Home] [Help]
1: PACKAGE BODY xla_source_params_f_pkg AS
2: /* $Header: xlathspm.pkb 120.1 2005/04/28 18:45:55 masada ship $ */
3:
4: --=============================================================================
5: -- *********** Local Trace Routine **********
11: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13:
14: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
15: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_source_params_f_pkg';
16:
17: g_log_level NUMBER;
18: g_log_enabled BOOLEAN;
19:
36: RAISE;
37:
38: WHEN OTHERS THEN
39: xla_exceptions_pkg.raise_message
40: (p_location => 'xla_source_params_f_pkg.trace');
41: END trace;
42:
43:
44: /*======================================================================+
393: AND source_code = p_source_code
394: AND user_sequence = p_user_sequence;
395:
396: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, NULL)) THEN
397: xla_source_params_f_pkg.update_row
398: (x_source_param_id => l_source_param_id
399: ,x_application_id => l_application_id
400: ,x_source_type_code => p_source_type_code
401: ,x_source_code => p_source_code
415: WHEN NO_DATA_FOUND THEN
416: SELECT xla_source_params_s.nextval INTO l_source_param_id
417: FROM dual;
418:
419: xla_source_params_f_pkg.insert_row
420: (x_rowid => l_rowid
421: ,x_source_param_id => l_source_param_id
422: ,x_application_id => l_application_id
423: ,x_source_type_code => p_source_type_code
446: WHEN NO_DATA_FOUND THEN
447: null;
448: WHEN OTHERS THEN
449: xla_exceptions_pkg.raise_message
450: (p_location => 'xla_source_params_f_pkg.load_row');
451:
452: END load_row;
453:
454:
468: g_log_level := C_LEVEL_LOG_DISABLED;
469: END IF;
470:
471:
472: end xla_source_params_f_pkg;