DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PVT dependencies on PA_DEBUG

Line 659: pa_debug.debug('PA_TASKS_MAINT_PVT.CREATE_TASK BEGIN');

655: l_wp_separate_from_fin VARCHAR2(1);
656:
657: BEGIN
658: IF (p_debug_mode = 'Y') THEN
659: pa_debug.debug('PA_TASKS_MAINT_PVT.CREATE_TASK BEGIN');
660: END IF;
661:
662: IF (p_commit = FND_API.G_TRUE) THEN
663: savepoint CREATE_TASK_PRIVATE;

Line 667: pa_debug.debug('Performing validations');

663: savepoint CREATE_TASK_PRIVATE;
664: END IF;
665:
666: IF (p_debug_mode = 'Y') THEN
667: pa_debug.debug('Performing validations');
668: END IF;
669:
670: IF (p_calling_module IN ('EXCHANGE')) THEN
671: --check if task reference is null

Line 2313: pa_debug.debug('PA_TASKS_MAINT_PVT.UPDATE_TASK BEGIN');

2309:
2310: BEGIN
2311:
2312: IF (p_debug_mode = 'Y') THEN
2313: pa_debug.debug('PA_TASKS_MAINT_PVT.UPDATE_TASK BEGIN');
2314: END IF;
2315:
2316: IF (p_commit = FND_API.G_TRUE) THEN
2317: savepoint UPDATE_TASK_PRIVATE;

Line 2321: pa_debug.debug('Performing validations');

2317: savepoint UPDATE_TASK_PRIVATE;
2318: END IF;
2319:
2320: IF (p_debug_mode = 'Y') THEN
2321: pa_debug.debug('Performing validations');
2322: END IF;
2323:
2324: IF (p_calling_module IN ('FORMS', 'EXCHANGE', 'SELF_SERVICE')) THEN
2325: --check if task_name is null

Line 3403: pa_debug.debug('PA_TASKS_MAINT_PVT.DELETE_TASK BEGIN');

3399: t_pm_product_code PA_TASKS.PM_PRODUCT_CODE%TYPE;
3400: t_parent_task_id PA_TASKS.PARENT_TASK_ID%TYPE;
3401: BEGIN
3402: IF (p_debug_mode = 'Y') THEN
3403: pa_debug.debug('PA_TASKS_MAINT_PVT.DELETE_TASK BEGIN');
3404: END IF;
3405:
3406: IF (p_commit = FND_API.G_TRUE) THEN
3407: savepoint DELETE_TASK_PRIVATE;

Line 3411: pa_debug.debug('Performing validations');

3407: savepoint DELETE_TASK_PRIVATE;
3408: END IF;
3409:
3410: IF (p_debug_mode = 'Y') THEN
3411: pa_debug.debug('Performing validations');
3412: END IF;
3413:
3414: -- Get PM_PRODUCT_CODE
3415: BEGIN

Line 6185: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

6181: x_msg_count := 0;
6182: x_return_status := FND_API.G_RET_STS_SUCCESS;
6183:
6184: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6185: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6186: l_user_id := fnd_global.user_id;
6187: l_login_id := fnd_global.login_id;
6188: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6189:

Line 6188: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');

6184: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6185: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6186: l_user_id := fnd_global.user_id;
6187: l_login_id := fnd_global.login_id;
6188: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6189:
6190: --l_debug_mode := NVL(p_debug_mode,'N');
6191: IF l_debug_mode = 'Y' THEN
6192: PA_DEBUG.set_curr_function( p_function => 'SET_UNSET_FINANCIAL_TASK',

Line 6192: PA_DEBUG.set_curr_function( p_function => 'SET_UNSET_FINANCIAL_TASK',

6188: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6189:
6190: --l_debug_mode := NVL(p_debug_mode,'N');
6191: IF l_debug_mode = 'Y' THEN
6192: PA_DEBUG.set_curr_function( p_function => 'SET_UNSET_FINANCIAL_TASK',
6193: p_debug_mode => l_debug_mode );
6194: END IF;
6195:
6196: IF l_debug_mode = 'Y' THEN

Line 6197: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';

6193: p_debug_mode => l_debug_mode );
6194: END IF;
6195:
6196: IF l_debug_mode = 'Y' THEN
6197: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';
6198: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6199: l_debug_level3);
6200:
6201: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,

Line 6198: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6194: END IF;
6195:
6196: IF l_debug_mode = 'Y' THEN
6197: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';
6198: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6199: l_debug_level3);
6200:
6201: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
6202: l_debug_level3);

Line 6201: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,

6197: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';
6198: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6199: l_debug_level3);
6200:
6201: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
6202: l_debug_level3);
6203: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
6204: l_debug_level3);
6205: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,

Line 6203: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,

6199: l_debug_level3);
6200:
6201: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
6202: l_debug_level3);
6203: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
6204: l_debug_level3);
6205: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
6206: l_debug_level3);
6207: END IF;

Line 6205: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,

6201: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
6202: l_debug_level3);
6203: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
6204: l_debug_level3);
6205: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
6206: l_debug_level3);
6207: END IF;
6208:
6209: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 6219: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Validating Input parameters';

6215: --savepoint SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6216: END IF;
6217:
6218: IF l_debug_mode = 'Y' THEN
6219: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Validating Input parameters';
6220: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6221: l_debug_level3);
6222: END IF;
6223:

Line 6220: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6216: END IF;
6217:
6218: IF l_debug_mode = 'Y' THEN
6219: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Validating Input parameters';
6220: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6221: l_debug_level3);
6222: END IF;
6223:
6224: IF (

Line 6231: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Both p_task_version_id and p_checked_flag are null';

6227: ( p_project_id IS NULL)
6228: )
6229: THEN
6230: IF l_debug_mode = 'Y' THEN
6231: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Both p_task_version_id and p_checked_flag are null';
6232: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6233: l_debug_level3);
6234: END IF;
6235: RAISE Invalid_Arg_Exc_WP;

Line 6232: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6228: )
6229: THEN
6230: IF l_debug_mode = 'Y' THEN
6231: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Both p_task_version_id and p_checked_flag are null';
6232: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6233: l_debug_level3);
6234: END IF;
6235: RAISE Invalid_Arg_Exc_WP;
6236: END IF;

Line 6267: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK :l_error_code :'||l_error_code||'l_error_msg_code :'||l_error_msg_code;

6263: IF (l_error_code <> 0) THEN
6264:
6265:
6266: IF l_debug_mode = 'Y' THEN
6267: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK :l_error_code :'||l_error_code||'l_error_msg_code :'||l_error_msg_code;
6268: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6269: l_debug_level3);
6270: END IF;
6271: PA_UTILS.ADD_MESSAGE(

Line 6268: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6264:
6265:
6266: IF l_debug_mode = 'Y' THEN
6267: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK :l_error_code :'||l_error_code||'l_error_msg_code :'||l_error_msg_code;
6268: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6269: l_debug_level3);
6270: END IF;
6271: PA_UTILS.ADD_MESSAGE(
6272: p_app_short_name => 'PA'

Line 6331: Pa_Debug.reset_curr_function;

6327:
6328: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls
6329: -- and it gives ORA 06512 numeric or value error
6330: IF l_debug_mode = 'Y' THEN
6331: Pa_Debug.reset_curr_function;
6332: END IF;
6333:
6334: EXCEPTION
6335:

Line 6364: Pa_Debug.reset_curr_function;

6360: x_msg_count := l_msg_count;
6361: END IF;
6362:
6363: IF l_debug_mode = 'Y' THEN
6364: Pa_Debug.reset_curr_function;
6365: END IF;
6366:
6367: WHEN Invalid_Arg_Exc_WP THEN
6368:

Line 6386: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

6382: , p_procedure_name => 'SET_UNSET_FINANCIAL_TASK'
6383: , p_error_text => x_msg_data);
6384:
6385: IF l_debug_mode = 'Y' THEN
6386: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6387: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6388: l_debug_level5);
6389:
6390: Pa_Debug.reset_curr_function;

Line 6387: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6383: , p_error_text => x_msg_data);
6384:
6385: IF l_debug_mode = 'Y' THEN
6386: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6387: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6388: l_debug_level5);
6389:
6390: Pa_Debug.reset_curr_function;
6391: END IF;

Line 6390: Pa_Debug.reset_curr_function;

6386: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6387: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6388: l_debug_level5);
6389:
6390: Pa_Debug.reset_curr_function;
6391: END IF;
6392: RAISE;
6393:
6394: WHEN OTHERS THEN

Line 6415: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

6411: , p_procedure_name => 'SET_UNSET_FINANCIAL_TASK'
6412: , p_error_text => x_msg_data);
6413:
6414: IF l_debug_mode = 'Y' THEN
6415: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6416: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6417: l_debug_level5);
6418: Pa_Debug.reset_curr_function;
6419: END IF;

Line 6416: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6412: , p_error_text => x_msg_data);
6413:
6414: IF l_debug_mode = 'Y' THEN
6415: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6416: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6417: l_debug_level5);
6418: Pa_Debug.reset_curr_function;
6419: END IF;
6420: RAISE;

Line 6418: Pa_Debug.reset_curr_function;

6414: IF l_debug_mode = 'Y' THEN
6415: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6416: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6417: l_debug_level5);
6418: Pa_Debug.reset_curr_function;
6419: END IF;
6420: RAISE;
6421: END SET_UNSET_FINANCIAL_TASK ;
6422:

Line 6584: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

6580: x_msg_count := 0;
6581: x_return_status := FND_API.G_RET_STS_SUCCESS;
6582:
6583: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6584: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6585: l_user_id := fnd_global.user_id;
6586: l_login_id := fnd_global.login_id;
6587: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6588:

Line 6587: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');

6583: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6584: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6585: l_user_id := fnd_global.user_id;
6586: l_login_id := fnd_global.login_id;
6587: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6588:
6589: --l_debug_mode := NVL(p_debug_mode,'N');
6590: IF l_debug_mode = 'Y' THEN
6591: PA_DEBUG.set_curr_function( p_function => 'SYNC_UP_WP_TASKS_WITH_FIN',

Line 6591: PA_DEBUG.set_curr_function( p_function => 'SYNC_UP_WP_TASKS_WITH_FIN',

6587: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6588:
6589: --l_debug_mode := NVL(p_debug_mode,'N');
6590: IF l_debug_mode = 'Y' THEN
6591: PA_DEBUG.set_curr_function( p_function => 'SYNC_UP_WP_TASKS_WITH_FIN',
6592: p_debug_mode => l_debug_mode );
6593: END IF;
6594:
6595: IF l_debug_mode = 'Y' THEN

Line 6596: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';

6592: p_debug_mode => l_debug_mode );
6593: END IF;
6594:
6595: IF l_debug_mode = 'Y' THEN
6596: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
6597: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6598: l_debug_level3);
6599:
6600: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,

Line 6597: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6593: END IF;
6594:
6595: IF l_debug_mode = 'Y' THEN
6596: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
6597: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6598: l_debug_level3);
6599:
6600: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
6601: l_debug_level3);

Line 6600: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,

6596: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
6597: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6598: l_debug_level3);
6599:
6600: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
6601: l_debug_level3);
6602: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
6603: l_debug_level3);
6604: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,

Line 6602: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,

6598: l_debug_level3);
6599:
6600: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
6601: l_debug_level3);
6602: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
6603: l_debug_level3);
6604: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
6605: l_debug_level3);
6606: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,

Line 6604: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,

6600: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
6601: l_debug_level3);
6602: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
6603: l_debug_level3);
6604: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
6605: l_debug_level3);
6606: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
6607: l_debug_level3);
6608: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,

Line 6606: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,

6602: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
6603: l_debug_level3);
6604: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
6605: l_debug_level3);
6606: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
6607: l_debug_level3);
6608: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
6609: l_debug_level3);
6610: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,

Line 6608: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,

6604: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
6605: l_debug_level3);
6606: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
6607: l_debug_level3);
6608: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
6609: l_debug_level3);
6610: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
6611: l_debug_level3);
6612: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,

Line 6610: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,

6606: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
6607: l_debug_level3);
6608: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
6609: l_debug_level3);
6610: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
6611: l_debug_level3);
6612: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
6613: l_debug_level3);
6614: END IF;

Line 6612: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,

6608: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
6609: l_debug_level3);
6610: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
6611: l_debug_level3);
6612: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
6613: l_debug_level3);
6614: END IF;
6615:
6616: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 6811: Pa_Debug.reset_curr_function;

6807:
6808: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls
6809: -- and it gives ORA 06512 numeric or value error
6810: IF l_debug_mode = 'Y' THEN
6811: Pa_Debug.reset_curr_function;
6812: END IF;
6813:
6814: EXCEPTION
6815:

Line 6858: Pa_Debug.reset_curr_function;

6854: x_msg_count := l_msg_count;
6855: END IF;
6856:
6857: IF l_debug_mode = 'Y' THEN
6858: Pa_Debug.reset_curr_function;
6859: END IF;
6860:
6861: WHEN Invalid_Arg_Exc_WP THEN
6862:

Line 6892: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

6888: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
6889: , p_error_text => x_msg_data);
6890:
6891: IF l_debug_mode = 'Y' THEN
6892: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6893: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6894: l_debug_level5);
6895: Pa_Debug.reset_curr_function;
6896: END IF;

Line 6893: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6889: , p_error_text => x_msg_data);
6890:
6891: IF l_debug_mode = 'Y' THEN
6892: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6893: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6894: l_debug_level5);
6895: Pa_Debug.reset_curr_function;
6896: END IF;
6897: RAISE;

Line 6895: Pa_Debug.reset_curr_function;

6891: IF l_debug_mode = 'Y' THEN
6892: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6893: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6894: l_debug_level5);
6895: Pa_Debug.reset_curr_function;
6896: END IF;
6897: RAISE;
6898:
6899: WHEN OTHERS THEN

Line 6930: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

6926: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
6927: , p_error_text => x_msg_data);
6928:
6929: IF l_debug_mode = 'Y' THEN
6930: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6931: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6932: l_debug_level5);
6933:
6934: Pa_Debug.reset_curr_function;

Line 6931: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,

6927: , p_error_text => x_msg_data);
6928:
6929: IF l_debug_mode = 'Y' THEN
6930: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6931: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6932: l_debug_level5);
6933:
6934: Pa_Debug.reset_curr_function;
6935: END IF;

Line 6934: Pa_Debug.reset_curr_function;

6930: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6931: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6932: l_debug_level5);
6933:
6934: Pa_Debug.reset_curr_function;
6935: END IF;
6936: RAISE;
6937: END SYNC_UP_WP_TASKS_WITH_FIN ;
6938: