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.14.12010000.4 2008/10/30 23:06:21 kmaddi 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.14.12010000.4 2008/10/30 23:06:21 kmaddi 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 1814: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PVT',

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',
1816: p_error_text => SUBSTRB(SQLERRM,1,240));
1817: RAISE;
1818: END CREATE_TASK;

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

2291:
2292: BEGIN
2293:
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;

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

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));
3333: RAISE;
3334: END UPDATE_TASK;

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

3381: t_pm_product_code PA_TASKS.PM_PRODUCT_CODE%TYPE;
3382: t_parent_task_id PA_TASKS.PARENT_TASK_ID%TYPE;
3383: BEGIN
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;

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

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));
3537: RAISE;
3538: END DELETE_TASK;

Line 3728: PA_TASKS_MAINT_PVT.UPDATE_TASK

3724:
3725: -- HSIU changes ends here
3726:
3727: -- 1) update the parent task id of the indenting task with the above task id
3728: PA_TASKS_MAINT_PVT.UPDATE_TASK
3729: (
3730: p_commit => p_commit
3731: ,p_validate_only => p_validate_only
3732: ,p_validation_level => p_validation_level

Line 3774: PA_TASKS_MAINT_PVT.UPDATE_TASK

3770:
3771:
3772: FOR cur_task_heirarchy_rec IN cur_task_heirarchy LOOP
3773:
3774: PA_TASKS_MAINT_PVT.UPDATE_TASK
3775: (
3776: p_commit => p_commit
3777: ,p_validate_only => p_validate_only
3778: ,p_validation_level => p_validation_level

Line 3817: PA_TASKS_MAINT_PVT.UPDATE_TASK

3813: OPEN cur_parent_of_above( l_task_level , l_top_task_id_above, l_display_sequence );
3814: FETCH cur_parent_of_above INTO l_new_parent_id, l_new_top_id;
3815: CLOSE cur_parent_of_above;
3816:
3817: PA_TASKS_MAINT_PVT.UPDATE_TASK
3818: (
3819: p_commit => p_commit
3820: ,p_validate_only => p_validate_only
3821: ,p_validation_level => p_validation_level

Line 3848: PA_TASKS_MAINT_PVT.UPDATE_TASK

3844:
3845:
3846: FOR cur_task_heirarchy_rec IN cur_task_heirarchy LOOP
3847:
3848: PA_TASKS_MAINT_PVT.UPDATE_TASK
3849: (
3850: p_commit => p_commit
3851: ,p_validate_only => p_validate_only
3852: ,p_validation_level => p_validation_level

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

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;
3888:

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: RAISE;
3906:

Line 4075: PA_TASKS_MAINT_PVT.UPDATE_TASK

4071: IF l_task_level_above < l_task_level
4072: THEN
4073: --2) update the parent task id of outdenting task with the parent task id of the task above
4074:
4075: PA_TASKS_MAINT_PVT.UPDATE_TASK
4076: (
4077: p_commit => p_commit
4078: ,p_validate_only => p_validate_only
4079: ,p_validation_level => p_validation_level

Line 4103: PA_TASKS_MAINT_PVT.UPDATE_TASK

4099: --1) update wbs level of outdenting task includinf its children
4100:
4101: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4102:
4103: PA_TASKS_MAINT_PVT.UPDATE_TASK
4104: (
4105: p_commit => p_commit
4106: ,p_validate_only => p_validate_only
4107: ,p_validation_level => p_validation_level

Line 4141: PA_TASKS_MAINT_PVT.UPDATE_TASK

4137: IF l_parent_task_id_above IS NULL
4138: THEN
4139: FOR cur_all_tasks_rec IN cur_all_tasks( l_top_task_id , l_display_sequence ) LOOP
4140:
4141: PA_TASKS_MAINT_PVT.UPDATE_TASK
4142: (
4143: p_commit => p_commit
4144: ,p_validate_only => p_validate_only
4145: ,p_validation_level => p_validation_level

Line 4173: PA_TASKS_MAINT_PVT.UPDATE_TASK

4169: --( these new child tasks used to be at the same level before the outdenting task outedented )
4170: --l_task_level now contains old value of the wbs level.
4171: FOR cur_new_child_task_rec IN cur_new_child_task( l_task_level, l_display_sequence ) LOOP
4172:
4173: PA_TASKS_MAINT_PVT.UPDATE_TASK
4174: (
4175: p_commit => p_commit
4176: ,p_validate_only => p_validate_only
4177: ,p_validation_level => p_validation_level

Line 4218: PA_TASKS_MAINT_PVT.UPDATE_TASK

4214: THEN
4215: l_new_top_id := p_task_id;
4216: l_new_parent_id := null;
4217: END IF;
4218: PA_TASKS_MAINT_PVT.UPDATE_TASK
4219: (
4220: p_commit => p_commit
4221: ,p_validate_only => p_validate_only
4222: ,p_validation_level => p_validation_level

Line 4247: PA_TASKS_MAINT_PVT.UPDATE_TASK

4243: --1) update wbs level
4244:
4245: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4246:
4247: PA_TASKS_MAINT_PVT.UPDATE_TASK
4248: (
4249: p_commit => p_commit
4250: ,p_validate_only => p_validate_only
4251: ,p_validation_level => p_validation_level

Line 4280: PA_TASKS_MAINT_PVT.UPDATE_TASK

4276: --l_task_level now contains old value of the wbs level.
4277: --Also update the top task id for the new children
4278: FOR cur_new_child_task_rec IN cur_new_child_task( l_task_level, l_display_sequence ) LOOP
4279:
4280: PA_TASKS_MAINT_PVT.UPDATE_TASK
4281: (
4282: p_commit => p_commit
4283: ,p_validate_only => p_validate_only
4284: ,p_validation_level => p_validation_level

Line 4327: PA_TASKS_MAINT_PVT.UPDATE_TASK

4323:
4324: --The outdenting task may become a child of another task or
4325: --it may become the top most task in its branch.
4326:
4327: PA_TASKS_MAINT_PVT.UPDATE_TASK
4328: (
4329: p_commit => p_commit
4330: ,p_validate_only => p_validate_only
4331: ,p_validation_level => p_validation_level

Line 4353: PA_TASKS_MAINT_PVT.UPDATE_TASK

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
4352:
4353: PA_TASKS_MAINT_PVT.UPDATE_TASK
4354: (
4355: p_commit => p_commit
4356: ,p_validate_only => p_validate_only
4357: ,p_validation_level => p_validation_level

Line 4385: PA_TASKS_MAINT_PVT.UPDATE_TASK

4381: --( these new child tasks used to be at the same level before the outdenting task outedented )
4382: --l_task_level now contains old value of the wbs level.
4383: FOR cur_new_child_task_rec IN cur_new_child_task( l_task_level, l_display_sequence ) LOOP
4384:
4385: PA_TASKS_MAINT_PVT.UPDATE_TASK
4386: (
4387: p_commit => p_commit
4388: ,p_validate_only => p_validate_only
4389: ,p_validation_level => p_validation_level

Line 4415: PA_TASKS_MAINT_PVT.UPDATE_TASK

4411: -- The outdenting task becomes the top most task
4412: ELSIF l_task_level = 2
4413: THEN
4414: --1) update parent of outdenting task as null
4415: PA_TASKS_MAINT_PVT.UPDATE_TASK
4416: (
4417: p_commit => p_commit
4418: ,p_validate_only => p_validate_only
4419: ,p_validation_level => p_validation_level

Line 4448: PA_TASKS_MAINT_PVT.UPDATE_TASK

4444: --( these new child tasks used to be at the same level before the outdenting task outedented )
4445: --l_task_level now contains old value of the wbs level.
4446: FOR cur_new_child_task_rec IN cur_new_child_task( l_task_level, l_display_sequence ) LOOP
4447:
4448: PA_TASKS_MAINT_PVT.UPDATE_TASK
4449: (
4450: p_commit => p_commit
4451: ,p_validate_only => p_validate_only
4452: ,p_validation_level => p_validation_level

Line 4477: PA_TASKS_MAINT_PVT.UPDATE_TASK

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
4477: PA_TASKS_MAINT_PVT.UPDATE_TASK
4478: (
4479: p_commit => p_commit
4480: ,p_validate_only => p_validate_only
4481: ,p_validation_level => p_validation_level

Line 4506: PA_TASKS_MAINT_PVT.UPDATE_TASK

4502:
4503: --1) update wbs level of outdenting task and its all child tasks
4504: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4505:
4506: PA_TASKS_MAINT_PVT.UPDATE_TASK
4507: (
4508: p_commit => p_commit
4509: ,p_validate_only => p_validate_only
4510: ,p_validation_level => p_validation_level

Line 4536: PA_TASKS_MAINT_PVT.UPDATE_TASK

4532: -- of outdenting task and child tasks of new child tasks with outdenting task id.
4533:
4534: --updating top_task_id of child tasks of outdenting task
4535: FOR cur_task_heirarchy_rec IN cur_task_heirarchy( p_task_id ) LOOP
4536: PA_TASKS_MAINT_PVT.UPDATE_TASK
4537: (
4538: p_commit => p_commit
4539: ,p_validate_only => p_validate_only
4540: ,p_validation_level => p_validation_level

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

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;
4574:

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: RAISE;
4592: END Outdent_Task;

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

4723: industry => l_fnd_industry,
4724: oracle_schema => l_table_owner);
4725: IF NOT l_fnd_return_status
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;

Line 4831: PA_TASKS_MAINT_PVT.CREATE_TASK

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: (
4833: p_commit => p_commit
4834: ,p_validate_only => p_validate_only
4835: ,p_validation_level => p_validation_level

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

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;
4936:

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

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;
4954: END Copy_Entire_Project;

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

5060: industry => l_fnd_industry,
5061: oracle_schema => l_table_owner);
5062: IF NOT l_fnd_return_status
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;

Line 5120: PA_TASKS_MAINT_PVT.CREATE_TASK

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: (
5122: p_commit => p_commit
5123: ,p_validate_only => p_validate_only
5124: ,p_validation_level => p_validation_level

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

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;
5217:

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

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;
5235: END Copy_Selected_Task;

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

5380: industry => l_fnd_industry,
5381: oracle_schema => l_table_owner);
5382: IF NOT l_fnd_return_status
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;

Line 5488: PA_TASKS_MAINT_PVT.CREATE_TASK

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: (
5490: p_commit => p_commit
5491: ,p_validate_only => p_validate_only
5492: ,p_validation_level => p_validation_level

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

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;
5595:

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

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;
5613:

Line 5923: PA_TASKS_MAINT_PVT.UPDATE_TASK

5919: l_display_sequence := -( l_ref_display_sequence + i ) ;
5920: END IF;
5921:
5922: --dbms_output.put_line( 'Before update task ' );
5923: PA_TASKS_MAINT_PVT.UPDATE_TASK
5924: (
5925: p_commit => p_commit
5926: ,p_validate_only => p_validate_only
5927: ,p_validation_level => p_validation_level

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

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;
6018:

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

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;
6036:

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

6125: p_debug_mode => l_debug_mode );
6126: END IF;
6127:
6128: IF l_debug_mode = 'Y' THEN
6129: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Printing Input parameters';
6130: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6131: l_debug_level3);
6132:
6133: Pa_Debug.WRITE(g_pkg_name,'p_task_version_id'||':'||p_task_version_id,

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

6147: --savepoint SET_FIN_FLAG_WRAPPER_PUBLIC; Bug 3735089
6148: END IF;
6149:
6150: IF l_debug_mode = 'Y' THEN
6151: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Validating Input parameters';
6152: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6153: l_debug_level3);
6154: END IF;
6155:

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

6159: ( p_project_id IS NULL)
6160: )
6161: THEN
6162: IF l_debug_mode = 'Y' THEN
6163: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SET_UNSET_FINANCIAL_TASK : Both p_task_version_id and p_checked_flag are null';
6164: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6165: l_debug_level3);
6166: END IF;
6167: RAISE Invalid_Arg_Exc_WP;

Line 6199: 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;

6195: IF (l_error_code <> 0) THEN
6196:
6197:
6198: IF l_debug_mode = 'Y' THEN
6199: 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;
6200: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6201: l_debug_level3);
6202: END IF;
6203: PA_UTILS.ADD_MESSAGE(

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

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
6275: ROLLBACK TO SET_UNSET_FINANCIAL_TASK_PVT;
6276: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089

Line 6282: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'

6278: IF c_get_task_id%ISOPEN THEN
6279: CLOSE c_get_task_id;
6280: END IF;
6281: Fnd_Msg_Pub.add_exc_msg
6282: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'
6283: , p_procedure_name => 'SET_UNSET_FINANCIAL_TASK'
6284: , p_error_text => x_msg_data);
6285:
6286: IF l_debug_mode = 'Y' THEN

Line 6311: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'

6307: CLOSE c_get_task_id;
6308: END IF;
6309:
6310: Fnd_Msg_Pub.add_exc_msg
6311: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'
6312: , p_procedure_name => 'SET_UNSET_FINANCIAL_TASK'
6313: , p_error_text => x_msg_data);
6314:
6315: IF l_debug_mode = 'Y' THEN

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

6493: p_debug_mode => l_debug_mode );
6494: END IF;
6495:
6496: IF l_debug_mode = 'Y' THEN
6497: Pa_Debug.g_err_stage:= 'PA_TASKS_MAINT_PVT : SYNC_UP_WP_TASKS_WITH_FIN : Printing Input parameters';
6498: Pa_Debug.WRITE(g_pkg_name,Pa_Debug.g_err_stage,
6499: l_debug_level3);
6500:
6501: Pa_Debug.WRITE(g_pkg_name,'p_project_id '||':'||p_project_id ,

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

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
6769: --ROLLBACK TO DELETE_MAPPING_PUBLIC; Bug 3735089
6770: ROLLBACK TO SYNC_UP_WP_TASKS_WITH_FIN_PVT;

Line 6788: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'

6784: IF c_get_pa_record_version_number%ISOPEN THEN
6785: CLOSE c_get_pa_record_version_number;
6786: END IF;
6787: Fnd_Msg_Pub.add_exc_msg
6788: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'
6789: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
6790: , p_error_text => x_msg_data);
6791:
6792: IF l_debug_mode = 'Y' THEN

Line 6826: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'

6822: IF c_get_pa_record_version_number%ISOPEN THEN
6823: CLOSE c_get_pa_record_version_number;
6824: END IF;
6825: Fnd_Msg_Pub.add_exc_msg
6826: ( p_pkg_name => 'PA_TASKS_MAINT_PVT'
6827: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
6828: , p_error_text => x_msg_data);
6829:
6830: IF l_debug_mode = 'Y' THEN

Line 6842: end PA_TASKS_MAINT_PVT;

6838: END SYNC_UP_WP_TASKS_WITH_FIN ;
6839:
6840: --End add by rtarway for FP.M development
6841:
6842: end PA_TASKS_MAINT_PVT;