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 PA_TASKS_MAINT_PVT

Line 1: package body PA_TASKS_MAINT_PVT as

1: package body PA_TASKS_MAINT_PVT as
2: /*$Header: PATSKSVB.pls 120.22.12020000.4 2013/04/09 11:06:47 pstawar ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'PA_TASKS_MAINT_PVT';
5: --begin add by rtarway for FP.M developement

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

1: package body PA_TASKS_MAINT_PVT as
2: /*$Header: PATSKSVB.pls 120.22.12020000.4 2013/04/09 11:06:47 pstawar ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'PA_TASKS_MAINT_PVT';
5: --begin add by rtarway for FP.M developement
6: Invalid_Arg_Exc_WP Exception;
7: --End add by rtarway for FP.M developement
8: -- API name : CREATE_TASK

Line 659: pa_debug.debug('PA_TASKS_MAINT_PVT.CREATE_TASK BEGIN');

655: l_wp_separate_from_fin VARCHAR2(1);
656:
657: BEGIN
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;

Line 1832: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

1828: END IF;
1829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1830: x_msg_count := FND_MSG_PUB.count_msg;
1831: --put message
1832: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
1833: p_procedure_name => 'CREATE_TASK',
1834: p_error_text => SUBSTRB(SQLERRM,1,240));
1835: RAISE;
1836: END CREATE_TASK;

Line 2313: pa_debug.debug('PA_TASKS_MAINT_PVT.UPDATE_TASK BEGIN');

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

Line 3348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

3344: END IF;
3345: x_msg_count := FND_MSG_PUB.count_msg;
3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3347: --put message
3348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3349: p_procedure_name => 'UPDATE_TASK',
3350: p_error_text => SUBSTRB(SQLERRM,1,240));
3351: RAISE;
3352: END UPDATE_TASK;

Line 3403: pa_debug.debug('PA_TASKS_MAINT_PVT.DELETE_TASK BEGIN');

3399: t_pm_product_code PA_TASKS.PM_PRODUCT_CODE%TYPE;
3400: t_parent_task_id PA_TASKS.PARENT_TASK_ID%TYPE;
3401: BEGIN
3402: IF (p_debug_mode = 'Y') THEN
3403: pa_debug.debug('PA_TASKS_MAINT_PVT.DELETE_TASK BEGIN');
3404: END IF;
3405:
3406: IF (p_commit = FND_API.G_TRUE) THEN
3407: savepoint DELETE_TASK_PRIVATE;

Line 3552: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

3548: END IF;
3549: x_msg_count := FND_MSG_PUB.count_msg;
3550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: --put message
3552: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
3553: p_procedure_name => 'DELETE_TASK',
3554: p_error_text => SUBSTRB(SQLERRM,1,240));
3555: RAISE;
3556: END DELETE_TASK;

Line 3746: PA_TASKS_MAINT_PVT.UPDATE_TASK

3742:
3743: -- HSIU changes ends here
3744:
3745: -- 1) update the parent task id of the indenting task with the above task id
3746: PA_TASKS_MAINT_PVT.UPDATE_TASK
3747: (
3748: p_commit => p_commit
3749: ,p_validate_only => p_validate_only
3750: ,p_validation_level => p_validation_level

Line 3792: PA_TASKS_MAINT_PVT.UPDATE_TASK

3788:
3789:
3790: FOR cur_task_heirarchy_rec IN cur_task_heirarchy LOOP
3791:
3792: PA_TASKS_MAINT_PVT.UPDATE_TASK
3793: (
3794: p_commit => p_commit
3795: ,p_validate_only => p_validate_only
3796: ,p_validation_level => p_validation_level

Line 3835: PA_TASKS_MAINT_PVT.UPDATE_TASK

3831: OPEN cur_parent_of_above( l_task_level , l_top_task_id_above, l_display_sequence );
3832: FETCH cur_parent_of_above INTO l_new_parent_id, l_new_top_id;
3833: CLOSE cur_parent_of_above;
3834:
3835: PA_TASKS_MAINT_PVT.UPDATE_TASK
3836: (
3837: p_commit => p_commit
3838: ,p_validate_only => p_validate_only
3839: ,p_validation_level => p_validation_level

Line 3866: PA_TASKS_MAINT_PVT.UPDATE_TASK

3862:
3863:
3864: FOR cur_task_heirarchy_rec IN cur_task_heirarchy LOOP
3865:
3866: PA_TASKS_MAINT_PVT.UPDATE_TASK
3867: (
3868: p_commit => p_commit
3869: ,p_validate_only => p_validate_only
3870: ,p_validation_level => p_validation_level

Line 3902: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 3920: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 4093: PA_TASKS_MAINT_PVT.UPDATE_TASK

4089: IF l_task_level_above < l_task_level
4090: THEN
4091: --2) update the parent task id of outdenting task with the parent task id of the task above
4092:
4093: PA_TASKS_MAINT_PVT.UPDATE_TASK
4094: (
4095: p_commit => p_commit
4096: ,p_validate_only => p_validate_only
4097: ,p_validation_level => p_validation_level

Line 4121: PA_TASKS_MAINT_PVT.UPDATE_TASK

4117: --1) update wbs level of outdenting task includinf its children
4118:
4119: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4120:
4121: PA_TASKS_MAINT_PVT.UPDATE_TASK
4122: (
4123: p_commit => p_commit
4124: ,p_validate_only => p_validate_only
4125: ,p_validation_level => p_validation_level

Line 4159: PA_TASKS_MAINT_PVT.UPDATE_TASK

4155: IF l_parent_task_id_above IS NULL
4156: THEN
4157: FOR cur_all_tasks_rec IN cur_all_tasks( l_top_task_id , l_display_sequence ) LOOP
4158:
4159: PA_TASKS_MAINT_PVT.UPDATE_TASK
4160: (
4161: p_commit => p_commit
4162: ,p_validate_only => p_validate_only
4163: ,p_validation_level => p_validation_level

Line 4191: PA_TASKS_MAINT_PVT.UPDATE_TASK

4187: --( these new child tasks used to be at the same level before the outdenting task outedented )
4188: --l_task_level now contains old value of the wbs level.
4189: FOR cur_new_child_task_rec IN cur_new_child_task( l_task_level, l_display_sequence ) LOOP
4190:
4191: PA_TASKS_MAINT_PVT.UPDATE_TASK
4192: (
4193: p_commit => p_commit
4194: ,p_validate_only => p_validate_only
4195: ,p_validation_level => p_validation_level

Line 4236: PA_TASKS_MAINT_PVT.UPDATE_TASK

4232: THEN
4233: l_new_top_id := p_task_id;
4234: l_new_parent_id := null;
4235: END IF;
4236: PA_TASKS_MAINT_PVT.UPDATE_TASK
4237: (
4238: p_commit => p_commit
4239: ,p_validate_only => p_validate_only
4240: ,p_validation_level => p_validation_level

Line 4265: PA_TASKS_MAINT_PVT.UPDATE_TASK

4261: --1) update wbs level
4262:
4263: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4264:
4265: PA_TASKS_MAINT_PVT.UPDATE_TASK
4266: (
4267: p_commit => p_commit
4268: ,p_validate_only => p_validate_only
4269: ,p_validation_level => p_validation_level

Line 4298: PA_TASKS_MAINT_PVT.UPDATE_TASK

4294: --l_task_level now contains old value of the wbs level.
4295: --Also update the top task id for the new children
4296: FOR cur_new_child_task_rec IN cur_new_child_task( l_task_level, l_display_sequence ) LOOP
4297:
4298: PA_TASKS_MAINT_PVT.UPDATE_TASK
4299: (
4300: p_commit => p_commit
4301: ,p_validate_only => p_validate_only
4302: ,p_validation_level => p_validation_level

Line 4345: PA_TASKS_MAINT_PVT.UPDATE_TASK

4341:
4342: --The outdenting task may become a child of another task or
4343: --it may become the top most task in its branch.
4344:
4345: PA_TASKS_MAINT_PVT.UPDATE_TASK
4346: (
4347: p_commit => p_commit
4348: ,p_validate_only => p_validate_only
4349: ,p_validation_level => p_validation_level

Line 4371: PA_TASKS_MAINT_PVT.UPDATE_TASK

4367:
4368: --1) update wbs level of outdenting task and its all child tasks
4369: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4370:
4371: PA_TASKS_MAINT_PVT.UPDATE_TASK
4372: (
4373: p_commit => p_commit
4374: ,p_validate_only => p_validate_only
4375: ,p_validation_level => p_validation_level

Line 4403: PA_TASKS_MAINT_PVT.UPDATE_TASK

4399: --( these new child tasks used to be at the same level before the outdenting task outedented )
4400: --l_task_level now contains old value of the wbs level.
4401: FOR cur_new_child_task_rec IN cur_new_child_task( l_task_level, l_display_sequence ) LOOP
4402:
4403: PA_TASKS_MAINT_PVT.UPDATE_TASK
4404: (
4405: p_commit => p_commit
4406: ,p_validate_only => p_validate_only
4407: ,p_validation_level => p_validation_level

Line 4433: PA_TASKS_MAINT_PVT.UPDATE_TASK

4429: -- The outdenting task becomes the top most task
4430: ELSIF l_task_level = 2
4431: THEN
4432: --1) update parent of outdenting task as null
4433: PA_TASKS_MAINT_PVT.UPDATE_TASK
4434: (
4435: p_commit => p_commit
4436: ,p_validate_only => p_validate_only
4437: ,p_validation_level => p_validation_level

Line 4466: PA_TASKS_MAINT_PVT.UPDATE_TASK

4462: --( these new child tasks used to be at the same level before the outdenting task outedented )
4463: --l_task_level now contains old value of the wbs level.
4464: FOR cur_new_child_task_rec IN cur_new_child_task( l_task_level, l_display_sequence ) LOOP
4465:
4466: PA_TASKS_MAINT_PVT.UPDATE_TASK
4467: (
4468: p_commit => p_commit
4469: ,p_validate_only => p_validate_only
4470: ,p_validation_level => p_validation_level

Line 4495: PA_TASKS_MAINT_PVT.UPDATE_TASK

4491: END IF;
4492:
4493: --updating top_task_id of child tasks of outdenting task's new child tasks
4494: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( cur_new_child_task_rec.task_id ) LOOP
4495: PA_TASKS_MAINT_PVT.UPDATE_TASK
4496: (
4497: p_commit => p_commit
4498: ,p_validate_only => p_validate_only
4499: ,p_validation_level => p_validation_level

Line 4524: PA_TASKS_MAINT_PVT.UPDATE_TASK

4520:
4521: --1) update wbs level of outdenting task and its all child tasks
4522: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4523:
4524: PA_TASKS_MAINT_PVT.UPDATE_TASK
4525: (
4526: p_commit => p_commit
4527: ,p_validate_only => p_validate_only
4528: ,p_validation_level => p_validation_level

Line 4554: PA_TASKS_MAINT_PVT.UPDATE_TASK

4550: -- of outdenting task and child tasks of new child tasks with outdenting task id.
4551:
4552: --updating top_task_id of child tasks of outdenting task
4553: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4554: PA_TASKS_MAINT_PVT.UPDATE_TASK
4555: (
4556: p_commit => p_commit
4557: ,p_validate_only => p_validate_only
4558: ,p_validation_level => p_validation_level

Line 4588: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 4606: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 4747: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

4743: industry => l_fnd_industry,
4744: oracle_schema => l_table_owner);
4745: IF NOT l_fnd_return_status
4746: THEN
4747: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
4748: p_procedure_name => 'Copy_Entire_Project',
4749: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
4750: RAISE FND_API.G_EXC_ERROR;
4751: END IF;

Line 4851: PA_TASKS_MAINT_PVT.CREATE_TASK

4847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4848: RAISE FND_API.G_EXC_ERROR;
4849: END IF;
4850:
4851: PA_TASKS_MAINT_PVT.CREATE_TASK
4852: (
4853: p_commit => p_commit
4854: ,p_validate_only => p_validate_only
4855: ,p_validation_level => p_validation_level

Line 4952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 4970: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 5086: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

5082: industry => l_fnd_industry,
5083: oracle_schema => l_table_owner);
5084: IF NOT l_fnd_return_status
5085: THEN
5086: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5087: p_procedure_name => 'Copy_Entire_Project',
5088: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
5089: RAISE FND_API.G_EXC_ERROR;
5090: END IF;

Line 5142: PA_TASKS_MAINT_PVT.CREATE_TASK

5138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5139: RAISE FND_API.G_EXC_ERROR;
5140: END IF;
5141:
5142: PA_TASKS_MAINT_PVT.CREATE_TASK
5143: (
5144: p_commit => p_commit
5145: ,p_validate_only => p_validate_only
5146: ,p_validation_level => p_validation_level

Line 5235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 5253: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 5408: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

5404: industry => l_fnd_industry,
5405: oracle_schema => l_table_owner);
5406: IF NOT l_fnd_return_status
5407: THEN
5408: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',
5409: p_procedure_name => 'Copy_Entire_Project',
5410: p_error_text => SUBSTRB('FND_INSTALLATION.GET_APP_INFO api call failed:'||SQLERRM,1,240));
5411: RAISE FND_API.G_EXC_ERROR;
5412: END IF;

Line 5512: PA_TASKS_MAINT_PVT.CREATE_TASK

5508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5509: RAISE FND_API.G_EXC_ERROR;
5510: END IF;
5511:
5512: PA_TASKS_MAINT_PVT.CREATE_TASK
5513: (
5514: p_commit => p_commit
5515: ,p_validate_only => p_validate_only
5516: ,p_validation_level => p_validation_level

Line 5615: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 5633: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 5973: PA_TASKS_MAINT_PVT.UPDATE_TASK

5969: l_display_sequence := -( l_ref_display_sequence + i ) ;
5970: END IF;
5971:
5972: --dbms_output.put_line( 'Before update task ' );
5973: PA_TASKS_MAINT_PVT.UPDATE_TASK
5974: (
5975: p_commit => p_commit
5976: ,p_validate_only => p_validate_only
5977: ,p_validation_level => p_validation_level

Line 6064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 6082: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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

Line 6197: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';

6193: p_debug_mode => l_debug_mode );
6194: END IF;
6195:
6196: IF l_debug_mode = 'Y' THEN
6197: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';
6198: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6199: l_debug_level3);
6200:
6201: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,

Line 6219: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Validating Input parameters';

6215: --savepoint SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6216: END IF;
6217:
6218: IF l_debug_mode = 'Y' THEN
6219: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Validating Input parameters';
6220: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6221: l_debug_level3);
6222: END IF;
6223:

Line 6231: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Both p_task_version_id and p_checked_flag are null';

6227: ( p_project_id IS NULL)
6228: )
6229: THEN
6230: IF l_debug_mode = 'Y' THEN
6231: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Both p_task_version_id and p_checked_flag are null';
6232: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6233: l_debug_level3);
6234: END IF;
6235: RAISE Invalid_Arg_Exc_WP;

Line 6267: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK :l_error_code :'||l_error_code||'l_error_msg_code :'||l_error_msg_code;

6263: IF (l_error_code <> 0) THEN
6264:
6265:
6266: IF l_debug_mode = 'Y' THEN
6267: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK :l_error_code :'||l_error_code||'l_error_msg_code :'||l_error_msg_code;
6268: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6269: l_debug_level3);
6270: END IF;
6271: PA_UTILS.ADD_MESSAGE(

Line 6371: x_msg_data := 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

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

Line 6381: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'

6377: IF c_get_task_id%ISOPEN THEN
6378: CLOSE c_get_task_id;
6379: END IF;
6380: Fnd_Msg_Pub.add_exc_msg
6381: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'
6382: , p_procedure_name => 'SET_UNSET_FINANCIAL_TASK'
6383: , p_error_text => x_msg_data);
6384:
6385: IF l_debug_mode = 'Y' THEN

Line 6410: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'

6406: CLOSE c_get_task_id;
6407: END IF;
6408:
6409: Fnd_Msg_Pub.add_exc_msg
6410: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'
6411: , p_procedure_name => 'SET_UNSET_FINANCIAL_TASK'
6412: , p_error_text => x_msg_data);
6413:
6414: IF l_debug_mode = 'Y' THEN

Line 6596: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';

6592: p_debug_mode => l_debug_mode );
6593: END IF;
6594:
6595: IF l_debug_mode = 'Y' THEN
6596: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
6597: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6598: l_debug_level3);
6599:
6600: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,

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

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

Line 6887: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'

6883: IF c_get_pa_record_version_number%ISOPEN THEN
6884: CLOSE c_get_pa_record_version_number;
6885: END IF;
6886: Fnd_Msg_Pub.add_exc_msg
6887: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'
6888: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
6889: , p_error_text => x_msg_data);
6890:
6891: IF l_debug_mode = 'Y' THEN

Line 6925: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'

6921: IF c_get_pa_record_version_number%ISOPEN THEN
6922: CLOSE c_get_pa_record_version_number;
6923: END IF;
6924: Fnd_Msg_Pub.add_exc_msg
6925: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'
6926: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
6927: , p_error_text => x_msg_data);
6928:
6929: IF l_debug_mode = 'Y' THEN

Line 6941: end PA_TASKS_MAINT_PVT;

6937: END SYNC_UP_WP_TASKS_WITH_FIN ;
6938:
6939: --End add by rtarway for FP.M development
6940:
6941: end PA_TASKS_MAINT_PVT;