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.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VWP_VISITS_STAGES_PVT

Line 1: PACKAGE BODY AHL_VWP_VISITS_STAGES_PVT AS

1: PACKAGE BODY AHL_VWP_VISITS_STAGES_PVT AS
2: /* $Header: AHLVSTGB.pls 120.2.12020000.2 2012/12/07 14:50:55 sareepar ship $ */
3:
4: -----------------------------------------------------------
5: -- PACKAGE

Line 6: -- AHL_VWP_VISITS_STAGES_PVT

2: /* $Header: AHLVSTGB.pls 120.2.12020000.2 2012/12/07 14:50:55 sareepar ship $ */
3:
4: -----------------------------------------------------------
5: -- PACKAGE
6: -- AHL_VWP_VISITS_STAGES_PVT
7: --
8: -- PURPOSE
9: -- This package specification is a Private API for managing
10: -- Planning --> Visit Work Package --> VISITS --> STAGES

Line 1155: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_SUCC_STG_START_DATES - l_return_status : '||l_return_status);

1151: x_msg_count => l_msg_count,
1152: x_msg_data => l_msg_data);
1153:
1154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_SUCC_STG_START_DATES - l_return_status : '||l_return_status);
1156: END IF;
1157:
1158: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1159: x_msg_count := l_msg_count;

Line 1181: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DEPENDENCY_RULES - l_return_status : '||l_return_status||' :p_x_stages_ovn_tbl cnt is '||p_x_stages_ovn_tbl.count);

1177: x_msg_count => l_msg_count,
1178: x_msg_data => l_msg_data);
1179:
1180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1181: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DEPENDENCY_RULES - l_return_status : '||l_return_status||' :p_x_stages_ovn_tbl cnt is '||p_x_stages_ovn_tbl.count);
1182: END IF;
1183:
1184: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1185: x_msg_count := l_msg_count;

Line 3009: ' Before Calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES ');

3005: FOR l_tasks_rec IN c_visit_tasks(l_visit_id, p_stage_type_assoc_tbl(i).stage_type_code) LOOP
3006: IF (l_log_statement >= l_log_current_level) THEN
3007: fnd_log.string(l_log_statement,
3008: L_DEBUG_KEY,
3009: ' Before Calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES ');
3010: END IF;
3011:
3012: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES(
3013: P_API_VERSION => 1.0,

Line 3012: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES(

3008: L_DEBUG_KEY,
3009: ' Before Calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES ');
3010: END IF;
3011:
3012: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES(
3013: P_API_VERSION => 1.0,
3014: P_VISIT_ID => l_visit_id,
3015: P_VISIT_TASK_ID => l_tasks_rec.visit_task_id,
3016: P_STAGE_NAME => l_stage_name,

Line 3234: l_stage_id := AHL_VWP_VISITS_STAGES_PVT.Get_Stage_Id;

3230:
3231: -- Loop through all the stages associated to the passed visit type code
3232: FOR l_stages_rec IN get_visit_type_stages(p_visit_type_code, P_VISIT_ID)
3233: LOOP
3234: l_stage_id := AHL_VWP_VISITS_STAGES_PVT.Get_Stage_Id;
3235:
3236: l_prev_stage_id := null;
3237: -- Cursor to find previous stage id
3238: OPEN c_prev_stage_id (l_stages_rec.visit_type_stage_id);

Line 3363: 'Before Calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES ');

3359: FOR l_tasks_rec IN c_visit_tasks(P_VISIT_ID, l_stagetypes_rec.stage_type_code) LOOP
3360: IF (l_log_statement >= l_log_current_level) THEN
3361: fnd_log.string(l_log_statement,
3362: L_DEBUG_KEY,
3363: 'Before Calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES ');
3364: END IF;
3365: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES(
3366: P_API_VERSION => 1.0,
3367: P_VISIT_ID => P_VISIT_ID,

Line 3365: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES(

3361: fnd_log.string(l_log_statement,
3362: L_DEBUG_KEY,
3363: 'Before Calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES ');
3364: END IF;
3365: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES(
3366: P_API_VERSION => 1.0,
3367: P_VISIT_ID => P_VISIT_ID,
3368: P_VISIT_TASK_ID => l_tasks_rec.visit_task_id,
3369: P_STAGE_NAME => l_stages_rec.stage_name,

Line 3378: ' After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES and return status: '||l_return_status);

3374:
3375: IF (l_log_statement >= l_log_current_level) THEN
3376: fnd_log.string(l_log_statement,
3377: L_DEBUG_KEY,
3378: ' After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_UPDATES and return status: '||l_return_status);
3379: END IF;
3380:
3381: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
3382: x_msg_count := l_msg_count;

Line 3461: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_RULES - l_return_status : '||l_return_status);

3457: x_msg_data => l_msg_data
3458: );
3459:
3460: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3461: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_RULES - l_return_status : '||l_return_status);
3462: END IF;
3463:
3464: l_msg_count := Fnd_Msg_Pub.count_msg;
3465: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> FND_API.G_RET_STS_SUCCESS THEN

Line 3711: l_stages_ovn_tbl AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_OVN_Tbl_Type;

3707: l_msg_data VARCHAR2(2000);
3708: l_msg_count NUMBER;
3709: l_return_status VARCHAR2(1);
3710:
3711: l_stages_ovn_tbl AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_OVN_Tbl_Type;
3712:
3713: BEGIN
3714:
3715: SAVEPOINT UPDATE_STAGES_HIERARICHY;

Line 3751: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.PROCESS_STAGE_DATES - l_return_status : '||l_return_status);

3747:
3748: --------------------------End of API Body---------------------------------------
3749:
3750: IF (l_log_statement >= l_log_current_level) THEN
3751: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.PROCESS_STAGE_DATES - l_return_status : '||l_return_status);
3752: END IF;
3753:
3754: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
3755: x_msg_count := l_msg_count;

Line 3861: l_stages_ovn_tbl AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_OVN_Tbl_Type;

3857:
3858: l_visit_start_date DATE; -- temporary variable to keep visit start date
3859: l_prev_stage_planned_end_date DATE; -- temporary variable to keep max planned end date of previous stage
3860:
3861: l_stages_ovn_tbl AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_OVN_Tbl_Type;
3862:
3863: l_msg_data VARCHAR2(2000);
3864: l_msg_count NUMBER;
3865: l_return_status VARCHAR2(1);

Line 3995: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.PROCESS_STAGE_DATES - l_return_status : '||l_return_status);

3991:
3992:
3993: --------------------------End of API Body---------------------------------------
3994: IF (l_log_statement >= l_log_current_level) THEN
3995: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.PROCESS_STAGE_DATES - l_return_status : '||l_return_status);
3996: END IF;
3997:
3998: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
3999: x_msg_count := l_msg_count;

Line 4176: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.PROCESS_STAGE_DATES - l_return_status : '||l_return_status);

4172: x_msg_data => l_msg_data);
4173:
4174: IF (l_log_statement >= l_log_current_level) THEN
4175: fnd_log.string(l_log_statement,L_DEBUG,'Stage rule : subject id:'||l_Stage_link_dets.subject_id||' object id:'||l_Stage_link_dets.object_id);
4176: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.PROCESS_STAGE_DATES - l_return_status : '||l_return_status);
4177: END IF;
4178:
4179: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4180: x_msg_count := l_msg_count;

Line 4258: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_SUCC_STG_START_DATES - l_return_status : '||l_return_status);

4254: x_msg_count => l_msg_count,
4255: x_msg_data => l_msg_data);
4256:
4257: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4258: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_SUCC_STG_START_DATES - l_return_status : '||l_return_status);
4259: END IF;
4260:
4261: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4262: x_msg_count := l_msg_count;

Line 4382: l_stages_ovn_tbl AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_OVN_Tbl_Type;

4378: l_prev_stage_id NUMBER;
4379: l_update_stage_id NUMBER;
4380:
4381: l_is_stages_parallel BOOLEAN default false;
4382: l_stages_ovn_tbl AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_OVN_Tbl_Type;
4383:
4384: L_API_VERSION CONSTANT NUMBER := 1.0;
4385: L_API_NAME CONSTANT VARCHAR2(30) := 'UPDATE_STG_RUL_HIERARCHY';
4386: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;

Line 4512: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_RULES - l_return_status : '||l_return_status);

4508: x_msg_data => l_msg_data
4509: );
4510:
4511: IF (l_log_statement >= l_log_current_level) THEN
4512: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_RULES - l_return_status : '||l_return_status);
4513: END IF;
4514:
4515: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4516: x_msg_count := l_msg_count;

Line 4540: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.PROCESS_STAGE_DATES - l_return_status : '||l_return_status);

4536:
4537:
4538: --------------------------End of API Body---------------------------------------
4539: IF (l_log_statement >= l_log_current_level) THEN
4540: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.PROCESS_STAGE_DATES - l_return_status : '||l_return_status);
4541: END IF;
4542:
4543: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4544: x_msg_count := l_msg_count;

Line 4567: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_SUCC_STG_START_DATES - l_return_status : '||l_return_status);

4563: x_msg_count => l_msg_count,
4564: x_msg_data => l_msg_data);
4565:
4566: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4567: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_SUCC_STG_START_DATES - l_return_status : '||l_return_status);
4568: END IF;
4569:
4570: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4571: x_msg_count := l_msg_count;

Line 4819: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');

4815:
4816: -- PRAKKUM :: 06-APR-2011 :: Bug 13711800 :: START
4817:
4818: IF (l_log_statement >= l_log_current_level) THEN
4819: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');
4820: END IF;
4821:
4822: VALIDATE_STAGE_DATES( p_visit_id => p_visit_id,
4823: x_return_status => l_return_status,

Line 4828: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);

4824: x_msg_count => l_msg_count,
4825: x_msg_data => l_msg_data);
4826:
4827: IF (l_log_statement >= l_log_current_level) THEN
4828: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);
4829: END IF;
4830:
4831: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4832: x_msg_count := l_msg_count;

Line 4908: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.CALC_STAGE_START_DURATIONS - l_return_status : '||l_return_status);

4904: x_msg_count => l_msg_count,
4905: x_msg_data => l_msg_data);
4906:
4907: IF (l_log_statement >= l_log_current_level) THEN
4908: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.CALC_STAGE_START_DURATIONS - l_return_status : '||l_return_status);
4909: END IF;
4910:
4911: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4912: x_msg_count := l_msg_count;

Line 4949: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DATES - l_return_status : '||l_return_status);

4945: x_msg_count => l_msg_count,
4946: x_msg_data => l_msg_data);
4947:
4948: IF (l_log_statement >= l_log_current_level) THEN
4949: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DATES - l_return_status : '||l_return_status);
4950: END IF;
4951:
4952: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4953: x_msg_count := l_msg_count;

Line 4983: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.GET_VALID_STAGES_LIST - l_return_status : '||l_return_status);

4979: x_msg_count => l_msg_count,
4980: x_msg_data => l_msg_data);
4981:
4982: IF (l_log_statement >= l_log_current_level) THEN
4983: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.GET_VALID_STAGES_LIST - l_return_status : '||l_return_status);
4984: END IF;
4985:
4986: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4987: x_msg_count := l_msg_count;

Line 5012: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DATES - l_return_status : '||l_return_status);

5008: x_msg_count => l_msg_count,
5009: x_msg_data => l_msg_data);
5010:
5011: IF (l_log_statement >= l_log_current_level) THEN
5012: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DATES - l_return_status : '||l_return_status);
5013: fnd_log.string(l_log_statement,L_DEBUG,'After call to update stage dates');
5014: END IF;
5015:
5016: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 5041: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.GET_VALID_STAGES_LIST - l_return_status : '||l_return_status);

5037: x_msg_count => l_msg_count,
5038: x_msg_data => l_msg_data);
5039:
5040: IF (l_log_statement >= l_log_current_level) THEN
5041: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.GET_VALID_STAGES_LIST - l_return_status : '||l_return_status);
5042: END IF;
5043:
5044: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5045: x_msg_count := l_msg_count;

Line 5069: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DATES - l_return_status : '||l_return_status);

5065: x_return_status => l_return_status,
5066: x_msg_count => l_msg_count,
5067: x_msg_data => l_msg_data);
5068: IF (l_log_statement >= l_log_current_level) THEN
5069: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DATES - l_return_status : '||l_return_status);
5070: END IF;
5071:
5072: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5073: x_msg_count := l_msg_count;

Line 5099: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.GET_VALID_STAGES_LIST - l_return_status : '||l_return_status);

5095: x_return_status => l_return_status,
5096: x_msg_count => l_msg_count,
5097: x_msg_data => l_msg_data);
5098: IF (l_log_statement >= l_log_current_level) THEN
5099: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.GET_VALID_STAGES_LIST - l_return_status : '||l_return_status);
5100: END IF;
5101:
5102: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5103: x_msg_count := l_msg_count;

Line 5127: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DATES - l_return_status : '||l_return_status);

5123: x_return_status => l_return_status,
5124: x_msg_count => l_msg_count,
5125: x_msg_data => l_msg_data);
5126: IF (l_log_statement >= l_log_current_level) THEN
5127: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGE_DATES - l_return_status : '||l_return_status);
5128: END IF;
5129:
5130: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5131: x_msg_count := l_msg_count;

Line 5161: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');

5157:
5158: -- PRAKKUM :: 13-FEB-2011 :: Bug 13711800 :: START
5159:
5160: IF (l_log_statement >= l_log_current_level) THEN
5161: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');
5162: END IF;
5163:
5164: VALIDATE_STAGE_DATES( p_visit_id => p_visit_id,
5165: x_return_status => l_return_status,

Line 5170: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);

5166: x_msg_count => l_msg_count,
5167: x_msg_data => l_msg_data);
5168:
5169: IF (l_log_statement >= l_log_current_level) THEN
5170: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);
5171: END IF;
5172:
5173: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5174: x_msg_count := l_msg_count;

Line 5338: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.CALC_STAGE_START_DURATIONS - l_return_status : '||l_return_status);

5334: x_msg_count => l_msg_count,
5335: x_msg_data => l_msg_data);
5336:
5337: IF (l_log_statement >= l_log_current_level) THEN
5338: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.CALC_STAGE_START_DURATIONS - l_return_status : '||l_return_status);
5339: END IF;
5340:
5341: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5342: x_msg_count := l_msg_count;

Line 5492: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.GET_VALID_STAGES_LIST - l_return_status : '||l_return_status);

5488: fnd_log.string(l_log_statement,L_DEBUG,'After Recursive call to GET_VALID_STAGES_LIST');
5489: END IF;
5490:
5491: IF (l_log_statement >= l_log_current_level) THEN
5492: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.GET_VALID_STAGES_LIST - l_return_status : '||l_return_status);
5493: END IF;
5494:
5495: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5496: x_msg_count := l_msg_count;

Line 5646: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGES_OVN_COUNT - l_return_status : '||l_return_status);

5642: x_msg_count => l_msg_count,
5643: x_msg_data => l_msg_data);
5644:
5645: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5646: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGES_OVN_COUNT - l_return_status : '||l_return_status);
5647: END IF;
5648:
5649: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5650: x_msg_count := l_msg_count;

Line 5910: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGES_OVN_COUNT - l_return_status : '||l_return_status);

5906: x_msg_count => l_msg_count,
5907: x_msg_data => l_msg_data);
5908:
5909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5910: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGES_OVN_COUNT - l_return_status : '||l_return_status);
5911: END IF;
5912:
5913: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5914: x_msg_count := l_msg_count;

Line 5971: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');

5967:
5968: -- PRAKKUM :: 13-FEB-2011 :: Bug 13711800 :: START
5969:
5970: IF (l_log_statement >= l_log_current_level) THEN
5971: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');
5972: END IF;
5973:
5974: VALIDATE_STAGE_DATES( p_visit_id => p_visit_id,
5975: x_return_status => l_return_status,

Line 5980: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);

5976: x_msg_count => l_msg_count,
5977: x_msg_data => l_msg_data);
5978:
5979: IF (l_log_statement >= l_log_current_level) THEN
5980: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);
5981: END IF;
5982:
5983: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
5984: x_msg_count := l_msg_count;

Line 6378: END AHL_VWP_VISITS_STAGES_PVT;

6374:
6375: END Compute_Stage_End_Date;
6376: -- PRAKKUM :: 13-FEB-2011 :: Bug 13711800 :: END
6377:
6378: END AHL_VWP_VISITS_STAGES_PVT;