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_TERR_NAMEACC_PUB dependencies on FND_LOG

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

73: l_role_name VARCHAR2(240);
74: l_num_res_rows NUMBER := 0;
75: BEGIN
76: -- New logging guidelines
77: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
79: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl.begin',
80: 'Start of the procedure JTF_TERR_NAMEACC_PUB.Set_Winners_tbl');
81: END IF;

Line 78: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

74: l_num_res_rows NUMBER := 0;
75: BEGIN
76: -- New logging guidelines
77: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
79: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl.begin',
80: 'Start of the procedure JTF_TERR_NAMEACC_PUB.Set_Winners_tbl');
81: END IF;
82: FND_MSG_PUB.initialize;

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

111: into x_party_name
112: from HZ_PARTIES
113: where party_id = p_party_id;
114: end if;
115: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
117: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl.begin',
118: 'Initializing Input and Output records');
119: END IF;

Line 116: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

112: from HZ_PARTIES
113: where party_id = p_party_id;
114: end if;
115: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
117: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl.begin',
118: 'Initializing Input and Output records');
119: END IF;
120: -- Assign input parameters to lp_trans_Rec

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

138: --Reset the global variables
139: l_RetCode := JTF_TERRITORY_GLOBAL_PUB.Reset;
140: IF p_api_mode = 'CURRENT'
141: THEN
142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
144: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
145: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in RealTime Mode');
146: END IF;

Line 143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

139: l_RetCode := JTF_TERRITORY_GLOBAL_PUB.Reset;
140: IF p_api_mode = 'CURRENT'
141: THEN
142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
144: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
145: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in RealTime Mode');
146: END IF;
147: JTY_ASSIGN_REALTIME_PUB.get_winners(

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

160: X_msg_count => lx_msg_count,
161: X_msg_data => lx_msg_data,
162: X_winners_rec => lx_winners_rec);
163: ELSE
164: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
166: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
167: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in Date EFfective Mode');
168: END IF;

Line 165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

161: X_msg_data => lx_msg_data,
162: X_winners_rec => lx_winners_rec);
163: ELSE
164: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
166: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
167: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in Date EFfective Mode');
168: END IF;
169: JTY_ASSIGN_REALTIME_PUB.get_winners(

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

184: X_winners_rec => lx_winners_rec);
185: END IF;
186: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
187: -- debug message
188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
191: 'JTY_ASSIGN_REALTIME_PUB.get_winners API has failed');
192: END IF;

Line 189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

185: END IF;
186: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
187: -- debug message
188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
191: 'JTY_ASSIGN_REALTIME_PUB.get_winners API has failed');
192: END IF;
193: RAISE FND_API.G_EXC_ERROR;

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

191: 'JTY_ASSIGN_REALTIME_PUB.get_winners API has failed');
192: END IF;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
197: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
198: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners');
199: END IF;

Line 196: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

192: END IF;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
197: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
198: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners');
199: END IF;
200: /*

Line 300: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

296: end loop;
297: END;
298: END IF;
299: COMMIT;
300: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
301: FND_LOG.string(FND_LOG.LEVEL_EVENT,
302: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl',
303: 'Number of winning resources : ' || l_num_res_rows);
304: END IF;

Line 301: FND_LOG.string(FND_LOG.LEVEL_EVENT,

297: END;
298: END IF;
299: COMMIT;
300: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
301: FND_LOG.string(FND_LOG.LEVEL_EVENT,
302: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl',
303: 'Number of winning resources : ' || l_num_res_rows);
304: END IF;
305: -- Debug Message

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

313: ( p_count => x_msg_count,
314: p_data => x_msg_data
315: );
316: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: End ');
317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
319: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl',
320: 'End of the procedure tf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl');
321: END IF;

Line 318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

314: p_data => x_msg_data
315: );
316: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: End ');
317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
319: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl',
320: 'End of the procedure tf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl');
321: END IF;
322: EXCEPTION

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

333: x_msg_count := lx_msg_count;
334:
335: END IF;
336:
337: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
338: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
339: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl.OTHERS',
340: substr(x_msg_data, 1, 4000));
341: END IF;

Line 338: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

334:
335: END IF;
336:
337: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
338: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
339: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl.OTHERS',
340: substr(x_msg_data, 1, 4000));
341: END IF;
342: End Set_Winners_tbl;