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_DEBUG_PUB dependencies on FND_API

Line 270: p_file_name IN varchar2 := FND_API.G_MISS_CHAR,

266: /** returns filename if alteast one message has been written to it.
267: otherwise returns NULL */
268:
269: PROCEDURE Debug(
270: p_file_name IN varchar2 := FND_API.G_MISS_CHAR,
271: p_debug_tbl IN debug_tbl_type := G_MISS_DEBUG_TBL,
272: p_module IN varchar2,
273: x_path OUT NOCOPY varchar2,
274: x_filename OUT NOCOPY varchar2,

Line 305: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

301: l_timestamp VARCHAR2(240);
302: l_return BOOLEAN := FALSE;
303: BEGIN
304:
305: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
306:
307: OPEN C_current_time;
308: FETCH C_current_time into l_timestamp;
309: CLOSE C_current_time;

Line 399: P_API_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,

395:
396: END Debug;
397:
398: PROCEDURE Handle_Exceptions(
399: P_API_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
400: P_PKG_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
401: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
402: P_SQLCODE IN NUMBER DEFAULT NULL,
403: P_SQLERRM IN VARCHAR2 DEFAULT NULL,

Line 400: P_PKG_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,

396: END Debug;
397:
398: PROCEDURE Handle_Exceptions(
399: P_API_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
400: P_PKG_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
401: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
402: P_SQLCODE IN NUMBER DEFAULT NULL,
403: P_SQLERRM IN VARCHAR2 DEFAULT NULL,
404: P_MSG_COUNT IN NUMBER := FND_API.G_MISS_NUM,

Line 401: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

397:
398: PROCEDURE Handle_Exceptions(
399: P_API_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
400: P_PKG_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
401: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
402: P_SQLCODE IN NUMBER DEFAULT NULL,
403: P_SQLERRM IN VARCHAR2 DEFAULT NULL,
404: P_MSG_COUNT IN NUMBER := FND_API.G_MISS_NUM,
405: P_LOG_LEVEL IN NUMBER DEFAULT NULL,

Line 404: P_MSG_COUNT IN NUMBER := FND_API.G_MISS_NUM,

400: P_PKG_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
401: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
402: P_SQLCODE IN NUMBER DEFAULT NULL,
403: P_SQLERRM IN VARCHAR2 DEFAULT NULL,
404: P_MSG_COUNT IN NUMBER := FND_API.G_MISS_NUM,
405: P_LOG_LEVEL IN NUMBER DEFAULT NULL,
406: P_LOG_MODULE IN VARCHAR2 DEFAULT NULL,
407: X_MSG_COUNT OUT NOCOPY NUMBER,
408: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 421: if l_api_name <> FND_API.G_MISS_CHAR then

417:
418: BEGIN
419: l_api_name := UPPER(p_api_name);
420:
421: if l_api_name <> FND_API.G_MISS_CHAR then
422: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
423: end if;
424:
425: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: end if;
424:
425: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
426: THEN
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: IF p_msg_count <> FND_API.G_MISS_NUM THEN
429: x_msg_count := p_msg_count;
430: ELSE
431: FND_MSG_PUB.Count_And_Get(

Line 428: IF p_msg_count <> FND_API.G_MISS_NUM THEN

424:
425: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
426: THEN
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: IF p_msg_count <> FND_API.G_MISS_NUM THEN
429: x_msg_count := p_msg_count;
430: ELSE
431: FND_MSG_PUB.Count_And_Get(
432: p_encoded => fnd_api.g_false,

Line 432: p_encoded => fnd_api.g_false,

428: IF p_msg_count <> FND_API.G_MISS_NUM THEN
429: x_msg_count := p_msg_count;
430: ELSE
431: FND_MSG_PUB.Count_And_Get(
432: p_encoded => fnd_api.g_false,
433: p_count => x_msg_count,
434: p_data => x_msg_data);
435: END IF;
436: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: p_data => x_msg_data);
435: END IF;
436: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
437: THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: IF p_msg_count <> FND_API.G_MISS_NUM THEN
440: x_msg_count := p_msg_count;
441: ELSE
442: FND_MSG_PUB.Count_And_Get(

Line 439: IF p_msg_count <> FND_API.G_MISS_NUM THEN

435: END IF;
436: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
437: THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: IF p_msg_count <> FND_API.G_MISS_NUM THEN
440: x_msg_count := p_msg_count;
441: ELSE
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => fnd_api.g_false,

Line 443: p_encoded => fnd_api.g_false,

439: IF p_msg_count <> FND_API.G_MISS_NUM THEN
440: x_msg_count := p_msg_count;
441: ELSE
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => fnd_api.g_false,
444: p_count => x_msg_count,
445: p_data => x_msg_data);
446: END IF;
447: ELSIF p_exception_level = G_EXC_OTHERS

Line 449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

445: p_data => x_msg_data);
446: END IF;
447: ELSIF p_exception_level = G_EXC_OTHERS
448: THEN
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450:
451: /* FND_MSG_PUB.Count_And_Get(
452: p_count => l_msg_count,
453: p_data => x_msg_data);

Line 468: IF p_msg_count <> FND_API.G_MISS_NUM THEN

464: FND_MSG_PUB.ADD;
465: l_msg_count := l_msg_count + 1;
466: end loop;
467:
468: IF p_msg_count <> FND_API.G_MISS_NUM THEN
469: x_msg_count := p_msg_count + l_msg_count;
470: -- messages added by this API
471: ELSE
472: FND_MSG_PUB.Count_And_Get(

Line 473: p_encoded => fnd_api.g_false,

469: x_msg_count := p_msg_count + l_msg_count;
470: -- messages added by this API
471: ELSE
472: FND_MSG_PUB.Count_And_Get(
473: p_encoded => fnd_api.g_false,
474: p_count => x_msg_count,
475: p_data => x_msg_data);
476: END IF;
477: END IF;

Line 527: -- l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);

523:
524: MSG_INDEX := FND_MSG_PUB.count_msg - p_message_count + 1;
525:
526: FOR l_count in 1..NVL(p_message_count,0) LOOP
527: -- l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
528: l_temp_msg := fnd_msg_pub.get(MSG_INDEX, fnd_api.g_true);
529: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
530:
531: OPEN Get_Appl_Id (l_appl_short_name);

Line 528: l_temp_msg := fnd_msg_pub.get(MSG_INDEX, fnd_api.g_true);

524: MSG_INDEX := FND_MSG_PUB.count_msg - p_message_count + 1;
525:
526: FOR l_count in 1..NVL(p_message_count,0) LOOP
527: -- l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
528: l_temp_msg := fnd_msg_pub.get(MSG_INDEX, fnd_api.g_true);
529: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
530:
531: OPEN Get_Appl_Id (l_appl_short_name);
532: FETCH Get_Appl_Id into l_id;

Line 543: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);

539: FETCH Get_Message_Num into l_message_num;
540: CLOSE Get_Message_Num;
541: END IF;
542:
543: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
544:
545: IF NVL(l_message_num, 0) <> 0 THEN
546: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';
547: ELSE

Line 552: fnd_msg_pub.get(MSG_INDEX, fnd_api.g_false);

548: l_temp_msg := NULL;
549: END IF;
550:
551: l_msg_list := l_msg_list || l_temp_msg ||
552: fnd_msg_pub.get(MSG_INDEX, fnd_api.g_false);
553: /*
554: IF l_count = 1 THEN
555: l_msg_list := l_msg_list || l_temp_msg ||
556: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

Line 556: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

552: fnd_msg_pub.get(MSG_INDEX, fnd_api.g_false);
553: /*
554: IF l_count = 1 THEN
555: l_msg_list := l_msg_list || l_temp_msg ||
556: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
557: ELSE
558: l_msg_list := l_msg_list || l_temp_msg ||
559: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
560: END IF;

Line 559: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);

555: l_msg_list := l_msg_list || l_temp_msg ||
556: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
557: ELSE
558: l_msg_list := l_msg_list || l_temp_msg ||
559: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
560: END IF;
561: */
562:
563: l_msg_list := l_msg_list || '