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 JTF_TTY_NA_TERRGP

Line 1: PACKAGE BODY JTF_TTY_NA_TERRGP AS

1: PACKAGE BODY JTF_TTY_NA_TERRGP AS
2: /* $Header: jtfttgpb.pls 120.6 2006/07/07 20:55:51 mhtran ship $ */
3: -- Start of Comments
4: -- PURPOSE
5: -- Custom Assignment API

Line 188: 'jtf.plsql.JTF_TTY_NA_TERRGP.buildTable',

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;
192: END buildTable;

Line 216: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',

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:
220: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 217: 'Start of the procedure JTF_TTY_NA_TERRGP.delete_bulk_TGA');

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:
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221: l_terrGrpId_tbl := jtf_terr_number_list();

Line 228: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',

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:
232: buildTable(p_tga_id_str, l_grpAcctId_tbl);

Line 238: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',

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:
242: -- Delete Named Account Resources

Line 270: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',

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:
274: -- Deleting Territories data from the JTF_TERR.. tables

Line 287: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',

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:
291: RAISE FND_API.G_EXC_ERROR;

Line 296: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',

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:
300: COMMIT;

Line 304: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',

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:
308: EXCEPTION

Line 305: 'End of the procedure JTF_TTY_NA_TERRGP.delete_bulk_TGA');

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:
308: EXCEPTION
309: WHEN NO_DATA_FOUND THEN

Line 317: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA.OTHERS',

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:
321: END delete_bulk_TGA;

Line 2157: jtf_tty_na_terrgp.sum_rm_bin(return_status, error_message);

2153: return_status VARCHAR2(30);
2154: error_message VARCHAR2(45);
2155:
2156: BEGIN
2157: jtf_tty_na_terrgp.sum_rm_bin(return_status, error_message);
2158: /*
2159: delete jtf_tty_rsc_acct_summ;
2160:
2161: insert into jtf_tty_rsc_acct_summ(

Line 3358: end JTF_TTY_NA_TERRGP;

3354:
3355: COMMIT;
3356: END log_event;
3357:
3358: end JTF_TTY_NA_TERRGP;