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_PROJ_PROD_PVT dependencies on AHL_VWP_RULES_PVT

Line 1141: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility.');

1137: -- RROY
1138: IF (l_log_statement >= l_log_current_level) THEN
1139: fnd_log.string(l_log_statement,
1140: L_DEBUG_KEY,
1141: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility.');
1142: END IF;
1143:
1144: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
1145: (x_check_project => l_chk_project,

Line 1144: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

1140: L_DEBUG_KEY,
1141: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility.');
1142: END IF;
1143:
1144: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
1145: (x_check_project => l_chk_project,
1146: x_return_status => l_return_status);
1147:
1148: IF (l_log_statement >= l_log_current_level) THEN

Line 1151: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' ||

1147:
1148: IF (l_log_statement >= l_log_current_level) THEN
1149: fnd_log.string(l_log_statement,
1150: L_DEBUG_KEY,
1151: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' ||
1152: l_return_status);
1153: END IF;
1154:
1155: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1159: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility.');

1155: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1156: IF (l_log_statement >= l_log_current_level) THEN
1157: fnd_log.string(l_log_statement,
1158: L_DEBUG_KEY,
1159: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility.');
1160: END IF;
1161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1162: RAISE FND_API.G_EXC_ERROR;
1163: ELSE

Line 1468: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');

1464: -- RROY
1465: IF (l_log_statement >= l_log_current_level) THEN
1466: fnd_log.string(l_log_statement,
1467: L_DEBUG_KEY,
1468: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1469: END IF;
1470: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
1471: ( x_check_project => l_chk_project,
1472: x_return_status => l_return_status);

Line 1470: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

1466: fnd_log.string(l_log_statement,
1467: L_DEBUG_KEY,
1468: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1469: END IF;
1470: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
1471: ( x_check_project => l_chk_project,
1472: x_return_status => l_return_status);
1473:
1474: IF (l_log_statement >= l_log_current_level) THEN

Line 1477: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);

1473:
1474: IF (l_log_statement >= l_log_current_level) THEN
1475: fnd_log.string(l_log_statement,
1476: L_DEBUG_KEY,
1477: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);
1478: END IF;
1479:
1480: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1481: IF (l_log_statement >= l_log_current_level) THEN

Line 1484: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');

1480: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1481: IF (l_log_statement >= l_log_current_level) THEN
1482: fnd_log.string(l_log_statement,
1483: L_DEBUG_KEY,
1484: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1485: END IF;
1486: x_return_status := l_return_status;
1487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1488: RAISE FND_API.G_EXC_ERROR;

Line 2092: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');

2088:
2089: IF (l_log_statement >= l_log_current_level) THEN
2090: fnd_log.string(l_log_statement,
2091: L_DEBUG_KEY,
2092: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
2093: END IF;
2094:
2095: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
2096: (x_check_project => l_chk_project,

Line 2095: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

2091: L_DEBUG_KEY,
2092: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
2093: END IF;
2094:
2095: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
2096: (x_check_project => l_chk_project,
2097: x_return_status => l_return_status);
2098:
2099: IF (l_log_statement >= l_log_current_level) THEN

Line 2102: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);

2098:
2099: IF (l_log_statement >= l_log_current_level) THEN
2100: fnd_log.string(l_log_statement,
2101: L_DEBUG_KEY,
2102: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);
2103: END IF;
2104:
2105: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2106: IF (l_log_statement >= l_log_current_level) THEN

Line 2109: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');

2105: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2106: IF (l_log_statement >= l_log_current_level) THEN
2107: fnd_log.string(l_log_statement,
2108: L_DEBUG_KEY,
2109: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
2110: END IF;
2111: x_return_status := l_return_status;
2112: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2113: RAISE FND_API.G_EXC_ERROR;

Line 2690: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');

2686: -- RROY
2687: IF (l_log_statement >= l_log_current_level) THEN
2688: fnd_log.string(l_log_statement,
2689: L_DEBUG_KEY,
2690: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
2691: END IF;
2692: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
2693: ( x_check_project => l_chk_project,
2694: x_return_status => l_return_status);

Line 2692: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

2688: fnd_log.string(l_log_statement,
2689: L_DEBUG_KEY,
2690: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
2691: END IF;
2692: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
2693: ( x_check_project => l_chk_project,
2694: x_return_status => l_return_status);
2695:
2696: IF (l_log_statement >= l_log_current_level) THEN

Line 2699: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);

2695:
2696: IF (l_log_statement >= l_log_current_level) THEN
2697: fnd_log.string(l_log_statement,
2698: L_DEBUG_KEY,
2699: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);
2700: END IF;
2701:
2702: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
2703: IF (l_log_statement >= l_log_current_level) THEN

Line 2706: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');

2702: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
2703: IF (l_log_statement >= l_log_current_level) THEN
2704: fnd_log.string(l_log_statement,
2705: L_DEBUG_KEY,
2706: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
2707: END IF;
2708: x_return_status := l_return_status;
2709: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2710: RAISE FND_API.G_EXC_ERROR;

Line 3920: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

3916:
3917: -- To check Project responsibilites
3918: -- Post 11.5.10
3919: -- RROY
3920: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
3921: (x_check_project => l_chk_project,
3922: x_return_status => l_return_status);
3923:
3924: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 4472: l_val_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type; --SKPATHAK :: VWPE

4468: x NUMBER:=0;
4469: l_dept_flag VARCHAR2(1):= 'N';
4470: l_dept NUMBER;
4471: l_dummy_i NUMBER;
4472: l_val_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type; --SKPATHAK :: VWPE
4473: l_plan_date_flag VARCHAR2(1):= 'N'; -- SOSAHNI :: BUG 16061401 :: FP base bug :: 12929344 :: 10/01/2013 :: Flag to check if plan date is missing
4474:
4475: -- To find visit related information
4476: -- Added where condition for checking DELETED status in 11.5.10

Line 4883: 'Before calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');

4879: IF c_visit_rec.visit_type_code IS NOT NULL THEN
4880: IF (l_log_statement >= l_log_current_level) THEN
4881: fnd_log.string(l_log_statement,
4882: L_DEBUG_KEY,
4883: 'Before calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');
4884: END IF;
4885:
4886: AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID (
4887: p_lookup_type => 'AHL_PLANNING_VISIT_TYPE',

Line 4886: AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID (

4882: L_DEBUG_KEY,
4883: 'Before calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');
4884: END IF;
4885:
4886: AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID (
4887: p_lookup_type => 'AHL_PLANNING_VISIT_TYPE',
4888: p_lookup_code => trim(c_visit_rec.visit_type_code),
4889: p_meaning => NULL,
4890: p_check_id_flag => 'Y',

Line 4897: 'After calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');

4893:
4894: IF (l_log_statement >= l_log_current_level) THEN
4895: fnd_log.string(l_log_statement,
4896: L_DEBUG_KEY,
4897: 'After calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');
4898: END IF;
4899:
4900: IF NVL(l_return_status, 'X') <> 'S' THEN
4901: Fnd_Message.SET_NAME('AHL','AHL_VWP_TYPE_CODE_NOT_EXISTS');

Line 5041: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_visit_rec.item_instance_id)= FND_API.G_RET_STS_ERROR) THEN

5037: -- To check all task's serial number are still active
5038: IF c_visit_rec.Item_Instance_Id IS NOT NULL THEN
5039:
5040: --BEGIN: jeli added for bug 3777720
5041: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_visit_rec.item_instance_id)= FND_API.G_RET_STS_ERROR) THEN
5042: --END: jeli added for bug 3777720
5043: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
5044: Fnd_Message.Set_Token('VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);
5045: Fnd_Msg_Pub.ADD;

Line 5058: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN

5054: EXIT WHEN c_task%NOTFOUND;
5055: IF c_task_rec.INSTANCE_ID IS NOT NULL THEN
5056: -- IF l_check_flag = 'N' THEN
5057: --BEGIN: jeli added for bug 3777720
5058: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
5059: --END: jeli added for bug 3777720
5060: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
5061: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5062: Fnd_Msg_Pub.ADD;

Line 5359: 'Before Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. p_visit_id = ' || p_visit_id );

5355: -- SKPATHAK :: ER:12730539 :: 01-AUG-2011 :: START :: Validate Return to Supply Flags
5356: IF (l_log_statement >= l_log_current_level) THEN
5357: fnd_log.string(l_log_statement,
5358: L_DEBUG_KEY,
5359: 'Before Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. p_visit_id = ' || p_visit_id );
5360: END IF;
5361:
5362: IF (p_visit_id IS NOT NULL AND p_module_type NOT IN ('CST','TSK','MR')) THEN
5363:

Line 5364: AHL_VWP_RULES_PVT.Validate_Return_To_Supply

5360: END IF;
5361:
5362: IF (p_visit_id IS NOT NULL AND p_module_type NOT IN ('CST','TSK','MR')) THEN
5363:
5364: AHL_VWP_RULES_PVT.Validate_Return_To_Supply
5365: (
5366: p_api_version => 1.0,
5367: p_init_msg_list => FND_API.G_FALSE,
5368: p_commit => FND_API.G_FALSE,

Line 5381: 'After Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. Return Status = ' || l_return_status );

5377:
5378: IF (l_log_statement >= l_log_current_level) THEN
5379: fnd_log.string(l_log_statement,
5380: L_DEBUG_KEY,
5381: 'After Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. Return Status = ' || l_return_status );
5382: END IF;
5383:
5384: IF l_return_status <> 'S' THEN
5385: -- SOSAHNI :: BUG 16089769 :: FP base bug 14098719 :: 10/01/2013 :: Added a loop to include all error messages in error table for showing error message on UI - Start

Line 7566: -- To call AHL_VWP_RULES_PVT.Update_Visit_Task_Flag to update any_task_chg_flag as 'N'

7562: -- Earlier this code was in Release_Visit procedure
7563: -- was moved here as whenever the visit is pushed to production
7564: -- 'any_task_chg_flag' in Visit should always be 'N'
7565: -----------------------------------------------
7566: -- To call AHL_VWP_RULES_PVT.Update_Visit_Task_Flag to update any_task_chg_flag as 'N'
7567: IF (l_log_statement >= l_log_current_level) THEN
7568: fnd_log.string(l_log_statement,
7569: L_DEBUG_KEY,
7570: 'Before calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag.');

Line 7570: 'Before calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag.');

7566: -- To call AHL_VWP_RULES_PVT.Update_Visit_Task_Flag to update any_task_chg_flag as 'N'
7567: IF (l_log_statement >= l_log_current_level) THEN
7568: fnd_log.string(l_log_statement,
7569: L_DEBUG_KEY,
7570: 'Before calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag.');
7571: END IF;
7572:
7573: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
7574: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

Line 7574: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

7570: 'Before calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag.');
7571: END IF;
7572:
7573: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
7574: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
7575: (p_visit_id => p_visit_id,
7576: p_flag => 'N',
7577: x_return_status => x_return_status);
7578: END IF;

Line 7583: 'After calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag');

7579:
7580: IF (l_log_statement >= l_log_current_level) THEN
7581: fnd_log.string(l_log_statement,
7582: L_DEBUG_KEY,
7583: 'After calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag');
7584: END IF;
7585: -- End By Shbhanda 16th Feb 2004 -------------
7586:
7587: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011

Line 8193: l_val_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type;

8189: l_tasks_tbl Task_Tbl_Type;
8190: l_validate_visit NUMBER:= 0;
8191: l_temp_msg_count NUMBER:=0; --rnahata
8192: -- SKPATHAK :: ER:12730539 :: 01-AUG-2011
8193: l_val_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type;
8194:
8195: -- chk if the visit is valid
8196: CURSOR c_validate_visit (x_id IN NUMBER) IS
8197: SELECT 1 FROM AHL_VISITS_B

Line 8378: 'Before Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. l_tasks_tbl.count = ' || l_tasks_tbl.count );

8374:
8375: IF (l_log_statement >= l_log_current_level) THEN
8376: fnd_log.string(l_log_statement,
8377: L_DEBUG_KEY,
8378: 'Before Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. l_tasks_tbl.count = ' || l_tasks_tbl.count );
8379: END IF;
8380:
8381: IF (p_visit_id IS NOT NULL) THEN
8382: AHL_VWP_RULES_PVT.Validate_Return_To_Supply

Line 8382: AHL_VWP_RULES_PVT.Validate_Return_To_Supply

8378: 'Before Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. l_tasks_tbl.count = ' || l_tasks_tbl.count );
8379: END IF;
8380:
8381: IF (p_visit_id IS NOT NULL) THEN
8382: AHL_VWP_RULES_PVT.Validate_Return_To_Supply
8383: (
8384: p_api_version => 1.0,
8385: p_init_msg_list => FND_API.G_FALSE,
8386: p_commit => FND_API.G_FALSE,

Line 8399: 'After Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. Return Status = ' || l_return_status );

8395:
8396: IF (l_log_statement >= l_log_current_level) THEN
8397: fnd_log.string(l_log_statement,
8398: L_DEBUG_KEY,
8399: 'After Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. Return Status = ' || l_return_status );
8400: END IF;
8401:
8402: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
8403: x_msg_count := l_msg_count;

Line 11673: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');

11669: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
11670: WHERE visit_id = c_visit_rec.visit_id;
11671:
11672: IF (l_log_statement >= l_log_current_level) THEN
11673: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');
11674: END IF;
11675:
11676: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
11677: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

Line 11677: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

11673: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');
11674: END IF;
11675:
11676: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
11677: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
11678: (p_visit_id => c_visit_rec.visit_id,
11679: p_flag => 'N',
11680: x_return_status => x_return_status);
11681: END IF;

Line 11684: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');

11680: x_return_status => x_return_status);
11681: END IF;
11682:
11683: IF (l_log_statement >= l_log_current_level) THEN
11684: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');
11685: END IF;
11686: END IF;
11687:
11688: /* MANESING::Bug 13713141, 16-Apr-2012, For Component Visits, Repair Batch status should also

Line 11928: -- AHL_VWP_RULES_PVT.Check_Proj_Responsibility calls PA_INTERFACE_UTILS_PUB.Set_Global_Info

11924:
11925: -- Begin changes by jaramana on Mar 4, 2008 for bug 6788115 (FP of 6759574)
11926: -- As per update from ravichandran.velusamy in Projects team in the bug 6759574,
11927: -- the call to PA_INTERFACE_UTILS_PUB.Set_Global_Info may be removed.
11928: -- AHL_VWP_RULES_PVT.Check_Proj_Responsibility calls PA_INTERFACE_UTILS_PUB.Set_Global_Info
11929: /***
11930: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
11931: (x_check_project => l_chk_project,
11932: x_return_status => l_return_status);

Line 11930: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

11926: -- As per update from ravichandran.velusamy in Projects team in the bug 6759574,
11927: -- the call to PA_INTERFACE_UTILS_PUB.Set_Global_Info may be removed.
11928: -- AHL_VWP_RULES_PVT.Check_Proj_Responsibility calls PA_INTERFACE_UTILS_PUB.Set_Global_Info
11929: /***
11930: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
11931: (x_check_project => l_chk_project,
11932: x_return_status => l_return_status);
11933:
11934: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 13469: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

13465: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before updating the task flag');
13466: END IF;
13467:
13468: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
13469: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
13470: (p_visit_id => c_visit_rec.visit_id,
13471: p_flag => 'N',
13472: x_return_status => x_return_status);
13473: END IF;

Line 14676: l_val_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type; --added by skpathak for VWPE

14672: l_count_val NUMBER := 0;
14673: l_task_tbl_in Task_Tbl_Type;
14674: l_task_tbl_out Task_Tbl_Type;
14675: l_is_task_already_added VARCHAR2(1) := 'N';
14676: l_val_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type; --added by skpathak for VWPE
14677: l_planned_order_flag VARCHAR2(1); --added by skpathak for VWPE
14678: l_has_pre_in_planning VARCHAR2(1);
14679:
14680: -- PRAKKUM :: VWPE: ER:12673125 :: 23-JUN-2011 :: Upgrade Changes - To find visit is old or new

Line 14777: 'Before Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. l_task_tbl_in.count = ' || l_task_tbl_in.count );

14773:
14774: IF (l_log_statement >= l_log_current_level) THEN
14775: fnd_log.string(l_log_statement,
14776: L_DEBUG_KEY,
14777: 'Before Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. l_task_tbl_in.count = ' || l_task_tbl_in.count );
14778: END IF;
14779:
14780: IF (p_visit_id IS NOT NULL) THEN
14781: AHL_VWP_RULES_PVT.Validate_Return_To_Supply

Line 14781: AHL_VWP_RULES_PVT.Validate_Return_To_Supply

14777: 'Before Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. l_task_tbl_in.count = ' || l_task_tbl_in.count );
14778: END IF;
14779:
14780: IF (p_visit_id IS NOT NULL) THEN
14781: AHL_VWP_RULES_PVT.Validate_Return_To_Supply
14782: (
14783: p_api_version => 1.0,
14784: p_init_msg_list => FND_API.G_FALSE,
14785: p_commit => FND_API.G_FALSE,

Line 14798: 'After Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. Return Status = ' || l_return_status );

14794:
14795: IF (l_log_statement >= l_log_current_level) THEN
14796: fnd_log.string(l_log_statement,
14797: L_DEBUG_KEY,
14798: 'After Calling AHL_VWP_RULES_PVT.Validate_Return_To_Supply. Return Status = ' || l_return_status );
14799: END IF;
14800:
14801: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
14802: x_msg_count := l_msg_count;