eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ITG_SYNCEXCHINBOUND_PVT dependencies on ITG_DEBUG

Line 39: itg_debug_pub.Add('Entering - GCC :Getting GL currency code' ,2);

35: IS
36: l_currency_code VARCHAR2(15);
37: BEGIN
38: IF (l_Debug_Level <= 2) THEN
39: itg_debug_pub.Add('Entering - GCC :Getting GL currency code' ,2);
40: END IF;
41:
42: BEGIN
43: SELECT currency_code

Line 49: itg_debug_pub.Add('GCC - l_currency_code'||l_currency_code ,1);

45: FROM gl_sets_of_books
46: WHERE set_of_books_id = p_sob_id;
47:
48: IF (l_Debug_Level <= 1) THEN
49: itg_debug_pub.Add('GCC - l_currency_code'||l_currency_code ,1);
50: END IF;
51:
52: EXCEPTION
53: WHEN OTHERS THEN

Line 59: itg_debug_pub.Add('Exiting - GCC :Getting GL currency code' ,2);

55: RAISE FND_API.G_EXC_ERROR;
56: END;
57:
58: IF (l_Debug_Level <= 2) THEN
59: itg_debug_pub.Add('Exiting - GCC :Getting GL currency code' ,2);
60: END IF;
61:
62: RETURN l_currency_code;
63: END;

Line 113: itg_debug_pub.Add('Entering - PER :Process_ExchangeRate' ,2);

109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: g_action := 'Exchange-rate sync';
111:
112: IF (l_Debug_Level <= 2) THEN
113: itg_debug_pub.Add('Entering - PER :Process_ExchangeRate' ,2);
114: END IF;
115:
116: BEGIN
117: SAVEPOINT Process_ExchangeRate_PVT;

Line 118: ITG_Debug.setup(

114: END IF;
115:
116: BEGIN
117: SAVEPOINT Process_ExchangeRate_PVT;
118: ITG_Debug.setup(
119: p_reset => TRUE,
120: p_pkg_name => G_PKG_NAME,
121: p_proc_name => l_api_name
122: );

Line 125: itg_debug_pub.Add('PER - Top of procedure.' ,1);

121: p_proc_name => l_api_name
122: );
123:
124: IF (l_Debug_Level <= 1) THEN
125: itg_debug_pub.Add('PER - Top of procedure.' ,1);
126: itg_debug_pub.Add('PER - p_syncind' ||p_syncind ,1);
127: itg_debug_pub.Add('PER - p_quantity' ||p_quantity ,1);
128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);
129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);

Line 126: itg_debug_pub.Add('PER - p_syncind' ||p_syncind ,1);

122: );
123:
124: IF (l_Debug_Level <= 1) THEN
125: itg_debug_pub.Add('PER - Top of procedure.' ,1);
126: itg_debug_pub.Add('PER - p_syncind' ||p_syncind ,1);
127: itg_debug_pub.Add('PER - p_quantity' ||p_quantity ,1);
128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);
129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);
130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);

Line 127: itg_debug_pub.Add('PER - p_quantity' ||p_quantity ,1);

123:
124: IF (l_Debug_Level <= 1) THEN
125: itg_debug_pub.Add('PER - Top of procedure.' ,1);
126: itg_debug_pub.Add('PER - p_syncind' ||p_syncind ,1);
127: itg_debug_pub.Add('PER - p_quantity' ||p_quantity ,1);
128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);
129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);
130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);
131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);

Line 128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);

124: IF (l_Debug_Level <= 1) THEN
125: itg_debug_pub.Add('PER - Top of procedure.' ,1);
126: itg_debug_pub.Add('PER - p_syncind' ||p_syncind ,1);
127: itg_debug_pub.Add('PER - p_quantity' ||p_quantity ,1);
128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);
129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);
130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);
131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);
132: itg_debug_pub.Add('PER - p_ratetype' ||p_ratetype ,1);

Line 129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);

125: itg_debug_pub.Add('PER - Top of procedure.' ,1);
126: itg_debug_pub.Add('PER - p_syncind' ||p_syncind ,1);
127: itg_debug_pub.Add('PER - p_quantity' ||p_quantity ,1);
128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);
129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);
130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);
131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);
132: itg_debug_pub.Add('PER - p_ratetype' ||p_ratetype ,1);
133: itg_debug_pub.Add('PER - p_creation_date' ||p_creation_date ,1);

Line 130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);

126: itg_debug_pub.Add('PER - p_syncind' ||p_syncind ,1);
127: itg_debug_pub.Add('PER - p_quantity' ||p_quantity ,1);
128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);
129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);
130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);
131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);
132: itg_debug_pub.Add('PER - p_ratetype' ||p_ratetype ,1);
133: itg_debug_pub.Add('PER - p_creation_date' ||p_creation_date ,1);
134: itg_debug_pub.Add('PER - p_effective_date' ||p_effective_date ,1);

Line 131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);

127: itg_debug_pub.Add('PER - p_quantity' ||p_quantity ,1);
128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);
129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);
130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);
131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);
132: itg_debug_pub.Add('PER - p_ratetype' ||p_ratetype ,1);
133: itg_debug_pub.Add('PER - p_creation_date' ||p_creation_date ,1);
134: itg_debug_pub.Add('PER - p_effective_date' ||p_effective_date ,1);
135: END IF;

Line 132: itg_debug_pub.Add('PER - p_ratetype' ||p_ratetype ,1);

128: itg_debug_pub.Add('PER - p_currency_from' ||p_currency_from ,1);
129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);
130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);
131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);
132: itg_debug_pub.Add('PER - p_ratetype' ||p_ratetype ,1);
133: itg_debug_pub.Add('PER - p_creation_date' ||p_creation_date ,1);
134: itg_debug_pub.Add('PER - p_effective_date' ||p_effective_date ,1);
135: END IF;
136:

Line 133: itg_debug_pub.Add('PER - p_creation_date' ||p_creation_date ,1);

129: itg_debug_pub.Add('PER - p_currency_to' ||p_currency_to ,1);
130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);
131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);
132: itg_debug_pub.Add('PER - p_ratetype' ||p_ratetype ,1);
133: itg_debug_pub.Add('PER - p_creation_date' ||p_creation_date ,1);
134: itg_debug_pub.Add('PER - p_effective_date' ||p_effective_date ,1);
135: END IF;
136:
137: g_action := 'Exchange-rate parameter validation';

Line 134: itg_debug_pub.Add('PER - p_effective_date' ||p_effective_date ,1);

130: itg_debug_pub.Add('PER - p_factor' ||p_factor ,1);
131: itg_debug_pub.Add('PER - p_sob' ||p_sob ,1);
132: itg_debug_pub.Add('PER - p_ratetype' ||p_ratetype ,1);
133: itg_debug_pub.Add('PER - p_creation_date' ||p_creation_date ,1);
134: itg_debug_pub.Add('PER - p_effective_date' ||p_effective_date ,1);
135: END IF;
136:
137: g_action := 'Exchange-rate parameter validation';
138: /* now validate data */

Line 176: itg_debug_pub.Add('PER - Checking/getting p_currency_to' ,1);

172:
173: /* validate currency: exist, enabled, date effective. not EMU to EMU. */
174: /* validate currto */
175: IF (l_Debug_Level <= 1) THEN
176: itg_debug_pub.Add('PER - Checking/getting p_currency_to' ,1);
177: END IF;
178:
179: OPEN currency_csr(p_currency_to);
180: FETCH currency_csr INTO currency_to_rec;

Line 196: itg_debug_pub.Add('PER - Checking/getting p_currency_from' ,1);

192: END IF;
193:
194:
195: IF (l_Debug_Level <= 1) THEN
196: itg_debug_pub.Add('PER - Checking/getting p_currency_from' ,1);
197: END IF;
198:
199: OPEN currency_csr(p_currency_from);
200: FETCH currency_csr INTO currency_from_rec;

Line 209: itg_debug_pub.Add('PER - Some final checks.' ,1);

205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207:
208: IF (l_Debug_Level <= 1) THEN
209: itg_debug_pub.Add('PER - Some final checks.' ,1);
210: END IF;
211:
212: IF currency_from_rec.currency_code = currency_to_rec.currency_code THEN
213: ITG_MSG.same_currency_code;

Line 231: itg_debug_pub.Add('PER - l_quantity'||l_quantity,1);

227: */
228: l_quantity := p_quantity / power(10, p_factor);
229:
230: IF (l_Debug_Level <= 1) THEN
231: itg_debug_pub.Add('PER - l_quantity'||l_quantity,1);
232: END IF;
233:
234:
235: /* round up to max precision allowed. */

Line 242: itg_debug_pub.Add('PER - Processing data.' ,1);

238: /* insert data */
239: g_action := 'Exchange-rate creation';
240:
241: IF (l_Debug_Level <= 1) THEN
242: itg_debug_pub.Add('PER - Processing data.' ,1);
243: END IF;
244:
245: IF (l_Debug_Level <= 1) THEN
246: itg_debug_pub.Add('PER - Insert into gl_daily_rates_interface' ,1);

Line 246: itg_debug_pub.Add('PER - Insert into gl_daily_rates_interface' ,1);

242: itg_debug_pub.Add('PER - Processing data.' ,1);
243: END IF;
244:
245: IF (l_Debug_Level <= 1) THEN
246: itg_debug_pub.Add('PER - Insert into gl_daily_rates_interface' ,1);
247: END IF;
248:
249: /* Set the Enable Trigger flag to TRUE "gl_crm_utilities_pkg.enable_trigger" */
250: gl_crm_utilities_pkg.change_flag(TRUE);

Line 280: itg_debug_pub.Add('PER - Check errors in gl_daily_rates_interface' ,1);

276: l_found BOOLEAN;
277:
278: BEGIN
279: IF (l_Debug_Level <= 1) THEN
280: itg_debug_pub.Add('PER - Check errors in gl_daily_rates_interface' ,1);
281: END IF;
282:
283: OPEN get_error_code;
284: FETCH get_error_code INTO l_error_code;

Line 300: itg_debug_pub.Add('EXITING - PER: Process_ExchangeRate.' ,2);

296:
297: COMMIT WORK;
298:
299: IF (l_Debug_Level <= 2) THEN
300: itg_debug_pub.Add('EXITING - PER: Process_ExchangeRate.' ,2);
301: END IF;
302: EXCEPTION
303: WHEN FND_API.G_EXC_ERROR THEN
304: ROLLBACK TO Process_ExchangeRate_PVT;

Line 312: itg_debug.msg('Unexpected error (Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);

308: WHEN OTHERS THEN
309: ROLLBACK TO Process_ExchangeRate_PVT;
310: ITG_msg.unexpected_error(g_action);
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: itg_debug.msg('Unexpected error (Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);
313: END;
314:
315:
316: -- Removed FND_MSG_PUB.Count_And_Get