40: WHEN NO_DATA_FOUND THEN
41: row_found := 0;
42: END;
43:
44: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
45: FND_LOG.string (log_level => FND_LOG.level_procedure,
46: module => g_module_prefix || l_module_name,
47: message => 'Entering PON_THREAD_DISC_PKG.GET_UNREAD_MESSAGE_COUNT'
48: || ', row_found = ' || row_found
41: row_found := 0;
42: END;
43:
44: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
45: FND_LOG.string (log_level => FND_LOG.level_procedure,
46: module => g_module_prefix || l_module_name,
47: message => 'Entering PON_THREAD_DISC_PKG.GET_UNREAD_MESSAGE_COUNT'
48: || ', row_found = ' || row_found
49: || ', p_auction_header_id = ' || p_auction_header_id
61: where pd.pk1_value = to_char(p_auction_header_id)
62: AND pd.entity_name = 'PON_AUCTION_HEADERS_ALL' ;
63: EXCEPTION
64: WHEN TOO_MANY_ROWS THEN
65: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
66: FND_LOG.string (log_level => FND_LOG.level_procedure,
67: module => g_module_prefix || l_module_name,
68: message => 'PON_THREAD_DISC_PKG.GET_UNREAD_MESSAGE_COUNT'
69: || ', Exception : Multiple Discussion Rows found for given auction header id : '|| p_auction_header_id);
62: AND pd.entity_name = 'PON_AUCTION_HEADERS_ALL' ;
63: EXCEPTION
64: WHEN TOO_MANY_ROWS THEN
65: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
66: FND_LOG.string (log_level => FND_LOG.level_procedure,
67: module => g_module_prefix || l_module_name,
68: message => 'PON_THREAD_DISC_PKG.GET_UNREAD_MESSAGE_COUNT'
69: || ', Exception : Multiple Discussion Rows found for given auction header id : '|| p_auction_header_id);
70: END IF;
75: AND pd.entity_name = 'PON_AUCTION_HEADERS_ALL'
76: AND ROWNUM = 1;
77: END;
78:
79: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
80: FND_LOG.string (log_level => FND_LOG.level_procedure,
81: module => g_module_prefix || l_module_name,
82: message => 'PON_THREAD_DISC_PKG.GET_UNREAD_MESSAGE_COUNT'
83: || ', l_discussion_id = '|| l_discussion_id);
76: AND ROWNUM = 1;
77: END;
78:
79: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
80: FND_LOG.string (log_level => FND_LOG.level_procedure,
81: module => g_module_prefix || l_module_name,
82: message => 'PON_THREAD_DISC_PKG.GET_UNREAD_MESSAGE_COUNT'
83: || ', l_discussion_id = '|| l_discussion_id);
84: END IF;
157: l_reply_count NUMBER;
158: l_module_name VARCHAR2(25) := 'GET_REPLIED_STATUS';
159:
160: BEGIN
161: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
162: FND_LOG.string (log_level => FND_LOG.level_procedure,
163: module => g_module_prefix || l_module_name,
164: message => 'Entering PON_THREAD_DISC_PKG.GET_REPLIED_STATUS'
165: || ', p_to_id = ' || p_to_id
158: l_module_name VARCHAR2(25) := 'GET_REPLIED_STATUS';
159:
160: BEGIN
161: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
162: FND_LOG.string (log_level => FND_LOG.level_procedure,
163: module => g_module_prefix || l_module_name,
164: message => 'Entering PON_THREAD_DISC_PKG.GET_REPLIED_STATUS'
165: || ', p_to_id = ' || p_to_id
166: || ', p_auctioneer_tp_id = ' || p_auctioneer_tp_id