DBA Data[Home] [Help]

APPS.FA_STANDARD_DDL_PKG dependencies on STANDARD

Line 1: PACKAGE BODY FA_STANDARD_DDL_PKG as

1: PACKAGE BODY FA_STANDARD_DDL_PKG as
2: /* $Header: faxsddlb.pls 120.4 2005/07/25 09:58:33 yyoon ship $ */
3:
4: procedure create_sequence(X_name varchar2,
5: X_start_num number,

Line 67: fa_standard_pkg.raise_error(

63: and sequence_owner = l_schema;
64:
65: if (L_chkLastNumber <> X_start_num) then
66: -- Error while creating the sequence
67: fa_standard_pkg.raise_error(
68: CALLED_FN => 'fa_standard_pkg.create_sequence',
69: CALLING_FN => X_Calling_Fn,
70: NAME => 'FA_SHARED_FATAL_ERROR'
71: ,p_log_level_rec => p_log_level_rec);

Line 68: CALLED_FN => 'fa_standard_pkg.create_sequence',

64:
65: if (L_chkLastNumber <> X_start_num) then
66: -- Error while creating the sequence
67: fa_standard_pkg.raise_error(
68: CALLED_FN => 'fa_standard_pkg.create_sequence',
69: CALLING_FN => X_Calling_Fn,
70: NAME => 'FA_SHARED_FATAL_ERROR'
71: ,p_log_level_rec => p_log_level_rec);
72: end if;

Line 76: fa_standard_pkg.raise_error(

72: end if;
73:
74: exception
75: when schema_err then
76: fa_standard_pkg.raise_error(
77: CALLED_FN => 'fa_standard_pkg.create_sequence',
78: CALLING_FN => X_Calling_Fn
79: ,p_log_level_rec => p_log_level_rec);
80: when others then

Line 77: CALLED_FN => 'fa_standard_pkg.create_sequence',

73:
74: exception
75: when schema_err then
76: fa_standard_pkg.raise_error(
77: CALLED_FN => 'fa_standard_pkg.create_sequence',
78: CALLING_FN => X_Calling_Fn
79: ,p_log_level_rec => p_log_level_rec);
80: when others then
81: fa_standard_pkg.raise_error(

Line 81: fa_standard_pkg.raise_error(

77: CALLED_FN => 'fa_standard_pkg.create_sequence',
78: CALLING_FN => X_Calling_Fn
79: ,p_log_level_rec => p_log_level_rec);
80: when others then
81: fa_standard_pkg.raise_error(
82: CALLED_FN => 'fa_standard_pkg.create_sequence',
83: CALLING_FN => X_Calling_Fn
84: ,p_log_level_rec => p_log_level_rec);
85: end create_sequence;

Line 82: CALLED_FN => 'fa_standard_pkg.create_sequence',

78: CALLING_FN => X_Calling_Fn
79: ,p_log_level_rec => p_log_level_rec);
80: when others then
81: fa_standard_pkg.raise_error(
82: CALLED_FN => 'fa_standard_pkg.create_sequence',
83: CALLING_FN => X_Calling_Fn
84: ,p_log_level_rec => p_log_level_rec);
85: end create_sequence;
86:

Line 87: END FA_STANDARD_DDL_PKG;

83: CALLING_FN => X_Calling_Fn
84: ,p_log_level_rec => p_log_level_rec);
85: end create_sequence;
86:
87: END FA_STANDARD_DDL_PKG;