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_PVT dependencies on FND_API

Line 14: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

10: -- Pre-reqs : None
11: -- Return Value : N/A
12: -- Parameters
13: -- p_api_version IN NUMBER := 1.0
14: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
15: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
16: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
17: -- p_validation_level IN VARCHAR2 := 100
18: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 15: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

11: -- Return Value : N/A
12: -- Parameters
13: -- p_api_version IN NUMBER := 1.0
14: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
15: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
16: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
17: -- p_validation_level IN VARCHAR2 := 100
18: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
19: -- p_debug_mode IN VARCHAR2 := 'N'

Line 16: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

12: -- Parameters
13: -- p_api_version IN NUMBER := 1.0
14: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
15: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
16: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
17: -- p_validation_level IN VARCHAR2 := 100
18: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
19: -- p_debug_mode IN VARCHAR2 := 'N'
20: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 123: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

119: --
120: procedure CREATE_TASK
121: (
122: p_api_version IN NUMBER := 1.0
123: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
124: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
125: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
126: ,p_validation_level IN VARCHAR2 := 100
127: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 124: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

120: procedure CREATE_TASK
121: (
122: p_api_version IN NUMBER := 1.0
123: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
124: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
125: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
126: ,p_validation_level IN VARCHAR2 := 100
127: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
128: ,p_debug_mode IN VARCHAR2 := 'N'

Line 125: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

121: (
122: p_api_version IN NUMBER := 1.0
123: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
124: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
125: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
126: ,p_validation_level IN VARCHAR2 := 100
127: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
128: ,p_debug_mode IN VARCHAR2 := 'N'
129:

Line 662: IF (p_commit = FND_API.G_TRUE) THEN

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;
664: END IF;
665:
666: IF (p_debug_mode = 'Y') THEN

Line 726: p_encoded => FND_API.G_TRUE,

722: IF (l_msg_count > 0) THEN
723: x_msg_count := l_msg_count;
724: IF (x_msg_count = 1) THEN
725: pa_interface_utils_pub.get_messages(
726: p_encoded => FND_API.G_TRUE,
727: p_msg_index => 1,
728: p_data => l_data,
729: p_msg_index_out => l_msg_index_out);
730: x_msg_data := l_data;

Line 732: RAISE FND_API.G_EXC_ERROR;

728: p_data => l_data,
729: p_msg_index_out => l_msg_index_out);
730: x_msg_data := l_data;
731: END IF;
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734: END IF;
735:
736:

Line 785: p_encoded => FND_API.G_TRUE,

781: IF (l_msg_count > 0) THEN
782: x_msg_count := l_msg_count;
783: IF (x_msg_count = 1) THEN
784: pa_interface_utils_pub.get_messages(
785: p_encoded => FND_API.G_TRUE,
786: p_msg_index => 1,
787: p_data => l_data,
788: p_msg_index_out => l_msg_index_out);
789: x_msg_data := l_data;

Line 791: RAISE FND_API.G_EXC_ERROR;

787: p_data => l_data,
788: p_msg_index_out => l_msg_index_out);
789: x_msg_data := l_data;
790: END IF;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794:
795: -- Get Task Id

Line 1200: p_encoded => FND_API.G_TRUE,

1196: IF (l_msg_count > 0) THEN
1197: x_msg_count := l_msg_count;
1198: IF (x_msg_count = 1) THEN
1199: pa_interface_utils_pub.get_messages(
1200: p_encoded => FND_API.G_TRUE,
1201: p_msg_index => 1,
1202: p_data => l_data,
1203: p_msg_index_out => l_msg_index_out);
1204: x_msg_data := l_data;

Line 1206: RAISE FND_API.G_EXC_ERROR;

1202: p_data => l_data,
1203: p_msg_index_out => l_msg_index_out);
1204: x_msg_data := l_data;
1205: END IF;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:
1209:
1210: IF (p_calling_module IN ('FORMS', 'SELF_SERVICE')) THEN

Line 1813: x_return_status := FND_API.G_RET_STS_SUCCESS;

1809: END IF;
1810:
1811:
1812:
1813: x_return_status := FND_API.G_RET_STS_SUCCESS;
1814: p_task_id := l_new_task_id;
1815: x_display_seq := l_sequence_number;
1816:
1817: end if; -- end check for chg_doc_cntxt

Line 1819: WHEN FND_API.G_EXC_ERROR THEN

1815: x_display_seq := l_sequence_number;
1816:
1817: end if; -- end check for chg_doc_cntxt
1818: EXCEPTION
1819: WHEN FND_API.G_EXC_ERROR THEN
1820: IF (p_commit = FND_API.G_TRUE) THEN
1821: ROLLBACK to CREATE_TASK_PRIVATE;
1822: END IF;
1823: x_msg_count := FND_MSG_PUB.count_msg;

Line 1820: IF (p_commit = FND_API.G_TRUE) THEN

1816:
1817: end if; -- end check for chg_doc_cntxt
1818: EXCEPTION
1819: WHEN FND_API.G_EXC_ERROR THEN
1820: IF (p_commit = FND_API.G_TRUE) THEN
1821: ROLLBACK to CREATE_TASK_PRIVATE;
1822: END IF;
1823: x_msg_count := FND_MSG_PUB.count_msg;
1824: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1824: x_return_status := FND_API.G_RET_STS_ERROR;

1820: IF (p_commit = FND_API.G_TRUE) THEN
1821: ROLLBACK to CREATE_TASK_PRIVATE;
1822: END IF;
1823: x_msg_count := FND_MSG_PUB.count_msg;
1824: x_return_status := FND_API.G_RET_STS_ERROR;
1825: WHEN OTHERS THEN
1826: IF (p_commit = FND_API.G_TRUE) THEN
1827: ROLLBACK to CREATE_TASK_PRIVATE;
1828: END IF;

Line 1826: IF (p_commit = FND_API.G_TRUE) THEN

1822: END IF;
1823: x_msg_count := FND_MSG_PUB.count_msg;
1824: x_return_status := FND_API.G_RET_STS_ERROR;
1825: WHEN OTHERS THEN
1826: IF (p_commit = FND_API.G_TRUE) THEN
1827: ROLLBACK to CREATE_TASK_PRIVATE;
1828: END IF;
1829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1830: x_msg_count := FND_MSG_PUB.count_msg;

Line 1829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1825: WHEN OTHERS THEN
1826: IF (p_commit = FND_API.G_TRUE) THEN
1827: ROLLBACK to CREATE_TASK_PRIVATE;
1828: END IF;
1829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1830: x_msg_count := FND_MSG_PUB.count_msg;
1831: --put message
1832: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
1833: p_procedure_name => 'CREATE_TASK',

Line 1844: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1840: -- Pre-reqs : None
1841: -- Return Value : N/A
1842: -- Parameters
1843: -- p_api_version IN NUMBER := 1.0
1844: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1845: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1846: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1847: -- p_validation_level IN VARCHAR2 := 100
1848: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 1845: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1841: -- Return Value : N/A
1842: -- Parameters
1843: -- p_api_version IN NUMBER := 1.0
1844: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1845: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1846: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1847: -- p_validation_level IN VARCHAR2 := 100
1848: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1849: -- p_debug_mode IN VARCHAR2 := 'N'

Line 1846: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1842: -- Parameters
1843: -- p_api_version IN NUMBER := 1.0
1844: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1845: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1846: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1847: -- p_validation_level IN VARCHAR2 := 100
1848: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1849: -- p_debug_mode IN VARCHAR2 := 'N'
1850: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1956: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1952:
1953: procedure UPDATE_TASK
1954: (
1955: p_api_version IN NUMBER := 1.0
1956: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1957: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1958: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1959: ,p_validation_level IN VARCHAR2 := 100
1960: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 1957: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1953: procedure UPDATE_TASK
1954: (
1955: p_api_version IN NUMBER := 1.0
1956: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1957: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1958: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1959: ,p_validation_level IN VARCHAR2 := 100
1960: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1961: ,p_debug_mode IN VARCHAR2 := 'N'

Line 1958: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1954: (
1955: p_api_version IN NUMBER := 1.0
1956: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1957: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1958: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1959: ,p_validation_level IN VARCHAR2 := 100
1960: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1961: ,p_debug_mode IN VARCHAR2 := 'N'
1962:

Line 2316: IF (p_commit = FND_API.G_TRUE) THEN

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

Line 2341: raise FND_API.G_EXC_ERROR;

2337: where task_id = p_task_id;
2338: EXCEPTION
2339: WHEN NO_DATA_FOUND THEN
2340: PA_UTILS.ADD_MESSAGE('PA','PA_EXP_NO_TASK'); -- specified task does not exist
2341: raise FND_API.G_EXC_ERROR;
2342: END;
2343: ELSE
2344: t_pm_product_code := p_pm_product_code;
2345: END IF;

Line 2539: p_encoded => FND_API.G_TRUE,

2535: IF (l_msg_count > 0) THEN
2536: x_msg_count := l_msg_count;
2537: IF (x_msg_count = 1) THEN
2538: pa_interface_utils_pub.get_messages(
2539: p_encoded => FND_API.G_TRUE,
2540: p_msg_index => 1,
2541: p_data => l_data,
2542: p_msg_index_out => l_msg_index_out);
2543: x_msg_data := l_data;

Line 2545: RAISE FND_API.G_EXC_ERROR;

2541: p_data => l_data,
2542: p_msg_index_out => l_msg_index_out);
2543: x_msg_data := l_data;
2544: END IF;
2545: RAISE FND_API.G_EXC_ERROR;
2546: END IF;
2547: END IF;
2548: END IF;
2549:

Line 2599: p_encoded => FND_API.G_TRUE,

2595: IF (l_msg_count > 0) THEN
2596: x_msg_count := l_msg_count;
2597: IF (x_msg_count = 1) THEN
2598: pa_interface_utils_pub.get_messages(
2599: p_encoded => FND_API.G_TRUE,
2600: p_msg_index => 1,
2601: p_data => l_data,
2602: p_msg_index_out => l_msg_index_out);
2603: x_msg_data := l_data;

Line 2605: RAISE FND_API.G_EXC_ERROR;

2601: p_data => l_data,
2602: p_msg_index_out => l_msg_index_out);
2603: x_msg_data := l_data;
2604: END IF;
2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607:
2608: --Check Completion Date
2609: -- Added for bug 5665772

Line 2775: p_encoded => FND_API.G_TRUE,

2771: IF (l_msg_count > 0) THEN
2772: x_msg_count := l_msg_count;
2773: IF (x_msg_count = 1) THEN
2774: pa_interface_utils_pub.get_messages(
2775: p_encoded => FND_API.G_TRUE,
2776: p_msg_index => 1,
2777: p_data => l_data,
2778: p_msg_index_out => l_msg_index_out);
2779: x_msg_data := l_data;

Line 2781: RAISE FND_API.G_EXC_ERROR;

2777: p_data => l_data,
2778: p_msg_index_out => l_msg_index_out);
2779: x_msg_data := l_data;
2780: END IF;
2781: RAISE FND_API.G_EXC_ERROR;
2782: END IF;
2783:
2784:
2785: --dbms_output.put_line( 'In update task 15' );

Line 3326: x_return_status := FND_API.G_RET_STS_SUCCESS;

3322: --End PA L Capital Project Changes 2872708
3323: tGEN_ETC_SOURCE_CODE
3324: );
3325:
3326: x_return_status := FND_API.G_RET_STS_SUCCESS;
3327:
3328:
3329: EXCEPTION
3330: WHEN FND_API.G_EXC_ERROR THEN

Line 3330: WHEN FND_API.G_EXC_ERROR THEN

3326: x_return_status := FND_API.G_RET_STS_SUCCESS;
3327:
3328:
3329: EXCEPTION
3330: WHEN FND_API.G_EXC_ERROR THEN
3331: IF (p_commit = FND_API.G_TRUE) THEN
3332: ROLLBACK to UPDATE_TASK_PRIVATE;
3333: END IF;
3334: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3331: IF (p_commit = FND_API.G_TRUE) THEN

3327:
3328:
3329: EXCEPTION
3330: WHEN FND_API.G_EXC_ERROR THEN
3331: IF (p_commit = FND_API.G_TRUE) THEN
3332: ROLLBACK to UPDATE_TASK_PRIVATE;
3333: END IF;
3334: x_return_status := FND_API.G_RET_STS_ERROR;
3335: WHEN NO_DATA_FOUND THEN

Line 3334: x_return_status := FND_API.G_RET_STS_ERROR;

3330: WHEN FND_API.G_EXC_ERROR THEN
3331: IF (p_commit = FND_API.G_TRUE) THEN
3332: ROLLBACK to UPDATE_TASK_PRIVATE;
3333: END IF;
3334: x_return_status := FND_API.G_RET_STS_ERROR;
3335: WHEN NO_DATA_FOUND THEN
3336: IF (p_commit = FND_API.G_TRUE) THEN
3337: ROLLBACK to UPDATE_TASK_PRIVATE;
3338: END IF;

Line 3336: IF (p_commit = FND_API.G_TRUE) THEN

3332: ROLLBACK to UPDATE_TASK_PRIVATE;
3333: END IF;
3334: x_return_status := FND_API.G_RET_STS_ERROR;
3335: WHEN NO_DATA_FOUND THEN
3336: IF (p_commit = FND_API.G_TRUE) THEN
3337: ROLLBACK to UPDATE_TASK_PRIVATE;
3338: END IF;
3339: x_msg_count := FND_MSG_PUB.count_msg;
3340: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3340: x_return_status := FND_API.G_RET_STS_ERROR;

3336: IF (p_commit = FND_API.G_TRUE) THEN
3337: ROLLBACK to UPDATE_TASK_PRIVATE;
3338: END IF;
3339: x_msg_count := FND_MSG_PUB.count_msg;
3340: x_return_status := FND_API.G_RET_STS_ERROR;
3341: WHEN OTHERS THEN
3342: IF (p_commit = FND_API.G_TRUE) THEN
3343: ROLLBACK to UPDATE_TASK_PRIVATE;
3344: END IF;

Line 3342: IF (p_commit = FND_API.G_TRUE) THEN

3338: END IF;
3339: x_msg_count := FND_MSG_PUB.count_msg;
3340: x_return_status := FND_API.G_RET_STS_ERROR;
3341: WHEN OTHERS THEN
3342: IF (p_commit = FND_API.G_TRUE) THEN
3343: ROLLBACK to UPDATE_TASK_PRIVATE;
3344: END IF;
3345: x_msg_count := FND_MSG_PUB.count_msg;
3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3342: IF (p_commit = FND_API.G_TRUE) THEN
3343: ROLLBACK to UPDATE_TASK_PRIVATE;
3344: END IF;
3345: x_msg_count := FND_MSG_PUB.count_msg;
3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3347: --put message
3348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3349: p_procedure_name => 'UPDATE_TASK',
3350: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 3358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

3354:
3355: procedure DELETE_TASK
3356: (
3357: p_api_version IN NUMBER := 1.0
3358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3359: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3360: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3361: ,p_validation_level IN VARCHAR2 := 100
3362: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 3359: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

3355: procedure DELETE_TASK
3356: (
3357: p_api_version IN NUMBER := 1.0
3358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3359: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3360: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3361: ,p_validation_level IN VARCHAR2 := 100
3362: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
3363: ,p_debug_mode IN VARCHAR2 := 'N'

Line 3360: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

3356: (
3357: p_api_version IN NUMBER := 1.0
3358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3359: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3360: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3361: ,p_validation_level IN VARCHAR2 := 100
3362: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
3363: ,p_debug_mode IN VARCHAR2 := 'N'
3364: ,p_task_id IN NUMBER

Line 3406: IF (p_commit = FND_API.G_TRUE) THEN

3402: IF (p_debug_mode = 'Y') THEN
3403: pa_debug.debug('PA_TASKS_MAINT_PVT.DELETE_TASK BEGIN');
3404: END IF;
3405:
3406: IF (p_commit = FND_API.G_TRUE) THEN
3407: savepoint DELETE_TASK_PRIVATE;
3408: END IF;
3409:
3410: IF (p_debug_mode = 'Y') THEN

Line 3423: raise FND_API.G_EXC_ERROR;

3419: where task_id = p_task_id;
3420: EXCEPTION
3421: WHEN NO_DATA_FOUND THEN
3422: PA_UTILS.ADD_MESSAGE('PA','PA_EXP_NO_TASK'); -- specified task does not exist
3423: raise FND_API.G_EXC_ERROR;
3424: END;
3425:
3426: -- Set controls
3427: IF (p_calling_module IN ('SELF_SERVICE')) THEN

Line 3458: raise FND_API.G_EXC_ERROR;

3454: If (p_calling_module IN ('SELF_SERVICE', 'FORM')) THEN
3455: --Check if task can be deleted;
3456: IF (t_pm_product_code IS NOT NULL) AND (l_delete_task_allowed = 'N') THEN
3457: PA_UTILS.ADD_MESSAGE('PA', 'PA_PR_PM_CANNOT_DELETE');
3458: raise FND_API.G_EXC_ERROR;
3459: END IF;
3460:
3461: /* do not stop delting the last task. FPM changes
3462: refer bug 3427157

Line 3471: raise FND_API.G_EXC_ERROR;

3467: --Check if this is last task;
3468: If (PA_TASK_UTILS.check_last_task(p_task_id) <> 0) THEN
3469: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3470: p_msg_name => 'PA_TK_CANT_DELETE_LAST_TASK');
3471: raise FND_API.G_EXC_ERROR;
3472: END IF;
3473: END IF;
3474: do not stop delting the last task. FPM changes*/
3475:

Line 3487: raise FND_API.G_EXC_ERROR;

3483: x_err_stage => l_err_stage,
3484: x_err_stack => l_err_stack);
3485: IF (l_err_code <> 0) THEN
3486: PA_UTILS.ADD_MESSAGE('PA', substr(l_err_stage, 1, 30));
3487: raise FND_API.G_EXC_ERROR;
3488: END IF;
3489: END IF;
3490: -- 4201927 end
3491:

Line 3505: raise FND_API.G_EXC_ERROR;

3501:
3502: If (l_err_code <> 0) THEN
3503: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3504: p_msg_name => substr(l_err_stage,1,30));
3505: raise FND_API.G_EXC_ERROR;
3506: END IF;
3507:
3508: IF (p_calling_module IN ('SELF_SERVICE', 'FORM')) THEN
3509: --Check if child exist for current parent task. If not,

Line 3527: (p_encoded => FND_API.G_TRUE,

3523: IF (l_msg_count > 0) then
3524: x_msg_count := l_msg_count;
3525: IF (x_msg_count = 1) then
3526: pa_interface_utils_pub.get_messages
3527: (p_encoded => FND_API.G_TRUE,
3528: p_msg_index => 1,
3529: p_data => l_data,
3530: p_msg_index_out => l_msg_index_out);
3531: x_msg_data := l_data;

Line 3533: raise FND_API.G_EXC_ERROR;

3529: p_data => l_data,
3530: p_msg_index_out => l_msg_index_out);
3531: x_msg_data := l_data;
3532: end if;
3533: raise FND_API.G_EXC_ERROR;
3534: end if;
3535:
3536: x_return_status := FND_API.G_RET_STS_SUCCESS;
3537:

Line 3536: x_return_status := FND_API.G_RET_STS_SUCCESS;

3532: end if;
3533: raise FND_API.G_EXC_ERROR;
3534: end if;
3535:
3536: x_return_status := FND_API.G_RET_STS_SUCCESS;
3537:
3538: EXCEPTION
3539: WHEN FND_API.G_EXC_ERROR THEN
3540: IF (p_commit = FND_API.G_TRUE) THEN

Line 3539: WHEN FND_API.G_EXC_ERROR THEN

3535:
3536: x_return_status := FND_API.G_RET_STS_SUCCESS;
3537:
3538: EXCEPTION
3539: WHEN FND_API.G_EXC_ERROR THEN
3540: IF (p_commit = FND_API.G_TRUE) THEN
3541: ROLLBACK to DELETE_TASK_PRIVATE;
3542: END IF;
3543: x_msg_count := FND_MSG_PUB.count_msg;

Line 3540: IF (p_commit = FND_API.G_TRUE) THEN

3536: x_return_status := FND_API.G_RET_STS_SUCCESS;
3537:
3538: EXCEPTION
3539: WHEN FND_API.G_EXC_ERROR THEN
3540: IF (p_commit = FND_API.G_TRUE) THEN
3541: ROLLBACK to DELETE_TASK_PRIVATE;
3542: END IF;
3543: x_msg_count := FND_MSG_PUB.count_msg;
3544: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3544: x_return_status := FND_API.G_RET_STS_ERROR;

3540: IF (p_commit = FND_API.G_TRUE) THEN
3541: ROLLBACK to DELETE_TASK_PRIVATE;
3542: END IF;
3543: x_msg_count := FND_MSG_PUB.count_msg;
3544: x_return_status := FND_API.G_RET_STS_ERROR;
3545: WHEN OTHERS THEN
3546: IF (p_commit = FND_API.G_TRUE) THEN
3547: ROLLBACK to DELETE_TASK_PRIVATE;
3548: END IF;

Line 3546: IF (p_commit = FND_API.G_TRUE) THEN

3542: END IF;
3543: x_msg_count := FND_MSG_PUB.count_msg;
3544: x_return_status := FND_API.G_RET_STS_ERROR;
3545: WHEN OTHERS THEN
3546: IF (p_commit = FND_API.G_TRUE) THEN
3547: ROLLBACK to DELETE_TASK_PRIVATE;
3548: END IF;
3549: x_msg_count := FND_MSG_PUB.count_msg;
3550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3546: IF (p_commit = FND_API.G_TRUE) THEN
3547: ROLLBACK to DELETE_TASK_PRIVATE;
3548: END IF;
3549: x_msg_count := FND_MSG_PUB.count_msg;
3550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: --put message
3552: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3553: p_procedure_name => 'DELETE_TASK',
3554: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 3563: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

3559: -- Type : Private procedure
3560: -- Pre-reqs : None
3561: -- Return Value : N/A
3562: -- Prameters
3563: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3564: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3565: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3566: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3567: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 3564: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

3560: -- Pre-reqs : None
3561: -- Return Value : N/A
3562: -- Prameters
3563: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3564: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3565: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3566: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3567: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3568: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 3565: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

3561: -- Return Value : N/A
3562: -- Prameters
3563: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3564: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3565: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3566: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3567: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3568: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
3569: -- p_project_id IN NUMBER REQUIRED

Line 3568: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

3564: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3565: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3566: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3567: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3568: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
3569: -- p_project_id IN NUMBER REQUIRED
3570: -- p_task_id IN NUMBER REQUIRED
3571: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
3572: -- x_return_status OUT VARCHAR2 REQUIRED

Line 3583: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

3579: --
3580: --
3581:
3582: PROCEDURE Indent_Task(
3583: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3584: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3585: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3586: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3587: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 3584: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

3580: --
3581:
3582: PROCEDURE Indent_Task(
3583: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3584: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3585: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3586: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3587: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3588: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 3585: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

3581:
3582: PROCEDURE Indent_Task(
3583: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3584: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3585: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3586: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3587: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3588: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
3589: ,p_project_id IN NUMBER

Line 3588: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

3584: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3585: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3586: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3587: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3588: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
3589: ,p_project_id IN NUMBER
3590: ,p_task_id IN NUMBER
3591: ,p_record_version_number IN NUMBER DEFAULT 1
3592: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3672: IF p_commit = FND_API.G_TRUE

3668: l_err_stage VARCHAR2(80); -- VARCHAR2(80)
3669:
3670: BEGIN
3671:
3672: IF p_commit = FND_API.G_TRUE
3673: THEN
3674: SAVEPOINT Edit_Structure;
3675: END IF;
3676: x_return_status := 'S';

Line 3708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3704: THEN
3705: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3706: p_msg_name => 'PA_TASK_CANNOT_INDENT' );
3707: x_msg_data := 'PA_TASK_CANNOT_INDENT';
3708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3709: RAISE FND_API.G_EXC_ERROR;
3710:
3711: ELSE
3712:

Line 3709: RAISE FND_API.G_EXC_ERROR;

3705: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3706: p_msg_name => 'PA_TASK_CANNOT_INDENT' );
3707: x_msg_data := 'PA_TASK_CANNOT_INDENT';
3708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3709: RAISE FND_API.G_EXC_ERROR;
3710:
3711: ELSE
3712:
3713: --dbms_output.put_line( 'Indent Task PVT : Stage 2' ||' l_task_level '||l_task_level||' l_task_level_above '||l_task_level_above);

Line 3772: RAISE FND_API.G_EXC_ERROR;

3768:
3769: IF l_msg_count > 0 THEN
3770: x_msg_count := l_msg_count;
3771: x_return_status := 'E';
3772: RAISE FND_API.G_EXC_ERROR;
3773: END IF;
3774:
3775: -- Changes for bug 3125880
3776: -- As Parent Task Id of the Task being indented is updated and b'coz of this

Line 3816: RAISE FND_API.G_EXC_ERROR;

3812:
3813: IF l_msg_count > 0 THEN
3814: x_msg_count := l_msg_count;
3815: x_return_status := 'E';
3816: RAISE FND_API.G_EXC_ERROR;
3817: END IF;
3818:
3819: END LOOP;
3820:

Line 3857: RAISE FND_API.G_EXC_ERROR;

3853:
3854: IF l_msg_count > 0 THEN
3855: x_msg_count := l_msg_count;
3856: x_return_status := 'E';
3857: RAISE FND_API.G_EXC_ERROR;
3858: END IF;
3859:
3860: -- 2) update the top task id of the indenting task including its children with the top task id of the task above.
3861: -- 3) update the wbs level of the indenting task and its children

Line 3888: RAISE FND_API.G_EXC_ERROR;

3884:
3885: IF l_msg_count > 0 THEN
3886: x_msg_count := l_msg_count;
3887: x_return_status := 'E';
3888: RAISE FND_API.G_EXC_ERROR;
3889: END IF;
3890:
3891: END LOOP;
3892: END IF;

Line 3896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3892: END IF;
3893: END IF;
3894:
3895: EXCEPTION
3896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3897: IF p_commit = FND_API.G_TRUE
3898: THEN
3899: ROLLBACK TO Edit_Structure;
3900: END IF;

Line 3897: IF p_commit = FND_API.G_TRUE

3893: END IF;
3894:
3895: EXCEPTION
3896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3897: IF p_commit = FND_API.G_TRUE
3898: THEN
3899: ROLLBACK TO Edit_Structure;
3900: END IF;
3901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3897: IF p_commit = FND_API.G_TRUE
3898: THEN
3899: ROLLBACK TO Edit_Structure;
3900: END IF;
3901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3902: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3903: p_procedure_name => 'Indent_task',
3904: p_error_text => SUBSTRB(SQLERRM,1,240));
3905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3902: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3903: p_procedure_name => 'Indent_task',
3904: p_error_text => SUBSTRB(SQLERRM,1,240));
3905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3906:
3907: WHEN FND_API.G_EXC_ERROR THEN
3908: IF p_commit = FND_API.G_TRUE
3909: THEN

Line 3907: WHEN FND_API.G_EXC_ERROR THEN

3903: p_procedure_name => 'Indent_task',
3904: p_error_text => SUBSTRB(SQLERRM,1,240));
3905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3906:
3907: WHEN FND_API.G_EXC_ERROR THEN
3908: IF p_commit = FND_API.G_TRUE
3909: THEN
3910: ROLLBACK TO Edit_Structure;
3911: END IF;

Line 3908: IF p_commit = FND_API.G_TRUE

3904: p_error_text => SUBSTRB(SQLERRM,1,240));
3905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3906:
3907: WHEN FND_API.G_EXC_ERROR THEN
3908: IF p_commit = FND_API.G_TRUE
3909: THEN
3910: ROLLBACK TO Edit_Structure;
3911: END IF;
3912: x_return_status := 'E';

Line 3915: IF p_commit = FND_API.G_TRUE

3911: END IF;
3912: x_return_status := 'E';
3913:
3914: WHEN OTHERS THEN
3915: IF p_commit = FND_API.G_TRUE
3916: THEN
3917: ROLLBACK TO Edit_Structure;
3918: END IF;
3919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3915: IF p_commit = FND_API.G_TRUE
3916: THEN
3917: ROLLBACK TO Edit_Structure;
3918: END IF;
3919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3920: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3921: p_procedure_name => 'Indent_task',
3922: p_error_text => SUBSTRB(SQLERRM,1,240));
3923: RAISE;

Line 3932: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

3928: -- Type : Private procedure
3929: -- Pre-reqs : None
3930: -- Return Value : N/A
3931: -- Prameters
3932: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3933: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3934: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3935: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3936: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 3933: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

3929: -- Pre-reqs : None
3930: -- Return Value : N/A
3931: -- Prameters
3932: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3933: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3934: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3935: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3936: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3937: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 3934: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

3930: -- Return Value : N/A
3931: -- Prameters
3932: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3933: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3934: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3935: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3936: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3937: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
3938: -- p_project_id IN NUMBER REQUIRED

Line 3937: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

3933: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3934: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3935: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3936: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3937: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
3938: -- p_project_id IN NUMBER REQUIRED
3939: -- p_task_id IN NUMBER REQUIRED
3940: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
3941: -- x_return_status OUT VARCHAR2 REQUIRED

Line 3952: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

3948: --
3949: --
3950:
3951: PROCEDURE Outdent_Task(
3952: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3953: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3954: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3955: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3956: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 3953: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

3949: --
3950:
3951: PROCEDURE Outdent_Task(
3952: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3953: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3954: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3955: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3956: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3957: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 3954: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

3950:
3951: PROCEDURE Outdent_Task(
3952: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3953: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3954: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3955: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3956: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3957: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
3958: ,p_project_id IN NUMBER

Line 3957: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

3953: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3954: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3955: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3956: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3957: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
3958: ,p_project_id IN NUMBER
3959: ,p_task_id IN NUMBER
3960: ,p_record_version_number IN NUMBER DEFAULT 1
3961: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4053: IF p_commit = FND_API.G_TRUE

4049: AND project_id = p_project_id
4050: AND top_task_id = p_top_task_id_above;
4051: BEGIN
4052:
4053: IF p_commit = FND_API.G_TRUE
4054: THEN
4055: SAVEPOINT Edit_Structure;
4056: END IF;
4057: x_return_status := 'S';

Line 4084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4080: THEN
4081: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4082: p_msg_name => 'PA_TASK_CANNOT_OUTDENT' );
4083: x_msg_data := 'PA_TASK_CANNOT_OUTDENT';
4084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4085: RAISE FND_API.G_EXC_ERROR;
4086: END IF;
4087:
4088: --If the task above is at lower wbs level

Line 4085: RAISE FND_API.G_EXC_ERROR;

4081: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4082: p_msg_name => 'PA_TASK_CANNOT_OUTDENT' );
4083: x_msg_data := 'PA_TASK_CANNOT_OUTDENT';
4084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4085: RAISE FND_API.G_EXC_ERROR;
4086: END IF;
4087:
4088: --If the task above is at lower wbs level
4089: IF l_task_level_above < l_task_level

Line 4114: RAISE FND_API.G_EXC_ERROR;

4110:
4111: IF l_msg_count > 0 THEN
4112: x_msg_count := l_msg_count;
4113: x_return_status := 'E';
4114: RAISE FND_API.G_EXC_ERROR;
4115: END IF;
4116:
4117: --1) update wbs level of outdenting task includinf its children
4118:

Line 4142: RAISE FND_API.G_EXC_ERROR;

4138:
4139: IF l_msg_count > 0 THEN
4140: x_msg_count := l_msg_count;
4141: x_return_status := 'E';
4142: RAISE FND_API.G_EXC_ERROR;
4143: END IF;
4144:
4145: END LOOP;
4146:

Line 4180: RAISE FND_API.G_EXC_ERROR;

4176:
4177: IF l_msg_count > 0 THEN
4178: x_msg_count := l_msg_count;
4179: x_return_status := 'E';
4180: RAISE FND_API.G_EXC_ERROR;
4181: END IF;
4182:
4183: END LOOP;
4184: END IF;

Line 4212: RAISE FND_API.G_EXC_ERROR;

4208:
4209: IF l_msg_count > 0 THEN
4210: x_msg_count := l_msg_count;
4211: x_return_status := 'E';
4212: RAISE FND_API.G_EXC_ERROR;
4213: END IF;
4214:
4215: END LOOP;
4216:

Line 4257: RAISE FND_API.G_EXC_ERROR;

4253:
4254: IF l_msg_count > 0 THEN
4255: x_msg_count := l_msg_count;
4256: x_return_status := 'E';
4257: RAISE FND_API.G_EXC_ERROR;
4258: END IF;
4259:
4260:
4261: --1) update wbs level

Line 4286: RAISE FND_API.G_EXC_ERROR;

4282:
4283: IF l_msg_count > 0 THEN
4284: x_msg_count := l_msg_count;
4285: x_return_status := 'E';
4286: RAISE FND_API.G_EXC_ERROR;
4287: END IF;
4288:
4289: END LOOP;
4290:

Line 4320: RAISE FND_API.G_EXC_ERROR;

4316:
4317: IF l_msg_count > 0 THEN
4318: x_msg_count := l_msg_count;
4319: x_return_status := 'E';
4320: RAISE FND_API.G_EXC_ERROR;
4321: END IF;
4322:
4323: END LOOP;
4324:

Line 4365: RAISE FND_API.G_EXC_ERROR;

4361:
4362: IF l_msg_count > 0 THEN
4363: x_msg_count := l_msg_count;
4364: x_return_status := 'E';
4365: RAISE FND_API.G_EXC_ERROR;
4366: END IF;
4367:
4368: --1) update wbs level of outdenting task and its all child tasks
4369: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP

Line 4392: RAISE FND_API.G_EXC_ERROR;

4388:
4389: IF l_msg_count > 0 THEN
4390: x_msg_count := l_msg_count;
4391: x_return_status := 'E';
4392: RAISE FND_API.G_EXC_ERROR;
4393: END IF;
4394: END LOOP;
4395:
4396: --2) updating parent of the new children

Line 4424: RAISE FND_API.G_EXC_ERROR;

4420:
4421: IF l_msg_count > 0 THEN
4422: x_msg_count := l_msg_count;
4423: x_return_status := 'E';
4424: RAISE FND_API.G_EXC_ERROR;
4425: END IF;
4426:
4427: END LOOP;
4428:

Line 4456: RAISE FND_API.G_EXC_ERROR;

4452:
4453: IF l_msg_count > 0 THEN
4454: x_msg_count := l_msg_count;
4455: x_return_status := 'E';
4456: RAISE FND_API.G_EXC_ERROR;
4457: END IF;
4458:
4459: --2) updating parent of the new children
4460:

Line 4490: RAISE FND_API.G_EXC_ERROR;

4486:
4487: IF l_msg_count > 0 THEN
4488: x_msg_count := l_msg_count;
4489: x_return_status := 'E';
4490: RAISE FND_API.G_EXC_ERROR;
4491: END IF;
4492:
4493: --updating top_task_id of child tasks of outdenting task's new child tasks
4494: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( cur_new_child_task_rec.task_id ) LOOP

Line 4516: RAISE FND_API.G_EXC_ERROR;

4512:
4513: IF l_msg_count > 0 THEN
4514: x_msg_count := l_msg_count;
4515: x_return_status := 'E';
4516: RAISE FND_API.G_EXC_ERROR;
4517: END IF;
4518: END LOOP;
4519: END LOOP;
4520:

Line 4544: RAISE FND_API.G_EXC_ERROR;

4540: l_msg_count := FND_MSG_PUB.count_msg;
4541: IF l_msg_count > 0 THEN
4542: x_msg_count := l_msg_count;
4543: x_return_status := 'E';
4544: RAISE FND_API.G_EXC_ERROR;
4545: END IF;
4546: END LOOP;
4547:
4548:

Line 4575: RAISE FND_API.G_EXC_ERROR;

4571:
4572: IF l_msg_count > 0 THEN
4573: x_msg_count := l_msg_count;
4574: x_return_status := 'E';
4575: RAISE FND_API.G_EXC_ERROR;
4576: END IF;
4577: END LOOP;
4578: END IF;
4579: END IF;

Line 4582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4578: END IF;
4579: END IF;
4580:
4581: EXCEPTION
4582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4583: IF p_commit = FND_API.G_TRUE
4584: THEN
4585: ROLLBACK TO Edit_Structure;
4586: END IF;

Line 4583: IF p_commit = FND_API.G_TRUE

4579: END IF;
4580:
4581: EXCEPTION
4582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4583: IF p_commit = FND_API.G_TRUE
4584: THEN
4585: ROLLBACK TO Edit_Structure;
4586: END IF;
4587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4583: IF p_commit = FND_API.G_TRUE
4584: THEN
4585: ROLLBACK TO Edit_Structure;
4586: END IF;
4587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4588: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4589: p_procedure_name => 'Outdent_task',
4590: p_error_text => SUBSTRB(SQLERRM,1,240));
4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4588: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4589: p_procedure_name => 'Outdent_task',
4590: p_error_text => SUBSTRB(SQLERRM,1,240));
4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4592:
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: IF p_commit = FND_API.G_TRUE
4595: THEN

Line 4593: WHEN FND_API.G_EXC_ERROR THEN

4589: p_procedure_name => 'Outdent_task',
4590: p_error_text => SUBSTRB(SQLERRM,1,240));
4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4592:
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: IF p_commit = FND_API.G_TRUE
4595: THEN
4596: ROLLBACK TO Edit_Structure;
4597: END IF;

Line 4594: IF p_commit = FND_API.G_TRUE

4590: p_error_text => SUBSTRB(SQLERRM,1,240));
4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4592:
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: IF p_commit = FND_API.G_TRUE
4595: THEN
4596: ROLLBACK TO Edit_Structure;
4597: END IF;
4598: x_return_status := 'E';

Line 4601: IF p_commit = FND_API.G_TRUE

4597: END IF;
4598: x_return_status := 'E';
4599:
4600: WHEN OTHERS THEN
4601: IF p_commit = FND_API.G_TRUE
4602: THEN
4603: ROLLBACK TO Edit_Structure;
4604: END IF;
4605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4601: IF p_commit = FND_API.G_TRUE
4602: THEN
4603: ROLLBACK TO Edit_Structure;
4604: END IF;
4605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4606: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4607: p_procedure_name => 'Outdent_task',
4608: p_error_text => SUBSTRB(SQLERRM,1,240));
4609: RAISE;

Line 4617: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

4613: -- Type : Private procedure
4614: -- Pre-reqs : None
4615: -- Return Value : N/A
4616: -- Prameters
4617: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4618: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4619: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4620: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4621: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 4618: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

4614: -- Pre-reqs : None
4615: -- Return Value : N/A
4616: -- Prameters
4617: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4618: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4619: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4620: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4621: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4622: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 4619: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

4615: -- Return Value : N/A
4616: -- Prameters
4617: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4618: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4619: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4620: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4621: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4622: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
4623: -- p_reference_project_id IN NUMBER

Line 4622: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

4618: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4619: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4620: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4621: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4622: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
4623: -- p_reference_project_id IN NUMBER
4624: -- p_reference_task_id IN NUMBER
4625: -- p_project_id IN NUMBER
4626: -- p_peer_or_sub IN VARCHAR2

Line 4639: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

4635: --
4636: --
4637:
4638: PROCEDURE Copy_Entire_Project(
4639: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4640: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4641: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4642: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4643: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 4640: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

4636: --
4637:
4638: PROCEDURE Copy_Entire_Project(
4639: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4640: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4641: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4642: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4643: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4644: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 4641: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

4637:
4638: PROCEDURE Copy_Entire_Project(
4639: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4640: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4641: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4642: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4643: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4644: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
4645: ,p_reference_project_id IN NUMBER

Line 4644: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

4640: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4641: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4642: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4643: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4644: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
4645: ,p_reference_project_id IN NUMBER
4646: ,p_reference_task_id IN NUMBER
4647: ,p_project_id IN NUMBER
4648: ,p_peer_or_sub IN VARCHAR2

Line 4729: IF p_commit = FND_API.G_TRUE

4725: l_data_length NUMBER;
4726:
4727: BEGIN
4728:
4729: IF p_commit = FND_API.G_TRUE
4730: THEN
4731: SAVEPOINT Copy;
4732: END IF;
4733: x_return_status := 'S';

Line 4750: RAISE FND_API.G_EXC_ERROR;

4746: THEN
4747: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4748: p_procedure_name => 'Copy_Entire_Project',
4749: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
4750: RAISE FND_API.G_EXC_ERROR;
4751: END IF;
4752: --schema swap changes
4753:
4754: OPEN cur_data_length(l_table_owner);

Line 4847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4843: THEN
4844: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4845: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
4846: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
4847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4848: RAISE FND_API.G_EXC_ERROR;
4849: END IF;
4850:
4851: PA_TASKS_MAINT_PVT.CREATE_TASK

Line 4848: RAISE FND_API.G_EXC_ERROR;

4844: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4845: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
4846: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
4847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4848: RAISE FND_API.G_EXC_ERROR;
4849: END IF;
4850:
4851: PA_TASKS_MAINT_PVT.CREATE_TASK
4852: (

Line 4915: RAISE FND_API.G_EXC_ERROR;

4911:
4912: IF l_msg_count > 0 THEN
4913: x_msg_count := l_msg_count;
4914: x_return_status := 'E';
4915: RAISE FND_API.G_EXC_ERROR;
4916: END IF;
4917:
4918:
4919: END LOOP;

Line 4942: RAISE FND_API.G_EXC_ERROR;

4938: AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
4939: EXCEPTION
4940: WHEN OTHERS THEN
4941: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
4942: RAISE FND_API.G_EXC_ERROR;
4943: END; */
4944:
4945: EXCEPTION
4946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4942: RAISE FND_API.G_EXC_ERROR;
4943: END; */
4944:
4945: EXCEPTION
4946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4947: IF p_commit = FND_API.G_TRUE
4948: THEN
4949: ROLLBACK TO Copy;
4950: END IF;

Line 4947: IF p_commit = FND_API.G_TRUE

4943: END; */
4944:
4945: EXCEPTION
4946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4947: IF p_commit = FND_API.G_TRUE
4948: THEN
4949: ROLLBACK TO Copy;
4950: END IF;
4951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4947: IF p_commit = FND_API.G_TRUE
4948: THEN
4949: ROLLBACK TO Copy;
4950: END IF;
4951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4953: p_procedure_name => 'Copy_Entire_Task',
4954: p_error_text => SUBSTRB(SQLERRM,1,240));
4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4953: p_procedure_name => 'Copy_Entire_Task',
4954: p_error_text => SUBSTRB(SQLERRM,1,240));
4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4956:
4957: WHEN FND_API.G_EXC_ERROR THEN
4958: IF p_commit = FND_API.G_TRUE
4959: THEN

Line 4957: WHEN FND_API.G_EXC_ERROR THEN

4953: p_procedure_name => 'Copy_Entire_Task',
4954: p_error_text => SUBSTRB(SQLERRM,1,240));
4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4956:
4957: WHEN FND_API.G_EXC_ERROR THEN
4958: IF p_commit = FND_API.G_TRUE
4959: THEN
4960: ROLLBACK TO Copy;
4961: END IF;

Line 4958: IF p_commit = FND_API.G_TRUE

4954: p_error_text => SUBSTRB(SQLERRM,1,240));
4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4956:
4957: WHEN FND_API.G_EXC_ERROR THEN
4958: IF p_commit = FND_API.G_TRUE
4959: THEN
4960: ROLLBACK TO Copy;
4961: END IF;
4962: x_return_status := 'E';

Line 4965: IF p_commit = FND_API.G_TRUE

4961: END IF;
4962: x_return_status := 'E';
4963:
4964: WHEN OTHERS THEN
4965: IF p_commit = FND_API.G_TRUE
4966: THEN
4967: ROLLBACK TO Copy;
4968: END IF;
4969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4965: IF p_commit = FND_API.G_TRUE
4966: THEN
4967: ROLLBACK TO Copy;
4968: END IF;
4969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4970: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4971: p_procedure_name => 'Copy_Entire_Task',
4972: p_error_text => SUBSTRB(SQLERRM,1,240));
4973: RAISE;

Line 4981: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

4977: -- Type : Private procedure
4978: -- Pre-reqs : None
4979: -- Return Value : N/A
4980: -- Prameters
4981: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4982: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4983: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4984: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4985: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 4982: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

4978: -- Pre-reqs : None
4979: -- Return Value : N/A
4980: -- Prameters
4981: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4982: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4983: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4984: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4985: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4986: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 4983: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

4979: -- Return Value : N/A
4980: -- Prameters
4981: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4982: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4983: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4984: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4985: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4986: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
4987: -- p_reference_project_id IN NUMBER

Line 4986: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

4982: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4983: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4984: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4985: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4986: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
4987: -- p_reference_project_id IN NUMBER
4988: -- p_reference_task_id IN NUMBER
4989: -- p_task_id IN NUMBER
4990: -- p_peer_or_sub IN VARCHAR2

Line 5003: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

4999: --
5000: --
5001:
5002: PROCEDURE Copy_Selected_Task(
5003: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5004: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5005: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5006: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5007: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 5004: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

5000: --
5001:
5002: PROCEDURE Copy_Selected_Task(
5003: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5004: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5005: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5006: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5007: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
5008: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 5005: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

5001:
5002: PROCEDURE Copy_Selected_Task(
5003: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5004: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5005: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5006: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5007: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
5008: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
5009: ,p_reference_project_id IN NUMBER

Line 5008: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

5004: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5005: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5006: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5007: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
5008: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
5009: ,p_reference_project_id IN NUMBER
5010: ,p_reference_task_id IN NUMBER
5011: ,p_task_id IN NUMBER
5012: ,p_peer_or_sub IN VARCHAR2

Line 5068: IF p_commit = FND_API.G_TRUE

5064: l_column_name VARCHAR2(30);
5065: l_data_length NUMBER;
5066:
5067: BEGIN
5068: IF p_commit = FND_API.G_TRUE
5069: THEN
5070: SAVEPOINT Copy;
5071: END IF;
5072: x_return_status := 'S';

Line 5089: RAISE FND_API.G_EXC_ERROR;

5085: THEN
5086: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5087: p_procedure_name => 'Copy_Entire_Project',
5088: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
5089: RAISE FND_API.G_EXC_ERROR;
5090: END IF;
5091: --schema swap changes
5092:
5093: OPEN cur_data_length(l_table_owner);

Line 5138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5134: THEN
5135: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5136: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
5137: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
5138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5139: RAISE FND_API.G_EXC_ERROR;
5140: END IF;
5141:
5142: PA_TASKS_MAINT_PVT.CREATE_TASK

Line 5139: RAISE FND_API.G_EXC_ERROR;

5135: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5136: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
5137: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
5138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5139: RAISE FND_API.G_EXC_ERROR;
5140: END IF;
5141:
5142: PA_TASKS_MAINT_PVT.CREATE_TASK
5143: (

Line 5197: RAISE FND_API.G_EXC_ERROR;

5193:
5194: IF l_msg_count > 0 THEN
5195: x_msg_count := l_msg_count;
5196: x_return_status := 'E';
5197: RAISE FND_API.G_EXC_ERROR;
5198: END IF;
5199:
5200: END LOOP;
5201:

Line 5225: RAISE FND_API.G_EXC_ERROR;

5221: AND ( display_sequence > -( l_display_seq + 1 ) or display_sequence < 0 );
5222: EXCEPTION
5223: WHEN OTHERS THEN
5224: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
5225: RAISE FND_API.G_EXC_ERROR;
5226: END;*/
5227:
5228: EXCEPTION
5229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5225: RAISE FND_API.G_EXC_ERROR;
5226: END;*/
5227:
5228: EXCEPTION
5229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5230: IF p_commit = FND_API.G_TRUE
5231: THEN
5232: ROLLBACK TO Copy;
5233: END IF;

Line 5230: IF p_commit = FND_API.G_TRUE

5226: END;*/
5227:
5228: EXCEPTION
5229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5230: IF p_commit = FND_API.G_TRUE
5231: THEN
5232: ROLLBACK TO Copy;
5233: END IF;
5234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5230: IF p_commit = FND_API.G_TRUE
5231: THEN
5232: ROLLBACK TO Copy;
5233: END IF;
5234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5236: p_procedure_name => 'Copy_Selected_Task',
5237: p_error_text => SUBSTRB(SQLERRM,1,240));
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5236: p_procedure_name => 'Copy_Selected_Task',
5237: p_error_text => SUBSTRB(SQLERRM,1,240));
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239:
5240: WHEN FND_API.G_EXC_ERROR THEN
5241: IF p_commit = FND_API.G_TRUE
5242: THEN

Line 5240: WHEN FND_API.G_EXC_ERROR THEN

5236: p_procedure_name => 'Copy_Selected_Task',
5237: p_error_text => SUBSTRB(SQLERRM,1,240));
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239:
5240: WHEN FND_API.G_EXC_ERROR THEN
5241: IF p_commit = FND_API.G_TRUE
5242: THEN
5243: ROLLBACK TO Copy;
5244: END IF;

Line 5241: IF p_commit = FND_API.G_TRUE

5237: p_error_text => SUBSTRB(SQLERRM,1,240));
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239:
5240: WHEN FND_API.G_EXC_ERROR THEN
5241: IF p_commit = FND_API.G_TRUE
5242: THEN
5243: ROLLBACK TO Copy;
5244: END IF;
5245: x_return_status := 'E';

Line 5248: IF p_commit = FND_API.G_TRUE

5244: END IF;
5245: x_return_status := 'E';
5246:
5247: WHEN OTHERS THEN
5248: IF p_commit = FND_API.G_TRUE
5249: THEN
5250: ROLLBACK TO Copy;
5251: END IF;
5252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5248: IF p_commit = FND_API.G_TRUE
5249: THEN
5250: ROLLBACK TO Copy;
5251: END IF;
5252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5253: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5254: p_procedure_name => 'Copy_Selected_Task',
5255: p_error_text => SUBSTRB(SQLERRM,1,240));
5256: RAISE;

Line 5264: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE

5260: -- Type : Private procedure
5261: -- Pre-reqs : None
5262: -- Return Value : N/A
5263: -- Prameters
5264: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
5265: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
5266: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
5267: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
5268: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

Line 5265: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE

5261: -- Pre-reqs : None
5262: -- Return Value : N/A
5263: -- Prameters
5264: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
5265: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
5266: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
5267: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
5268: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
5269: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

Line 5266: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL

5262: -- Return Value : N/A
5263: -- Prameters
5264: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
5265: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
5266: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
5267: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
5268: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
5269: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
5270: -- p_reference_project_id IN NUMBER

Line 5269: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

5265: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
5266: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
5267: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
5268: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
5269: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
5270: -- p_reference_project_id IN NUMBER
5271: -- p_reference_task_id IN NUMBER
5272: -- p_project_id IN NUMBER
5273: -- p_task_id IN NUMBER

Line 5287: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

5283: --
5284: --
5285:
5286: PROCEDURE Copy_Entire_Task(
5287: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5288: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5289: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5290: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5291: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 5288: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

5284: --
5285:
5286: PROCEDURE Copy_Entire_Task(
5287: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5288: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5289: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5290: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5291: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
5292: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 5289: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

5285:
5286: PROCEDURE Copy_Entire_Task(
5287: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5288: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5289: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5290: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5291: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
5292: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
5293: ,p_reference_project_id IN NUMBER

Line 5292: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

5288: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5289: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5290: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5291: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
5292: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
5293: ,p_reference_project_id IN NUMBER
5294: ,p_reference_task_id IN NUMBER
5295: ,p_project_id IN NUMBER
5296: ,p_task_id IN NUMBER

Line 5390: IF p_commit = FND_API.G_TRUE

5386: l_data_length NUMBER;
5387:
5388: BEGIN
5389:
5390: IF p_commit = FND_API.G_TRUE
5391: THEN
5392: SAVEPOINT Copy;
5393: END IF;
5394: x_return_status := 'S';

Line 5411: RAISE FND_API.G_EXC_ERROR;

5407: THEN
5408: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5409: p_procedure_name => 'Copy_Entire_Project',
5410: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
5411: RAISE FND_API.G_EXC_ERROR;
5412: END IF;
5413: --schema swap changes
5414:
5415: OPEN cur_data_length(l_table_owner);

Line 5508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5504: THEN
5505: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5506: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
5507: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
5508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5509: RAISE FND_API.G_EXC_ERROR;
5510: END IF;
5511:
5512: PA_TASKS_MAINT_PVT.CREATE_TASK

Line 5509: RAISE FND_API.G_EXC_ERROR;

5505: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5506: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
5507: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
5508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5509: RAISE FND_API.G_EXC_ERROR;
5510: END IF;
5511:
5512: PA_TASKS_MAINT_PVT.CREATE_TASK
5513: (

Line 5577: RAISE FND_API.G_EXC_ERROR;

5573:
5574: IF l_msg_count > 0 THEN
5575: x_msg_count := l_msg_count;
5576: x_return_status := 'E';
5577: RAISE FND_API.G_EXC_ERROR;
5578: END IF;
5579:
5580: END LOOP;
5581:

Line 5605: RAISE FND_API.G_EXC_ERROR;

5601: AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
5602: EXCEPTION
5603: WHEN OTHERS THEN
5604: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
5605: RAISE FND_API.G_EXC_ERROR;
5606: END; */
5607:
5608: EXCEPTION
5609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5605: RAISE FND_API.G_EXC_ERROR;
5606: END; */
5607:
5608: EXCEPTION
5609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5610: IF p_commit = FND_API.G_TRUE
5611: THEN
5612: ROLLBACK TO Copy;
5613: END IF;

Line 5610: IF p_commit = FND_API.G_TRUE

5606: END; */
5607:
5608: EXCEPTION
5609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5610: IF p_commit = FND_API.G_TRUE
5611: THEN
5612: ROLLBACK TO Copy;
5613: END IF;
5614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5610: IF p_commit = FND_API.G_TRUE
5611: THEN
5612: ROLLBACK TO Copy;
5613: END IF;
5614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5615: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5616: p_procedure_name => 'Copy_Entire_Task',
5617: p_error_text => SUBSTRB(SQLERRM,1,240));
5618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5615: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5616: p_procedure_name => 'Copy_Entire_Task',
5617: p_error_text => SUBSTRB(SQLERRM,1,240));
5618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5619:
5620: WHEN FND_API.G_EXC_ERROR THEN
5621: IF p_commit = FND_API.G_TRUE
5622: THEN

Line 5620: WHEN FND_API.G_EXC_ERROR THEN

5616: p_procedure_name => 'Copy_Entire_Task',
5617: p_error_text => SUBSTRB(SQLERRM,1,240));
5618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5619:
5620: WHEN FND_API.G_EXC_ERROR THEN
5621: IF p_commit = FND_API.G_TRUE
5622: THEN
5623: ROLLBACK TO Copy;
5624: END IF;

Line 5621: IF p_commit = FND_API.G_TRUE

5617: p_error_text => SUBSTRB(SQLERRM,1,240));
5618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5619:
5620: WHEN FND_API.G_EXC_ERROR THEN
5621: IF p_commit = FND_API.G_TRUE
5622: THEN
5623: ROLLBACK TO Copy;
5624: END IF;
5625: x_return_status := 'E';

Line 5628: IF p_commit = FND_API.G_TRUE

5624: END IF;
5625: x_return_status := 'E';
5626:
5627: WHEN OTHERS THEN
5628: IF p_commit = FND_API.G_TRUE
5629: THEN
5630: ROLLBACK TO Copy;
5631: END IF;
5632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5628: IF p_commit = FND_API.G_TRUE
5629: THEN
5630: ROLLBACK TO Copy;
5631: END IF;
5632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5633: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5634: p_procedure_name => 'Copy_Entire_Task',
5635: p_error_text => SUBSTRB(SQLERRM,1,240));
5636: RAISE;

Line 5647: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5643: -- Pre-reqs : None
5644: -- Return Value : N/A
5645: -- Prameters
5646: -- p_api_version IN NUMBER := 1.0
5647: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5648: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
5649: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5650: -- p_validation_level IN VARCHAR2 := 100
5651: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 5648: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

5644: -- Return Value : N/A
5645: -- Prameters
5646: -- p_api_version IN NUMBER := 1.0
5647: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5648: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
5649: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5650: -- p_validation_level IN VARCHAR2 := 100
5651: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5652: -- p_debug_mode IN VARCHAR2 := 'N'

Line 5649: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

5645: -- Prameters
5646: -- p_api_version IN NUMBER := 1.0
5647: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5648: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
5649: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5650: -- p_validation_level IN VARCHAR2 := 100
5651: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5652: -- p_debug_mode IN VARCHAR2 := 'N'
5653: -- p_reference_project_id IN NUMBER

Line 5671: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5667: --
5668:
5669: PROCEDURE Move_Task(
5670: p_api_version IN NUMBER := 1.0
5671: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5672: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5673: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5674: ,p_validation_level IN VARCHAR2 := 100
5675: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 5672: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5668:
5669: PROCEDURE Move_Task(
5670: p_api_version IN NUMBER := 1.0
5671: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5672: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5673: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5674: ,p_validation_level IN VARCHAR2 := 100
5675: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5676: ,p_debug_mode IN VARCHAR2 := 'N'

Line 5673: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

5669: PROCEDURE Move_Task(
5670: p_api_version IN NUMBER := 1.0
5671: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5672: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5673: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5674: ,p_validation_level IN VARCHAR2 := 100
5675: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5676: ,p_debug_mode IN VARCHAR2 := 'N'
5677: ,p_reference_project_id IN NUMBER

Line 5778: x_return_status:= FND_API.G_RET_STS_SUCCESS;

5774: cur_tasks_rec cur_tasks%ROWTYPE; -- added for bug 16088808
5775:
5776: BEGIN
5777:
5778: x_return_status:= FND_API.G_RET_STS_SUCCESS;
5779:
5780: --dbms_output.put_line( 'In move task 0' );
5781:
5782: --Ref project and task id Required check.

Line 5789: IF l_return_status = FND_API.G_RET_STS_ERROR

5785: p_reference_task_id => p_reference_task_id,
5786: x_return_status => l_return_status,
5787: x_error_msg_code => l_error_msg_code );
5788:
5789: IF l_return_status = FND_API.G_RET_STS_ERROR
5790: THEN
5791: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5792: p_msg_name => l_error_msg_code);
5793: x_msg_data := l_error_msg_code;

Line 5795: RAISE FND_API.G_EXC_ERROR;

5791: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5792: p_msg_name => l_error_msg_code);
5793: x_msg_data := l_error_msg_code;
5794: x_return_status := 'E';
5795: RAISE FND_API.G_EXC_ERROR;
5796: END IF;
5797:
5798: --dbms_output.put_line( 'In move task 1' );
5799:

Line 5807: IF l_return_status = FND_API.G_RET_STS_ERROR

5803: p_task_id => p_task_id,
5804: x_return_status => l_return_status,
5805: x_error_msg_code => l_error_msg_code );
5806:
5807: IF l_return_status = FND_API.G_RET_STS_ERROR
5808: THEN
5809: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5810: p_msg_name => l_error_msg_code);
5811: x_msg_data := l_error_msg_code;

Line 5813: RAISE FND_API.G_EXC_ERROR;

5809: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5810: p_msg_name => l_error_msg_code);
5811: x_msg_data := l_error_msg_code;
5812: x_return_status := 'E';
5813: RAISE FND_API.G_EXC_ERROR;
5814: END IF;
5815: --dbms_output.put_line( 'In move task 2' );
5816:
5817:

Line 5823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5819: THEN
5820: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5821: p_msg_name => 'PA_TASK_MOV_NOT_ALLOWED' );
5822: x_msg_data := 'PA_TASK_MOV_NOT_ALLOWED';
5823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END IF;
5826:
5827: --dbms_output.put_line( 'In move task 3' );

Line 5824: RAISE FND_API.G_EXC_ERROR;

5820: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5821: p_msg_name => 'PA_TASK_MOV_NOT_ALLOWED' );
5822: x_msg_data := 'PA_TASK_MOV_NOT_ALLOWED';
5823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END IF;
5826:
5827: --dbms_output.put_line( 'In move task 3' );
5828:

Line 6002: RAISE FND_API.G_EXC_ERROR;

5998: x_return_status := 'E';
5999: x_msg_data := x_msg_data;
6000: --dbms_output.put_line( 'x_msg_data in update task '||x_msg_data );
6001:
6002: RAISE FND_API.G_EXC_ERROR;
6003: END IF;
6004:
6005: END LOOP;
6006:

Line 6054: RAISE FND_API.G_EXC_ERROR;

6050: display_sequence <= l_max_display_sequence ) or display_sequence < 0 );
6051: EXCEPTION
6052: WHEN OTHERS THEN
6053: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
6054: RAISE FND_API.G_EXC_ERROR;
6055: END; */
6056:
6057: EXCEPTION
6058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6054: RAISE FND_API.G_EXC_ERROR;
6055: END; */
6056:
6057: EXCEPTION
6058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6059: IF p_commit = FND_API.G_TRUE
6060: THEN
6061: ROLLBACK TO Move;
6062: END IF;

Line 6059: IF p_commit = FND_API.G_TRUE

6055: END; */
6056:
6057: EXCEPTION
6058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6059: IF p_commit = FND_API.G_TRUE
6060: THEN
6061: ROLLBACK TO Move;
6062: END IF;
6063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6059: IF p_commit = FND_API.G_TRUE
6060: THEN
6061: ROLLBACK TO Move;
6062: END IF;
6063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
6065: p_procedure_name => 'Move_Task',
6066: p_error_text => SUBSTRB(SQLERRM,1,240));
6067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
6065: p_procedure_name => 'Move_Task',
6066: p_error_text => SUBSTRB(SQLERRM,1,240));
6067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6068:
6069: WHEN FND_API.G_EXC_ERROR THEN
6070: IF p_commit = FND_API.G_TRUE
6071: THEN

Line 6069: WHEN FND_API.G_EXC_ERROR THEN

6065: p_procedure_name => 'Move_Task',
6066: p_error_text => SUBSTRB(SQLERRM,1,240));
6067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6068:
6069: WHEN FND_API.G_EXC_ERROR THEN
6070: IF p_commit = FND_API.G_TRUE
6071: THEN
6072: ROLLBACK TO Move;
6073: END IF;

Line 6070: IF p_commit = FND_API.G_TRUE

6066: p_error_text => SUBSTRB(SQLERRM,1,240));
6067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6068:
6069: WHEN FND_API.G_EXC_ERROR THEN
6070: IF p_commit = FND_API.G_TRUE
6071: THEN
6072: ROLLBACK TO Move;
6073: END IF;
6074: x_return_status := 'E';

Line 6077: IF p_commit = FND_API.G_TRUE

6073: END IF;
6074: x_return_status := 'E';
6075:
6076: WHEN OTHERS THEN
6077: IF p_commit = FND_API.G_TRUE
6078: THEN
6079: ROLLBACK TO Move;
6080: END IF;
6081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6077: IF p_commit = FND_API.G_TRUE
6078: THEN
6079: ROLLBACK TO Move;
6080: END IF;
6081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6082: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
6083: p_procedure_name => 'Move_Task',
6084: p_error_text => SUBSTRB(SQLERRM,1,240));
6085: RAISE;

Line 6107: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

6103: -- p_project_id NUMBER YES Project ID
6104: PROCEDURE SET_UNSET_FINANCIAL_TASK
6105: (
6106: p_api_version IN NUMBER := 1.0
6107: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6108: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6109: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6110: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6111: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 6108: , p_commit IN VARCHAR2 := FND_API.G_FALSE

6104: PROCEDURE SET_UNSET_FINANCIAL_TASK
6105: (
6106: p_api_version IN NUMBER := 1.0
6107: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6108: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6109: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6110: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6111: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6112: , p_task_version_id IN NUMBER

Line 6109: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

6105: (
6106: p_api_version IN NUMBER := 1.0
6107: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6108: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6109: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6110: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6111: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6112: , p_task_version_id IN NUMBER
6113: , p_project_id IN NUMBER

Line 6110: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6106: p_api_version IN NUMBER := 1.0
6107: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6108: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6109: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6110: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6111: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6112: , p_task_version_id IN NUMBER
6113: , p_project_id IN NUMBER
6114: , p_checked_flag IN VARCHAR2

Line 6182: x_return_status := FND_API.G_RET_STS_SUCCESS;

6178:
6179:
6180: BEGIN
6181: x_msg_count := 0;
6182: x_return_status := FND_API.G_RET_STS_SUCCESS;
6183:
6184: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6185: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6186: l_user_id := fnd_global.user_id;

Line 6209: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

6205: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
6206: l_debug_level3);
6207: END IF;
6208:
6209: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6210: FND_MSG_PUB.initialize;
6211: END IF;
6212:
6213: IF (p_commit = FND_API.G_TRUE) THEN

Line 6213: IF (p_commit = FND_API.G_TRUE) THEN

6209: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6210: FND_MSG_PUB.initialize;
6211: END IF;
6212:
6213: IF (p_commit = FND_API.G_TRUE) THEN
6214: savepoint SET_UNSET_FINANCIAL_TASK_PVT;
6215: --savepoint SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6216: END IF;
6217:

Line 6275: RAISE FND_API.G_EXC_ERROR;

6271: PA_UTILS.ADD_MESSAGE(
6272: p_app_short_name => 'PA'
6273: , p_msg_name => substr(l_error_msg_code,1,30)--bug 3735089 used substr
6274: );
6275: RAISE FND_API.G_EXC_ERROR;
6276: END IF;
6277: -- END IF; --NVL(l_task_exists,'N') ='Y' THEN
6278: END IF;
6279: --added for the Bug 14640666

Line 6302: RAISE FND_API.G_EXC_ERROR;

6298: p_token2 => 'TASK_NUMBER',
6299: p_value2 => l_task_number,
6300: p_token3 => 'MESSAGE',
6301: p_value3 => l_err_message);
6302: RAISE FND_API.G_EXC_ERROR;
6303: END IF;
6304: END IF;
6305: CLOSE c_task_exists_in_pa_tasks;
6306: END IF;

Line 6324: IF (p_commit = FND_API.G_TRUE) THEN

6320: AND
6321: project_id = p_project_id;
6322:
6323:
6324: IF (p_commit = FND_API.G_TRUE) THEN
6325: COMMIT;
6326: END IF;
6327:
6328: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls

Line 6336: WHEN FND_API.G_EXC_ERROR THEN

6332: END IF;
6333:
6334: EXCEPTION
6335:
6336: WHEN FND_API.G_EXC_ERROR THEN
6337:
6338: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6339: l_msg_count := Fnd_Msg_Pub.count_msg;
6340:

Line 6338: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6334: EXCEPTION
6335:
6336: WHEN FND_API.G_EXC_ERROR THEN
6337:
6338: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6339: l_msg_count := Fnd_Msg_Pub.count_msg;
6340:
6341: IF p_commit = FND_API.G_TRUE THEN
6342: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;

Line 6341: IF p_commit = FND_API.G_TRUE THEN

6337:
6338: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6339: l_msg_count := Fnd_Msg_Pub.count_msg;
6340:
6341: IF p_commit = FND_API.G_TRUE THEN
6342: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;
6343: --ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6344: END IF;
6345: IF c_get_task_id%ISOPEN THEN

Line 6351: ( p_encoded => Fnd_Api.G_TRUE

6347: END IF;
6348: IF l_msg_count = 1 AND x_msg_data IS NULL
6349: THEN
6350: Pa_Interface_Utils_Pub.get_messages
6351: ( p_encoded => Fnd_Api.G_TRUE
6352: , p_msg_index => 1
6353: , p_msg_count => l_msg_count
6354: , p_msg_data => l_msg_data
6355: , p_data => l_data

Line 6369: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6365: END IF;
6366:
6367: WHEN Invalid_Arg_Exc_WP THEN
6368:
6369: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6370: x_msg_count := 1;
6371: x_msg_data := 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
6372:
6373: IF p_commit = FND_API.G_TRUE THEN

Line 6373: IF p_commit = FND_API.G_TRUE THEN

6369: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6370: x_msg_count := 1;
6371: x_msg_data := 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
6372:
6373: IF p_commit = FND_API.G_TRUE THEN
6374: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;
6375: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6376: END IF;
6377: IF c_get_task_id%ISOPEN THEN

Line 6396: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6392: RAISE;
6393:
6394: WHEN OTHERS THEN
6395:
6396: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6397: x_msg_count := 1;
6398: x_msg_data := substr(SQLERRM,1,120);-- Bug 3735089 Added substr
6399:
6400: IF p_commit = FND_API.G_TRUE THEN

Line 6400: IF p_commit = FND_API.G_TRUE THEN

6396: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6397: x_msg_count := 1;
6398: x_msg_data := substr(SQLERRM,1,120);-- Bug 3735089 Added substr
6399:
6400: IF p_commit = FND_API.G_TRUE THEN
6401: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;
6402: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6403: END IF;
6404:

Line 6450: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

6446:
6447: PROCEDURE SYNC_UP_WP_TASKS_WITH_FIN
6448: (
6449: p_api_version IN NUMBER := 1.0
6450: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6451: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6452: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6453: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6454: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 6451: , p_commit IN VARCHAR2 := FND_API.G_FALSE

6447: PROCEDURE SYNC_UP_WP_TASKS_WITH_FIN
6448: (
6449: p_api_version IN NUMBER := 1.0
6450: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6451: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6452: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6453: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6454: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6455: , p_debug_mode IN VARCHAR2 := 'N'

Line 6452: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

6448: (
6449: p_api_version IN NUMBER := 1.0
6450: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6451: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6452: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6453: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6454: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6455: , p_debug_mode IN VARCHAR2 := 'N'
6456: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 6453: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6449: p_api_version IN NUMBER := 1.0
6450: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6451: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6452: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6453: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6454: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6455: , p_debug_mode IN VARCHAR2 := 'N'
6456: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6457: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM

Line 6456: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM

6452: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6453: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6454: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6455: , p_debug_mode IN VARCHAR2 := 'N'
6456: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6457: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6458: , p_project_id IN NUMBER
6459: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6460: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 6457: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM

6453: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6454: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6455: , p_debug_mode IN VARCHAR2 := 'N'
6456: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6457: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6458: , p_project_id IN NUMBER
6459: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6460: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6461: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 6460: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM

6456: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6457: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6458: , p_project_id IN NUMBER
6459: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6460: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6461: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
6462: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
6463: , p_mode IN VARCHAR2 := 'SINGLE'
6464: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 6461: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM

6457: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6458: , p_project_id IN NUMBER
6459: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6460: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6461: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
6462: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
6463: , p_mode IN VARCHAR2 := 'SINGLE'
6464: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6465: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 6462: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

6458: , p_project_id IN NUMBER
6459: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6460: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6461: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
6462: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
6463: , p_mode IN VARCHAR2 := 'SINGLE'
6464: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6465: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6466: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 6581: x_return_status := FND_API.G_RET_STS_SUCCESS;

6577:
6578:
6579: BEGIN
6580: x_msg_count := 0;
6581: x_return_status := FND_API.G_RET_STS_SUCCESS;
6582:
6583: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6584: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6585: l_user_id := fnd_global.user_id;

Line 6616: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

6612: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
6613: l_debug_level3);
6614: END IF;
6615:
6616: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6617: FND_MSG_PUB.initialize;
6618: END IF;
6619:
6620: IF (p_commit = FND_API.G_TRUE) THEN

Line 6620: IF (p_commit = FND_API.G_TRUE) THEN

6616: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6617: FND_MSG_PUB.initialize;
6618: END IF;
6619:
6620: IF (p_commit = FND_API.G_TRUE) THEN
6621: --savepoint SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6622: savepoint SYNC_UP_WP_TASKS_WITH_FIN_PVT;
6623: END IF;
6624: --get carrying_out_organization_id

Line 6648: , p_init_msg_list => FND_API.G_FALSE

6644:
6645: PA_TASKS_MAINT_PUB.DELETE_TASK
6646: (
6647: p_commit => p_commit
6648: , p_init_msg_list => FND_API.G_FALSE
6649: , p_calling_module => p_calling_module
6650: , p_debug_mode => l_debug_mode
6651: , p_project_id => p_project_id
6652: , p_task_id => l_task_id

Line 6661: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

6657: , x_msg_data => x_msg_data
6658: );
6659:
6660:
6661: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6662: THEN
6663: RAISE FND_API.G_EXC_ERROR;
6664: END IF;
6665: END IF;

Line 6663: RAISE FND_API.G_EXC_ERROR;

6659:
6660:
6661: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6662: THEN
6663: RAISE FND_API.G_EXC_ERROR;
6664: END IF;
6665: END IF;
6666:
6667: ELSIF (p_checked_flag='Y')

Line 6693: ,p_init_msg_list => FND_API.G_FALSE

6689: PA_TASKS_MAINT_PUB.CREATE_TASK
6690: (
6691: p_commit => p_commit
6692: ,p_calling_module => p_calling_module
6693: ,p_init_msg_list => FND_API.G_FALSE
6694: ,p_debug_mode => l_debug_mode
6695: ,p_project_id => p_project_id
6696: ,p_reference_task_id => l_parent_task_id
6697: ,p_peer_or_sub => 'SUB'

Line 6708: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

6704: ,x_return_status => x_return_status
6705: ,x_msg_count => x_msg_count
6706: ,x_msg_data => x_msg_data
6707: );
6708: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6709: THEN
6710: RAISE FND_API.G_EXC_ERROR;
6711: END IF;
6712:

Line 6710: RAISE FND_API.G_EXC_ERROR;

6706: ,x_msg_data => x_msg_data
6707: );
6708: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6709: THEN
6710: RAISE FND_API.G_EXC_ERROR;
6711: END IF;
6712:
6713: END IF;
6714: END IF;

Line 6748: , p_init_msg_list => FND_API.G_FALSE

6744: PA_TASKS_MAINT_PUB.DELETE_TASK
6745: (
6746: p_commit => p_commit
6747: , p_calling_module => p_calling_module
6748: , p_init_msg_list => FND_API.G_FALSE
6749: , p_debug_mode => l_debug_mode
6750: , p_project_id => p_project_id
6751: , p_task_id => l_task_id
6752: , p_record_version_number => l_patask_record_version_number

Line 6759: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

6755: , x_return_status => x_return_status
6756: , x_msg_count => x_msg_count
6757: , x_msg_data => x_msg_data
6758: );
6759: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6760: THEN
6761: RAISE FND_API.G_EXC_ERROR;
6762: END IF;
6763:

Line 6761: RAISE FND_API.G_EXC_ERROR;

6757: , x_msg_data => x_msg_data
6758: );
6759: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6760: THEN
6761: RAISE FND_API.G_EXC_ERROR;
6762: END IF;
6763:
6764: ELSIF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='N' AND iCounter.financial_task_flag='Y')
6765: THEN

Line 6780: ,p_init_msg_list => FND_API.G_FALSE

6776: PA_TASKS_MAINT_PUB.CREATE_TASK
6777: (
6778: p_commit => p_commit
6779: ,p_calling_module => p_calling_module
6780: ,p_init_msg_list => FND_API.G_FALSE
6781: ,p_validate_only => p_validate_only
6782: ,p_debug_mode => l_debug_mode
6783: ,p_project_id => p_project_id
6784: ,p_reference_task_id => l_parent_task_id

Line 6796: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

6792: ,x_return_status =>x_return_status
6793: ,x_msg_count =>x_msg_count
6794: ,x_msg_data =>x_msg_data
6795: );
6796: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6797: THEN
6798: RAISE FND_API.G_EXC_ERROR;
6799: END IF;
6800: END IF;

Line 6798: RAISE FND_API.G_EXC_ERROR;

6794: ,x_msg_data =>x_msg_data
6795: );
6796: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6797: THEN
6798: RAISE FND_API.G_EXC_ERROR;
6799: END IF;
6800: END IF;
6801: END LOOP;
6802: END IF;

Line 6804: IF (p_commit = FND_API.G_TRUE) THEN

6800: END IF;
6801: END LOOP;
6802: END IF;
6803:
6804: IF (p_commit = FND_API.G_TRUE) THEN
6805: COMMIT;
6806: END IF;
6807:
6808: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls

Line 6816: WHEN FND_API.G_EXC_ERROR THEN

6812: END IF;
6813:
6814: EXCEPTION
6815:
6816: WHEN FND_API.G_EXC_ERROR THEN
6817:
6818: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6819: l_msg_count := Fnd_Msg_Pub.count_msg;
6820:

Line 6818: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6814: EXCEPTION
6815:
6816: WHEN FND_API.G_EXC_ERROR THEN
6817:
6818: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6819: l_msg_count := Fnd_Msg_Pub.count_msg;
6820:
6821: IF p_commit = FND_API.G_TRUE THEN
6822: --ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089

Line 6821: IF p_commit = FND_API.G_TRUE THEN

6817:
6818: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6819: l_msg_count := Fnd_Msg_Pub.count_msg;
6820:
6821: IF p_commit = FND_API.G_TRUE THEN
6822: --ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6823: ROLLBACK TO SYNC_UP_WP_TASKS_WITH_FIN_PVT;
6824: END IF;
6825:

Line 6845: ( p_encoded => Fnd_Api.G_TRUE

6841:
6842: IF l_msg_count = 1 AND x_msg_data IS NULL
6843: THEN
6844: Pa_Interface_Utils_Pub.get_messages
6845: ( p_encoded => Fnd_Api.G_TRUE
6846: , p_msg_index => 1
6847: , p_msg_count => l_msg_count
6848: , p_msg_data => l_msg_data
6849: , p_data => l_data

Line 6863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6859: END IF;
6860:
6861: WHEN Invalid_Arg_Exc_WP THEN
6862:
6863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6864: x_msg_count := 1;
6865: x_msg_data := 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
6866:
6867: IF p_commit = FND_API.G_TRUE THEN

Line 6867: IF p_commit = FND_API.G_TRUE THEN

6863: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6864: x_msg_count := 1;
6865: x_msg_data := 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
6866:
6867: IF p_commit = FND_API.G_TRUE THEN
6868: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6869: ROLLBACK TO SYNC_UP_WP_TASKS_WITH_FIN_PVT;
6870: END IF;
6871: IF c_get_task_id%ISOPEN THEN

Line 6901: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6897: RAISE;
6898:
6899: WHEN OTHERS THEN
6900:
6901: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6902: x_msg_count := 1;
6903: x_msg_data := substr(SQLERRM,1,120);-- Bug 3735089 Added substr
6904: IF p_commit = FND_API.G_TRUE THEN
6905: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089

Line 6904: IF p_commit = FND_API.G_TRUE THEN

6900:
6901: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6902: x_msg_count := 1;
6903: x_msg_data := substr(SQLERRM,1,120);-- Bug 3735089 Added substr
6904: IF p_commit = FND_API.G_TRUE THEN
6905: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6906: ROLLBACK TO SYNC_UP_WP_TASKS_WITH_FIN_PVT;
6907: END IF;
6908: