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 2126: PO_DEBUG.debug_stmt(p_log_head => l_log_head,

2122: AND fu.user_id = p_user_id;
2123:
2124: l_progress := '020';
2125: IF g_debug_stmt THEN
2126: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2127: p_token => l_progress,
2128: p_message => 'user name: '||l_user_name||' party name: '||l_party_name);
2129: END IF;
2130:

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

2141:
2142: l_result := FND_MESSAGE.get;
2143:
2144: IF g_debug_stmt THEN
2145: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2146: p_token => l_progress,
2147: p_message => 'l_result: '||l_result);
2148: END IF;
2149: RETURN l_result;

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

2151: EXCEPTION
2152: WHEN NO_DATA_FOUND THEN
2153: l_result := '';
2154: IF g_debug_stmt THEN
2155: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2156: p_token => l_progress,
2157: p_message => 'l_result: '||l_result);
2158: END IF;
2159: RETURN l_result;

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

2161: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
2162: p_procedure_name => 'get_party_vendor_name',
2163: p_error_text => 'Progress: '||l_progress||' Error: '||SUBSTRB(SQLERRM,1,215));
2164: IF g_debug_unexp THEN
2165: PO_DEBUG.debug_exc(p_log_head => l_log_head ||'get_party_vendor_name',
2166: p_progress => l_progress);
2167: END IF;
2168: RETURN NULL;
2169: END get_party_vendor_name;

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

2209: AND fu.user_id = p_user_id;
2210:
2211: l_progress := '020';
2212: IF g_debug_stmt THEN
2213: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2214: p_token => l_progress,
2215: p_message => 'l_fu_email_address: '||l_fu_email_address||' l_hp_email_address: '||l_hp_email_address);
2216: END IF;
2217:

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

2225:
2226: EXCEPTION
2227: WHEN NO_DATA_FOUND THEN
2228: IF g_debug_stmt THEN
2229: PO_DEBUG.debug_stmt(p_log_head => l_log_head,
2230: p_token => l_progress,
2231: p_message => 'No data found');
2232: END IF;
2233: RETURN NULL;

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

2235: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
2236: p_procedure_name => 'get_vendor_email',
2237: p_error_text => 'Progress: '||l_progress||' Error: '||SUBSTRB(SQLERRM,1,215));
2238: IF g_debug_unexp THEN
2239: PO_DEBUG.debug_exc(p_log_head => l_log_head ||'get_vendor_email',
2240: p_progress => l_progress);
2241: END IF;
2242: RETURN NULL;
2243: END get_vendor_email;