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.JTF_TTY_NA_TERRGP dependencies on FND_LOG

Line 186: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

182:
183: EXCEPTION
184: WHEN OTHERS THEN
185: l_err_msg := SQLCODE || ' : ' || substr(SQLERRM, 1, 1950);
186: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
188: 'jtf.plsql.JTF_TTY_NA_TERRGP.buildTable',
189: l_err_msg);
190: END IF;

Line 187: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

183: EXCEPTION
184: WHEN OTHERS THEN
185: l_err_msg := SQLCODE || ' : ' || substr(SQLERRM, 1, 1950);
186: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
188: 'jtf.plsql.JTF_TTY_NA_TERRGP.buildTable',
189: l_err_msg);
190: END IF;
191: RAISE;

Line 214: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

210: l_acctId_tbl jtf_terr_number_list;
211:
212: BEGIN
213:
214: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
215: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
216: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
217: 'Start of the procedure JTF_TTY_NA_TERRGP.delete_bulk_TGA');
218: END IF;

Line 215: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

211:
212: BEGIN
213:
214: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
215: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
216: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
217: 'Start of the procedure JTF_TTY_NA_TERRGP.delete_bulk_TGA');
218: END IF;
219:

Line 226: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

222: l_grpAcctId_tbl := jtf_terr_number_list();
223: l_acctId_tbl := jtf_terr_number_list();
224:
225:
226: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
228: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
229: 'Building PL/SQL tables from Input Strings');
230: END IF;

Line 227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

223: l_acctId_tbl := jtf_terr_number_list();
224:
225:
226: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
228: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
229: 'Building PL/SQL tables from Input Strings');
230: END IF;
231:

Line 236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

232: buildTable(p_tga_id_str, l_grpAcctId_tbl);
233: buildTable(p_terr_gp_id_str, l_terrGrpId_tbl);
234: buildTable(p_named_acct_id_str, l_acctId_tbl);
235:
236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
238: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
239: 'Deleting from JTF_TTY... tables');
240: END IF;

Line 237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

233: buildTable(p_terr_gp_id_str, l_terrGrpId_tbl);
234: buildTable(p_named_acct_id_str, l_acctId_tbl);
235:
236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
238: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
239: 'Deleting from JTF_TTY... tables');
240: END IF;
241:

Line 268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

264: FROM JTF_TTY_NAMED_ACCTS a
265: WHERE a.named_account_id = AQM.named_account_id);
266:
267:
268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
269: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
270: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
271: 'Calling procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
272: END IF;

Line 269: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

265: WHERE a.named_account_id = AQM.named_account_id);
266:
267:
268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
269: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
270: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
271: 'Calling procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
272: END IF;
273:

Line 285: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

281:
282:
283: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
284: -- debug message
285: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
286: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
287: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
288: 'JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA API has failed');
289: END IF;

Line 286: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

282:
283: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
284: -- debug message
285: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
286: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
287: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
288: 'JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA API has failed');
289: END IF;
290:

Line 294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

290:
291: RAISE FND_API.G_EXC_ERROR;
292: END IF;
293:
294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
296: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
297: 'Returning from JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
298: END IF;

Line 295: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

291: RAISE FND_API.G_EXC_ERROR;
292: END IF;
293:
294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
296: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
297: 'Returning from JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
298: END IF;
299:

Line 302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

298: END IF;
299:
300: COMMIT;
301:
302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
304: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
305: 'End of the procedure JTF_TTY_NA_TERRGP.delete_bulk_TGA');
306: END IF;

Line 303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

299:
300: COMMIT;
301:
302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
304: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
305: 'End of the procedure JTF_TTY_NA_TERRGP.delete_bulk_TGA');
306: END IF;
307:

Line 315: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

311: WHEN OTHERS THEN
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: x_msg_data := SQLCODE || ' : ' || SQLERRM;
314: x_msg_count := 1;
315: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
316: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
317: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA.OTHERS',
318: substr(x_msg_data, 1, 4000));
319: END IF;

Line 316: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: x_msg_data := SQLCODE || ' : ' || SQLERRM;
314: x_msg_count := 1;
315: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
316: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
317: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA.OTHERS',
318: substr(x_msg_data, 1, 4000));
319: END IF;
320: