DBA Data[Home] [Help]

APPS.GL_EURO_USER_RATE_API dependencies on FND_MESSAGE

Line 126: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

122:
123: euro_code := gl_currency_api.get_euro_code;
124:
125: IF (x_relationship = 'EMU-OTHER') THEN
126: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
127: fnd_message.set_token('CURRENCY1', euro_code);
128: fnd_message.set_token('CURRENCY2', x_to_currency);
129: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
130:

Line 127: fnd_message.set_token('CURRENCY1', euro_code);

123: euro_code := gl_currency_api.get_euro_code;
124:
125: IF (x_relationship = 'EMU-OTHER') THEN
126: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
127: fnd_message.set_token('CURRENCY1', euro_code);
128: fnd_message.set_token('CURRENCY2', x_to_currency);
129: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
130:
131: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

Line 128: fnd_message.set_token('CURRENCY2', x_to_currency);

124:
125: IF (x_relationship = 'EMU-OTHER') THEN
126: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
127: fnd_message.set_token('CURRENCY1', euro_code);
128: fnd_message.set_token('CURRENCY2', x_to_currency);
129: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
130:
131: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
132: fnd_message.set_token('CURRENCY1', euro_code);

Line 129: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);

125: IF (x_relationship = 'EMU-OTHER') THEN
126: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
127: fnd_message.set_token('CURRENCY1', euro_code);
128: fnd_message.set_token('CURRENCY2', x_to_currency);
129: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
130:
131: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
132: fnd_message.set_token('CURRENCY1', euro_code);
133: fnd_message.set_token('CURRENCY2', x_from_currency);

Line 131: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

127: fnd_message.set_token('CURRENCY1', euro_code);
128: fnd_message.set_token('CURRENCY2', x_to_currency);
129: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
130:
131: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
132: fnd_message.set_token('CURRENCY1', euro_code);
133: fnd_message.set_token('CURRENCY2', x_from_currency);
134: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
135:

Line 132: fnd_message.set_token('CURRENCY1', euro_code);

128: fnd_message.set_token('CURRENCY2', x_to_currency);
129: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
130:
131: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
132: fnd_message.set_token('CURRENCY1', euro_code);
133: fnd_message.set_token('CURRENCY2', x_from_currency);
134: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
135:
136: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

Line 133: fnd_message.set_token('CURRENCY2', x_from_currency);

129: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
130:
131: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
132: fnd_message.set_token('CURRENCY1', euro_code);
133: fnd_message.set_token('CURRENCY2', x_from_currency);
134: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
135:
136: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
137: fnd_message.set_token('CURRENCY1', x_from_currency);

Line 134: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);

130:
131: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
132: fnd_message.set_token('CURRENCY1', euro_code);
133: fnd_message.set_token('CURRENCY2', x_from_currency);
134: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
135:
136: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
137: fnd_message.set_token('CURRENCY1', x_from_currency);
138: fnd_message.set_token('CURRENCY2', x_to_currency);

Line 136: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

132: fnd_message.set_token('CURRENCY1', euro_code);
133: fnd_message.set_token('CURRENCY2', x_from_currency);
134: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
135:
136: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
137: fnd_message.set_token('CURRENCY1', x_from_currency);
138: fnd_message.set_token('CURRENCY2', x_to_currency);
139: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
140:

Line 137: fnd_message.set_token('CURRENCY1', x_from_currency);

133: fnd_message.set_token('CURRENCY2', x_from_currency);
134: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
135:
136: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
137: fnd_message.set_token('CURRENCY1', x_from_currency);
138: fnd_message.set_token('CURRENCY2', x_to_currency);
139: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
140:
141: x_euro_to_emu_rate := gl_currency_api.get_rate(

Line 138: fnd_message.set_token('CURRENCY2', x_to_currency);

134: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
135:
136: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
137: fnd_message.set_token('CURRENCY1', x_from_currency);
138: fnd_message.set_token('CURRENCY2', x_to_currency);
139: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
140:
141: x_euro_to_emu_rate := gl_currency_api.get_rate(
142: euro_code,

Line 139: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);

135:
136: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
137: fnd_message.set_token('CURRENCY1', x_from_currency);
138: fnd_message.set_token('CURRENCY2', x_to_currency);
139: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
140:
141: x_euro_to_emu_rate := gl_currency_api.get_rate(
142: euro_code,
143: x_from_currency,

Line 148: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

144: trunc(x_conversion_date),
145: NULL);
146:
147: ELSIF (x_relationship = 'OTHER-EMU') THEN
148: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
149: fnd_message.set_token('CURRENCY1', x_from_currency);
150: fnd_message.set_token('CURRENCY2', euro_code);
151: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
152:

Line 149: fnd_message.set_token('CURRENCY1', x_from_currency);

145: NULL);
146:
147: ELSIF (x_relationship = 'OTHER-EMU') THEN
148: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
149: fnd_message.set_token('CURRENCY1', x_from_currency);
150: fnd_message.set_token('CURRENCY2', euro_code);
151: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
152:
153: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

Line 150: fnd_message.set_token('CURRENCY2', euro_code);

146:
147: ELSIF (x_relationship = 'OTHER-EMU') THEN
148: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
149: fnd_message.set_token('CURRENCY1', x_from_currency);
150: fnd_message.set_token('CURRENCY2', euro_code);
151: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
152:
153: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
154: fnd_message.set_token('CURRENCY1', euro_code);

Line 151: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);

147: ELSIF (x_relationship = 'OTHER-EMU') THEN
148: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
149: fnd_message.set_token('CURRENCY1', x_from_currency);
150: fnd_message.set_token('CURRENCY2', euro_code);
151: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
152:
153: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
154: fnd_message.set_token('CURRENCY1', euro_code);
155: fnd_message.set_token('CURRENCY2', x_to_currency);

Line 153: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

149: fnd_message.set_token('CURRENCY1', x_from_currency);
150: fnd_message.set_token('CURRENCY2', euro_code);
151: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
152:
153: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
154: fnd_message.set_token('CURRENCY1', euro_code);
155: fnd_message.set_token('CURRENCY2', x_to_currency);
156: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
157:

Line 154: fnd_message.set_token('CURRENCY1', euro_code);

150: fnd_message.set_token('CURRENCY2', euro_code);
151: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
152:
153: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
154: fnd_message.set_token('CURRENCY1', euro_code);
155: fnd_message.set_token('CURRENCY2', x_to_currency);
156: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
157:
158: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

Line 155: fnd_message.set_token('CURRENCY2', x_to_currency);

151: x_euro_to_other_prompt := substrb(fnd_message.get, 1, 30);
152:
153: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
154: fnd_message.set_token('CURRENCY1', euro_code);
155: fnd_message.set_token('CURRENCY2', x_to_currency);
156: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
157:
158: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
159: fnd_message.set_token('CURRENCY1', x_from_currency);

Line 156: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);

152:
153: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
154: fnd_message.set_token('CURRENCY1', euro_code);
155: fnd_message.set_token('CURRENCY2', x_to_currency);
156: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
157:
158: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
159: fnd_message.set_token('CURRENCY1', x_from_currency);
160: fnd_message.set_token('CURRENCY2', x_to_currency);

Line 158: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');

154: fnd_message.set_token('CURRENCY1', euro_code);
155: fnd_message.set_token('CURRENCY2', x_to_currency);
156: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
157:
158: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
159: fnd_message.set_token('CURRENCY1', x_from_currency);
160: fnd_message.set_token('CURRENCY2', x_to_currency);
161: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
162:

Line 159: fnd_message.set_token('CURRENCY1', x_from_currency);

155: fnd_message.set_token('CURRENCY2', x_to_currency);
156: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
157:
158: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
159: fnd_message.set_token('CURRENCY1', x_from_currency);
160: fnd_message.set_token('CURRENCY2', x_to_currency);
161: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
162:
163: x_euro_to_emu_rate := gl_currency_api.get_rate(

Line 160: fnd_message.set_token('CURRENCY2', x_to_currency);

156: x_euro_to_emu_prompt := substrb(fnd_message.get, 1, 30);
157:
158: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
159: fnd_message.set_token('CURRENCY1', x_from_currency);
160: fnd_message.set_token('CURRENCY2', x_to_currency);
161: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
162:
163: x_euro_to_emu_rate := gl_currency_api.get_rate(
164: euro_code,

Line 161: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);

157:
158: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
159: fnd_message.set_token('CURRENCY1', x_from_currency);
160: fnd_message.set_token('CURRENCY2', x_to_currency);
161: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
162:
163: x_euro_to_emu_rate := gl_currency_api.get_rate(
164: euro_code,
165: x_to_currency,