DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_DEBUG

Line 400: pa_debug.debug('PA_TASK_PVT1.CREATE_TASK begin');

396:
397: --dbms_output.put_line(( 'Inside CREATE_TASK private API' );
398:
399: IF (p_debug_mode = 'Y') THEN
400: pa_debug.debug('PA_TASK_PVT1.CREATE_TASK begin');
401: END IF;
402:
403: IF (p_commit = FND_API.G_TRUE) THEN
404: savepoint CREATE_TASK_PRIVATE;

Line 408: pa_debug.debug('Performing validations');

404: savepoint CREATE_TASK_PRIVATE;
405: END IF;
406:
407: IF (p_debug_mode = 'Y') THEN
408: pa_debug.debug('Performing validations');
409: END IF;
410:
411: IF p_object_type <> 'PA_TASKS'
412: THEN

Line 1891: pa_debug.debug('PA_TASK_PVT1.UPDATE_TASK begin');

1887: --Bug 14213385 end
1888: BEGIN
1889:
1890: IF (p_debug_mode = 'Y') THEN
1891: pa_debug.debug('PA_TASK_PVT1.UPDATE_TASK begin');
1892: END IF;
1893:
1894: IF (p_commit = FND_API.G_TRUE) THEN
1895: savepoint UPDATE_TASK_PRIVATE;

Line 1899: pa_debug.debug('Performing validations');

1895: savepoint UPDATE_TASK_PRIVATE;
1896: END IF;
1897:
1898: IF (p_debug_mode = 'Y') THEN
1899: pa_debug.debug('Performing validations');
1900: END IF;
1901:
1902: --dbms_output.put_line(( 'Get the basic attributes of the task.' );
1903:

Line 3385: pa_debug.debug('PA_TASK_PVT1.CREATE_TASK_VERSION begin');

3381: BEGIN
3382:
3383: --my_error_msg( 'In create_task_version pvt API' );
3384: IF (p_debug_mode = 'Y') THEN
3385: pa_debug.debug('PA_TASK_PVT1.CREATE_TASK_VERSION begin');
3386: END IF;
3387:
3388: IF (p_commit = FND_API.G_TRUE) THEN
3389: savepoint CREATE_TASK_VER_PRIVATE;

Line 3393: pa_debug.debug('Performing validations');

3389: savepoint CREATE_TASK_VER_PRIVATE;
3390: END IF;
3391:
3392: IF (p_debug_mode = 'Y') THEN
3393: pa_debug.debug('Performing validations');
3394: END IF;
3395:
3396: IF ( p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_attribute_category IS NOT NULL )
3397: THEN

Line 4238: pa_debug.debug('PA_TASK_PVT1.UPDATE_TASK_VERSION begin');

4234: END IF;
4235: -- 14556729:Huawei code change :get the Sharing code and process below code only if its fully shared
4236:
4237: IF (p_debug_mode = 'Y') THEN
4238: pa_debug.debug('PA_TASK_PVT1.UPDATE_TASK_VERSION begin');
4239: END IF;
4240:
4241: IF (p_commit = FND_API.G_TRUE) THEN
4242: savepoint UPDATE_TASK_VER_PRIVATE;

Line 4246: pa_debug.debug('Performing validations');

4242: savepoint UPDATE_TASK_VER_PRIVATE;
4243: END IF;
4244:
4245: IF (p_debug_mode = 'Y') THEN
4246: pa_debug.debug('Performing validations');
4247: END IF;
4248:
4249: --Bug 13895419 start
4250: --Fetch parent_task_id and ref_parent_task_id for source task and target task respectively from db.

Line 5620: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

5616: l_calling_context VARCHAR2(255) := NULL; -- Bug 9535723
5617:
5618: BEGIN
5619:
5620: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5621:
5622: -- Added for FP_M changes : Bhumesh
5623: -- 4201927 Removed following code for performance issue
5624: -- the same information ( project_id ) is already available in below select

Line 5669: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VERSION begin');

5665: */
5666: -- 4201927 end
5667:
5668: IF (p_debug_mode = 'Y') THEN
5669: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VERSION begin');
5670: END IF;
5671:
5672: IF (p_commit = FND_API.G_TRUE) THEN
5673: savepoint DELETE_TASK_VER_PRIVATE;

Line 5677: pa_debug.debug('Performing validations');

5673: savepoint DELETE_TASK_VER_PRIVATE;
5674: END IF;
5675:
5676: IF (p_debug_mode = 'Y') THEN
5677: pa_debug.debug('Performing validations');
5678: END IF;
5679:
5680: --hsiu
5681: --added for task weighting changes

Line 6243: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='

6239: FETCH get_subproj_relation INTO get_subproj_relation_rec;
6240: IF get_subproj_relation%FOUND --bug 4573340
6241: THEN
6242: IF l_debug_mode = 'Y' THEN
6243: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
6244: ||get_subproj_relation_rec.object_relationship_id, 3);
6245: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
6246: ||get_subproj_relation_rec.record_version_number, 3);
6247:

Line 6245: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='

6241: THEN
6242: IF l_debug_mode = 'Y' THEN
6243: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
6244: ||get_subproj_relation_rec.object_relationship_id, 3);
6245: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
6246: ||get_subproj_relation_rec.record_version_number, 3);
6247:
6248: END IF;
6249:

Line 6267: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);

6263: ,x_msg_data => l_msg_data
6264: );
6265:
6266: IF l_debug_mode = 'Y' THEN
6267: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);
6268: END IF;
6269:
6270: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6271: x_msg_count := FND_MSG_PUB.count_msg;

Line 7074: pa_debug.debug('PA_TASK_PVT1.CREATE_SCHEDULE_VERSION begin');

7070: l_ext_remain_duration NUMBER;
7071: l_ext_sch_duration NUMBER;
7072: BEGIN
7073: IF (p_debug_mode = 'Y') THEN
7074: pa_debug.debug('PA_TASK_PVT1.CREATE_SCHEDULE_VERSION begin');
7075: END IF;
7076:
7077: IF (p_commit = FND_API.G_TRUE) THEN
7078: savepoint CREATE_SCH_VER_PRIVATE;

Line 7082: pa_debug.debug('Performing validations');

7078: savepoint CREATE_SCH_VER_PRIVATE;
7079: END IF;
7080:
7081: IF (p_debug_mode = 'Y') THEN
7082: pa_debug.debug('Performing validations');
7083: END IF;
7084:
7085:
7086: IF ( p_calendar_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_calendar_id IS NULL )

Line 7969: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

7965: l_workplan_version_enable_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
7966:
7967: BEGIN
7968:
7969: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
7970:
7971: IF (l_debug_mode = 'Y') THEN
7972: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION begin',3);
7973: END IF;

Line 7972: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION begin',3);

7968:
7969: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
7970:
7971: IF (l_debug_mode = 'Y') THEN
7972: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION begin',3);
7973: END IF;
7974:
7975: IF (p_commit = FND_API.G_TRUE) THEN
7976: savepoint UPDATE_SCH_VER_PRIVATE;

Line 7980: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'Performing validations',3);

7976: savepoint UPDATE_SCH_VER_PRIVATE;
7977: END IF;
7978:
7979: IF (l_debug_mode = 'Y') THEN
7980: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'Performing validations',3);
7981: END IF;
7982:
7983: OPEN cur_val;
7984: FETCH cur_val into cur_val_rec;

Line 8099: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);

8095: --end bug 4620492
8096: END IF; -- end changes for bug 13923366
8097:
8098: IF (l_debug_mode = 'Y') THEN
8099: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
8100: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
8101: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
8102: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
8103: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);

Line 8100: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);

8096: END IF; -- end changes for bug 13923366
8097:
8098: IF (l_debug_mode = 'Y') THEN
8099: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
8100: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
8101: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
8102: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
8103: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);
8104: END IF;

Line 8101: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);

8097:
8098: IF (l_debug_mode = 'Y') THEN
8099: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
8100: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
8101: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
8102: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
8103: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);
8104: END IF;
8105:

Line 8102: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);

8098: IF (l_debug_mode = 'Y') THEN
8099: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
8100: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
8101: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
8102: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
8103: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);
8104: END IF;
8105:
8106: --For bug 2638649

Line 8103: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);

8099: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
8100: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
8101: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
8102: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
8103: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);
8104: END IF;
8105:
8106: --For bug 2638649
8107: IF ( p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND p_scheduled_start_date IS NOT NULL )

Line 9235: pa_debug.debug('PA_TASK_PVT1.Update_Task_Weighting begin');

9231:
9232:
9233: BEGIN
9234: IF (p_debug_mode = 'Y') THEN
9235: pa_debug.debug('PA_TASK_PVT1.Update_Task_Weighting begin');
9236: END IF;
9237:
9238: IF (p_commit = FND_API.G_TRUE) THEN
9239: savepoint update_task_weighting_pvt;

Line 9243: pa_debug.debug('Performing validations');

9239: savepoint update_task_weighting_pvt;
9240: END IF;
9241:
9242: IF (p_debug_mode = 'Y') THEN
9243: pa_debug.debug('Performing validations');
9244: END IF;
9245:
9246: IF (p_weighting_percentage is null) THEN
9247: l_weighting_percentage := 0;

Line 9253: pa_debug.debug('Querying up the row from the object relationship table.');

9249: l_weighting_percentage := p_weighting_percentage;
9250: END IF;
9251:
9252: IF (p_debug_mode = 'Y') THEN
9253: pa_debug.debug('Querying up the row from the object relationship table.');
9254: END IF;
9255:
9256: OPEN cur_obj_relationships( p_object_relationship_id );
9257: FETCH cur_obj_relationships INTO cur_obj_relationships_rec;

Line 9775: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

9771: l_debug_mode VARCHAR2(1);
9772: l_dest_proj_id pa_object_relationships.object_id_to2%type; --Bug 14591859
9773: BEGIN
9774:
9775: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
9776:
9777: IF (p_debug_mode = 'Y') THEN
9778: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL begin');
9779: END IF;

Line 9778: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL begin');

9774:
9775: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
9776:
9777: IF (p_debug_mode = 'Y') THEN
9778: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL begin');
9779: END IF;
9780:
9781: IF (p_commit = FND_API.G_TRUE) THEN
9782: savepoint DELETE_TASK_VER_WO_VAL;

Line 10021: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='

10017: --Bug 14591859: One task can have multiple projects linked to it. So need to delete all the sub-projects associated to it.
10018: l_dest_proj_id:=null; --Added for the Bug 14591859
10019: FOR get_subproj_relation_rec in get_subproj_relation(cur_child_tasks_rec.object_id_to1) LOOP --Added for the Bug 14591859
10020: IF l_debug_mode = 'Y' THEN
10021: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
10022: ||get_subproj_relation_rec.object_relationship_id, 3);
10023: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
10024: ||get_subproj_relation_rec.record_version_number, 3);
10025:

Line 10023: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='

10019: FOR get_subproj_relation_rec in get_subproj_relation(cur_child_tasks_rec.object_id_to1) LOOP --Added for the Bug 14591859
10020: IF l_debug_mode = 'Y' THEN
10021: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
10022: ||get_subproj_relation_rec.object_relationship_id, 3);
10023: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
10024: ||get_subproj_relation_rec.record_version_number, 3);
10025:
10026: END IF;
10027:

Line 10047: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);

10043: ,x_msg_data => l_msg_data
10044: );
10045:
10046: IF l_debug_mode = 'Y' THEN
10047: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);
10048: END IF;
10049:
10050:
10051: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 10773: pa_debug.debug('PA_TASK_PVT1.Update_Dates_To_All_Versions begin');

10769: START WITH OBJECT_ID_TO1 = c_elem_ver_id ;
10770:
10771: BEGIN
10772: IF (p_debug_mode = 'Y') THEN
10773: pa_debug.debug('PA_TASK_PVT1.Update_Dates_To_All_Versions begin');
10774: END IF;
10775:
10776: IF (p_commit = FND_API.G_TRUE) THEN
10777: savepoint UPDATE_SCH_VER_PRIVATE_DATES;

Line 10898: pa_debug.debug('PA_TASK_PVT1.DISP_SEQ_NUM_LEVEL_DEFER begin');

10894: level_sequence ,
10895: sub_level_Seq;
10896: BEGIN
10897: IF (p_debug_mode = 'Y') THEN
10898: pa_debug.debug('PA_TASK_PVT1.DISP_SEQ_NUM_LEVEL_DEFER begin');
10899: END IF;
10900:
10901: IF (p_commit = FND_API.G_TRUE) THEN
10902: savepoint DISP_SEQ_NUM_LEVEL_DEFER;

Line 11056: pa_debug.debug('PA_TASK_PVT1.DEFER_CALC_TASK_WEIGTHAGE begin');

11052: l_data c_array;
11053: l_plsql_max_array_size CONSTANT NUMBER := 1000;
11054: BEGIN
11055: IF (p_debug_mode = 'Y') THEN
11056: pa_debug.debug('PA_TASK_PVT1.DEFER_CALC_TASK_WEIGTHAGE begin');
11057: END IF;
11058:
11059: IF (p_commit = FND_API.G_TRUE) THEN
11060: savepoint DEFER_CALC_TASK_WEIGTHAGE;