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.3 2009/02/26 13:47:52 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.3 2009/02/26 13:47:52 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 1238: pa_debug.debug('PA_TASKS_MAINT_PUB.UPDATE_TASK END');

1234: commit;
1235: END IF;
1236:
1237: IF (p_debug_mode = 'Y') THEN
1238: pa_debug.debug('PA_TASKS_MAINT_PUB.UPDATE_TASK END');
1239: END IF;
1240:
1241: EXCEPTION
1242: WHEN FND_API.G_EXC_ERROR THEN

Line 1255: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1251: END IF;
1252: x_msg_count := FND_MSG_PUB.count_msg;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254: --put message
1255: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1256: p_procedure_name => 'UPDATE_TASK',
1257: p_error_text => substrb(SQLERRM,1,240));
1258: -- RAISE;
1259: END UPDATE_TASK;

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

1340: BEGIN
1341: pa_tasks_maint_utils.set_org_id(p_project_id);
1342:
1343:
1344: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.DELETE_TASK');
1345:
1346: IF (p_debug_mode = 'Y') THEN
1347: pa_debug.debug('PA_TASKS_MAINT_PUB.DELETE_TASK begin');
1348: END IF;

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

1343:
1344: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.DELETE_TASK');
1345:
1346: IF (p_debug_mode = 'Y') THEN
1347: pa_debug.debug('PA_TASKS_MAINT_PUB.DELETE_TASK begin');
1348: END IF;
1349:
1350: IF (p_commit = FND_API.G_TRUE) THEN
1351: savepoint DELETE_TASK;

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

1465: commit;
1466: END IF;
1467:
1468: IF (p_debug_mode = 'Y') THEN
1469: pa_debug.debug('PA_TASKS_MAINT_PUB.DELETE_TASK END');
1470: END IF;
1471:
1472: EXCEPTION
1473: WHEN FND_API.G_EXC_ERROR THEN

Line 1485: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1481: ROLLBACK to DELETE_TASK;
1482: END IF;
1483: x_msg_count := FND_MSG_PUB.count_msg;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1486: p_procedure_name => 'DELETE_TASK',
1487: p_error_text => substrb(SQLERRM,1,240));
1488: END DELETE_TASK;
1489:

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

1756: THEN
1757: ROLLBACK TO Edit_Structure;
1758: END IF;
1759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1760: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1761: p_procedure_name => 'Edit_Task_Structure',
1762: p_error_text => SUBSTRB(SQLERRM,1,240));
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764:

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

1774: THEN
1775: ROLLBACK TO Edit_Structure;
1776: END IF;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1779: p_procedure_name => 'Edit_Task_Structure',
1780: p_error_text => SUBSTRB(SQLERRM,1,240));
1781: RAISE;
1782:

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

2085: THEN
2086: ROLLBACK TO Move;
2087: END IF;
2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2089: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2090: p_procedure_name => 'Move_Task',
2091: p_error_text => SUBSTRB(SQLERRM,1,240));
2092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2093:

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

2103: THEN
2104: ROLLBACK TO Move;
2105: END IF;
2106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2107: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2108: p_procedure_name => 'Move_Task',
2109: p_error_text => SUBSTRB(SQLERRM,1,240));
2110: RAISE;
2111:

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

2429: THEN
2430: ROLLBACK TO Copy;
2431: END IF;
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2434: p_procedure_name => 'Copy_Task',
2435: p_error_text => SUBSTRB(SQLERRM,1,240));
2436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2437:

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

2447: THEN
2448: ROLLBACK TO Copy;
2449: END IF;
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2452: p_procedure_name => 'Copy_Task',
2453: p_error_text => SUBSTRB(SQLERRM,1,240));
2454: RAISE;
2455:

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

2683: END IF;
2684:
2685: IF l_debug_mode = 'Y' THEN
2686:
2687: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Printing Input parameters';
2688:
2689: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2690: l_debug_level3);
2691: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,

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

2708: savepoint SET_FIN_FLAG_WRAPPER_PUBLIC;
2709: END IF;
2710:
2711: IF l_debug_mode = 'Y' THEN
2712: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Validating Input parameters';
2713: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2714: l_debug_level3);
2715: END IF;
2716:

Line 2726: 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';

2722: p_published_version_exists IS NULL
2723: )
2724: THEN
2725: IF l_debug_mode = 'Y' THEN
2726: 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';
2727: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2728: l_debug_level3);
2729: END IF;
2730: RAISE Invalid_Arg_Exc_WP;

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

2730: RAISE Invalid_Arg_Exc_WP;
2731: END IF;
2732:
2733: IF l_debug_mode = 'Y' THEN
2734: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : Calling set_unset_financial_task';
2735: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
2736: l_debug_level3);
2737: END IF;
2738: --This part of code is common whether p_checked_flag is 'Y' or 'N'

Line 2893: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN

2889: FETCH c_get_immediate_parent INTO l_last_task_parent_id;
2890: IF (c_get_immediate_parent%NOTFOUND)
2891: THEN
2892: --if the parent is structure then then pass p_parent_task_version_id as null
2893: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN
2894: (
2895: p_api_version => 1.0
2896: , p_init_msg_list => FND_API.G_FALSE
2897: , p_commit => p_commit

Line 2925: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN

2921:
2922: ELSE
2923:
2924: --else pass the derived parent task version id
2925: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN
2926: (
2927: p_debug_mode => l_debug_mode
2928: , p_commit => p_commit
2929: , p_init_msg_list => FND_API.G_FALSE

Line 2959: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN

2955: THEN
2956:
2957: FOR iCounter IN REVERSE l_task_version_id_tbl.FIRST..l_task_version_id_tbl.LAST-1 LOOP
2958:
2959: PA_TASKS_MAINT_PUB.SYNC_UP_WP_TASKS_WITH_FIN
2960: (
2961: p_debug_mode => l_debug_mode
2962: , p_commit => p_commit
2963: , p_init_msg_list => FND_API.G_FALSE

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

3038: WHEN Invalid_Arg_Exc_WP THEN
3039:
3040: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3041: x_msg_count := 1;
3042: x_msg_data := 'PA_TASKS_MAINT_PUB : SET_FINANCIAL_FLAG_WRAPPER : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
3043:
3044: IF p_commit = FND_API.G_TRUE THEN
3045: ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC;
3046: END IF;

Line 3061: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3057: IF c_get_pa_record_version_number%ISOPEN THEN
3058: CLOSE c_get_pa_record_version_number;
3059: END IF;
3060: Fnd_Msg_Pub.add_exc_msg
3061: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3062: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3063: , p_error_text => x_msg_data);
3064:
3065: IF l_debug_mode = 'Y' THEN

Line 3098: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3094: CLOSE c_get_pa_record_version_number;
3095: END IF;
3096:
3097: Fnd_Msg_Pub.add_exc_msg
3098: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3099: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3100: , p_error_text => x_msg_data);
3101:
3102: IF l_debug_mode = 'Y' THEN

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

3266:
3267:
3268:
3269: IF l_debug_mode = 'Y' THEN
3270: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB:POPULATE_TEMP_TABLE:Printing Input parameters';
3271: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3272: l_debug_level3);
3273: Pa_Debug.WRITE(g_pkg_name,'p_structure_version_id'||':'||p_structure_version_id,
3274: l_debug_level3);

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

3308: savepoint POPULATE_TEMP_TBL_PUB;
3309: END IF;
3310:
3311: IF l_debug_mode = 'Y' THEN
3312: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : Validating Input parameters';
3313: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3314: l_debug_level3);
3315: END IF;
3316:

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

3320: ( p_project_id IS NULL )
3321: )
3322: THEN
3323: IF l_debug_mode = 'Y' THEN
3324: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : At least one of the mandatory IN parameters are passed as NULL';
3325: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3326: l_debug_level3);
3327: END IF;
3328: RAISE Invalid_Arg_Exc_WP;

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

3466: WHEN Invalid_Arg_Exc_WP THEN
3467:
3468: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3469: x_msg_count := 1;
3470: x_msg_data := 'PA_TASKS_MAINT_PUB : POPULATE_TEMP_TABLE : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
3471:
3472: IF p_commit = FND_API.G_TRUE THEN
3473: ROLLBACK TO POPULATE_TEMP_TABLE_PUB;
3474: END IF;

Line 3483: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3479: IF c_get_parents%ISOPEN THEN
3480: CLOSE c_get_parents;
3481: END IF;
3482: Fnd_Msg_Pub.add_exc_msg
3483: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3484: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3485: , p_error_text => x_msg_data);
3486:
3487: IF l_debug_mode = 'Y' THEN

Line 3513: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3509: CLOSE c_get_parents;
3510: END IF;
3511:
3512: Fnd_Msg_Pub.add_exc_msg
3513: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3514: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3515: , p_error_text => x_msg_data);
3516:
3517: IF l_debug_mode = 'Y' THEN

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

3599: p_debug_mode => l_debug_mode );
3600: END IF;
3601:
3602: IF l_debug_mode = 'Y' THEN
3603: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
3604: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3605: l_debug_level3);
3606: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,
3607: l_debug_level3);

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

3629: savepoint SYNC_UP_WITH_FIN_PUBLIC;
3630: END IF;
3631:
3632: IF l_debug_mode = 'Y' THEN
3633: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Validating Input parameters';
3634: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3635: l_debug_level3);
3636: END IF;
3637:

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

3637:
3638: IF ( p_project_id IS NULL)
3639: THEN
3640: IF l_debug_mode = 'Y' THEN
3641: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Mandatory parameters are null';
3642: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3643: l_debug_level3);
3644: END IF;
3645: RAISE Invalid_Arg_Exc_WP;

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

3648: --Validating for p_mode, it shopuld be either SINGLE or ALL
3649: /*IF (p_mode <> 'SINGLE' OR p_mode <> 'ALL')
3650: THEN
3651: IF l_debug_mode = 'Y' THEN
3652: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : p_mode is invalid';
3653: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3654: l_debug_level3);
3655: END IF;
3656: RAISE Invalid_Arg_Exc_WP;

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

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

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

3674: ( p_structure_version_id IS NULL OR p_structure_version_id = FND_API.G_MISS_NUM )
3675: )
3676: THEN
3677: IF l_debug_mode = 'Y' THEN
3678: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : Manadatory parameters with mode '||p_mode||'are not passed';
3679: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
3680: l_debug_level3);
3681: END IF;
3682: RAISE Invalid_Arg_Exc_WP;

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

3748: WHEN Invalid_Arg_Exc_WP THEN
3749:
3750: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3751: x_msg_count := 1;
3752: x_msg_data := 'PA_TASKS_MAINT_PUB : SYNC_UP_WP_TASKS_WITH_FIN : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
3753:
3754: IF p_commit = FND_API.G_TRUE THEN
3755: ROLLBACK TO SYNC_UP_WITH_FIN_PUBLIC;
3756: END IF;

Line 3760: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3756: END IF;
3757:
3758:
3759: Fnd_Msg_Pub.add_exc_msg
3760: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3761: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3762: , p_error_text => x_msg_data);
3763: IF l_debug_mode = 'Y' THEN
3764: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

Line 3785: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'

3781:
3782:
3783:
3784: Fnd_Msg_Pub.add_exc_msg
3785: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3786: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3787: , p_error_text => x_msg_data);
3788:
3789: IF l_debug_mode = 'Y' THEN

Line 3799: end PA_TASKS_MAINT_PUB;

3795: RAISE;
3796: END SYNC_UP_WP_TASKS_WITH_FIN ;
3797:
3798: --3279982 End Add rtarway for FP.M develeopment
3799: end PA_TASKS_MAINT_PUB;