DBA Data[Home] [Help]

APPS.PO_WF_BUILD_ACCOUNT_INIT dependencies on PO_WF_DEBUG

Line 5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

1: PACKAGE BODY PO_WF_BUILD_ACCOUNT_INIT AS
2: /* $Header: POXWPOSB.pls 120.7.12020000.2 2013/06/06 14:33:01 gjyothi ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs
8: g_pkg_name CONSTANT VARCHAR2(100) := 'PO_WF_BUILD_ACCOUNT_INIT';
9: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.'||g_pkg_name||'.';

Line 7: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs

3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs
8: g_pkg_name CONSTANT VARCHAR2(100) := 'PO_WF_BUILD_ACCOUNT_INIT';
9: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.'||g_pkg_name||'.';
10:
11: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

Line 162: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs

158: l_bom_cost_element_id NUMBER;
159: l_wip_entity_type NUMBER;
160: --< Shared Proc FPJ End >
161:
162: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs
163: l_api_name CONSTANT VARCHAR2(100) := 'set_ag_wf_attributes';
164: l_progress VARCHAR2(10) := '000';
165: BEGIN
166:

Line 1137: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs

1133: END IF; --is distribution type check
1134: --
1135:
1136:
1137: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs
1138: l_progress := '050';
1139:
1140: IF g_debug_stmt THEN
1141: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 1197: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs

1193: l_vendor_employee_id PER_PEOPLE_F.person_id%TYPE;
1194: l_vendor_employee_number PER_PEOPLE_F.employee_number%TYPE;
1195: l_vendor_type PO_VENDORS.vendor_type_lookup_code%TYPE;
1196:
1197: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs
1198: l_api_name CONSTANT VARCHAR2(100) := 'derive_pa_params';
1199: l_progress VARCHAR2(10) := '000';
1200:
1201: BEGIN

Line 1368: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs

1364: concat_descrs VARCHAR2(2000);
1365: l_block_activity_label VARCHAR2(60);
1366: l_progress VARCHAR2(3); --< Shared Proc FPJ >
1367:
1368: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs
1369: l_api_name CONSTANT VARCHAR2(100) := 'generate_destination_accounts';
1370: BEGIN
1371:
1372: IF g_debug_stmt THEN

Line 1739: l_debug_msg PO_WF_DEBUG.debug_message%TYPE; --< Shared Proc FPJ >

1735: x_block_activity_label VARCHAR2(60);
1736: x_insert_if_new BOOLEAN := TRUE;
1737: x_new_ccid_generated BOOLEAN := FALSE;
1738: x_success BOOLEAN;
1739: l_debug_msg PO_WF_DEBUG.debug_message%TYPE; --< Shared Proc FPJ >
1740: l_progress VARCHAR2(3); --< Shared Proc FPJ >
1741: x_appl_short_name VARCHAR2(40);
1742: x_flex_field_code VARCHAR2(150);
1743: x_flex_field_struc_num NUMBER; -- coa_id

Line 1747: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs

1743: x_flex_field_struc_num NUMBER; -- coa_id
1744:
1745: was_ccid_passed_in_from_form BOOLEAN := FALSE;
1746:
1747: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs
1748: l_api_name CONSTANT VARCHAR2(100) := 'Start_Workflow_internal';
1749: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE; --
1750:
1751: BEGIN

Line 2345: IF (g_po_wf_debug = 'Y') THEN

2341: x_success, -- IN OUT BOOLEAN
2342: FB_ERROR_MSG, -- IN OUT VARCHAR2
2343: x_new_combination); -- IN OUT BOOLEAN
2344:
2345: IF (g_po_wf_debug = 'Y') THEN
2346: IF (x_success) THEN
2347: IF g_debug_stmt THEN
2348: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2349: p_token => l_progress,

Line 2518: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs

2514: l_progress VARCHAR2(3); --< Shared Proc FPJ >
2515: l_return_status VARCHAR2(1); -- FND_API.g_ret_sts_success
2516: -- $FND_TOP/patch/115/sql/AFASAPIS.pls
2517:
2518: -- Added debug comments to FND logs instead on PO_WF_DEBUG logs
2519: l_api_name CONSTANT VARCHAR2(100) := 'start_workflow';
2520:
2521: BEGIN
2522: IF g_debug_stmt THEN

Line 2685: IF (g_po_wf_debug = 'Y') THEN

2681: );
2682:
2683: l_progress := '040';
2684:
2685: IF (g_po_wf_debug = 'Y') THEN
2686: IF (x_success) THEN
2687: IF g_debug_stmt THEN
2688: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2689: p_token => l_progress,

Line 2738: IF (g_po_wf_debug = 'Y') THEN

2734: (x_coa_id <> l_ship_to_ou_coa_id) ) THEN
2735:
2736: l_progress := '060';
2737:
2738: IF (g_po_wf_debug = 'Y') THEN
2739: IF g_debug_stmt THEN
2740: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2741: p_token => l_progress,
2742: p_message => 'Second call to Start_Workflow_internal with DOUs COA');

Line 2847: IF (g_po_wf_debug = 'Y') THEN

2843: );
2844:
2845: l_progress := '070';
2846:
2847: IF (g_po_wf_debug = 'Y') THEN
2848: IF (x_success) THEN
2849: IF g_debug_stmt THEN
2850: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2851: p_token => l_progress,