DBA Data[Home] [Help]

APPS.JTF_DEBUG_PUB dependencies on FND_MSG_PUB

Line 89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

85: exception
86: when others then
87: l_profile_name := 'UTL_FILE_LOG';
88: end;
89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
90: FND_MESSAGE.Set_Name('JTF', 'JTF_DEBUG_ERROR1');
91: FND_MESSAGE.Set_Token('EXCEPTION_NAME',exception_name, FALSE);
92: FND_MESSAGE.Set_Token('PROFILE_NAME',l_profile_name, FALSE);
93: FND_MSG_PUB.ADD;

Line 93: FND_MSG_PUB.ADD;

89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
90: FND_MESSAGE.Set_Name('JTF', 'JTF_DEBUG_ERROR1');
91: FND_MESSAGE.Set_Token('EXCEPTION_NAME',exception_name, FALSE);
92: FND_MESSAGE.Set_Token('PROFILE_NAME',l_profile_name, FALSE);
93: FND_MSG_PUB.ADD;
94: END IF;
95: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
96: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
97: ,P_MSG_COUNT => 1

Line 96: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

92: FND_MESSAGE.Set_Token('PROFILE_NAME',l_profile_name, FALSE);
93: FND_MSG_PUB.ADD;
94: END IF;
95: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
96: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
97: ,P_MSG_COUNT => 1
98: ,X_MSG_COUNT => X_MSG_COUNT
99: ,X_MSG_DATA => X_MSG_DATA
100: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 425: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR

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
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;

Line 431: FND_MSG_PUB.Count_And_Get(

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,
433: p_count => x_msg_count,
434: p_data => x_msg_data);
435: END IF;

Line 436: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
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;

Line 442: FND_MSG_PUB.Count_And_Get(

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,
444: p_count => x_msg_count,
445: p_data => x_msg_data);
446: END IF;

Line 451: /* FND_MSG_PUB.Count_And_Get(

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);
454: */
455: FND_MESSAGE.Set_Name('JTF', 'JTF_ERROR_RETURNED');

Line 458: FND_MSG_PUB.ADD;

454: */
455: FND_MESSAGE.Set_Name('JTF', 'JTF_ERROR_RETURNED');
456: FND_MESSAGE.Set_token('PKG_NAME' , p_pkg_name);
457: FND_MESSAGE.Set_token('API_NAME' , p_api_name);
458: FND_MSG_PUB.ADD;
459: l_len_sqlerrm := Length(P_SQLERRM) ;
460: While l_len_sqlerrm >= i Loop
461: FND_MESSAGE.Set_Name('JTF', 'JTF_SQLERRM');
462: FND_MESSAGE.Set_token('ERR_TEXT' , substr(P_SQLERRM,i,240));

Line 464: FND_MSG_PUB.ADD;

460: While l_len_sqlerrm >= i Loop
461: FND_MESSAGE.Set_Name('JTF', 'JTF_SQLERRM');
462: FND_MESSAGE.Set_token('ERR_TEXT' , substr(P_SQLERRM,i,240));
463: i := i + 240;
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

Line 472: FND_MSG_PUB.Count_And_Get(

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(
473: p_encoded => fnd_api.g_false,
474: p_count => x_msg_count,
475: p_data => x_msg_data);
476: END IF;

Line 482: l_msg_data := fnd_msg_pub.get( p_msg_index => k,

478: -- Logging the error
479:
480: IF (P_LOG_LEVEL is not null ) AND (P_LOG_MODULE is not null) THEN
481: for k in 1 ..x_msg_count loop
482: l_msg_data := fnd_msg_pub.get( p_msg_index => k,
483: p_encoded => 'F'
484: );
485: LOG_DEBUG( P_LOG_LEVEL, P_LOG_MODULE, P_PKG_NAME || '.' || P_API_NAME || '-' || k || '-' || substr(l_msg_data,1,200) );
486: end loop;

Line 524: MSG_INDEX := FND_MSG_PUB.count_msg - p_message_count + 1;

520: and lng.LANGUAGE_CODE = msg.language_code
521: and lng.language_id = x_lang_id;
522: BEGIN
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);

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 || '

Line 578: MSG_INDEX := FND_MSG_PUB.count_msg - p_message_count + 1;

574: -- delete all the messages that have been read
575: -- can do this when the message is read but i don't want to mess with
576: -- the index
577:
578: MSG_INDEX := FND_MSG_PUB.count_msg - p_message_count + 1;
579: for i in 1..x_message_count loop
580: fnd_msg_pub.delete_msg(MSG_INDEX);
581: MSG_INDEX := MSG_INDEX + 1;
582: end loop;

Line 580: fnd_msg_pub.delete_msg(MSG_INDEX);

576: -- the index
577:
578: MSG_INDEX := FND_MSG_PUB.count_msg - p_message_count + 1;
579: for i in 1..x_message_count loop
580: fnd_msg_pub.delete_msg(MSG_INDEX);
581: MSG_INDEX := MSG_INDEX + 1;
582: end loop;
583:
584: END Get_Messages;