2: /* $Header: POXPROJB.pls 120.2.12020000.2 2013/05/30 11:51:02 gjyothi ship $ */
3:
4: --< Bug 3265539 Start >
5: -- Debugging booleans used to bypass logging when turned off
6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
8:
9: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_PROJECT_DETAILS_SV';
10: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
3:
4: --< Bug 3265539 Start >
5: -- Debugging booleans used to bypass logging when turned off
6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
8:
9: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_PROJECT_DETAILS_SV';
10: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
11:
80: EXCEPTION
81: WHEN FND_API.g_exc_unexpected_error THEN
82: x_return_status := FND_API.g_ret_sts_unexp_error;
83: IF g_debug_unexp THEN
84: PO_DEBUG.debug_exc
85: (p_log_head => g_module_prefix||'get_project_task_num',
86: p_progress => l_progress);
87: END IF;
88: WHEN OTHERS THEN
91: p_procedure_name => 'get_project_task_num',
92: p_error_text => 'Progress: '||l_progress||
93: ' Error: '||SUBSTRB(SQLERRM,1,215));
94: IF g_debug_unexp THEN
95: PO_DEBUG.debug_exc
96: (p_log_head => g_module_prefix||'get_project_task_num',
97: p_progress => l_progress);
98: END IF;
99: END get_project_task_num ;
233: x_return_status := FND_API.g_ret_sts_unexp_error;
234: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
235: p_procedure_name => 'all_proj_idtonum_wpr');
236: IF g_debug_unexp THEN
237: PO_DEBUG.debug_exc
238: (p_log_head => g_module_prefix||'all_proj_idtonum_wpr',
239: p_progress => '000');
240: END IF;
241: END all_proj_idtonum_wpr;
308: BEGIN
309: l_progress := '000';
310:
311: IF g_debug_stmt THEN
312: PO_DEBUG.debug_stmt
313: (p_log_head => g_module_prefix||'validate_proj_references_wpr',
314: p_token => 'BEGIN',
315: p_message => 'inv org ID: '||p_inventory_org_id||' ou ID: '||
316: p_operating_unit||' project ID: '||p_project_id||' task ID: '||
350: x_calling_function => p_calling_function,
351: x_error_code => x_error_code);
352:
353: IF g_debug_stmt THEN
354: PO_DEBUG.debug_stmt
355: (p_log_head => g_module_prefix||'validate_proj_references_wpr',
356: p_token => 'END',
357: p_message => 'return code: '||x_return_code||' error code: '||
358: x_error_code);
360: EXCEPTION
361: WHEN FND_API.g_exc_unexpected_error THEN
362: x_return_code := pjm_validate_failure;
363: IF g_debug_unexp THEN
364: PO_DEBUG.debug_exc
365: (p_log_head => g_module_prefix||'validate_proj_references_wpr',
366: p_progress => l_progress);
367: END IF;
368: WHEN OTHERS THEN
371: p_procedure_name => 'validate_proj_references_wpr',
372: p_error_text => 'Progress: '||l_progress||
373: ' Error: '||SUBSTRB(SQLERRM,1,215));
374: IF g_debug_unexp THEN
375: PO_DEBUG.debug_exc
376: (p_log_head => g_module_prefix||'validate_proj_references_wpr',
377: p_progress => l_progress);
378: END IF;
379: END validate_proj_references_wpr;