DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on AHL_VWP_TIMES_PVT

Line 1103: l_duration := AHL_VWP_TIMES_PVT.Get_task_duration(c_task_rec.quantity,l_route_id);

1099: /*
1100: Added by rnahata for Bug 6447221 / 6512871
1101: Task duration will be calculated based on route time span as well as resource requirements
1102: */
1103: l_duration := AHL_VWP_TIMES_PVT.Get_task_duration(c_task_rec.quantity,l_route_id);
1104: ELSE
1105: l_zone := NULL;
1106: l_sub_zone := NULL;
1107: l_duration := c_task_data_rec.duration;

Line 2474: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times' );

2470: --Now adjust the times derivation for task
2471: IF (l_log_statement >= l_log_current_level) THEN
2472: fnd_log.string(l_log_statement,
2473: L_DEBUG_KEY,
2474: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times' );
2475: END IF;
2476:
2477: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Call Adjust_Task_Times only if past date is null
2478: IF l_task_rec.PAST_TASK_START_DATE IS NULL THEN

Line 2479: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,

2475: END IF;
2476:
2477: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Call Adjust_Task_Times only if past date is null
2478: IF l_task_rec.PAST_TASK_START_DATE IS NULL THEN
2479: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
2480: p_init_msg_list => Fnd_Api.G_FALSE,
2481: p_commit => Fnd_Api.G_FALSE,
2482: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
2483: x_return_status => l_return_status,

Line 2492: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );

2488:
2489: IF (l_log_statement >= l_log_current_level) THEN
2490: fnd_log.string(l_log_statement,
2491: L_DEBUG_KEY,
2492: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
2493: END IF;
2494:
2495: --Standard check to count messages
2496: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 3196: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times' );

3192: --Now adjust the times derivation for task
3193: IF (l_log_statement >= l_log_current_level) THEN
3194: fnd_log.string(l_log_statement,
3195: L_DEBUG_KEY,
3196: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times' );
3197: END IF;
3198:
3199: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
3200: p_init_msg_list => Fnd_Api.G_FALSE,

Line 3199: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,

3195: L_DEBUG_KEY,
3196: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times' );
3197: END IF;
3198:
3199: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
3200: p_init_msg_list => Fnd_Api.G_FALSE,
3201: p_commit => Fnd_Api.G_FALSE,
3202: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
3203: x_return_status => l_return_status,

Line 3211: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );

3207:
3208: IF (l_log_statement >= l_log_current_level) THEN
3209: fnd_log.string(l_log_statement,
3210: L_DEBUG_KEY,
3211: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
3212: END IF;
3213:
3214: --Standard check to count messages
3215: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 4509: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');

4505: --Now adjust the times derivation for task
4506: IF (l_log_statement >= l_log_current_level) THEN
4507: fnd_log.string(l_log_statement,
4508: L_DEBUG_KEY,
4509: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');
4510: END IF;
4511:
4512: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Call Adjust_Task_Times only if past date is null
4513: IF l_old_Task_rec.PAST_TASK_START_DATE IS NULL THEN

Line 4514: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,

4510: END IF;
4511:
4512: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Call Adjust_Task_Times only if past date is null
4513: IF l_old_Task_rec.PAST_TASK_START_DATE IS NULL THEN
4514: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
4515: p_init_msg_list => Fnd_Api.G_FALSE,
4516: p_commit => Fnd_Api.G_FALSE,
4517: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
4518: x_return_status => l_return_status,

Line 4527: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );

4523:
4524: IF (l_log_statement >= l_log_current_level) THEN
4525: fnd_log.string(l_log_statement,
4526: L_DEBUG_KEY,
4527: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = '|| l_return_status );
4528: END IF;
4529:
4530: --Standard check to count messages
4531: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 5117: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');

5113: --Now adjust the times derivation for task
5114: IF (l_log_statement >= l_log_current_level) THEN
5115: fnd_log.string(l_log_statement,
5116: L_DEBUG_KEY,
5117: 'Before Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');
5118: END IF;
5119:
5120: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Call Adjust_Task_Times only if past date is null
5121: IF l_task_rec.PAST_TASK_START_DATE IS NULL THEN

Line 5122: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,

5118: END IF;
5119:
5120: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Call Adjust_Task_Times only if past date is null
5121: IF l_task_rec.PAST_TASK_START_DATE IS NULL THEN
5122: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
5123: p_init_msg_list => Fnd_Api.G_FALSE,
5124: p_commit => Fnd_Api.G_FALSE,
5125: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
5126: x_return_status => l_return_status,

Line 5135: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = ' || l_return_status);

5131:
5132: IF (l_log_statement >= l_log_current_level) THEN
5133: fnd_log.string(l_log_statement,
5134: L_DEBUG_KEY,
5135: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = ' || l_return_status);
5136: END IF;
5137:
5138: --Standard check to count messages
5139: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 5765: 'Before calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');

5761: --Now adjust the times derivation for task
5762: IF (l_log_statement >= l_log_current_level) THEN
5763: fnd_log.string(l_log_statement,
5764: L_DEBUG_KEY,
5765: 'Before calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');
5766: END IF;
5767: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
5768: p_init_msg_list => Fnd_Api.G_FALSE,
5769: p_commit => Fnd_Api.G_FALSE,

Line 5767: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,

5763: fnd_log.string(l_log_statement,
5764: L_DEBUG_KEY,
5765: 'Before calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');
5766: END IF;
5767: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
5768: p_init_msg_list => Fnd_Api.G_FALSE,
5769: p_commit => Fnd_Api.G_FALSE,
5770: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
5771: x_return_status => l_return_status,

Line 5778: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = ' || l_return_status);

5774: p_task_id =>l_task_rec.visit_task_id);
5775: IF (l_log_statement >= l_log_current_level) THEN
5776: fnd_log.string(l_log_statement,
5777: L_DEBUG_KEY,
5778: 'After Calling AHL_VWP_TIMES_PVT.Adjust_Task_Times, Return Status = ' || l_return_status);
5779: END IF;
5780:
5781: --Standard check to count messages
5782: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 6129: 'Before Calling AHL_VWP_TIMES_PVT.calculate_Task_Times');

6125:
6126: IF (l_log_statement >= l_log_current_level) THEN
6127: fnd_log.string(l_log_statement,
6128: L_DEBUG_KEY,
6129: 'Before Calling AHL_VWP_TIMES_PVT.calculate_Task_Times');
6130: END IF;
6131:
6132: AHL_VWP_TIMES_PVT.calculate_Task_Times(p_api_version => 1.0,
6133: p_init_msg_list => Fnd_Api.G_FALSE,

Line 6132: AHL_VWP_TIMES_PVT.calculate_Task_Times(p_api_version => 1.0,

6128: L_DEBUG_KEY,
6129: 'Before Calling AHL_VWP_TIMES_PVT.calculate_Task_Times');
6130: END IF;
6131:
6132: AHL_VWP_TIMES_PVT.calculate_Task_Times(p_api_version => 1.0,
6133: p_init_msg_list => Fnd_Api.G_FALSE,
6134: p_commit => Fnd_Api.G_FALSE,
6135: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
6136: x_return_status => l_return_status,

Line 6144: 'After Calling AHL_VWP_TIMES_PVT.calculate_Task_Times, Return Status = ' || l_return_status);

6140:
6141: IF (l_log_statement >= l_log_current_level) THEN
6142: fnd_log.string(l_log_statement,
6143: L_DEBUG_KEY,
6144: 'After Calling AHL_VWP_TIMES_PVT.calculate_Task_Times, Return Status = ' || l_return_status);
6145: END IF;
6146:
6147: IF (l_log_statement >= l_log_current_level) THEN
6148: fnd_log.string(l_log_statement,

Line 8813: -- Flag to decide if call to AHL_VWP_TIMES_PVT.Calculate_Task_Times is needed

8809: l_task_type VARCHAR2(30);
8810: -- End changes by rnahata for Issue 105
8811:
8812: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010
8813: -- Flag to decide if call to AHL_VWP_TIMES_PVT.Calculate_Task_Times is needed
8814: l_past_dates_flag VARCHAR(1):= 'N' ;
8815:
8816: -- To find visit related information
8817: CURSOR c_visit(x_id IN NUMBER) IS

Line 9178: -- Skip calling AHL_VWP_TIMES_PVT.Calculate_Task_Times if

9174: END LOOP;
9175: END IF;
9176: l_task_data := l_task_tbl;
9177: -- SKPATHAK :: Bug 8343599 :: 14_APR-2009 :: Begin
9178: -- Skip calling AHL_VWP_TIMES_PVT.Calculate_Task_Times if
9179: -- the user has entered task start date for Non Routine
9180: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Added one more condition (l_past_dates_flag = 'N')
9181: IF (p_module_type <> 'SR' OR l_task_tbl(1).task_start_date IS NULL) AND (l_past_dates_flag = 'N') THEN
9182: IF (l_log_statement >= l_log_current_level) THEN

Line 9185: 'Before Calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');

9181: IF (p_module_type <> 'SR' OR l_task_tbl(1).task_start_date IS NULL) AND (l_past_dates_flag = 'N') THEN
9182: IF (l_log_statement >= l_log_current_level) THEN
9183: fnd_log.string(l_log_statement,
9184: L_DEBUG_KEY,
9185: 'Before Calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
9186: END IF;
9187: AHL_VWP_TIMES_PVT.Calculate_Task_Times(p_api_version => 1.0,
9188: p_init_msg_list => Fnd_Api.G_FALSE,
9189: p_commit => Fnd_Api.G_FALSE,

Line 9187: AHL_VWP_TIMES_PVT.Calculate_Task_Times(p_api_version => 1.0,

9183: fnd_log.string(l_log_statement,
9184: L_DEBUG_KEY,
9185: 'Before Calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
9186: END IF;
9187: AHL_VWP_TIMES_PVT.Calculate_Task_Times(p_api_version => 1.0,
9188: p_init_msg_list => Fnd_Api.G_FALSE,
9189: p_commit => Fnd_Api.G_FALSE,
9190: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
9191: x_return_status => l_return_status,

Line 9199: 'After Calling AHL_VWP_TIMES_PVT.Calculate_Task_Times. Return Status = ' || l_return_status );

9195:
9196: IF (l_log_statement >= l_log_current_level) THEN
9197: fnd_log.string(l_log_statement,
9198: L_DEBUG_KEY,
9199: 'After Calling AHL_VWP_TIMES_PVT.Calculate_Task_Times. Return Status = ' || l_return_status );
9200: END IF;
9201:
9202: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
9203: x_msg_count := l_msg_count;

Line 9211: -- We are making this call after AHL_VWP_TIMES_PVT.Calculate_Task_Times, so that by this point of time, we can access all the already validated task rules and task related info from the DB.

9207: END IF;
9208: -- SKPATHAK :: Bug 8343599 :: 14_APR-2009 :: End
9209:
9210: --VWPE :: tchimira :: 19-FEB -2011 :: start
9211: -- We are making this call after AHL_VWP_TIMES_PVT.Calculate_Task_Times, so that by this point of time, we can access all the already validated task rules and task related info from the DB.
9212: IF (l_log_statement >= l_log_current_level) THEN
9213: fnd_log.string(l_log_statement,
9214: L_DEBUG_KEY,
9215: 'Before Calling AHL_VWP_RULES_PVT.Handle_Task_Dependency');