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:
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');
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);
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);
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:
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');
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);
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);
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:
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(
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,
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,
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:
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');
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);
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);
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:
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');
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);
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);
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:
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(
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,
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,