DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on PO_DEBUG

Line 7: G_DEBUG_STMT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_INQ_SV';
6: G_LOG_HEAD CONSTANT VARCHAR2(50) := 'po.plsql.'||G_PKG_NAME||'.';
7: G_DEBUG_STMT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8: G_DEBUG_UNEXP BOOLEAN := PO_DEBUG.is_debug_unexp_on;
9: --
10:
11: /*============================= PO_INQ_SV ===============================*/

Line 8: G_DEBUG_UNEXP BOOLEAN := PO_DEBUG.is_debug_unexp_on;

4: --
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_INQ_SV';
6: G_LOG_HEAD CONSTANT VARCHAR2(50) := 'po.plsql.'||G_PKG_NAME||'.';
7: G_DEBUG_STMT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8: G_DEBUG_UNEXP BOOLEAN := PO_DEBUG.is_debug_unexp_on;
9: --
10:
11: /*============================= PO_INQ_SV ===============================*/
12: /* Local procedure */

Line 2070: PO_DEBUG.debug_stmt(p_log_head => l_log_head,

2066: AND fu.user_id = p_user_id;
2067:
2068: l_progress := '020';
2069: IF g_debug_stmt THEN
2070: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2071: p_token => l_progress,
2072: p_message => 'user name: '||l_user_name||' party name: '||l_party_name);
2073: END IF;
2074:

Line 2089: PO_DEBUG.debug_stmt(p_log_head => l_log_head,

2085:
2086: l_result := FND_MESSAGE.get;
2087:
2088: IF g_debug_stmt THEN
2089: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2090: p_token => l_progress,
2091: p_message => 'l_result: '||l_result);
2092: END IF;
2093: RETURN l_result;

Line 2099: PO_DEBUG.debug_stmt(p_log_head => l_log_head,

2095: EXCEPTION
2096: WHEN NO_DATA_FOUND THEN
2097: l_result := '';
2098: IF g_debug_stmt THEN
2099: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2100: p_token => l_progress,
2101: p_message => 'l_result: '||l_result);
2102: END IF;
2103: RETURN l_result;

Line 2109: PO_DEBUG.debug_exc(p_log_head => l_log_head ||'get_party_vendor_name',

2105: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
2106: p_procedure_name => 'get_party_vendor_name',
2107: p_error_text => 'Progress: '||l_progress||' Error: '||SUBSTRB(SQLERRM,1,215));
2108: IF g_debug_unexp THEN
2109: PO_DEBUG.debug_exc(p_log_head => l_log_head ||'get_party_vendor_name',
2110: p_progress => l_progress);
2111: END IF;
2112: RETURN NULL;
2113: END get_party_vendor_name;

Line 2157: PO_DEBUG.debug_stmt(p_log_head => l_log_head,

2153: AND fu.user_id = p_user_id;
2154:
2155: l_progress := '020';
2156: IF g_debug_stmt THEN
2157: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2158: p_token => l_progress,
2159: p_message => 'l_fu_email_address: '||l_fu_email_address||' l_hp_email_address: '||l_hp_email_address);
2160: END IF;
2161:

Line 2173: PO_DEBUG.debug_stmt(p_log_head => l_log_head,

2169:
2170: EXCEPTION
2171: WHEN NO_DATA_FOUND THEN
2172: IF g_debug_stmt THEN
2173: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2174: p_token => l_progress,
2175: p_message => 'No data found');
2176: END IF;
2177: RETURN NULL;

Line 2183: PO_DEBUG.debug_exc(p_log_head => l_log_head ||'get_vendor_email',

2179: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
2180: p_procedure_name => 'get_vendor_email',
2181: p_error_text => 'Progress: '||l_progress||' Error: '||SUBSTRB(SQLERRM,1,215));
2182: IF g_debug_unexp THEN
2183: PO_DEBUG.debug_exc(p_log_head => l_log_head ||'get_vendor_email',
2184: p_progress => l_progress);
2185: END IF;
2186: RETURN NULL;
2187: END get_vendor_email;