DBA Data[Home] [Help]

APPS.GL_PERIOD_TYPES_PKG dependencies on FND_MESSAGE

Line 70: fnd_message.set_name('SQLGL', 'GL_DUP_USER_PERIOD_TYPE');

66: FETCH check_dups INTO dummy;
67:
68: IF check_dups%FOUND THEN
69: CLOSE check_dups;
70: fnd_message.set_name('SQLGL', 'GL_DUP_USER_PERIOD_TYPE');
71: app_exception.raise_exception;
72: END IF;
73:
74: CLOSE check_dups;

Line 78: fnd_message.set_name('SQLGL','Unhandled Exception');

74: CLOSE check_dups;
75: EXCEPTION
76: WHEN app_exception.application_exception THEN RAISE;
77: WHEN OTHERS THEN
78: fnd_message.set_name('SQLGL','Unhandled Exception');
79: fnd_message.set_token('PROCEDURE', 'Check_Unique_User_Type');
80: RAISE;
81: END Check_Unique_User_Type;
82:

Line 79: fnd_message.set_token('PROCEDURE', 'Check_Unique_User_Type');

75: EXCEPTION
76: WHEN app_exception.application_exception THEN RAISE;
77: WHEN OTHERS THEN
78: fnd_message.set_name('SQLGL','Unhandled Exception');
79: fnd_message.set_token('PROCEDURE', 'Check_Unique_User_Type');
80: RAISE;
81: END Check_Unique_User_Type;
82:
83: PROCEDURE Check_Unique_Type(x_period_type VARCHAR2,

Line 101: fnd_message.set_name('SQLGL', 'GL_DUP_UNIQUE_ID');

97: FETCH chk_dups INTO t_var;
98:
99: IF chk_dups%FOUND THEN
100: CLOSE chk_dups;
101: fnd_message.set_name('SQLGL', 'GL_DUP_UNIQUE_ID');
102: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
103: app_exception.raise_exception;
104: END IF;
105:

Line 102: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');

98:
99: IF chk_dups%FOUND THEN
100: CLOSE chk_dups;
101: fnd_message.set_name('SQLGL', 'GL_DUP_UNIQUE_ID');
102: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
103: app_exception.raise_exception;
104: END IF;
105:
106: CLOSE chk_dups;

Line 110: fnd_message.set_name('SQLGL','Unhandled Exception');

106: CLOSE chk_dups;
107: EXCEPTION
108: WHEN app_exception.application_exception THEN RAISE;
109: WHEN OTHERS THEN
110: fnd_message.set_name('SQLGL','Unhandled Exception');
111: fnd_message.set_token('PROCEDURE', 'Check_Unique_Type');
112: RAISE;
113: END Check_Unique_Type;
114:

Line 111: fnd_message.set_token('PROCEDURE', 'Check_Unique_Type');

107: EXCEPTION
108: WHEN app_exception.application_exception THEN RAISE;
109: WHEN OTHERS THEN
110: fnd_message.set_name('SQLGL','Unhandled Exception');
111: fnd_message.set_token('PROCEDURE', 'Check_Unique_Type');
112: RAISE;
113: END Check_Unique_Type;
114:
115: PROCEDURE Get_New_Id(x_period_type IN OUT NOCOPY VARCHAR2) IS

Line 123: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');

119: into x_period_type
120: from dual;
121:
122: IF (x_period_type is NULL) THEN
123: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');
124: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
125: app_exception.raise_exception;
126: END IF;
127: EXCEPTION

Line 124: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');

120: from dual;
121:
122: IF (x_period_type is NULL) THEN
123: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');
124: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
125: app_exception.raise_exception;
126: END IF;
127: EXCEPTION
128: WHEN app_exception.application_exception THEN RAISE;

Line 130: fnd_message.set_name('SQLGL','Unhandled Exception');

126: END IF;
127: EXCEPTION
128: WHEN app_exception.application_exception THEN RAISE;
129: WHEN OTHERS THEN
130: fnd_message.set_name('SQLGL','Unhandled Exception');
131: fnd_message.set_token('PROCEDURE', 'Get_New_Id');
132: RAISE;
133: END Get_New_Id;
134:

Line 131: fnd_message.set_token('PROCEDURE', 'Get_New_Id');

127: EXCEPTION
128: WHEN app_exception.application_exception THEN RAISE;
129: WHEN OTHERS THEN
130: fnd_message.set_name('SQLGL','Unhandled Exception');
131: fnd_message.set_token('PROCEDURE', 'Get_New_Id');
132: RAISE;
133: END Get_New_Id;
134:
135:

Line 198: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');

194: BEGIN
195: -- validate input parameters
196: if ( x_period_type is null) then
197:
198: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');
199: app_exception.raise_exception;
200: end if;
201:
202: if (X_OWNER = 'SEED') then