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.IEX_NOTES_PVT dependencies on IEX_DEBUG_PUB

Line 60: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: Begin');

56:
57: -- START OF BODY OF API
58: -- IF PG_DEBUG < 10 THEN
59: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
60: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: Begin');
61: END IF;
62:
63: -- IF PG_DEBUG < 10 THEN
64: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 65: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: G_USER_ID = ' || FND_GLOBAL.USER_ID);

61: END IF;
62:
63: -- IF PG_DEBUG < 10 THEN
64: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
65: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: G_USER_ID = ' || FND_GLOBAL.USER_ID);
66: END IF;
67:
68: -- IF PG_DEBUG < 10 THEN
69: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 70: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: Going thru context table');

66: END IF;
67:
68: -- IF PG_DEBUG < 10 THEN
69: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
70: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: Going thru context table');
71: END IF;
72: FOR i IN 1..p_contexts_tbl.COUNT LOOP
73: -- IF PG_DEBUG < 10 THEN
74: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 75: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: loop = ' || i);

71: END IF;
72: FOR i IN 1..p_contexts_tbl.COUNT LOOP
73: -- IF PG_DEBUG < 10 THEN
74: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
75: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: loop = ' || i);
76: END IF;
77: l_jtf_note_contexts_table(i).note_context_type := p_contexts_tbl(i).CONTEXT_TYPE;
78: l_jtf_note_contexts_table(i).note_context_type_id := p_contexts_tbl(i).CONTEXT_ID;
79: l_jtf_note_contexts_table(i).last_update_date := sysdate;

Line 86: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type);

82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;
83: l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;
84: -- IF PG_DEBUG < 10 THEN
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
86: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type);
87: END IF;
88: -- IF PG_DEBUG < 10 THEN
89: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
90: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type_id);

Line 90: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type_id);

86: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type);
87: END IF;
88: -- IF PG_DEBUG < 10 THEN
89: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
90: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type_id);
91: END IF;
92: END LOOP;
93:
94: -- IF PG_DEBUG < 10 THEN

Line 96: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: Before call to jtf_notes_pub.create_note');

92: END LOOP;
93:
94: -- IF PG_DEBUG < 10 THEN
95: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
96: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: Before call to jtf_notes_pub.create_note');
97: END IF;
98: jtf_notes_pub.create_note(
99: P_Api_Version => 1.0,
100: P_Init_Msg_List => FND_API.G_FALSE,

Line 123: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: After call to jtf_notes_pub.create_note');

119: p_note_type => p_note_type);
120:
121: -- IF PG_DEBUG < 10 THEN
122: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
123: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: After call to jtf_notes_pub.create_note');
124: END IF;
125: -- IF PG_DEBUG < 10 THEN
126: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
127: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: l_Return_Status: ' || l_Return_Status);

Line 127: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: l_Return_Status: ' || l_Return_Status);

123: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: After call to jtf_notes_pub.create_note');
124: END IF;
125: -- IF PG_DEBUG < 10 THEN
126: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
127: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: l_Return_Status: ' || l_Return_Status);
128: END IF;
129:
130: -- check for errors
131: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 140: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: End');

136:
137: -- END OF BODY OF API
138: -- IF PG_DEBUG < 10 THEN
139: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
140: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: End');
141: END IF;
142:
143: -- Standard check of p_commit.
144: IF FND_API.To_Boolean( p_commit ) THEN

Line 241: iex_debug_pub.LogMessage(l_proc_name || ':' || 'begin');

237: l_proc_name CONSTANT VARCHAR2(100) := 'GET_NOTES_SUMMARY';
238:
239: begin
240:
241: iex_debug_pub.LogMessage(l_proc_name || ':' || 'begin');
242:
243: l_fnd_user_id := p_user_id;
244: l_object_code := p_object_code;
245: l_object_id := p_object_id;

Line 271: iex_debug_pub.LogMessage(l_proc_name || ':' || 'after populating code table:' || l_count );

267: l_start := l_end + 1;
268: l_end := instr(l_object_code, ',', l_start, 1);
269: END LOOP;
270:
271: iex_debug_pub.LogMessage(l_proc_name || ':' || 'after populating code table:' || l_count );
272: l_start := 1;
273: l_count := 0;
274: l_length := LENGTH(l_object_id);
275: l_end := instr(l_object_id, ',', l_start, 1);

Line 291: iex_debug_pub.LogMessage(l_proc_name || ':' || 'after populating id table:' || l_count );

287: l_start := l_end + 1;
288: l_end := instr(l_object_id, ',', l_start, 1);
289: END LOOP;
290:
291: iex_debug_pub.LogMessage(l_proc_name || ':' || 'after populating id table:' || l_count );
292: l_curr_rec_size := 0;
293: l_note_summary_size := 0;
294: l_curr_rec := null;
295: l_note_summary := null;

Line 326: iex_debug_pub.LogMessage(l_proc_name || ':after create l_where_cond:' || l_count || ':' || l_length);

322:
323: END IF;
324:
325: l_length := length(l_where_cond);
326: iex_debug_pub.LogMessage(l_proc_name || ':after create l_where_cond:' || l_count || ':' || l_length);
327:
328: l_sql_stmt := 'SELECT a.notes, a.created_by_name, a.creation_date, ' ||
329: ' a.note_type_meaning, a.note_status_meaning, ' ||
330: ' a.source_object_id, a.source_object_code, ' ||

Line 342: iex_debug_pub.LogMessage(l_proc_name || ':before create l_sql_stmt:' || l_count, l_length);

338: 'AND tl.language = userenv(''LANG'') ' ||
339: 'AND a.jtf_note_id IN (SELECT jtf_note_id FROM jtf_note_contexts WHERE ' ;
340:
341: l_length := length(l_sql_stmt);
342: iex_debug_pub.LogMessage(l_proc_name || ':before create l_sql_stmt:' || l_count, l_length);
343:
344: l_sql_stmt := l_sql_stmt || l_where_cond || ') ' ||
345: 'ORDER BY a.creation_date';
346:

Line 351: iex_debug_pub.LogMessage(l_proc_name || ':after create l_sql_stmt:' || l_count || ':' || l_length);

347: IF p_summary_order = 'D' THEN
348: l_sql_stmt := l_sql_stmt || ' DESC' ;
349: END IF;
350:
351: iex_debug_pub.LogMessage(l_proc_name || ':after create l_sql_stmt:' || l_count || ':' || l_length);
352:
353: -- dbms_output.put_line(length(l_sql_stmt));
354: -- dbms_output.put_line(substr(l_sql_stmt,1,200));
355: -- dbms_output.put_line(substr(l_sql_stmt,201,200));

Line 416: iex_debug_pub.LogMessage(l_proc_name || ':Error' || l_sqlcode);

412: close C_note_details;
413: EXCEPTION
414: WHEN OTHERS THEN
415: l_sqlcode := SQLCODE;
416: iex_debug_pub.LogMessage(l_proc_name || ':Error' || l_sqlcode);
417: iex_debug_pub.LogMessage(l_proc_name || ':l_count=' || to_char(l_count));
418: l_length := length(l_where_cond);
419: iex_debug_pub.LogMessage(l_proc_name || ':l_where_cond=' , l_length);
420: l_length := length(l_sql_stmt);

Line 417: iex_debug_pub.LogMessage(l_proc_name || ':l_count=' || to_char(l_count));

413: EXCEPTION
414: WHEN OTHERS THEN
415: l_sqlcode := SQLCODE;
416: iex_debug_pub.LogMessage(l_proc_name || ':Error' || l_sqlcode);
417: iex_debug_pub.LogMessage(l_proc_name || ':l_count=' || to_char(l_count));
418: l_length := length(l_where_cond);
419: iex_debug_pub.LogMessage(l_proc_name || ':l_where_cond=' , l_length);
420: l_length := length(l_sql_stmt);
421: iex_debug_pub.LogMessage(l_proc_name || ':l_sql_stmt=' , l_length);

Line 419: iex_debug_pub.LogMessage(l_proc_name || ':l_where_cond=' , l_length);

415: l_sqlcode := SQLCODE;
416: iex_debug_pub.LogMessage(l_proc_name || ':Error' || l_sqlcode);
417: iex_debug_pub.LogMessage(l_proc_name || ':l_count=' || to_char(l_count));
418: l_length := length(l_where_cond);
419: iex_debug_pub.LogMessage(l_proc_name || ':l_where_cond=' , l_length);
420: l_length := length(l_sql_stmt);
421: iex_debug_pub.LogMessage(l_proc_name || ':l_sql_stmt=' , l_length);
422: END Get_Notes_Summary;
423:

Line 421: iex_debug_pub.LogMessage(l_proc_name || ':l_sql_stmt=' , l_length);

417: iex_debug_pub.LogMessage(l_proc_name || ':l_count=' || to_char(l_count));
418: l_length := length(l_where_cond);
419: iex_debug_pub.LogMessage(l_proc_name || ':l_where_cond=' , l_length);
420: l_length := length(l_sql_stmt);
421: iex_debug_pub.LogMessage(l_proc_name || ':l_sql_stmt=' , l_length);
422: END Get_Notes_Summary;
423:
424: FUNCTION GET_NOTE_HISTORY(p_jtf_note_id NUMBER)
425: RETURN VARCHAR2 IS