eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASKS_MAINT_PUB dependencies on PA_DEBUG

Line 273: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.CREATE_TASK');

269: BEGIN
270:
271: pa_tasks_maint_utils.set_org_id(p_project_id);
272:
273: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.CREATE_TASK');
274:
275: IF (p_debug_mode = 'Y') THEN
276: pa_debug.debug('PA_TASKS_MAINT_PUB.CREATE_TASK begin');
277: END IF;

Line 276: pa_debug.debug('PA_TASKS_MAINT_PUB.CREATE_TASK begin');

272:
273: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.CREATE_TASK');
274:
275: IF (p_debug_mode = 'Y') THEN
276: pa_debug.debug('PA_TASKS_MAINT_PUB.CREATE_TASK begin');
277: END IF;
278:
279: IF p_commit = FND_API.G_TRUE THEN
280: savepoint CREATE_TASK;

Line 288: pa_debug.debug('Performing ID validations and conversions');

284: raise FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
288: pa_debug.debug('Performing ID validations and conversions');
289: FND_MSG_PUB.initialize;
290: END IF;
291:
292: --BEGIN VALIDATIONS

Line 601: pa_debug.debug('PA_TASKS_MAINT_PUB.CREATE_TASK END');

597: commit;
598: END IF;
599:
600: IF (p_debug_mode = 'Y') THEN
601: pa_debug.debug('PA_TASKS_MAINT_PUB.CREATE_TASK END');
602: END IF;
603:
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN

Line 929: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.UPDATE_TASK');

925:
926: BEGIN
927: pa_tasks_maint_utils.set_org_id(p_project_id);
928:
929: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.UPDATE_TASK');
930:
931: IF (p_debug_mode = 'Y') THEN
932: pa_debug.debug('PA_TASKS_MAINT_PUB.UPDATE_TASK begin');
933: END IF;

Line 932: pa_debug.debug('PA_TASKS_MAINT_PUB.UPDATE_TASK begin');

928:
929: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.UPDATE_TASK');
930:
931: IF (p_debug_mode = 'Y') THEN
932: pa_debug.debug('PA_TASKS_MAINT_PUB.UPDATE_TASK begin');
933: END IF;
934:
935: IF p_commit = FND_API.G_TRUE THEN
936: savepoint UPDATE_TASK;

Line 944: pa_debug.debug('Performing ID validations and conversions');

940: raise FND_API.G_EXC_UNEXPECTED_ERROR;
941: END IF;
942:
943: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
944: pa_debug.debug('Performing ID validations and conversions');
945: FND_MSG_PUB.initialize;
946: END IF;
947:
948: --BEGIN VALIDATIONS

Line 1230: pa_debug.debug('PA_TASKS_MAINT_PUB.UPDATE_TASK END');

1226: commit;
1227: END IF;
1228:
1229: IF (p_debug_mode = 'Y') THEN
1230: pa_debug.debug('PA_TASKS_MAINT_PUB.UPDATE_TASK END');
1231: END IF;
1232:
1233: EXCEPTION
1234: WHEN FND_API.G_EXC_ERROR THEN

Line 1336: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.DELETE_TASK');

1332: BEGIN
1333: pa_tasks_maint_utils.set_org_id(p_project_id);
1334:
1335:
1336: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.DELETE_TASK');
1337:
1338: IF (p_debug_mode = 'Y') THEN
1339: pa_debug.debug('PA_TASKS_MAINT_PUB.DELETE_TASK begin');
1340: END IF;

Line 1339: pa_debug.debug('PA_TASKS_MAINT_PUB.DELETE_TASK begin');

1335:
1336: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.DELETE_TASK');
1337:
1338: IF (p_debug_mode = 'Y') THEN
1339: pa_debug.debug('PA_TASKS_MAINT_PUB.DELETE_TASK begin');
1340: END IF;
1341:
1342: IF (p_commit = FND_API.G_TRUE) THEN
1343: savepoint DELETE_TASK;

Line 1352: pa_debug.debug('Performing ID validations and conversions');

1348: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1349: END IF;
1350:
1351: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
1352: pa_debug.debug('Performing ID validations and conversions');
1353: FND_MSG_PUB.initialize;
1354: END IF;
1355:
1356: --Check if there is any error

Line 1461: pa_debug.debug('PA_TASKS_MAINT_PUB.DELETE_TASK END');

1457: commit;
1458: END IF;
1459:
1460: IF (p_debug_mode = 'Y') THEN
1461: pa_debug.debug('PA_TASKS_MAINT_PUB.DELETE_TASK END');
1462: END IF;
1463:
1464: EXCEPTION
1465: WHEN FND_API.G_EXC_ERROR THEN

Line 1552: pa_debug.debug('Edit Task Structure PUB : Checking the api version number.');

1548:
1549: -- Standard call to check for call compatibility
1550: IF (p_debug_mode = 'Y')
1551: THEN
1552: pa_debug.debug('Edit Task Structure PUB : Checking the api version number.');
1553: END IF;
1554:
1555: IF p_commit = FND_API.G_TRUE
1556: THEN

Line 1570: pa_debug.debug('Edit Task Structure PUB : Initializing message stack.');

1566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1567: END IF;
1568:
1569: if (p_debug_mode = 'Y') then
1570: pa_debug.debug('Edit Task Structure PUB : Initializing message stack.');
1571: end if;
1572:
1573: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.Edit_Task_Structure');
1574:

Line 1573: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.Edit_Task_Structure');

1569: if (p_debug_mode = 'Y') then
1570: pa_debug.debug('Edit Task Structure PUB : Initializing message stack.');
1571: end if;
1572:
1573: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.Edit_Task_Structure');
1574:
1575: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1576: fnd_msg_pub.initialize;
1577: end if;

Line 1715: pa_debug.debug('Edit Task Structure PUB : checking message count');

1711: --dbms_output.put_line( 'After Edit Task structure. ' );
1712:
1713:
1714: if (p_debug_mode = 'Y') then
1715: pa_debug.debug('Edit Task Structure PUB : checking message count');
1716: end if;
1717: l_msg_count := FND_MSG_PUB.count_msg;
1718:
1719: If l_msg_count > 0 THEN

Line 1856: pa_debug.debug('Move Task PUB : Checking the api version number.');

1852:
1853: -- Standard call to check for call compatibility
1854: IF (p_debug_mode = 'Y')
1855: THEN
1856: pa_debug.debug('Move Task PUB : Checking the api version number.');
1857: END IF;
1858: IF p_commit = FND_API.G_TRUE
1859: THEN
1860: SAVEPOINT Move;

Line 1870: pa_debug.debug('Move Task PUB : Initializing message stack.');

1866: THEN
1867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1868: END IF;
1869: if (p_debug_mode = 'Y') then
1870: pa_debug.debug('Move Task PUB : Initializing message stack.');
1871: end if;
1872: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.MOVE_TASK');
1873: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1874: fnd_msg_pub.initialize;

Line 1872: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.MOVE_TASK');

1868: END IF;
1869: if (p_debug_mode = 'Y') then
1870: pa_debug.debug('Move Task PUB : Initializing message stack.');
1871: end if;
1872: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.MOVE_TASK');
1873: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1874: fnd_msg_pub.initialize;
1875: end if;
1876:

Line 1998: pa_debug.debug('Move Task PUB : checking message count');

1994:
1995: --dbms_output.put_line( 'After locking 2 ' );
1996:
1997: if (p_debug_mode = 'Y') then
1998: pa_debug.debug('Move Task PUB : checking message count');
1999: end if;
2000:
2001: l_msg_count := FND_MSG_PUB.count_msg;
2002:

Line 2040: pa_debug.debug('Move Task PUB : checking message count');

2036: ,x_msg_count => l_msg_count
2037: ,x_msg_data => l_msg_data );
2038:
2039: if (p_debug_mode = 'Y') then
2040: pa_debug.debug('Move Task PUB : checking message count');
2041: end if;
2042: l_msg_count := FND_MSG_PUB.count_msg;
2043:
2044:

Line 2189: pa_debug.debug('Copy Task PUB : Checking the api version number.');

2185: pa_tasks_maint_utils.set_org_id(p_project_id);
2186: -- Standard call to check for call compatibility
2187: IF (p_debug_mode = 'Y')
2188: THEN
2189: pa_debug.debug('Copy Task PUB : Checking the api version number.');
2190: END IF;
2191: IF p_commit = FND_API.G_TRUE
2192: THEN
2193: SAVEPOINT Copy;

Line 2203: pa_debug.debug('Copy Task PUB : Initializing message stack.');

2199: THEN
2200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2201: END IF;
2202: if (p_debug_mode = 'Y') then
2203: pa_debug.debug('Copy Task PUB : Initializing message stack.');
2204: end if;
2205: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.COPY_TASK');
2206: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2207: fnd_msg_pub.initialize;

Line 2205: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.COPY_TASK');

2201: END IF;
2202: if (p_debug_mode = 'Y') then
2203: pa_debug.debug('Copy Task PUB : Initializing message stack.');
2204: end if;
2205: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.COPY_TASK');
2206: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2207: fnd_msg_pub.initialize;
2208: end if;
2209:

Line 2386: pa_debug.debug('Edit Task Structure PUB : checking message count');

2382:
2383: END IF;
2384:
2385: if (p_debug_mode = 'Y') then
2386: pa_debug.debug('Edit Task Structure PUB : checking message count');
2387: end if;
2388: l_msg_count := FND_MSG_PUB.count_msg;
2389:
2390:

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

2662: --Delete the elements from the table, if any
2663: l_task_version_id_tbl.DELETE;
2664:
2665: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
2666: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2667: l_user_id := fnd_global.user_id;
2668: l_login_id := fnd_global.login_id;
2669: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
2670:

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

2665: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
2666: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2667: l_user_id := fnd_global.user_id;
2668: l_login_id := fnd_global.login_id;
2669: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
2670:
2671: --l_debug_mode := NVL(p_debug_mode,'N');
2672: IF l_debug_mode = 'Y' THEN
2673: PA_DEBUG.set_curr_function( p_function => 'SET_FINANCIAL_FLAG_WRAPPER',

Line 2673: PA_DEBUG.set_curr_function( p_function => 'SET_FINANCIAL_FLAG_WRAPPER',

2669: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
2670:
2671: --l_debug_mode := NVL(p_debug_mode,'N');
2672: IF l_debug_mode = 'Y' THEN
2673: PA_DEBUG.set_curr_function( p_function => 'SET_FINANCIAL_FLAG_WRAPPER',
2674: p_debug_mode => l_debug_mode );
2675: END IF;
2676:
2677: IF l_debug_mode = 'Y' THEN

Line 2679: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Printing Input parameters';

2675: END IF;
2676:
2677: IF l_debug_mode = 'Y' THEN
2678:
2679: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Printing Input parameters';
2680:
2681: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2682: l_debug_level3);
2683: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,

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

2677: IF l_debug_mode = 'Y' THEN
2678:
2679: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Printing Input parameters';
2680:
2681: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2682: l_debug_level3);
2683: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
2684: l_debug_level3);
2685: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,

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

2679: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Printing Input parameters';
2680:
2681: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2682: l_debug_level3);
2683: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
2684: l_debug_level3);
2685: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
2686: l_debug_level3);
2687: Pa_Debug.WRITE(g_pkg_name,'p_record_version_number'||':'||p_record_version_number,

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

2681: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2682: l_debug_level3);
2683: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
2684: l_debug_level3);
2685: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
2686: l_debug_level3);
2687: Pa_Debug.WRITE(g_pkg_name,'p_record_version_number'||':'||p_record_version_number,
2688: l_debug_level3);
2689: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,

Line 2687: Pa_Debug.WRITE(g_pkg_name,'p_record_version_number'||':'||p_record_version_number,

2683: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,
2684: l_debug_level3);
2685: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
2686: l_debug_level3);
2687: Pa_Debug.WRITE(g_pkg_name,'p_record_version_number'||':'||p_record_version_number,
2688: l_debug_level3);
2689: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
2690: l_debug_level3);
2691: Pa_Debug.WRITE(g_pkg_name,'p_published_version_exists'||':'||p_published_version_exists,

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

2685: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag'||':'||p_checked_flag,
2686: l_debug_level3);
2687: Pa_Debug.WRITE(g_pkg_name,'p_record_version_number'||':'||p_record_version_number,
2688: l_debug_level3);
2689: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
2690: l_debug_level3);
2691: Pa_Debug.WRITE(g_pkg_name,'p_published_version_exists'||':'||p_published_version_exists,
2692: l_debug_level3);
2693: END IF;

Line 2691: Pa_Debug.WRITE(g_pkg_name,'p_published_version_exists'||':'||p_published_version_exists,

2687: Pa_Debug.WRITE(g_pkg_name,'p_record_version_number'||':'||p_record_version_number,
2688: l_debug_level3);
2689: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
2690: l_debug_level3);
2691: Pa_Debug.WRITE(g_pkg_name,'p_published_version_exists'||':'||p_published_version_exists,
2692: l_debug_level3);
2693: END IF;
2694:
2695: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 2704: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Validating Input parameters';

2700: savepoint SET_FIN_FLAG_WRAPPER_PUBLIC;
2701: END IF;
2702:
2703: IF l_debug_mode = 'Y' THEN
2704: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Validating Input parameters';
2705: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2706: l_debug_level3);
2707: END IF;
2708:

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

2701: END IF;
2702:
2703: IF l_debug_mode = 'Y' THEN
2704: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Validating Input parameters';
2705: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2706: l_debug_level3);
2707: END IF;
2708:
2709: IF (

Line 2718: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : At least one of the mandatory IN parameters are passed as NULL';

2714: p_published_version_exists IS NULL
2715: )
2716: THEN
2717: IF l_debug_mode = 'Y' THEN
2718: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : At least one of the mandatory IN parameters are passed as NULL';
2719: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2720: l_debug_level3);
2721: END IF;
2722: RAISE Invalid_Arg_Exc_WP;

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

2715: )
2716: THEN
2717: IF l_debug_mode = 'Y' THEN
2718: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : At least one of the mandatory IN parameters are passed as NULL';
2719: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2720: l_debug_level3);
2721: END IF;
2722: RAISE Invalid_Arg_Exc_WP;
2723: END IF;

Line 2726: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Calling set_unset_financial_task';

2722: RAISE Invalid_Arg_Exc_WP;
2723: END IF;
2724:
2725: IF l_debug_mode = 'Y' THEN
2726: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Calling set_unset_financial_task';
2727: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2728: l_debug_level3);
2729: END IF;
2730: --This part of code is common whether p_checked_flag is 'Y' or 'N'

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

2723: END IF;
2724:
2725: IF l_debug_mode = 'Y' THEN
2726: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Calling set_unset_financial_task';
2727: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2728: l_debug_level3);
2729: END IF;
2730: --This part of code is common whether p_checked_flag is 'Y' or 'N'
2731: --Call API to set/unset financial_flag for p_task_version_id depending on p_checked_flag.

Line 2982: Pa_Debug.reset_curr_function;

2978: END IF;
2979: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls
2980: -- and it gives ORA 06512 numeric or value error
2981: IF l_debug_mode = 'Y' THEN
2982: Pa_Debug.reset_curr_function;
2983: END IF;
2984:
2985: EXCEPTION
2986:

Line 3027: Pa_Debug.reset_curr_function;

3023: x_msg_count := l_msg_count;
3024: END IF;
3025:
3026: IF l_debug_mode = 'Y' THEN
3027: Pa_Debug.reset_curr_function;
3028: END IF;
3029:
3030: WHEN Invalid_Arg_Exc_WP THEN
3031:

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

3054: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3055: , p_error_text => x_msg_data);
3056:
3057: IF l_debug_mode = 'Y' THEN
3058: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3059: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3060: l_debug_level5);
3061: Pa_Debug.reset_curr_function;
3062: END IF;

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

3055: , p_error_text => x_msg_data);
3056:
3057: IF l_debug_mode = 'Y' THEN
3058: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3059: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3060: l_debug_level5);
3061: Pa_Debug.reset_curr_function;
3062: END IF;
3063: RAISE;

Line 3061: Pa_Debug.reset_curr_function;

3057: IF l_debug_mode = 'Y' THEN
3058: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3059: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3060: l_debug_level5);
3061: Pa_Debug.reset_curr_function;
3062: END IF;
3063: RAISE;
3064:
3065: WHEN OTHERS THEN

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

3091: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3092: , p_error_text => x_msg_data);
3093:
3094: IF l_debug_mode = 'Y' THEN
3095: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3096: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3097: l_debug_level5);
3098:
3099: Pa_Debug.reset_curr_function;

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

3092: , p_error_text => x_msg_data);
3093:
3094: IF l_debug_mode = 'Y' THEN
3095: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3096: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3097: l_debug_level5);
3098:
3099: Pa_Debug.reset_curr_function;
3100:

Line 3099: Pa_Debug.reset_curr_function;

3095: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3096: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3097: l_debug_level5);
3098:
3099: Pa_Debug.reset_curr_function;
3100:
3101: END IF;
3102: RAISE;
3103: END SET_FINANCIAL_FLAG_WRAPPER ;

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

3248:
3249: x_msg_count := 0;
3250: x_return_status := FND_API.G_RET_STS_SUCCESS;
3251:
3252: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3253: --l_debug_mode := NVL(p_debug_mode,'N');
3254: IF l_debug_mode = 'Y' THEN
3255: PA_DEBUG.set_curr_function( p_function => 'POPULATE_TEMP_TABLE',
3256: p_debug_mode => l_debug_mode );

Line 3255: PA_DEBUG.set_curr_function( p_function => 'POPULATE_TEMP_TABLE',

3251:
3252: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3253: --l_debug_mode := NVL(p_debug_mode,'N');
3254: IF l_debug_mode = 'Y' THEN
3255: PA_DEBUG.set_curr_function( p_function => 'POPULATE_TEMP_TABLE',
3256: p_debug_mode => l_debug_mode );
3257: END IF;
3258:
3259:

Line 3262: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB:POPULATE_TEMP_TABLE:Printing Input parameters';

3258:
3259:
3260:
3261: IF l_debug_mode = 'Y' THEN
3262: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB:POPULATE_TEMP_TABLE:Printing Input parameters';
3263: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3264: l_debug_level3);
3265: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'||p_structure_version_id,
3266: l_debug_level3);

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

3259:
3260:
3261: IF l_debug_mode = 'Y' THEN
3262: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB:POPULATE_TEMP_TABLE:Printing Input parameters';
3263: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3264: l_debug_level3);
3265: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'||p_structure_version_id,
3266: l_debug_level3);
3267: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,

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

3261: IF l_debug_mode = 'Y' THEN
3262: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB:POPULATE_TEMP_TABLE:Printing Input parameters';
3263: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3264: l_debug_level3);
3265: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'||p_structure_version_id,
3266: l_debug_level3);
3267: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
3268: l_debug_level3);
3269: END IF;

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

3263: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3264: l_debug_level3);
3265: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'||p_structure_version_id,
3266: l_debug_level3);
3267: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
3268: l_debug_level3);
3269: END IF;
3270:
3271: --Delete all elements from temporary table first.

Line 3304: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : Validating Input parameters';

3300: savepoint POPULATE_TEMP_TBL_PUB;
3301: END IF;
3302:
3303: IF l_debug_mode = 'Y' THEN
3304: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : Validating Input parameters';
3305: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3306: l_debug_level3);
3307: END IF;
3308:

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

3301: END IF;
3302:
3303: IF l_debug_mode = 'Y' THEN
3304: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : Validating Input parameters';
3305: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3306: l_debug_level3);
3307: END IF;
3308:
3309: IF (

Line 3316: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : At least one of the mandatory IN parameters are passed as NULL';

3312: ( p_project_id IS NULL )
3313: )
3314: THEN
3315: IF l_debug_mode = 'Y' THEN
3316: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : At least one of the mandatory IN parameters are passed as NULL';
3317: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3318: l_debug_level3);
3319: END IF;
3320: RAISE Invalid_Arg_Exc_WP;

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

3313: )
3314: THEN
3315: IF l_debug_mode = 'Y' THEN
3316: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : At least one of the mandatory IN parameters are passed as NULL';
3317: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3318: l_debug_level3);
3319: END IF;
3320: RAISE Invalid_Arg_Exc_WP;
3321: END IF;

Line 3455: Pa_Debug.reset_curr_function;

3451: ELSE
3452: x_msg_count := l_msg_count;
3453: END IF;
3454: IF l_debug_mode = 'Y' THEN
3455: Pa_Debug.reset_curr_function;
3456: END IF;
3457:
3458: WHEN Invalid_Arg_Exc_WP THEN
3459:

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

3476: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3477: , p_error_text => x_msg_data);
3478:
3479: IF l_debug_mode = 'Y' THEN
3480: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3481: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3482: l_debug_level5);
3483: Pa_Debug.reset_curr_function;
3484: END IF;

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

3477: , p_error_text => x_msg_data);
3478:
3479: IF l_debug_mode = 'Y' THEN
3480: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3481: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3482: l_debug_level5);
3483: Pa_Debug.reset_curr_function;
3484: END IF;
3485: RAISE;

Line 3483: Pa_Debug.reset_curr_function;

3479: IF l_debug_mode = 'Y' THEN
3480: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3481: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3482: l_debug_level5);
3483: Pa_Debug.reset_curr_function;
3484: END IF;
3485: RAISE;
3486:
3487: WHEN OTHERS THEN

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

3506: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3507: , p_error_text => x_msg_data);
3508:
3509: IF l_debug_mode = 'Y' THEN
3510: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3511: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3512: l_debug_level5);
3513: Pa_Debug.reset_curr_function;
3514: END IF;

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

3507: , p_error_text => x_msg_data);
3508:
3509: IF l_debug_mode = 'Y' THEN
3510: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3511: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3512: l_debug_level5);
3513: Pa_Debug.reset_curr_function;
3514: END IF;
3515: RAISE;

Line 3513: Pa_Debug.reset_curr_function;

3509: IF l_debug_mode = 'Y' THEN
3510: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3511: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3512: l_debug_level5);
3513: Pa_Debug.reset_curr_function;
3514: END IF;
3515: RAISE;
3516: END POPULATE_TEMP_TABLE ;
3517:

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

3579: x_msg_count := 0;
3580: x_return_status := FND_API.G_RET_STS_SUCCESS;
3581:
3582: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
3583: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3584: l_user_id := fnd_global.user_id;
3585: l_login_id := fnd_global.login_id;
3586: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
3587:

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

3582: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
3583: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3584: l_user_id := fnd_global.user_id;
3585: l_login_id := fnd_global.login_id;
3586: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
3587:
3588: --l_debug_mode := NVL(p_debug_mode,'N');
3589: IF l_debug_mode = 'Y' THEN
3590: PA_DEBUG.set_curr_function( p_function => 'SYNC_UP_WP_TASKS_WITH_FIN',

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

3586: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
3587:
3588: --l_debug_mode := NVL(p_debug_mode,'N');
3589: IF l_debug_mode = 'Y' THEN
3590: PA_DEBUG.set_curr_function( p_function => 'SYNC_UP_WP_TASKS_WITH_FIN',
3591: p_debug_mode => l_debug_mode );
3592: END IF;
3593:
3594: IF l_debug_mode = 'Y' THEN

Line 3595: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';

3591: p_debug_mode => l_debug_mode );
3592: END IF;
3593:
3594: IF l_debug_mode = 'Y' THEN
3595: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
3596: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3597: l_debug_level3);
3598: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
3599: l_debug_level3);

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

3592: END IF;
3593:
3594: IF l_debug_mode = 'Y' THEN
3595: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
3596: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3597: l_debug_level3);
3598: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
3599: l_debug_level3);
3600: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,

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

3594: IF l_debug_mode = 'Y' THEN
3595: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
3596: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3597: l_debug_level3);
3598: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
3599: l_debug_level3);
3600: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
3601: l_debug_level3);
3602: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,

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

3596: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3597: l_debug_level3);
3598: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
3599: l_debug_level3);
3600: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
3601: l_debug_level3);
3602: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
3603: l_debug_level3);
3604: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,

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

3598: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
3599: l_debug_level3);
3600: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
3601: l_debug_level3);
3602: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
3603: l_debug_level3);
3604: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
3605: l_debug_level3);
3606: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,

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

3600: Pa_Debug.WRITE(g_pkg_name,'p_syncup_all_tasks'||':'||p_syncup_all_tasks,
3601: l_debug_level3);
3602: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
3603: l_debug_level3);
3604: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
3605: l_debug_level3);
3606: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
3607: l_debug_level3);
3608: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,

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

3602: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'|| p_task_version_id ,
3603: l_debug_level3);
3604: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
3605: l_debug_level3);
3606: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
3607: l_debug_level3);
3608: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
3609: l_debug_level3);
3610: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,

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

3604: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'|| p_structure_version_id,
3605: l_debug_level3);
3606: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
3607: l_debug_level3);
3608: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
3609: l_debug_level3);
3610: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
3611: l_debug_level3);
3612: Pa_Debug.WRITE(g_pkg_name,'p_patask_record_version_number'||':'||p_patask_record_version_number,

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

3606: Pa_Debug.WRITE(g_pkg_name,'p_checked_flag '||':'||p_checked_flag ,
3607: l_debug_level3);
3608: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
3609: l_debug_level3);
3610: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
3611: l_debug_level3);
3612: Pa_Debug.WRITE(g_pkg_name,'p_patask_record_version_number'||':'||p_patask_record_version_number,
3613: l_debug_level3);
3614: END IF;

Line 3612: Pa_Debug.WRITE(g_pkg_name,'p_patask_record_version_number'||':'||p_patask_record_version_number,

3608: Pa_Debug.WRITE(g_pkg_name,'p_mode'||':'||p_mode,
3609: l_debug_level3);
3610: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
3611: l_debug_level3);
3612: Pa_Debug.WRITE(g_pkg_name,'p_patask_record_version_number'||':'||p_patask_record_version_number,
3613: l_debug_level3);
3614: END IF;
3615:
3616: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 3625: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Validating Input parameters';

3621: savepoint SYNC_UP_WITH_FIN_PUBLIC;
3622: END IF;
3623:
3624: IF l_debug_mode = 'Y' THEN
3625: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Validating Input parameters';
3626: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3627: l_debug_level3);
3628: END IF;
3629:

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

3622: END IF;
3623:
3624: IF l_debug_mode = 'Y' THEN
3625: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Validating Input parameters';
3626: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3627: l_debug_level3);
3628: END IF;
3629:
3630: IF ( p_project_id IS NULL)

Line 3633: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Mandatory parameters are null';

3629:
3630: IF ( p_project_id IS NULL)
3631: THEN
3632: IF l_debug_mode = 'Y' THEN
3633: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Mandatory parameters are null';
3634: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3635: l_debug_level3);
3636: END IF;
3637: RAISE Invalid_Arg_Exc_WP;

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

3630: IF ( p_project_id IS NULL)
3631: THEN
3632: IF l_debug_mode = 'Y' THEN
3633: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Mandatory parameters are null';
3634: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3635: l_debug_level3);
3636: END IF;
3637: RAISE Invalid_Arg_Exc_WP;
3638: END IF;

Line 3644: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : p_mode is invalid';

3640: --Validating for p_mode, it shopuld be either SINGLE or ALL
3641: /*IF (p_mode <> 'SINGLE' OR p_mode <> 'ALL')
3642: THEN
3643: IF l_debug_mode = 'Y' THEN
3644: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : p_mode is invalid';
3645: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3646: l_debug_level3);
3647: END IF;
3648: RAISE Invalid_Arg_Exc_WP;

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

3641: /*IF (p_mode <> 'SINGLE' OR p_mode <> 'ALL')
3642: THEN
3643: IF l_debug_mode = 'Y' THEN
3644: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : p_mode is invalid';
3645: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3646: l_debug_level3);
3647: END IF;
3648: RAISE Invalid_Arg_Exc_WP;
3649: END IF;*/

Line 3659: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Manadatory parameters with mode '||p_mode||'are not passed';

3655: )
3656: )
3657: THEN
3658: IF l_debug_mode = 'Y' THEN
3659: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Manadatory parameters with mode '||p_mode||'are not passed';
3660: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3661: l_debug_level3);
3662: END IF;
3663: RAISE Invalid_Arg_Exc_WP;

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

3656: )
3657: THEN
3658: IF l_debug_mode = 'Y' THEN
3659: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Manadatory parameters with mode '||p_mode||'are not passed';
3660: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3661: l_debug_level3);
3662: END IF;
3663: RAISE Invalid_Arg_Exc_WP;
3664: ELSIF ( ( p_mode = 'ALL')

Line 3670: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Manadatory parameters with mode '||p_mode||'are not passed';

3666: ( p_structure_version_id IS NULL OR p_structure_version_id = FND_API.G_MISS_NUM )
3667: )
3668: THEN
3669: IF l_debug_mode = 'Y' THEN
3670: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Manadatory parameters with mode '||p_mode||'are not passed';
3671: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3672: l_debug_level3);
3673: END IF;
3674: RAISE Invalid_Arg_Exc_WP;

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

3667: )
3668: THEN
3669: IF l_debug_mode = 'Y' THEN
3670: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Manadatory parameters with mode '||p_mode||'are not passed';
3671: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3672: l_debug_level3);
3673: END IF;
3674: RAISE Invalid_Arg_Exc_WP;
3675: END IF;

Line 3707: Pa_Debug.reset_curr_function;

3703:
3704: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls
3705: -- and it gives ORA 06512 numeric or value error
3706: IF l_debug_mode = 'Y' THEN
3707: Pa_Debug.reset_curr_function;
3708: END IF;
3709:
3710: EXCEPTION
3711:

Line 3737: Pa_Debug.reset_curr_function;

3733: ELSE
3734: x_msg_count := l_msg_count;
3735: END IF;
3736: IF l_debug_mode = 'Y' THEN
3737: Pa_Debug.reset_curr_function;
3738: END IF;
3739:
3740: WHEN Invalid_Arg_Exc_WP THEN
3741:

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

3752: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3753: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3754: , p_error_text => x_msg_data);
3755: IF l_debug_mode = 'Y' THEN
3756: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3757: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3758: l_debug_level5);
3759:
3760: Pa_Debug.reset_curr_function;

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

3753: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3754: , p_error_text => x_msg_data);
3755: IF l_debug_mode = 'Y' THEN
3756: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3757: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3758: l_debug_level5);
3759:
3760: Pa_Debug.reset_curr_function;
3761: END IF;

Line 3760: Pa_Debug.reset_curr_function;

3756: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3757: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3758: l_debug_level5);
3759:
3760: Pa_Debug.reset_curr_function;
3761: END IF;
3762: RAISE;
3763:
3764: WHEN OTHERS THEN

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

3778: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3779: , p_error_text => x_msg_data);
3780:
3781: IF l_debug_mode = 'Y' THEN
3782: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3783: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3784: l_debug_level5);
3785: Pa_Debug.reset_curr_function;
3786: END IF;

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

3779: , p_error_text => x_msg_data);
3780:
3781: IF l_debug_mode = 'Y' THEN
3782: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3783: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3784: l_debug_level5);
3785: Pa_Debug.reset_curr_function;
3786: END IF;
3787: RAISE;

Line 3785: Pa_Debug.reset_curr_function;

3781: IF l_debug_mode = 'Y' THEN
3782: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3783: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3784: l_debug_level5);
3785: Pa_Debug.reset_curr_function;
3786: END IF;
3787: RAISE;
3788: END SYNC_UP_WP_TASKS_WITH_FIN ;
3789: