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 1797: x_return_status := FND_API.G_RET_STS_SUCCESS;

1793: END IF;
1794:
1795:
1796:
1797: x_return_status := FND_API.G_RET_STS_SUCCESS;
1798: p_task_id := l_new_task_id;
1799: x_display_seq := l_sequence_number;
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN

Line 1801: WHEN FND_API.G_EXC_ERROR THEN

1797: x_return_status := FND_API.G_RET_STS_SUCCESS;
1798: p_task_id := l_new_task_id;
1799: x_display_seq := l_sequence_number;
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN
1802: IF (p_commit = FND_API.G_TRUE) THEN
1803: ROLLBACK to CREATE_TASK_PRIVATE;
1804: END IF;
1805: x_msg_count := FND_MSG_PUB.count_msg;

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

1798: p_task_id := l_new_task_id;
1799: x_display_seq := l_sequence_number;
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN
1802: IF (p_commit = FND_API.G_TRUE) THEN
1803: ROLLBACK to CREATE_TASK_PRIVATE;
1804: END IF;
1805: x_msg_count := FND_MSG_PUB.count_msg;
1806: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1806: x_return_status := FND_API.G_RET_STS_ERROR;

1802: IF (p_commit = FND_API.G_TRUE) THEN
1803: ROLLBACK to CREATE_TASK_PRIVATE;
1804: END IF;
1805: x_msg_count := FND_MSG_PUB.count_msg;
1806: x_return_status := FND_API.G_RET_STS_ERROR;
1807: WHEN OTHERS THEN
1808: IF (p_commit = FND_API.G_TRUE) THEN
1809: ROLLBACK to CREATE_TASK_PRIVATE;
1810: END IF;

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

1804: END IF;
1805: x_msg_count := FND_MSG_PUB.count_msg;
1806: x_return_status := FND_API.G_RET_STS_ERROR;
1807: WHEN OTHERS THEN
1808: IF (p_commit = FND_API.G_TRUE) THEN
1809: ROLLBACK to CREATE_TASK_PRIVATE;
1810: END IF;
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1812: x_msg_count := FND_MSG_PUB.count_msg;

Line 1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1807: WHEN OTHERS THEN
1808: IF (p_commit = FND_API.G_TRUE) THEN
1809: ROLLBACK to CREATE_TASK_PRIVATE;
1810: END IF;
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1812: x_msg_count := FND_MSG_PUB.count_msg;
1813: --put message
1814: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
1815: p_procedure_name => 'CREATE_TASK',

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

1822: -- Pre-reqs : None
1823: -- Return Value : N/A
1824: -- Parameters
1825: -- p_api_version IN NUMBER := 1.0
1826: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1827: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1828: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1829: -- p_validation_level IN VARCHAR2 := 100
1830: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

1823: -- Return Value : N/A
1824: -- Parameters
1825: -- p_api_version IN NUMBER := 1.0
1826: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1827: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1828: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1829: -- p_validation_level IN VARCHAR2 := 100
1830: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1831: -- p_debug_mode IN VARCHAR2 := 'N'

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

1824: -- Parameters
1825: -- p_api_version IN NUMBER := 1.0
1826: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1827: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1828: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1829: -- p_validation_level IN VARCHAR2 := 100
1830: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1831: -- p_debug_mode IN VARCHAR2 := 'N'
1832: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1934:
1935: procedure UPDATE_TASK
1936: (
1937: p_api_version IN NUMBER := 1.0
1938: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1939: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1940: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1941: ,p_validation_level IN VARCHAR2 := 100
1942: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

1935: procedure UPDATE_TASK
1936: (
1937: p_api_version IN NUMBER := 1.0
1938: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1939: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1940: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1941: ,p_validation_level IN VARCHAR2 := 100
1942: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1943: ,p_debug_mode IN VARCHAR2 := 'N'

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

1936: (
1937: p_api_version IN NUMBER := 1.0
1938: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1939: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1940: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1941: ,p_validation_level IN VARCHAR2 := 100
1942: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1943: ,p_debug_mode IN VARCHAR2 := 'N'
1944:

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

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

Line 2323: raise FND_API.G_EXC_ERROR;

2319: where task_id = p_task_id;
2320: EXCEPTION
2321: WHEN NO_DATA_FOUND THEN
2322: PA_UTILS.ADD_MESSAGE('PA','PA_EXP_NO_TASK'); -- specified task does not exist
2323: raise FND_API.G_EXC_ERROR;
2324: END;
2325: ELSE
2326: t_pm_product_code := p_pm_product_code;
2327: END IF;

Line 2521: p_encoded => FND_API.G_TRUE,

2517: IF (l_msg_count > 0) THEN
2518: x_msg_count := l_msg_count;
2519: IF (x_msg_count = 1) THEN
2520: pa_interface_utils_pub.get_messages(
2521: p_encoded => FND_API.G_TRUE,
2522: p_msg_index => 1,
2523: p_data => l_data,
2524: p_msg_index_out => l_msg_index_out);
2525: x_msg_data := l_data;

Line 2527: RAISE FND_API.G_EXC_ERROR;

2523: p_data => l_data,
2524: p_msg_index_out => l_msg_index_out);
2525: x_msg_data := l_data;
2526: END IF;
2527: RAISE FND_API.G_EXC_ERROR;
2528: END IF;
2529: END IF;
2530: END IF;
2531:

Line 2581: p_encoded => FND_API.G_TRUE,

2577: IF (l_msg_count > 0) THEN
2578: x_msg_count := l_msg_count;
2579: IF (x_msg_count = 1) THEN
2580: pa_interface_utils_pub.get_messages(
2581: p_encoded => FND_API.G_TRUE,
2582: p_msg_index => 1,
2583: p_data => l_data,
2584: p_msg_index_out => l_msg_index_out);
2585: x_msg_data := l_data;

Line 2587: RAISE FND_API.G_EXC_ERROR;

2583: p_data => l_data,
2584: p_msg_index_out => l_msg_index_out);
2585: x_msg_data := l_data;
2586: END IF;
2587: RAISE FND_API.G_EXC_ERROR;
2588: END IF;
2589:
2590: --Check Completion Date
2591: -- Added for bug 5665772

Line 2757: p_encoded => FND_API.G_TRUE,

2753: IF (l_msg_count > 0) THEN
2754: x_msg_count := l_msg_count;
2755: IF (x_msg_count = 1) THEN
2756: pa_interface_utils_pub.get_messages(
2757: p_encoded => FND_API.G_TRUE,
2758: p_msg_index => 1,
2759: p_data => l_data,
2760: p_msg_index_out => l_msg_index_out);
2761: x_msg_data := l_data;

Line 2763: RAISE FND_API.G_EXC_ERROR;

2759: p_data => l_data,
2760: p_msg_index_out => l_msg_index_out);
2761: x_msg_data := l_data;
2762: END IF;
2763: RAISE FND_API.G_EXC_ERROR;
2764: END IF;
2765:
2766:
2767: --dbms_output.put_line( 'In update task 15' );

Line 3308: x_return_status := FND_API.G_RET_STS_SUCCESS;

3304: --End PA L Capital Project Changes 2872708
3305: tGEN_ETC_SOURCE_CODE
3306: );
3307:
3308: x_return_status := FND_API.G_RET_STS_SUCCESS;
3309:
3310:
3311: EXCEPTION
3312: WHEN FND_API.G_EXC_ERROR THEN

Line 3312: WHEN FND_API.G_EXC_ERROR THEN

3308: x_return_status := FND_API.G_RET_STS_SUCCESS;
3309:
3310:
3311: EXCEPTION
3312: WHEN FND_API.G_EXC_ERROR THEN
3313: IF (p_commit = FND_API.G_TRUE) THEN
3314: ROLLBACK to UPDATE_TASK_PRIVATE;
3315: END IF;
3316: x_return_status := FND_API.G_RET_STS_ERROR;

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

3309:
3310:
3311: EXCEPTION
3312: WHEN FND_API.G_EXC_ERROR THEN
3313: IF (p_commit = FND_API.G_TRUE) THEN
3314: ROLLBACK to UPDATE_TASK_PRIVATE;
3315: END IF;
3316: x_return_status := FND_API.G_RET_STS_ERROR;
3317: WHEN NO_DATA_FOUND THEN

Line 3316: x_return_status := FND_API.G_RET_STS_ERROR;

3312: WHEN FND_API.G_EXC_ERROR THEN
3313: IF (p_commit = FND_API.G_TRUE) THEN
3314: ROLLBACK to UPDATE_TASK_PRIVATE;
3315: END IF;
3316: x_return_status := FND_API.G_RET_STS_ERROR;
3317: WHEN NO_DATA_FOUND THEN
3318: IF (p_commit = FND_API.G_TRUE) THEN
3319: ROLLBACK to UPDATE_TASK_PRIVATE;
3320: END IF;

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

3314: ROLLBACK to UPDATE_TASK_PRIVATE;
3315: END IF;
3316: x_return_status := FND_API.G_RET_STS_ERROR;
3317: WHEN NO_DATA_FOUND THEN
3318: IF (p_commit = FND_API.G_TRUE) THEN
3319: ROLLBACK to UPDATE_TASK_PRIVATE;
3320: END IF;
3321: x_msg_count := FND_MSG_PUB.count_msg;
3322: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3322: x_return_status := FND_API.G_RET_STS_ERROR;

3318: IF (p_commit = FND_API.G_TRUE) THEN
3319: ROLLBACK to UPDATE_TASK_PRIVATE;
3320: END IF;
3321: x_msg_count := FND_MSG_PUB.count_msg;
3322: x_return_status := FND_API.G_RET_STS_ERROR;
3323: WHEN OTHERS THEN
3324: IF (p_commit = FND_API.G_TRUE) THEN
3325: ROLLBACK to UPDATE_TASK_PRIVATE;
3326: END IF;

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

3320: END IF;
3321: x_msg_count := FND_MSG_PUB.count_msg;
3322: x_return_status := FND_API.G_RET_STS_ERROR;
3323: WHEN OTHERS THEN
3324: IF (p_commit = FND_API.G_TRUE) THEN
3325: ROLLBACK to UPDATE_TASK_PRIVATE;
3326: END IF;
3327: x_msg_count := FND_MSG_PUB.count_msg;
3328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3324: IF (p_commit = FND_API.G_TRUE) THEN
3325: ROLLBACK to UPDATE_TASK_PRIVATE;
3326: END IF;
3327: x_msg_count := FND_MSG_PUB.count_msg;
3328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3329: --put message
3330: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3331: p_procedure_name => 'UPDATE_TASK',
3332: p_error_text => SUBSTRB(SQLERRM,1,240));

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

3336:
3337: procedure DELETE_TASK
3338: (
3339: p_api_version IN NUMBER := 1.0
3340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3341: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3342: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3343: ,p_validation_level IN VARCHAR2 := 100
3344: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

3337: procedure DELETE_TASK
3338: (
3339: p_api_version IN NUMBER := 1.0
3340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3341: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3342: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3343: ,p_validation_level IN VARCHAR2 := 100
3344: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
3345: ,p_debug_mode IN VARCHAR2 := 'N'

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

3338: (
3339: p_api_version IN NUMBER := 1.0
3340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3341: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3342: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3343: ,p_validation_level IN VARCHAR2 := 100
3344: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
3345: ,p_debug_mode IN VARCHAR2 := 'N'
3346: ,p_task_id IN NUMBER

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

3384: IF (p_debug_mode = 'Y') THEN
3385: pa_debug.debug('PA_TASKS_MAINT_PVT.DELETE_TASK BEGIN');
3386: END IF;
3387:
3388: IF (p_commit = FND_API.G_TRUE) THEN
3389: savepoint DELETE_TASK_PRIVATE;
3390: END IF;
3391:
3392: IF (p_debug_mode = 'Y') THEN

Line 3405: raise FND_API.G_EXC_ERROR;

3401: where task_id = p_task_id;
3402: EXCEPTION
3403: WHEN NO_DATA_FOUND THEN
3404: PA_UTILS.ADD_MESSAGE('PA','PA_EXP_NO_TASK'); -- specified task does not exist
3405: raise FND_API.G_EXC_ERROR;
3406: END;
3407:
3408: -- Set controls
3409: IF (p_calling_module IN ('SELF_SERVICE')) THEN

Line 3440: raise FND_API.G_EXC_ERROR;

3436: If (p_calling_module IN ('SELF_SERVICE', 'FORM')) THEN
3437: --Check if task can be deleted;
3438: IF (t_pm_product_code IS NOT NULL) AND (l_delete_task_allowed = 'N') THEN
3439: PA_UTILS.ADD_MESSAGE('PA', 'PA_PR_PM_CANNOT_DELETE');
3440: raise FND_API.G_EXC_ERROR;
3441: END IF;
3442:
3443: /* do not stop delting the last task. FPM changes
3444: refer bug 3427157

Line 3453: raise FND_API.G_EXC_ERROR;

3449: --Check if this is last task;
3450: If (PA_TASK_UTILS.check_last_task(p_task_id) <> 0) THEN
3451: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3452: p_msg_name => 'PA_TK_CANT_DELETE_LAST_TASK');
3453: raise FND_API.G_EXC_ERROR;
3454: END IF;
3455: END IF;
3456: do not stop delting the last task. FPM changes*/
3457:

Line 3469: raise FND_API.G_EXC_ERROR;

3465: x_err_stage => l_err_stage,
3466: x_err_stack => l_err_stack);
3467: IF (l_err_code <> 0) THEN
3468: PA_UTILS.ADD_MESSAGE('PA', substr(l_err_stage, 1, 30));
3469: raise FND_API.G_EXC_ERROR;
3470: END IF;
3471: END IF;
3472: -- 4201927 end
3473:

Line 3487: raise FND_API.G_EXC_ERROR;

3483:
3484: If (l_err_code <> 0) THEN
3485: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3486: p_msg_name => substr(l_err_stage,1,30));
3487: raise FND_API.G_EXC_ERROR;
3488: END IF;
3489:
3490: IF (p_calling_module IN ('SELF_SERVICE', 'FORM')) THEN
3491: --Check if child exist for current parent task. If not,

Line 3509: (p_encoded => FND_API.G_TRUE,

3505: IF (l_msg_count > 0) then
3506: x_msg_count := l_msg_count;
3507: IF (x_msg_count = 1) then
3508: pa_interface_utils_pub.get_messages
3509: (p_encoded => FND_API.G_TRUE,
3510: p_msg_index => 1,
3511: p_data => l_data,
3512: p_msg_index_out => l_msg_index_out);
3513: x_msg_data := l_data;

Line 3515: raise FND_API.G_EXC_ERROR;

3511: p_data => l_data,
3512: p_msg_index_out => l_msg_index_out);
3513: x_msg_data := l_data;
3514: end if;
3515: raise FND_API.G_EXC_ERROR;
3516: end if;
3517:
3518: x_return_status := FND_API.G_RET_STS_SUCCESS;
3519:

Line 3518: x_return_status := FND_API.G_RET_STS_SUCCESS;

3514: end if;
3515: raise FND_API.G_EXC_ERROR;
3516: end if;
3517:
3518: x_return_status := FND_API.G_RET_STS_SUCCESS;
3519:
3520: EXCEPTION
3521: WHEN FND_API.G_EXC_ERROR THEN
3522: IF (p_commit = FND_API.G_TRUE) THEN

Line 3521: WHEN FND_API.G_EXC_ERROR THEN

3517:
3518: x_return_status := FND_API.G_RET_STS_SUCCESS;
3519:
3520: EXCEPTION
3521: WHEN FND_API.G_EXC_ERROR THEN
3522: IF (p_commit = FND_API.G_TRUE) THEN
3523: ROLLBACK to DELETE_TASK_PRIVATE;
3524: END IF;
3525: x_msg_count := FND_MSG_PUB.count_msg;

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

3518: x_return_status := FND_API.G_RET_STS_SUCCESS;
3519:
3520: EXCEPTION
3521: WHEN FND_API.G_EXC_ERROR THEN
3522: IF (p_commit = FND_API.G_TRUE) THEN
3523: ROLLBACK to DELETE_TASK_PRIVATE;
3524: END IF;
3525: x_msg_count := FND_MSG_PUB.count_msg;
3526: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3526: x_return_status := FND_API.G_RET_STS_ERROR;

3522: IF (p_commit = FND_API.G_TRUE) THEN
3523: ROLLBACK to DELETE_TASK_PRIVATE;
3524: END IF;
3525: x_msg_count := FND_MSG_PUB.count_msg;
3526: x_return_status := FND_API.G_RET_STS_ERROR;
3527: WHEN OTHERS THEN
3528: IF (p_commit = FND_API.G_TRUE) THEN
3529: ROLLBACK to DELETE_TASK_PRIVATE;
3530: END IF;

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

3524: END IF;
3525: x_msg_count := FND_MSG_PUB.count_msg;
3526: x_return_status := FND_API.G_RET_STS_ERROR;
3527: WHEN OTHERS THEN
3528: IF (p_commit = FND_API.G_TRUE) THEN
3529: ROLLBACK to DELETE_TASK_PRIVATE;
3530: END IF;
3531: x_msg_count := FND_MSG_PUB.count_msg;
3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3528: IF (p_commit = FND_API.G_TRUE) THEN
3529: ROLLBACK to DELETE_TASK_PRIVATE;
3530: END IF;
3531: x_msg_count := FND_MSG_PUB.count_msg;
3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3533: --put message
3534: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3535: p_procedure_name => 'DELETE_TASK',
3536: p_error_text => SUBSTRB(SQLERRM,1,240));

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

3541: -- Type : Private procedure
3542: -- Pre-reqs : None
3543: -- Return Value : N/A
3544: -- Prameters
3545: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3546: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3547: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3548: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3549: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

3542: -- Pre-reqs : None
3543: -- Return Value : N/A
3544: -- Prameters
3545: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3546: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3547: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3548: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3549: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3550: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

3543: -- Return Value : N/A
3544: -- Prameters
3545: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3546: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3547: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3548: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3549: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3550: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
3551: -- p_project_id IN NUMBER REQUIRED

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

3546: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3547: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3548: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3549: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3550: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
3551: -- p_project_id IN NUMBER REQUIRED
3552: -- p_task_id IN NUMBER REQUIRED
3553: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
3554: -- x_return_status OUT VARCHAR2 REQUIRED

Line 3565: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

3561: --
3562: --
3563:
3564: PROCEDURE Indent_Task(
3565: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3566: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3567: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3568: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3569: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 3566: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

3562: --
3563:
3564: PROCEDURE Indent_Task(
3565: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3566: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3567: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3568: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3569: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3570: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 3567: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

3563:
3564: PROCEDURE Indent_Task(
3565: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3566: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3567: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3568: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3569: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3570: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
3571: ,p_project_id IN NUMBER

Line 3570: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

3566: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3567: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3568: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3569: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3570: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
3571: ,p_project_id IN NUMBER
3572: ,p_task_id IN NUMBER
3573: ,p_record_version_number IN NUMBER DEFAULT 1
3574: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3654: IF p_commit = FND_API.G_TRUE

3650: l_err_stage VARCHAR2(80); -- VARCHAR2(80)
3651:
3652: BEGIN
3653:
3654: IF p_commit = FND_API.G_TRUE
3655: THEN
3656: SAVEPOINT Edit_Structure;
3657: END IF;
3658: x_return_status := 'S';

Line 3690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3686: THEN
3687: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3688: p_msg_name => 'PA_TASK_CANNOT_INDENT' );
3689: x_msg_data := 'PA_TASK_CANNOT_INDENT';
3690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3691: RAISE FND_API.G_EXC_ERROR;
3692:
3693: ELSE
3694:

Line 3691: RAISE FND_API.G_EXC_ERROR;

3687: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3688: p_msg_name => 'PA_TASK_CANNOT_INDENT' );
3689: x_msg_data := 'PA_TASK_CANNOT_INDENT';
3690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3691: RAISE FND_API.G_EXC_ERROR;
3692:
3693: ELSE
3694:
3695: --dbms_output.put_line( 'Indent Task PVT : Stage 2' ||' l_task_level '||l_task_level||' l_task_level_above '||l_task_level_above);

Line 3754: RAISE FND_API.G_EXC_ERROR;

3750:
3751: IF l_msg_count > 0 THEN
3752: x_msg_count := l_msg_count;
3753: x_return_status := 'E';
3754: RAISE FND_API.G_EXC_ERROR;
3755: END IF;
3756:
3757: -- Changes for bug 3125880
3758: -- As Parent Task Id of the Task being indented is updated and b'coz of this

Line 3798: RAISE FND_API.G_EXC_ERROR;

3794:
3795: IF l_msg_count > 0 THEN
3796: x_msg_count := l_msg_count;
3797: x_return_status := 'E';
3798: RAISE FND_API.G_EXC_ERROR;
3799: END IF;
3800:
3801: END LOOP;
3802:

Line 3839: RAISE FND_API.G_EXC_ERROR;

3835:
3836: IF l_msg_count > 0 THEN
3837: x_msg_count := l_msg_count;
3838: x_return_status := 'E';
3839: RAISE FND_API.G_EXC_ERROR;
3840: END IF;
3841:
3842: -- 2) update the top task id of the indenting task including its children with the top task id of the task above.
3843: -- 3) update the wbs level of the indenting task and its children

Line 3870: RAISE FND_API.G_EXC_ERROR;

3866:
3867: IF l_msg_count > 0 THEN
3868: x_msg_count := l_msg_count;
3869: x_return_status := 'E';
3870: RAISE FND_API.G_EXC_ERROR;
3871: END IF;
3872:
3873: END LOOP;
3874: END IF;

Line 3878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3874: END IF;
3875: END IF;
3876:
3877: EXCEPTION
3878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3879: IF p_commit = FND_API.G_TRUE
3880: THEN
3881: ROLLBACK TO Edit_Structure;
3882: END IF;

Line 3879: IF p_commit = FND_API.G_TRUE

3875: END IF;
3876:
3877: EXCEPTION
3878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3879: IF p_commit = FND_API.G_TRUE
3880: THEN
3881: ROLLBACK TO Edit_Structure;
3882: END IF;
3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3879: IF p_commit = FND_API.G_TRUE
3880: THEN
3881: ROLLBACK TO Edit_Structure;
3882: END IF;
3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3884: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3885: p_procedure_name => 'Indent_task',
3886: p_error_text => SUBSTRB(SQLERRM,1,240));
3887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3884: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3885: p_procedure_name => 'Indent_task',
3886: p_error_text => SUBSTRB(SQLERRM,1,240));
3887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3888:
3889: WHEN FND_API.G_EXC_ERROR THEN
3890: IF p_commit = FND_API.G_TRUE
3891: THEN

Line 3889: WHEN FND_API.G_EXC_ERROR THEN

3885: p_procedure_name => 'Indent_task',
3886: p_error_text => SUBSTRB(SQLERRM,1,240));
3887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3888:
3889: WHEN FND_API.G_EXC_ERROR THEN
3890: IF p_commit = FND_API.G_TRUE
3891: THEN
3892: ROLLBACK TO Edit_Structure;
3893: END IF;

Line 3890: IF p_commit = FND_API.G_TRUE

3886: p_error_text => SUBSTRB(SQLERRM,1,240));
3887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3888:
3889: WHEN FND_API.G_EXC_ERROR THEN
3890: IF p_commit = FND_API.G_TRUE
3891: THEN
3892: ROLLBACK TO Edit_Structure;
3893: END IF;
3894: x_return_status := 'E';

Line 3897: IF p_commit = FND_API.G_TRUE

3893: END IF;
3894: x_return_status := 'E';
3895:
3896: WHEN OTHERS 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: RAISE;

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

3910: -- Type : Private procedure
3911: -- Pre-reqs : None
3912: -- Return Value : N/A
3913: -- Prameters
3914: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3915: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3916: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3917: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3918: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

3911: -- Pre-reqs : None
3912: -- Return Value : N/A
3913: -- Prameters
3914: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3915: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3916: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3917: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3918: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3919: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

3912: -- Return Value : N/A
3913: -- Prameters
3914: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
3915: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3916: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3917: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3918: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3919: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
3920: -- p_project_id IN NUMBER REQUIRED

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

3915: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
3916: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
3917: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
3918: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
3919: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
3920: -- p_project_id IN NUMBER REQUIRED
3921: -- p_task_id IN NUMBER REQUIRED
3922: -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
3923: -- x_return_status OUT VARCHAR2 REQUIRED

Line 3934: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

3930: --
3931: --
3932:
3933: PROCEDURE Outdent_Task(
3934: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3935: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3936: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3937: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3938: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 3935: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

3931: --
3932:
3933: PROCEDURE Outdent_Task(
3934: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3935: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3936: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3937: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3938: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3939: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 3936: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

3932:
3933: PROCEDURE Outdent_Task(
3934: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3935: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3936: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3937: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3938: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3939: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
3940: ,p_project_id IN NUMBER

Line 3939: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

3935: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
3936: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
3937: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
3938: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
3939: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
3940: ,p_project_id IN NUMBER
3941: ,p_task_id IN NUMBER
3942: ,p_record_version_number IN NUMBER DEFAULT 1
3943: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4035: IF p_commit = FND_API.G_TRUE

4031: AND project_id = p_project_id
4032: AND top_task_id = p_top_task_id_above;
4033: BEGIN
4034:
4035: IF p_commit = FND_API.G_TRUE
4036: THEN
4037: SAVEPOINT Edit_Structure;
4038: END IF;
4039: x_return_status := 'S';

Line 4066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4062: THEN
4063: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4064: p_msg_name => 'PA_TASK_CANNOT_OUTDENT' );
4065: x_msg_data := 'PA_TASK_CANNOT_OUTDENT';
4066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4067: RAISE FND_API.G_EXC_ERROR;
4068: END IF;
4069:
4070: --If the task above is at lower wbs level

Line 4067: RAISE FND_API.G_EXC_ERROR;

4063: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4064: p_msg_name => 'PA_TASK_CANNOT_OUTDENT' );
4065: x_msg_data := 'PA_TASK_CANNOT_OUTDENT';
4066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4067: RAISE FND_API.G_EXC_ERROR;
4068: END IF;
4069:
4070: --If the task above is at lower wbs level
4071: IF l_task_level_above < l_task_level

Line 4096: RAISE FND_API.G_EXC_ERROR;

4092:
4093: IF l_msg_count > 0 THEN
4094: x_msg_count := l_msg_count;
4095: x_return_status := 'E';
4096: RAISE FND_API.G_EXC_ERROR;
4097: END IF;
4098:
4099: --1) update wbs level of outdenting task includinf its children
4100:

Line 4124: RAISE FND_API.G_EXC_ERROR;

4120:
4121: IF l_msg_count > 0 THEN
4122: x_msg_count := l_msg_count;
4123: x_return_status := 'E';
4124: RAISE FND_API.G_EXC_ERROR;
4125: END IF;
4126:
4127: END LOOP;
4128:

Line 4162: RAISE FND_API.G_EXC_ERROR;

4158:
4159: IF l_msg_count > 0 THEN
4160: x_msg_count := l_msg_count;
4161: x_return_status := 'E';
4162: RAISE FND_API.G_EXC_ERROR;
4163: END IF;
4164:
4165: END LOOP;
4166: END IF;

Line 4194: RAISE FND_API.G_EXC_ERROR;

4190:
4191: IF l_msg_count > 0 THEN
4192: x_msg_count := l_msg_count;
4193: x_return_status := 'E';
4194: RAISE FND_API.G_EXC_ERROR;
4195: END IF;
4196:
4197: END LOOP;
4198:

Line 4239: RAISE FND_API.G_EXC_ERROR;

4235:
4236: IF l_msg_count > 0 THEN
4237: x_msg_count := l_msg_count;
4238: x_return_status := 'E';
4239: RAISE FND_API.G_EXC_ERROR;
4240: END IF;
4241:
4242:
4243: --1) update wbs level

Line 4268: RAISE FND_API.G_EXC_ERROR;

4264:
4265: IF l_msg_count > 0 THEN
4266: x_msg_count := l_msg_count;
4267: x_return_status := 'E';
4268: RAISE FND_API.G_EXC_ERROR;
4269: END IF;
4270:
4271: END LOOP;
4272:

Line 4302: RAISE FND_API.G_EXC_ERROR;

4298:
4299: IF l_msg_count > 0 THEN
4300: x_msg_count := l_msg_count;
4301: x_return_status := 'E';
4302: RAISE FND_API.G_EXC_ERROR;
4303: END IF;
4304:
4305: END LOOP;
4306:

Line 4347: RAISE FND_API.G_EXC_ERROR;

4343:
4344: IF l_msg_count > 0 THEN
4345: x_msg_count := l_msg_count;
4346: x_return_status := 'E';
4347: RAISE FND_API.G_EXC_ERROR;
4348: END IF;
4349:
4350: --1) update wbs level of outdenting task and its all child tasks
4351: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP

Line 4374: RAISE FND_API.G_EXC_ERROR;

4370:
4371: IF l_msg_count > 0 THEN
4372: x_msg_count := l_msg_count;
4373: x_return_status := 'E';
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376: END LOOP;
4377:
4378: --2) updating parent of the new children

Line 4406: RAISE FND_API.G_EXC_ERROR;

4402:
4403: IF l_msg_count > 0 THEN
4404: x_msg_count := l_msg_count;
4405: x_return_status := 'E';
4406: RAISE FND_API.G_EXC_ERROR;
4407: END IF;
4408:
4409: END LOOP;
4410:

Line 4438: RAISE FND_API.G_EXC_ERROR;

4434:
4435: IF l_msg_count > 0 THEN
4436: x_msg_count := l_msg_count;
4437: x_return_status := 'E';
4438: RAISE FND_API.G_EXC_ERROR;
4439: END IF;
4440:
4441: --2) updating parent of the new children
4442:

Line 4472: RAISE FND_API.G_EXC_ERROR;

4468:
4469: IF l_msg_count > 0 THEN
4470: x_msg_count := l_msg_count;
4471: x_return_status := 'E';
4472: RAISE FND_API.G_EXC_ERROR;
4473: END IF;
4474:
4475: --updating top_task_id of child tasks of outdenting task's new child tasks
4476: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( cur_new_child_task_rec.task_id ) LOOP

Line 4498: RAISE FND_API.G_EXC_ERROR;

4494:
4495: IF l_msg_count > 0 THEN
4496: x_msg_count := l_msg_count;
4497: x_return_status := 'E';
4498: RAISE FND_API.G_EXC_ERROR;
4499: END IF;
4500: END LOOP;
4501: END LOOP;
4502:

Line 4526: RAISE FND_API.G_EXC_ERROR;

4522: l_msg_count := FND_MSG_PUB.count_msg;
4523: IF l_msg_count > 0 THEN
4524: x_msg_count := l_msg_count;
4525: x_return_status := 'E';
4526: RAISE FND_API.G_EXC_ERROR;
4527: END IF;
4528: END LOOP;
4529:
4530:

Line 4557: RAISE FND_API.G_EXC_ERROR;

4553:
4554: IF l_msg_count > 0 THEN
4555: x_msg_count := l_msg_count;
4556: x_return_status := 'E';
4557: RAISE FND_API.G_EXC_ERROR;
4558: END IF;
4559: END LOOP;
4560: END IF;
4561: END IF;

Line 4564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4560: END IF;
4561: END IF;
4562:
4563: EXCEPTION
4564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4565: IF p_commit = FND_API.G_TRUE
4566: THEN
4567: ROLLBACK TO Edit_Structure;
4568: END IF;

Line 4565: IF p_commit = FND_API.G_TRUE

4561: END IF;
4562:
4563: EXCEPTION
4564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4565: IF p_commit = FND_API.G_TRUE
4566: THEN
4567: ROLLBACK TO Edit_Structure;
4568: END IF;
4569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4565: IF p_commit = FND_API.G_TRUE
4566: THEN
4567: ROLLBACK TO Edit_Structure;
4568: END IF;
4569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4570: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4571: p_procedure_name => 'Outdent_task',
4572: p_error_text => SUBSTRB(SQLERRM,1,240));
4573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4570: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4571: p_procedure_name => 'Outdent_task',
4572: p_error_text => SUBSTRB(SQLERRM,1,240));
4573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4574:
4575: WHEN FND_API.G_EXC_ERROR THEN
4576: IF p_commit = FND_API.G_TRUE
4577: THEN

Line 4575: WHEN FND_API.G_EXC_ERROR THEN

4571: p_procedure_name => 'Outdent_task',
4572: p_error_text => SUBSTRB(SQLERRM,1,240));
4573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4574:
4575: WHEN FND_API.G_EXC_ERROR THEN
4576: IF p_commit = FND_API.G_TRUE
4577: THEN
4578: ROLLBACK TO Edit_Structure;
4579: END IF;

Line 4576: IF p_commit = FND_API.G_TRUE

4572: p_error_text => SUBSTRB(SQLERRM,1,240));
4573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4574:
4575: WHEN FND_API.G_EXC_ERROR THEN
4576: IF p_commit = FND_API.G_TRUE
4577: THEN
4578: ROLLBACK TO Edit_Structure;
4579: END IF;
4580: x_return_status := 'E';

Line 4583: IF p_commit = FND_API.G_TRUE

4579: END IF;
4580: x_return_status := 'E';
4581:
4582: WHEN OTHERS 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: RAISE;

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

4595: -- Type : Private procedure
4596: -- Pre-reqs : None
4597: -- Return Value : N/A
4598: -- Prameters
4599: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4600: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4601: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4602: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4603: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

4596: -- Pre-reqs : None
4597: -- Return Value : N/A
4598: -- Prameters
4599: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4600: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4601: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4602: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4603: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4604: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

4597: -- Return Value : N/A
4598: -- Prameters
4599: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4600: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4601: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4602: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4603: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4604: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
4605: -- p_reference_project_id IN NUMBER

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

4600: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4601: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4602: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4603: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4604: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
4605: -- p_reference_project_id IN NUMBER
4606: -- p_reference_task_id IN NUMBER
4607: -- p_project_id IN NUMBER
4608: -- p_peer_or_sub IN VARCHAR2

Line 4621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

4617: --
4618: --
4619:
4620: PROCEDURE Copy_Entire_Project(
4621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4622: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4623: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4624: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4625: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 4622: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

4618: --
4619:
4620: PROCEDURE Copy_Entire_Project(
4621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4622: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4623: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4624: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4625: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4626: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 4623: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

4619:
4620: PROCEDURE Copy_Entire_Project(
4621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4622: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4623: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4624: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4625: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4626: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
4627: ,p_reference_project_id IN NUMBER

Line 4626: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

4622: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4623: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4624: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4625: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4626: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
4627: ,p_reference_project_id IN NUMBER
4628: ,p_reference_task_id IN NUMBER
4629: ,p_project_id IN NUMBER
4630: ,p_peer_or_sub IN VARCHAR2

Line 4709: IF p_commit = FND_API.G_TRUE

4705: l_data_length NUMBER;
4706:
4707: BEGIN
4708:
4709: IF p_commit = FND_API.G_TRUE
4710: THEN
4711: SAVEPOINT Copy;
4712: END IF;
4713: x_return_status := 'S';

Line 4730: RAISE FND_API.G_EXC_ERROR;

4726: THEN
4727: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4728: p_procedure_name => 'Copy_Entire_Project',
4729: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
4730: RAISE FND_API.G_EXC_ERROR;
4731: END IF;
4732: --schema swap changes
4733:
4734: OPEN cur_data_length(l_table_owner);

Line 4827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4823: THEN
4824: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4825: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
4826: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
4827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4828: RAISE FND_API.G_EXC_ERROR;
4829: END IF;
4830:
4831: PA_TASKS_MAINT_PVT.CREATE_TASK

Line 4828: RAISE FND_API.G_EXC_ERROR;

4824: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4825: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
4826: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
4827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4828: RAISE FND_API.G_EXC_ERROR;
4829: END IF;
4830:
4831: PA_TASKS_MAINT_PVT.CREATE_TASK
4832: (

Line 4895: RAISE FND_API.G_EXC_ERROR;

4891:
4892: IF l_msg_count > 0 THEN
4893: x_msg_count := l_msg_count;
4894: x_return_status := 'E';
4895: RAISE FND_API.G_EXC_ERROR;
4896: END IF;
4897:
4898:
4899: END LOOP;

Line 4922: RAISE FND_API.G_EXC_ERROR;

4918: AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
4919: EXCEPTION
4920: WHEN OTHERS THEN
4921: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
4922: RAISE FND_API.G_EXC_ERROR;
4923: END; */
4924:
4925: EXCEPTION
4926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4922: RAISE FND_API.G_EXC_ERROR;
4923: END; */
4924:
4925: EXCEPTION
4926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4927: IF p_commit = FND_API.G_TRUE
4928: THEN
4929: ROLLBACK TO Copy;
4930: END IF;

Line 4927: IF p_commit = FND_API.G_TRUE

4923: END; */
4924:
4925: EXCEPTION
4926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4927: IF p_commit = FND_API.G_TRUE
4928: THEN
4929: ROLLBACK TO Copy;
4930: END IF;
4931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4927: IF p_commit = FND_API.G_TRUE
4928: THEN
4929: ROLLBACK TO Copy;
4930: END IF;
4931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4932: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4933: p_procedure_name => 'Copy_Entire_Task',
4934: p_error_text => SUBSTRB(SQLERRM,1,240));
4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4932: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4933: p_procedure_name => 'Copy_Entire_Task',
4934: p_error_text => SUBSTRB(SQLERRM,1,240));
4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4936:
4937: WHEN FND_API.G_EXC_ERROR THEN
4938: IF p_commit = FND_API.G_TRUE
4939: THEN

Line 4937: WHEN FND_API.G_EXC_ERROR THEN

4933: p_procedure_name => 'Copy_Entire_Task',
4934: p_error_text => SUBSTRB(SQLERRM,1,240));
4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4936:
4937: WHEN FND_API.G_EXC_ERROR THEN
4938: IF p_commit = FND_API.G_TRUE
4939: THEN
4940: ROLLBACK TO Copy;
4941: END IF;

Line 4938: IF p_commit = FND_API.G_TRUE

4934: p_error_text => SUBSTRB(SQLERRM,1,240));
4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4936:
4937: WHEN FND_API.G_EXC_ERROR THEN
4938: IF p_commit = FND_API.G_TRUE
4939: THEN
4940: ROLLBACK TO Copy;
4941: END IF;
4942: x_return_status := 'E';

Line 4945: IF p_commit = FND_API.G_TRUE

4941: END IF;
4942: x_return_status := 'E';
4943:
4944: WHEN OTHERS THEN
4945: IF p_commit = FND_API.G_TRUE
4946: THEN
4947: ROLLBACK TO Copy;
4948: END IF;
4949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

4957: -- Type : Private procedure
4958: -- Pre-reqs : None
4959: -- Return Value : N/A
4960: -- Prameters
4961: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4962: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4963: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4964: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4965: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

4958: -- Pre-reqs : None
4959: -- Return Value : N/A
4960: -- Prameters
4961: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4962: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4963: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4964: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4965: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4966: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

4959: -- Return Value : N/A
4960: -- Prameters
4961: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
4962: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4963: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4964: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4965: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4966: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
4967: -- p_reference_project_id IN NUMBER

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

4962: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
4963: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
4964: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
4965: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
4966: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
4967: -- p_reference_project_id IN NUMBER
4968: -- p_reference_task_id IN NUMBER
4969: -- p_task_id IN NUMBER
4970: -- p_peer_or_sub IN VARCHAR2

Line 4983: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

4979: --
4980: --
4981:
4982: PROCEDURE Copy_Selected_Task(
4983: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4984: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4985: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4986: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4987: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 4984: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

4980: --
4981:
4982: PROCEDURE Copy_Selected_Task(
4983: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4984: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4985: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4986: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4987: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4988: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 4985: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

4981:
4982: PROCEDURE Copy_Selected_Task(
4983: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4984: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4985: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4986: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4987: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4988: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
4989: ,p_reference_project_id IN NUMBER

Line 4988: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

4984: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
4985: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
4986: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
4987: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4988: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
4989: ,p_reference_project_id IN NUMBER
4990: ,p_reference_task_id IN NUMBER
4991: ,p_task_id IN NUMBER
4992: ,p_peer_or_sub IN VARCHAR2

Line 5046: IF p_commit = FND_API.G_TRUE

5042: l_column_name VARCHAR2(30);
5043: l_data_length NUMBER;
5044:
5045: BEGIN
5046: IF p_commit = FND_API.G_TRUE
5047: THEN
5048: SAVEPOINT Copy;
5049: END IF;
5050: x_return_status := 'S';

Line 5067: RAISE FND_API.G_EXC_ERROR;

5063: THEN
5064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5065: p_procedure_name => 'Copy_Entire_Project',
5066: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
5067: RAISE FND_API.G_EXC_ERROR;
5068: END IF;
5069: --schema swap changes
5070:
5071: OPEN cur_data_length(l_table_owner);

Line 5116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5112: THEN
5113: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5114: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
5115: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
5116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5117: RAISE FND_API.G_EXC_ERROR;
5118: END IF;
5119:
5120: PA_TASKS_MAINT_PVT.CREATE_TASK

Line 5117: RAISE FND_API.G_EXC_ERROR;

5113: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5114: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
5115: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
5116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5117: RAISE FND_API.G_EXC_ERROR;
5118: END IF;
5119:
5120: PA_TASKS_MAINT_PVT.CREATE_TASK
5121: (

Line 5175: RAISE FND_API.G_EXC_ERROR;

5171:
5172: IF l_msg_count > 0 THEN
5173: x_msg_count := l_msg_count;
5174: x_return_status := 'E';
5175: RAISE FND_API.G_EXC_ERROR;
5176: END IF;
5177:
5178: END LOOP;
5179:

Line 5203: RAISE FND_API.G_EXC_ERROR;

5199: AND ( display_sequence > -( l_display_seq + 1 ) or display_sequence < 0 );
5200: EXCEPTION
5201: WHEN OTHERS THEN
5202: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
5203: RAISE FND_API.G_EXC_ERROR;
5204: END;*/
5205:
5206: EXCEPTION
5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5203: RAISE FND_API.G_EXC_ERROR;
5204: END;*/
5205:
5206: EXCEPTION
5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5208: IF p_commit = FND_API.G_TRUE
5209: THEN
5210: ROLLBACK TO Copy;
5211: END IF;

Line 5208: IF p_commit = FND_API.G_TRUE

5204: END;*/
5205:
5206: EXCEPTION
5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5208: IF p_commit = FND_API.G_TRUE
5209: THEN
5210: ROLLBACK TO Copy;
5211: END IF;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5208: IF p_commit = FND_API.G_TRUE
5209: THEN
5210: ROLLBACK TO Copy;
5211: END IF;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5214: p_procedure_name => 'Copy_Selected_Task',
5215: p_error_text => SUBSTRB(SQLERRM,1,240));
5216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5214: p_procedure_name => 'Copy_Selected_Task',
5215: p_error_text => SUBSTRB(SQLERRM,1,240));
5216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5217:
5218: WHEN FND_API.G_EXC_ERROR THEN
5219: IF p_commit = FND_API.G_TRUE
5220: THEN

Line 5218: WHEN FND_API.G_EXC_ERROR THEN

5214: p_procedure_name => 'Copy_Selected_Task',
5215: p_error_text => SUBSTRB(SQLERRM,1,240));
5216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5217:
5218: WHEN FND_API.G_EXC_ERROR THEN
5219: IF p_commit = FND_API.G_TRUE
5220: THEN
5221: ROLLBACK TO Copy;
5222: END IF;

Line 5219: IF p_commit = FND_API.G_TRUE

5215: p_error_text => SUBSTRB(SQLERRM,1,240));
5216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5217:
5218: WHEN FND_API.G_EXC_ERROR THEN
5219: IF p_commit = FND_API.G_TRUE
5220: THEN
5221: ROLLBACK TO Copy;
5222: END IF;
5223: x_return_status := 'E';

Line 5226: IF p_commit = FND_API.G_TRUE

5222: END IF;
5223: x_return_status := 'E';
5224:
5225: WHEN OTHERS THEN
5226: IF p_commit = FND_API.G_TRUE
5227: THEN
5228: ROLLBACK TO Copy;
5229: END IF;
5230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

5238: -- Type : Private procedure
5239: -- Pre-reqs : None
5240: -- Return Value : N/A
5241: -- Prameters
5242: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
5243: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
5244: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
5245: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
5246: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'

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

5239: -- Pre-reqs : None
5240: -- Return Value : N/A
5241: -- Prameters
5242: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
5243: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
5244: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
5245: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
5246: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
5247: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM

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

5240: -- Return Value : N/A
5241: -- Prameters
5242: -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
5243: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
5244: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
5245: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
5246: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
5247: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
5248: -- p_reference_project_id IN NUMBER

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

5243: -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
5244: -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
5245: -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
5246: -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
5247: -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
5248: -- p_reference_project_id IN NUMBER
5249: -- p_reference_task_id IN NUMBER
5250: -- p_project_id IN NUMBER
5251: -- p_task_id IN NUMBER

Line 5265: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

5261: --
5262: --
5263:
5264: PROCEDURE Copy_Entire_Task(
5265: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5266: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5267: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5268: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5269: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'

Line 5266: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE

5262: --
5263:
5264: PROCEDURE Copy_Entire_Task(
5265: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5266: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5267: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5268: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5269: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
5270: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 5267: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

5263:
5264: PROCEDURE Copy_Entire_Task(
5265: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5266: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE
5267: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
5268: ,p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE'
5269: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
5270: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM
5271: ,p_reference_project_id IN NUMBER

Line 5270: ,p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 5366: IF p_commit = FND_API.G_TRUE

5362: l_data_length NUMBER;
5363:
5364: BEGIN
5365:
5366: IF p_commit = FND_API.G_TRUE
5367: THEN
5368: SAVEPOINT Copy;
5369: END IF;
5370: x_return_status := 'S';

Line 5387: RAISE FND_API.G_EXC_ERROR;

5383: THEN
5384: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5385: p_procedure_name => 'Copy_Entire_Project',
5386: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
5387: RAISE FND_API.G_EXC_ERROR;
5388: END IF;
5389: --schema swap changes
5390:
5391: OPEN cur_data_length(l_table_owner);

Line 5484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5480: THEN
5481: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5482: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
5483: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
5484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5485: RAISE FND_API.G_EXC_ERROR;
5486: END IF;
5487:
5488: PA_TASKS_MAINT_PVT.CREATE_TASK

Line 5485: RAISE FND_API.G_EXC_ERROR;

5481: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5482: p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
5483: x_msg_data := 'PA_TASK_PREFIX_TOO_LARGE';
5484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5485: RAISE FND_API.G_EXC_ERROR;
5486: END IF;
5487:
5488: PA_TASKS_MAINT_PVT.CREATE_TASK
5489: (

Line 5553: RAISE FND_API.G_EXC_ERROR;

5549:
5550: IF l_msg_count > 0 THEN
5551: x_msg_count := l_msg_count;
5552: x_return_status := 'E';
5553: RAISE FND_API.G_EXC_ERROR;
5554: END IF;
5555:
5556: END LOOP;
5557:

Line 5581: RAISE FND_API.G_EXC_ERROR;

5577: AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
5578: EXCEPTION
5579: WHEN OTHERS THEN
5580: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
5581: RAISE FND_API.G_EXC_ERROR;
5582: END; */
5583:
5584: EXCEPTION
5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5581: RAISE FND_API.G_EXC_ERROR;
5582: END; */
5583:
5584: EXCEPTION
5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5586: IF p_commit = FND_API.G_TRUE
5587: THEN
5588: ROLLBACK TO Copy;
5589: END IF;

Line 5586: IF p_commit = FND_API.G_TRUE

5582: END; */
5583:
5584: EXCEPTION
5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5586: IF p_commit = FND_API.G_TRUE
5587: THEN
5588: ROLLBACK TO Copy;
5589: END IF;
5590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5586: IF p_commit = FND_API.G_TRUE
5587: THEN
5588: ROLLBACK TO Copy;
5589: END IF;
5590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5591: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5592: p_procedure_name => 'Copy_Entire_Task',
5593: p_error_text => SUBSTRB(SQLERRM,1,240));
5594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5591: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5592: p_procedure_name => 'Copy_Entire_Task',
5593: p_error_text => SUBSTRB(SQLERRM,1,240));
5594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5595:
5596: WHEN FND_API.G_EXC_ERROR THEN
5597: IF p_commit = FND_API.G_TRUE
5598: THEN

Line 5596: WHEN FND_API.G_EXC_ERROR THEN

5592: p_procedure_name => 'Copy_Entire_Task',
5593: p_error_text => SUBSTRB(SQLERRM,1,240));
5594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5595:
5596: WHEN FND_API.G_EXC_ERROR THEN
5597: IF p_commit = FND_API.G_TRUE
5598: THEN
5599: ROLLBACK TO Copy;
5600: END IF;

Line 5597: IF p_commit = FND_API.G_TRUE

5593: p_error_text => SUBSTRB(SQLERRM,1,240));
5594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5595:
5596: WHEN FND_API.G_EXC_ERROR THEN
5597: IF p_commit = FND_API.G_TRUE
5598: THEN
5599: ROLLBACK TO Copy;
5600: END IF;
5601: x_return_status := 'E';

Line 5604: IF p_commit = FND_API.G_TRUE

5600: END IF;
5601: x_return_status := 'E';
5602:
5603: WHEN OTHERS THEN
5604: IF p_commit = FND_API.G_TRUE
5605: THEN
5606: ROLLBACK TO Copy;
5607: END IF;
5608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5604: IF p_commit = FND_API.G_TRUE
5605: THEN
5606: ROLLBACK TO Copy;
5607: END IF;
5608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5609: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5610: p_procedure_name => 'Copy_Entire_Task',
5611: p_error_text => SUBSTRB(SQLERRM,1,240));
5612: RAISE;

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

5619: -- Pre-reqs : None
5620: -- Return Value : N/A
5621: -- Prameters
5622: -- p_api_version IN NUMBER := 1.0
5623: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5624: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
5625: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5626: -- p_validation_level IN VARCHAR2 := 100
5627: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

5620: -- Return Value : N/A
5621: -- Prameters
5622: -- p_api_version IN NUMBER := 1.0
5623: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5624: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
5625: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5626: -- p_validation_level IN VARCHAR2 := 100
5627: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5628: -- p_debug_mode IN VARCHAR2 := 'N'

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

5621: -- Prameters
5622: -- p_api_version IN NUMBER := 1.0
5623: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5624: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
5625: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5626: -- p_validation_level IN VARCHAR2 := 100
5627: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5628: -- p_debug_mode IN VARCHAR2 := 'N'
5629: -- p_reference_project_id IN NUMBER

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

5643: --
5644:
5645: PROCEDURE Move_Task(
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:
5645: PROCEDURE Move_Task(
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: PROCEDURE Move_Task(
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 5744: x_return_status:= FND_API.G_RET_STS_SUCCESS;

5740: l_err_stage VARCHAR2(80); -- VARCHAR2(80)
5741:
5742: BEGIN
5743:
5744: x_return_status:= FND_API.G_RET_STS_SUCCESS;
5745:
5746: --dbms_output.put_line( 'In move task 0' );
5747:
5748: --Ref project and task id Required check.

Line 5755: IF l_return_status = FND_API.G_RET_STS_ERROR

5751: p_reference_task_id => p_reference_task_id,
5752: x_return_status => l_return_status,
5753: x_error_msg_code => l_error_msg_code );
5754:
5755: IF l_return_status = FND_API.G_RET_STS_ERROR
5756: THEN
5757: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5758: p_msg_name => l_error_msg_code);
5759: x_msg_data := l_error_msg_code;

Line 5761: RAISE FND_API.G_EXC_ERROR;

5757: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5758: p_msg_name => l_error_msg_code);
5759: x_msg_data := l_error_msg_code;
5760: x_return_status := 'E';
5761: RAISE FND_API.G_EXC_ERROR;
5762: END IF;
5763:
5764: --dbms_output.put_line( 'In move task 1' );
5765:

Line 5773: IF l_return_status = FND_API.G_RET_STS_ERROR

5769: p_task_id => p_task_id,
5770: x_return_status => l_return_status,
5771: x_error_msg_code => l_error_msg_code );
5772:
5773: IF l_return_status = FND_API.G_RET_STS_ERROR
5774: THEN
5775: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5776: p_msg_name => l_error_msg_code);
5777: x_msg_data := l_error_msg_code;

Line 5779: RAISE FND_API.G_EXC_ERROR;

5775: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5776: p_msg_name => l_error_msg_code);
5777: x_msg_data := l_error_msg_code;
5778: x_return_status := 'E';
5779: RAISE FND_API.G_EXC_ERROR;
5780: END IF;
5781: --dbms_output.put_line( 'In move task 2' );
5782:
5783:

Line 5789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5785: THEN
5786: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5787: p_msg_name => 'PA_TASK_MOV_NOT_ALLOWED' );
5788: x_msg_data := 'PA_TASK_MOV_NOT_ALLOWED';
5789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5790: RAISE FND_API.G_EXC_ERROR;
5791: END IF;
5792:
5793: --dbms_output.put_line( 'In move task 3' );

Line 5790: RAISE FND_API.G_EXC_ERROR;

5786: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5787: p_msg_name => 'PA_TASK_MOV_NOT_ALLOWED' );
5788: x_msg_data := 'PA_TASK_MOV_NOT_ALLOWED';
5789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5790: RAISE FND_API.G_EXC_ERROR;
5791: END IF;
5792:
5793: --dbms_output.put_line( 'In move task 3' );
5794:

Line 5952: RAISE FND_API.G_EXC_ERROR;

5948: x_return_status := 'E';
5949: x_msg_data := x_msg_data;
5950: --dbms_output.put_line( 'x_msg_data in update task '||x_msg_data );
5951:
5952: RAISE FND_API.G_EXC_ERROR;
5953: END IF;
5954:
5955: END LOOP;
5956:

Line 6004: RAISE FND_API.G_EXC_ERROR;

6000: display_sequence <= l_max_display_sequence ) or display_sequence < 0 );
6001: EXCEPTION
6002: WHEN OTHERS THEN
6003: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
6004: RAISE FND_API.G_EXC_ERROR;
6005: END; */
6006:
6007: EXCEPTION
6008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6004: RAISE FND_API.G_EXC_ERROR;
6005: END; */
6006:
6007: EXCEPTION
6008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6009: IF p_commit = FND_API.G_TRUE
6010: THEN
6011: ROLLBACK TO Move;
6012: END IF;

Line 6009: IF p_commit = FND_API.G_TRUE

6005: END; */
6006:
6007: EXCEPTION
6008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6009: IF p_commit = FND_API.G_TRUE
6010: THEN
6011: ROLLBACK TO Move;
6012: END IF;
6013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6009: IF p_commit = FND_API.G_TRUE
6010: THEN
6011: ROLLBACK TO Move;
6012: END IF;
6013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6014: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
6015: p_procedure_name => 'Move_Task',
6016: p_error_text => SUBSTRB(SQLERRM,1,240));
6017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6014: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
6015: p_procedure_name => 'Move_Task',
6016: p_error_text => SUBSTRB(SQLERRM,1,240));
6017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6018:
6019: WHEN FND_API.G_EXC_ERROR THEN
6020: IF p_commit = FND_API.G_TRUE
6021: THEN

Line 6019: WHEN FND_API.G_EXC_ERROR THEN

6015: p_procedure_name => 'Move_Task',
6016: p_error_text => SUBSTRB(SQLERRM,1,240));
6017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6018:
6019: WHEN FND_API.G_EXC_ERROR THEN
6020: IF p_commit = FND_API.G_TRUE
6021: THEN
6022: ROLLBACK TO Move;
6023: END IF;

Line 6020: IF p_commit = FND_API.G_TRUE

6016: p_error_text => SUBSTRB(SQLERRM,1,240));
6017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6018:
6019: WHEN FND_API.G_EXC_ERROR THEN
6020: IF p_commit = FND_API.G_TRUE
6021: THEN
6022: ROLLBACK TO Move;
6023: END IF;
6024: x_return_status := 'E';

Line 6027: IF p_commit = FND_API.G_TRUE

6023: END IF;
6024: x_return_status := 'E';
6025:
6026: WHEN OTHERS THEN
6027: IF p_commit = FND_API.G_TRUE
6028: THEN
6029: ROLLBACK TO Move;
6030: END IF;
6031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6027: IF p_commit = FND_API.G_TRUE
6028: THEN
6029: ROLLBACK TO Move;
6030: END IF;
6031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6032: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
6033: p_procedure_name => 'Move_Task',
6034: p_error_text => SUBSTRB(SQLERRM,1,240));
6035: RAISE;

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

6053: -- p_project_id NUMBER YES Project ID
6054: PROCEDURE SET_UNSET_FINANCIAL_TASK
6055: (
6056: p_api_version IN NUMBER := 1.0
6057: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6058: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6059: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6060: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6061: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

6054: PROCEDURE SET_UNSET_FINANCIAL_TASK
6055: (
6056: p_api_version IN NUMBER := 1.0
6057: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6058: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6059: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6060: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6061: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6062: , p_task_version_id IN NUMBER

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

6055: (
6056: p_api_version IN NUMBER := 1.0
6057: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6058: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6059: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6060: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6061: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6062: , p_task_version_id IN NUMBER
6063: , p_project_id IN NUMBER

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

6056: p_api_version IN NUMBER := 1.0
6057: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6058: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6059: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6060: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6061: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6062: , p_task_version_id IN NUMBER
6063: , p_project_id IN NUMBER
6064: , p_checked_flag IN VARCHAR2

Line 6114: x_return_status := FND_API.G_RET_STS_SUCCESS;

6110:
6111:
6112: BEGIN
6113: x_msg_count := 0;
6114: x_return_status := FND_API.G_RET_STS_SUCCESS;
6115:
6116: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6117: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6118: l_user_id := fnd_global.user_id;

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

6137: Pa_Debug.WRITE(g_pkg_name,'p_project_id'||':'||p_project_id,
6138: l_debug_level3);
6139: END IF;
6140:
6141: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6142: FND_MSG_PUB.initialize;
6143: END IF;
6144:
6145: IF (p_commit = FND_API.G_TRUE) THEN

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

6141: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6142: FND_MSG_PUB.initialize;
6143: END IF;
6144:
6145: IF (p_commit = FND_API.G_TRUE) THEN
6146: savepoint SET_UNSET_FINANCIAL_TASK_PVT;
6147: --savepoint SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6148: END IF;
6149:

Line 6207: RAISE FND_API.G_EXC_ERROR;

6203: PA_UTILS.ADD_MESSAGE(
6204: p_app_short_name => 'PA'
6205: , p_msg_name => substr(l_error_msg_code,1,30)--bug 3735089 used substr
6206: );
6207: RAISE FND_API.G_EXC_ERROR;
6208: END IF;
6209: -- END IF; --NVL(l_task_exists,'N') ='Y' THEN
6210: END IF;
6211: --Update the table with financial flag

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

6221: AND
6222: project_id = p_project_id;
6223:
6224:
6225: IF (p_commit = FND_API.G_TRUE) THEN
6226: COMMIT;
6227: END IF;
6228:
6229: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls

Line 6237: WHEN FND_API.G_EXC_ERROR THEN

6233: END IF;
6234:
6235: EXCEPTION
6236:
6237: WHEN FND_API.G_EXC_ERROR THEN
6238:
6239: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6240: l_msg_count := Fnd_Msg_Pub.count_msg;
6241:

Line 6239: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6235: EXCEPTION
6236:
6237: WHEN FND_API.G_EXC_ERROR THEN
6238:
6239: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6240: l_msg_count := Fnd_Msg_Pub.count_msg;
6241:
6242: IF p_commit = FND_API.G_TRUE THEN
6243: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;

Line 6242: IF p_commit = FND_API.G_TRUE THEN

6238:
6239: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6240: l_msg_count := Fnd_Msg_Pub.count_msg;
6241:
6242: IF p_commit = FND_API.G_TRUE THEN
6243: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;
6244: --ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6245: END IF;
6246: IF c_get_task_id%ISOPEN THEN

Line 6252: ( p_encoded => Fnd_Api.G_TRUE

6248: END IF;
6249: IF l_msg_count = 1 AND x_msg_data IS NULL
6250: THEN
6251: Pa_Interface_Utils_Pub.get_messages
6252: ( p_encoded => Fnd_Api.G_TRUE
6253: , p_msg_index => 1
6254: , p_msg_count => l_msg_count
6255: , p_msg_data => l_msg_data
6256: , p_data => l_data

Line 6270: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6266: END IF;
6267:
6268: WHEN Invalid_Arg_Exc_WP THEN
6269:
6270: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6271: x_msg_count := 1;
6272: x_msg_data := 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
6273:
6274: IF p_commit = FND_API.G_TRUE THEN

Line 6274: IF p_commit = FND_API.G_TRUE THEN

6270: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6271: x_msg_count := 1;
6272: x_msg_data := 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
6273:
6274: IF p_commit = FND_API.G_TRUE THEN
6275: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;
6276: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6277: END IF;
6278: IF c_get_task_id%ISOPEN THEN

Line 6297: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6293: RAISE;
6294:
6295: WHEN OTHERS THEN
6296:
6297: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6298: x_msg_count := 1;
6299: x_msg_data := substr(SQLERRM,1,120);-- Bug 3735089 Added substr
6300:
6301: IF p_commit = FND_API.G_TRUE THEN

Line 6301: IF p_commit = FND_API.G_TRUE THEN

6297: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6298: x_msg_count := 1;
6299: x_msg_data := substr(SQLERRM,1,120);-- Bug 3735089 Added substr
6300:
6301: IF p_commit = FND_API.G_TRUE THEN
6302: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;
6303: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6304: END IF;
6305:

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

6347:
6348: PROCEDURE SYNC_UP_WP_TASKS_WITH_FIN
6349: (
6350: p_api_version IN NUMBER := 1.0
6351: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6352: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6353: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6354: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6355: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

6348: PROCEDURE SYNC_UP_WP_TASKS_WITH_FIN
6349: (
6350: p_api_version IN NUMBER := 1.0
6351: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6352: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6353: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6354: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6355: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6356: , p_debug_mode IN VARCHAR2 := 'N'

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

6349: (
6350: p_api_version IN NUMBER := 1.0
6351: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6352: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6353: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6354: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6355: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6356: , p_debug_mode IN VARCHAR2 := 'N'
6357: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM

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

6350: p_api_version IN NUMBER := 1.0
6351: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6352: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6353: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6354: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6355: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6356: , p_debug_mode IN VARCHAR2 := 'N'
6357: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6358: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

6353: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
6354: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6355: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6356: , p_debug_mode IN VARCHAR2 := 'N'
6357: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6358: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6359: , p_project_id IN NUMBER
6360: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6361: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM

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

6354: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6355: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6356: , p_debug_mode IN VARCHAR2 := 'N'
6357: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6358: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6359: , p_project_id IN NUMBER
6360: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6361: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6362: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM

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

6357: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6358: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6359: , p_project_id IN NUMBER
6360: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6361: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6362: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
6363: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
6364: , p_mode IN VARCHAR2 := 'SINGLE'
6365: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

6358: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
6359: , p_project_id IN NUMBER
6360: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6361: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6362: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
6363: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
6364: , p_mode IN VARCHAR2 := 'SINGLE'
6365: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6366: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

6359: , p_project_id IN NUMBER
6360: , p_syncup_all_tasks IN VARCHAR2 := 'N'
6361: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
6362: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
6363: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
6364: , p_mode IN VARCHAR2 := 'SINGLE'
6365: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6366: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6367: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 6482: x_return_status := FND_API.G_RET_STS_SUCCESS;

6478:
6479:
6480: BEGIN
6481: x_msg_count := 0;
6482: x_return_status := FND_API.G_RET_STS_SUCCESS;
6483:
6484: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6485: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6486: l_user_id := fnd_global.user_id;

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

6513: Pa_Debug.WRITE(g_pkg_name,'p_parent_task_version_id'||':'||p_parent_task_version_id,
6514: l_debug_level3);
6515: END IF;
6516:
6517: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6518: FND_MSG_PUB.initialize;
6519: END IF;
6520:
6521: IF (p_commit = FND_API.G_TRUE) THEN

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

6517: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6518: FND_MSG_PUB.initialize;
6519: END IF;
6520:
6521: IF (p_commit = FND_API.G_TRUE) THEN
6522: --savepoint SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6523: savepoint SYNC_UP_WP_TASKS_WITH_FIN_PVT;
6524: END IF;
6525: --get carrying_out_organization_id

Line 6549: , p_init_msg_list => FND_API.G_FALSE

6545:
6546: PA_TASKS_MAINT_PUB.DELETE_TASK
6547: (
6548: p_commit => p_commit
6549: , p_init_msg_list => FND_API.G_FALSE
6550: , p_calling_module => p_calling_module
6551: , p_debug_mode => l_debug_mode
6552: , p_project_id => p_project_id
6553: , p_task_id => l_task_id

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

6558: , x_msg_data => x_msg_data
6559: );
6560:
6561:
6562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6563: THEN
6564: RAISE FND_API.G_EXC_ERROR;
6565: END IF;
6566: END IF;

Line 6564: RAISE FND_API.G_EXC_ERROR;

6560:
6561:
6562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6563: THEN
6564: RAISE FND_API.G_EXC_ERROR;
6565: END IF;
6566: END IF;
6567:
6568: ELSIF (p_checked_flag='Y')

Line 6594: ,p_init_msg_list => FND_API.G_FALSE

6590: PA_TASKS_MAINT_PUB.CREATE_TASK
6591: (
6592: p_commit => p_commit
6593: ,p_calling_module => p_calling_module
6594: ,p_init_msg_list => FND_API.G_FALSE
6595: ,p_debug_mode => l_debug_mode
6596: ,p_project_id => p_project_id
6597: ,p_reference_task_id => l_parent_task_id
6598: ,p_peer_or_sub => 'SUB'

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

6605: ,x_return_status => x_return_status
6606: ,x_msg_count => x_msg_count
6607: ,x_msg_data => x_msg_data
6608: );
6609: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6610: THEN
6611: RAISE FND_API.G_EXC_ERROR;
6612: END IF;
6613:

Line 6611: RAISE FND_API.G_EXC_ERROR;

6607: ,x_msg_data => x_msg_data
6608: );
6609: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6610: THEN
6611: RAISE FND_API.G_EXC_ERROR;
6612: END IF;
6613:
6614: END IF;
6615: END IF;

Line 6649: , p_init_msg_list => FND_API.G_FALSE

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

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

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

Line 6662: RAISE FND_API.G_EXC_ERROR;

6658: , x_msg_data => x_msg_data
6659: );
6660: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6661: THEN
6662: RAISE FND_API.G_EXC_ERROR;
6663: END IF;
6664:
6665: ELSIF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='N' AND iCounter.financial_task_flag='Y')
6666: THEN

Line 6681: ,p_init_msg_list => FND_API.G_FALSE

6677: PA_TASKS_MAINT_PUB.CREATE_TASK
6678: (
6679: p_commit => p_commit
6680: ,p_calling_module => p_calling_module
6681: ,p_init_msg_list => FND_API.G_FALSE
6682: ,p_validate_only => p_validate_only
6683: ,p_debug_mode => l_debug_mode
6684: ,p_project_id => p_project_id
6685: ,p_reference_task_id => l_parent_task_id

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

6693: ,x_return_status =>x_return_status
6694: ,x_msg_count =>x_msg_count
6695: ,x_msg_data =>x_msg_data
6696: );
6697: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6698: THEN
6699: RAISE FND_API.G_EXC_ERROR;
6700: END IF;
6701: END IF;

Line 6699: RAISE FND_API.G_EXC_ERROR;

6695: ,x_msg_data =>x_msg_data
6696: );
6697: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6698: THEN
6699: RAISE FND_API.G_EXC_ERROR;
6700: END IF;
6701: END IF;
6702: END LOOP;
6703: END IF;

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

6701: END IF;
6702: END LOOP;
6703: END IF;
6704:
6705: IF (p_commit = FND_API.G_TRUE) THEN
6706: COMMIT;
6707: END IF;
6708:
6709: -- Bug 3735089 : using reset_curr_function too, just using set_curr_function may overflow it after several recursive calls

Line 6717: WHEN FND_API.G_EXC_ERROR THEN

6713: END IF;
6714:
6715: EXCEPTION
6716:
6717: WHEN FND_API.G_EXC_ERROR THEN
6718:
6719: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6720: l_msg_count := Fnd_Msg_Pub.count_msg;
6721:

Line 6719: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6715: EXCEPTION
6716:
6717: WHEN FND_API.G_EXC_ERROR THEN
6718:
6719: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6720: l_msg_count := Fnd_Msg_Pub.count_msg;
6721:
6722: IF p_commit = FND_API.G_TRUE THEN
6723: --ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089

Line 6722: IF p_commit = FND_API.G_TRUE THEN

6718:
6719: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6720: l_msg_count := Fnd_Msg_Pub.count_msg;
6721:
6722: IF p_commit = FND_API.G_TRUE THEN
6723: --ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6724: ROLLBACK TO SYNC_UP_WP_TASKS_WITH_FIN_PVT;
6725: END IF;
6726:

Line 6746: ( p_encoded => Fnd_Api.G_TRUE

6742:
6743: IF l_msg_count = 1 AND x_msg_data IS NULL
6744: THEN
6745: Pa_Interface_Utils_Pub.get_messages
6746: ( p_encoded => Fnd_Api.G_TRUE
6747: , p_msg_index => 1
6748: , p_msg_count => l_msg_count
6749: , p_msg_data => l_msg_data
6750: , p_data => l_data

Line 6764: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6760: END IF;
6761:
6762: WHEN Invalid_Arg_Exc_WP THEN
6763:
6764: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6765: x_msg_count := 1;
6766: x_msg_data := 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
6767:
6768: IF p_commit = FND_API.G_TRUE THEN

Line 6768: IF p_commit = FND_API.G_TRUE THEN

6764: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6765: x_msg_count := 1;
6766: x_msg_data := 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
6767:
6768: IF p_commit = FND_API.G_TRUE THEN
6769: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6770: ROLLBACK TO SYNC_UP_WP_TASKS_WITH_FIN_PVT;
6771: END IF;
6772: IF c_get_task_id%ISOPEN THEN

Line 6802: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6798: RAISE;
6799:
6800: WHEN OTHERS THEN
6801:
6802: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6803: x_msg_count := 1;
6804: x_msg_data := substr(SQLERRM,1,120);-- Bug 3735089 Added substr
6805: IF p_commit = FND_API.G_TRUE THEN
6806: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089

Line 6805: IF p_commit = FND_API.G_TRUE THEN

6801:
6802: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6803: x_msg_count := 1;
6804: x_msg_data := substr(SQLERRM,1,120);-- Bug 3735089 Added substr
6805: IF p_commit = FND_API.G_TRUE THEN
6806: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6807: ROLLBACK TO SYNC_UP_WP_TASKS_WITH_FIN_PVT;
6808: END IF;
6809: