APPS.PO_HR_INTERFACE_PVT dependencies on PO_DEBUG

Line 6: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;

2: /* $Header: POHRINTB.pls 120.3 2008/06/26 06:52:56 adbharga noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HR_INTERFACE_PVT';
5: g_log_head CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
6: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8:
9:
10: PROCEDURE is_Supplier_Updatable (

Line 7: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HR_INTERFACE_PVT';
5: g_log_head CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
6: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8:
9:
10: PROCEDURE is_Supplier_Updatable (
11: p_assignment_id IN NUMBER,

Line 25: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Start');

21:
22:
23:
24: BEGIN
25: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Start');
26:
27: l_progress:=010;
28: BEGIN
29: select 'Y'

Line 53: PO_DEBUG.debug_stmt(l_log_head,l_progress,'No Record found');

49: BETWEEN Nvl(paaf.effective_start_date,SYSDATE-1) AND Nvl(paaf.effective_end_date,SYSDATE+1)
50: );
51: EXCEPTION
52: when NO_DATA_FOUND THEN
53: PO_DEBUG.debug_stmt(l_log_head,l_progress,'No Record found');
54: RETURN;
55: END;
56:
57: l_progress:=020;

Line 59: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Record found');

55: END;
56:
57: l_progress:=020;
58: IF X_flag='Y' THEN
59: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Record found');
60: fnd_message.set_name('PO','PO_ACTIVE_SUPPLIER_EXISTS');
61: APP_EXCEPTION.RAISE_EXCEPTION;
62:
63: ELSE

Line 64: PO_DEBUG.debug_stmt(l_log_head,l_progress,'No Record found');

60: fnd_message.set_name('PO','PO_ACTIVE_SUPPLIER_EXISTS');
61: APP_EXCEPTION.RAISE_EXCEPTION;
62:
63: ELSE
64: PO_DEBUG.debug_stmt(l_log_head,l_progress,'No Record found');
65: RETURN;
66: END IF;
67:
68: END is_Supplier_Updatable;