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_TASKS_MAINT_PUB

Line 1: package body PA_TASKS_MAINT_PUB as

1: package body PA_TASKS_MAINT_PUB as
2: /*$Header: PATSKSPB.pls 120.5.12010000.2 2008/09/17 16:08:47 bifernan ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'PA_TASKS_MAINT_PUB';
5: --begin add by rtarwat for FP.M developement

Line 4: g_pkg_name CONSTANT VARCHAR2(30):= 'PA_TASKS_MAINT_PUB';

1: package body PA_TASKS_MAINT_PUB as
2: /*$Header: PATSKSPB.pls 120.5.12010000.2 2008/09/17 16:08:47 bifernan ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'PA_TASKS_MAINT_PUB';
5: --begin add by rtarwat for FP.M developement
6: Invalid_Arg_Exc_WP Exception;
7: --begin add by rtarwat for FP.M developement
8: -- API Name: CREATE_TASK

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 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 617: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

613: ROLLBACK to CREATE_TASK;
614: END IF;
615: x_msg_count := FND_MSG_PUB.count_msg;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
618: p_procedure_name => 'CREATE_TASK',
619: p_error_text => substrb(SQLERRM,1,240));
620: RAISE;
621: END CREATE_TASK;

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 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 1247: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1243: END IF;
1244: x_msg_count := FND_MSG_PUB.count_msg;
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: --put message
1247: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1248: p_procedure_name => 'UPDATE_TASK',
1249: p_error_text => substrb(SQLERRM,1,240));
1250: -- RAISE;
1251: END UPDATE_TASK;

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 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 1477: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1473: ROLLBACK to DELETE_TASK;
1474: END IF;
1475: x_msg_count := FND_MSG_PUB.count_msg;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1478: p_procedure_name => 'DELETE_TASK',
1479: p_error_text => substrb(SQLERRM,1,240));
1480: END DELETE_TASK;
1481:

Line 1752: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1748: THEN
1749: ROLLBACK TO Edit_Structure;
1750: END IF;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1753: p_procedure_name => 'Edit_Task_Structure',
1754: p_error_text => SUBSTRB(SQLERRM,1,240));
1755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1756:

Line 1770: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1766: THEN
1767: ROLLBACK TO Edit_Structure;
1768: END IF;
1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1770: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1771: p_procedure_name => 'Edit_Task_Structure',
1772: p_error_text => SUBSTRB(SQLERRM,1,240));
1773: RAISE;
1774:

Line 2081: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2077: THEN
2078: ROLLBACK TO Move;
2079: END IF;
2080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2081: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2082: p_procedure_name => 'Move_Task',
2083: p_error_text => SUBSTRB(SQLERRM,1,240));
2084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2085:

Line 2099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2095: THEN
2096: ROLLBACK TO Move;
2097: END IF;
2098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2100: p_procedure_name => 'Move_Task',
2101: p_error_text => SUBSTRB(SQLERRM,1,240));
2102: RAISE;
2103:

Line 2425: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2421: THEN
2422: ROLLBACK TO Copy;
2423: END IF;
2424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2425: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2426: p_procedure_name => 'Copy_Task',
2427: p_error_text => SUBSTRB(SQLERRM,1,240));
2428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2429:

Line 2443: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2439: THEN
2440: ROLLBACK TO Copy;
2441: END IF;
2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2443: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2444: p_procedure_name => 'Copy_Task',
2445: p_error_text => SUBSTRB(SQLERRM,1,240));
2446: RAISE;
2447:

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 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 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 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 2885: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN

2881: FETCH c_get_immediate_parent INTO l_last_task_parent_id;
2882: IF (c_get_immediate_parent%NOTFOUND)
2883: THEN
2884: --if the parent is structure then then pass p_parent_task_version_id as null
2885: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN
2886: (
2887: p_api_version => 1.0
2888: , p_init_msg_list => FND_API.G_FALSE
2889: , p_commit => p_commit

Line 2917: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN

2913:
2914: ELSE
2915:
2916: --else pass the derived parent task version id
2917: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN
2918: (
2919: p_debug_mode => l_debug_mode
2920: , p_commit => p_commit
2921: , p_init_msg_list => FND_API.G_FALSE

Line 2951: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN

2947: THEN
2948:
2949: FOR iCounter IN REVERSE l_task_version_id_tbl.FIRST..l_task_version_id_tbl.LAST-1 LOOP
2950:
2951: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN
2952: (
2953: p_debug_mode => l_debug_mode
2954: , p_commit => p_commit
2955: , p_init_msg_list => FND_API.G_FALSE

Line 3034: x_msg_data := 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

3030: WHEN Invalid_Arg_Exc_WP THEN
3031:
3032: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3033: x_msg_count := 1;
3034: x_msg_data := 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
3035:
3036: IF p_commit = FND_API.G_TRUE THEN
3037: ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC;
3038: END IF;

Line 3053: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3049: IF c_get_pa_record_version_number%ISOPEN THEN
3050: CLOSE c_get_pa_record_version_number;
3051: END IF;
3052: Fnd_Msg_Pub.add_exc_msg
3053: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3054: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3055: , p_error_text => x_msg_data);
3056:
3057: IF l_debug_mode = 'Y' THEN

Line 3090: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3086: CLOSE c_get_pa_record_version_number;
3087: END IF;
3088:
3089: Fnd_Msg_Pub.add_exc_msg
3090: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3091: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3092: , p_error_text => x_msg_data);
3093:
3094: IF l_debug_mode = 'Y' THEN

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 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 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 3462: x_msg_data := 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

3458: WHEN Invalid_Arg_Exc_WP THEN
3459:
3460: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3461: x_msg_count := 1;
3462: x_msg_data := 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
3463:
3464: IF p_commit = FND_API.G_TRUE THEN
3465: ROLLBACK TO POPULATE_TEMP_TABLE_PUB;
3466: END IF;

Line 3475: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3471: IF c_get_parents%ISOPEN THEN
3472: CLOSE c_get_parents;
3473: END IF;
3474: Fnd_Msg_Pub.add_exc_msg
3475: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3476: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3477: , p_error_text => x_msg_data);
3478:
3479: IF l_debug_mode = 'Y' THEN

Line 3505: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3501: CLOSE c_get_parents;
3502: END IF;
3503:
3504: Fnd_Msg_Pub.add_exc_msg
3505: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3506: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3507: , p_error_text => x_msg_data);
3508:
3509: 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 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 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 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 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 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 3744: x_msg_data := 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

3740: WHEN Invalid_Arg_Exc_WP THEN
3741:
3742: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3743: x_msg_count := 1;
3744: x_msg_data := 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
3745:
3746: IF p_commit = FND_API.G_TRUE THEN
3747: ROLLBACK TO SYNC_UP_WITH_FIN_PUBLIC;
3748: END IF;

Line 3752: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3748: END IF;
3749:
3750:
3751: Fnd_Msg_Pub.add_exc_msg
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;

Line 3777: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3773:
3774:
3775:
3776: Fnd_Msg_Pub.add_exc_msg
3777: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
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

Line 3791: end PA_TASKS_MAINT_PUB;

3787: RAISE;
3788: END SYNC_UP_WP_TASKS_WITH_FIN ;
3789:
3790: --3279982 End Add rtarway for FP.M develeopment
3791: end PA_TASKS_MAINT_PUB;