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 2295: pa_debug.debug('PA_TASKS_MAINT_PVT.UPDATE_TASK BEGIN');

2291:
2292: BEGIN
2293:
2294: IF (p_debug_mode = 'Y') THEN
2295: pa_debug.debug('PA_TASKS_MAINT_PVT.UPDATE_TASK BEGIN');
2296: END IF;
2297:
2298: IF (p_commit = FND_API.G_TRUE) THEN
2299: savepoint UPDATE_TASK_PRIVATE;

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

2299: savepoint UPDATE_TASK_PRIVATE;
2300: END IF;
2301:
2302: IF (p_debug_mode = 'Y') THEN
2303: pa_debug.debug('Performing validations');
2304: END IF;
2305:
2306: IF (p_calling_module IN ('FORMS', 'EXCHANGE', 'SELF_SERVICE')) THEN
2307: --check if task_name is null

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

3381: t_pm_product_code PA_TASKS.PM_PRODUCT_CODE%TYPE;
3382: t_parent_task_id PA_TASKS.PARENT_TASK_ID%TYPE;
3383: BEGIN
3384: IF (p_debug_mode = 'Y') THEN
3385: pa_debug.debug('PA_TASKS_MAINT_PVT.DELETE_TASK BEGIN');
3386: END IF;
3387:
3388: IF (p_commit = FND_API.G_TRUE) THEN
3389: savepoint DELETE_TASK_PRIVATE;

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

3389: savepoint DELETE_TASK_PRIVATE;
3390: END IF;
3391:
3392: IF (p_debug_mode = 'Y') THEN
3393: pa_debug.debug('Performing validations');
3394: END IF;
3395:
3396: -- Get PM_PRODUCT_CODE
3397: BEGIN

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

6113: x_msg_count := 0;
6114: x_return_status := FND_API.G_RET_STS_SUCCESS;
6115:
6116: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6117: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6118: l_user_id := fnd_global.user_id;
6119: l_login_id := fnd_global.login_id;
6120: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6121:

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

6116: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6117: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6118: l_user_id := fnd_global.user_id;
6119: l_login_id := fnd_global.login_id;
6120: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6121:
6122: --l_debug_mode := NVL(p_debug_mode,'N');
6123: IF l_debug_mode = 'Y' THEN
6124: PA_DEBUG.set_curr_function( p_function => 'SET_UNSET_FINANCIAL_TASK',

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

6120: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6121:
6122: --l_debug_mode := NVL(p_debug_mode,'N');
6123: IF l_debug_mode = 'Y' THEN
6124: PA_DEBUG.set_curr_function( p_function => 'SET_UNSET_FINANCIAL_TASK',
6125: p_debug_mode => l_debug_mode );
6126: END IF;
6127:
6128: IF l_debug_mode = 'Y' THEN

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

6125: p_debug_mode => l_debug_mode );
6126: END IF;
6127:
6128: IF l_debug_mode = 'Y' THEN
6129: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';
6130: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6131: l_debug_level3);
6132:
6133: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,

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

6126: END IF;
6127:
6128: IF l_debug_mode = 'Y' THEN
6129: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';
6130: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6131: l_debug_level3);
6132:
6133: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
6134: l_debug_level3);

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

6129: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';
6130: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6131: l_debug_level3);
6132:
6133: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
6134: l_debug_level3);
6135: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
6136: l_debug_level3);
6137: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,

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

6131: l_debug_level3);
6132:
6133: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
6134: l_debug_level3);
6135: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
6136: l_debug_level3);
6137: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
6138: l_debug_level3);
6139: END IF;

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

6133: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
6134: l_debug_level3);
6135: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
6136: l_debug_level3);
6137: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
6138: l_debug_level3);
6139: END IF;
6140:
6141: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

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

6147: --savepoint SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6148: END IF;
6149:
6150: IF l_debug_mode = 'Y' THEN
6151: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Validating Input parameters';
6152: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6153: l_debug_level3);
6154: END IF;
6155:

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

6148: END IF;
6149:
6150: IF l_debug_mode = 'Y' THEN
6151: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Validating Input parameters';
6152: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6153: l_debug_level3);
6154: END IF;
6155:
6156: IF (

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

6159: ( p_project_id IS NULL)
6160: )
6161: THEN
6162: IF l_debug_mode = 'Y' THEN
6163: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Both p_task_version_id and p_checked_flag are null';
6164: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6165: l_debug_level3);
6166: END IF;
6167: RAISE Invalid_Arg_Exc_WP;

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

6160: )
6161: THEN
6162: IF l_debug_mode = 'Y' THEN
6163: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Both p_task_version_id and p_checked_flag are null';
6164: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6165: l_debug_level3);
6166: END IF;
6167: RAISE Invalid_Arg_Exc_WP;
6168: END IF;

Line 6199: 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;

6195: IF (l_error_code <> 0) THEN
6196:
6197:
6198: IF l_debug_mode = 'Y' THEN
6199: 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;
6200: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6201: l_debug_level3);
6202: END IF;
6203: PA_UTILS.ADD_MESSAGE(

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

6196:
6197:
6198: IF l_debug_mode = 'Y' THEN
6199: 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;
6200: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6201: l_debug_level3);
6202: END IF;
6203: PA_UTILS.ADD_MESSAGE(
6204: p_app_short_name => 'PA'

Line 6232: Pa_Debug.reset_curr_function;

6228:
6229: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls
6230: -- and it gives ORA 06512 numeric or value error
6231: IF l_debug_mode = 'Y' THEN
6232: Pa_Debug.reset_curr_function;
6233: END IF;
6234:
6235: EXCEPTION
6236:

Line 6265: Pa_Debug.reset_curr_function;

6261: x_msg_count := l_msg_count;
6262: END IF;
6263:
6264: IF l_debug_mode = 'Y' THEN
6265: Pa_Debug.reset_curr_function;
6266: END IF;
6267:
6268: WHEN Invalid_Arg_Exc_WP THEN
6269:

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

6283: , p_procedure_name => 'SET_UNSET_FINANCIAL_TASK'
6284: , p_error_text => x_msg_data);
6285:
6286: IF l_debug_mode = 'Y' THEN
6287: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6288: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6289: l_debug_level5);
6290:
6291: Pa_Debug.reset_curr_function;

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

6284: , p_error_text => x_msg_data);
6285:
6286: IF l_debug_mode = 'Y' THEN
6287: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6288: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6289: l_debug_level5);
6290:
6291: Pa_Debug.reset_curr_function;
6292: END IF;

Line 6291: Pa_Debug.reset_curr_function;

6287: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6288: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6289: l_debug_level5);
6290:
6291: Pa_Debug.reset_curr_function;
6292: END IF;
6293: RAISE;
6294:
6295: WHEN OTHERS THEN

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

6312: , p_procedure_name => 'SET_UNSET_FINANCIAL_TASK'
6313: , p_error_text => x_msg_data);
6314:
6315: IF l_debug_mode = 'Y' THEN
6316: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6317: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6318: l_debug_level5);
6319: Pa_Debug.reset_curr_function;
6320: END IF;

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

6313: , p_error_text => x_msg_data);
6314:
6315: IF l_debug_mode = 'Y' THEN
6316: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6317: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6318: l_debug_level5);
6319: Pa_Debug.reset_curr_function;
6320: END IF;
6321: RAISE;

Line 6319: Pa_Debug.reset_curr_function;

6315: IF l_debug_mode = 'Y' THEN
6316: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6317: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6318: l_debug_level5);
6319: Pa_Debug.reset_curr_function;
6320: END IF;
6321: RAISE;
6322: END SET_UNSET_FINANCIAL_TASK ;
6323:

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

6481: x_msg_count := 0;
6482: x_return_status := FND_API.G_RET_STS_SUCCESS;
6483:
6484: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6485: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6486: l_user_id := fnd_global.user_id;
6487: l_login_id := fnd_global.login_id;
6488: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6489:

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

6484: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6485: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6486: l_user_id := fnd_global.user_id;
6487: l_login_id := fnd_global.login_id;
6488: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6489:
6490: --l_debug_mode := NVL(p_debug_mode,'N');
6491: IF l_debug_mode = 'Y' THEN
6492: PA_DEBUG.set_curr_function( p_function => 'SYNC_UP_WP_TASKS_WITH_FIN',

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

6488: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6489:
6490: --l_debug_mode := NVL(p_debug_mode,'N');
6491: IF l_debug_mode = 'Y' THEN
6492: PA_DEBUG.set_curr_function( p_function => 'SYNC_UP_WP_TASKS_WITH_FIN',
6493: p_debug_mode => l_debug_mode );
6494: END IF;
6495:
6496: IF l_debug_mode = 'Y' THEN

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

6493: p_debug_mode => l_debug_mode );
6494: END IF;
6495:
6496: IF l_debug_mode = 'Y' THEN
6497: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
6498: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6499: l_debug_level3);
6500:
6501: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,

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

6494: END IF;
6495:
6496: IF l_debug_mode = 'Y' THEN
6497: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
6498: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6499: l_debug_level3);
6500:
6501: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
6502: l_debug_level3);

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

6497: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
6498: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6499: l_debug_level3);
6500:
6501: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
6502: l_debug_level3);
6503: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
6504: l_debug_level3);
6505: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,

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

6499: l_debug_level3);
6500:
6501: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
6502: l_debug_level3);
6503: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
6504: l_debug_level3);
6505: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
6506: l_debug_level3);
6507: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,

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

6501: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
6502: l_debug_level3);
6503: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
6504: l_debug_level3);
6505: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
6506: l_debug_level3);
6507: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
6508: l_debug_level3);
6509: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,

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

6503: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
6504: l_debug_level3);
6505: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
6506: l_debug_level3);
6507: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
6508: l_debug_level3);
6509: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
6510: l_debug_level3);
6511: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,

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

6505: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
6506: l_debug_level3);
6507: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
6508: l_debug_level3);
6509: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
6510: l_debug_level3);
6511: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
6512: l_debug_level3);
6513: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,

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

6507: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
6508: l_debug_level3);
6509: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
6510: l_debug_level3);
6511: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
6512: l_debug_level3);
6513: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
6514: l_debug_level3);
6515: END IF;

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

6509: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
6510: l_debug_level3);
6511: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
6512: l_debug_level3);
6513: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
6514: l_debug_level3);
6515: END IF;
6516:
6517: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 6712: Pa_Debug.reset_curr_function;

6708:
6709: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls
6710: -- and it gives ORA 06512 numeric or value error
6711: IF l_debug_mode = 'Y' THEN
6712: Pa_Debug.reset_curr_function;
6713: END IF;
6714:
6715: EXCEPTION
6716:

Line 6759: Pa_Debug.reset_curr_function;

6755: x_msg_count := l_msg_count;
6756: END IF;
6757:
6758: IF l_debug_mode = 'Y' THEN
6759: Pa_Debug.reset_curr_function;
6760: END IF;
6761:
6762: WHEN Invalid_Arg_Exc_WP THEN
6763:

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

6789: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
6790: , p_error_text => x_msg_data);
6791:
6792: IF l_debug_mode = 'Y' THEN
6793: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6794: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6795: l_debug_level5);
6796: Pa_Debug.reset_curr_function;
6797: END IF;

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

6790: , p_error_text => x_msg_data);
6791:
6792: IF l_debug_mode = 'Y' THEN
6793: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6794: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6795: l_debug_level5);
6796: Pa_Debug.reset_curr_function;
6797: END IF;
6798: RAISE;

Line 6796: Pa_Debug.reset_curr_function;

6792: IF l_debug_mode = 'Y' THEN
6793: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6794: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6795: l_debug_level5);
6796: Pa_Debug.reset_curr_function;
6797: END IF;
6798: RAISE;
6799:
6800: WHEN OTHERS THEN

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

6827: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
6828: , p_error_text => x_msg_data);
6829:
6830: IF l_debug_mode = 'Y' THEN
6831: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6832: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6833: l_debug_level5);
6834:
6835: Pa_Debug.reset_curr_function;

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

6828: , p_error_text => x_msg_data);
6829:
6830: IF l_debug_mode = 'Y' THEN
6831: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6832: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6833: l_debug_level5);
6834:
6835: Pa_Debug.reset_curr_function;
6836: END IF;

Line 6835: Pa_Debug.reset_curr_function;

6831: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
6832: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6833: l_debug_level5);
6834:
6835: Pa_Debug.reset_curr_function;
6836: END IF;
6837: RAISE;
6838: END SYNC_UP_WP_TASKS_WITH_FIN ;
6839: