DBA Data[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VWP_RULES_PVT

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

577: -- RROY
578: IF (l_log_statement >= l_log_current_level) THEN
579: fnd_log.string(l_log_statement,
580: L_DEBUG_KEY,
581: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility.');
582: END IF;
583:
584: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
585: (x_check_project => l_chk_project,

Line 584: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

580: L_DEBUG_KEY,
581: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility.');
582: END IF;
583:
584: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
585: (x_check_project => l_chk_project,
586: x_return_status => l_return_status);
587:
588: IF (l_log_statement >= l_log_current_level) THEN

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

587:
588: IF (l_log_statement >= l_log_current_level) THEN
589: fnd_log.string(l_log_statement,
590: L_DEBUG_KEY,
591: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' ||
592: l_return_status);
593: END IF;
594:
595: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

595: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
596: IF (l_log_statement >= l_log_current_level) THEN
597: fnd_log.string(l_log_statement,
598: L_DEBUG_KEY,
599: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility.');
600: END IF;
601: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
602: RAISE FND_API.G_EXC_ERROR;
603: ELSE

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

885: -- RROY
886: IF (l_log_statement >= l_log_current_level) THEN
887: fnd_log.string(l_log_statement,
888: L_DEBUG_KEY,
889: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
890: END IF;
891: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
892: ( x_check_project => l_chk_project,
893: x_return_status => l_return_status);

Line 891: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

887: fnd_log.string(l_log_statement,
888: L_DEBUG_KEY,
889: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
890: END IF;
891: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
892: ( x_check_project => l_chk_project,
893: x_return_status => l_return_status);
894:
895: IF (l_log_statement >= l_log_current_level) THEN

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

894:
895: IF (l_log_statement >= l_log_current_level) THEN
896: fnd_log.string(l_log_statement,
897: L_DEBUG_KEY,
898: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);
899: END IF;
900:
901: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
902: IF (l_log_statement >= l_log_current_level) THEN

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

901: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
902: IF (l_log_statement >= l_log_current_level) THEN
903: fnd_log.string(l_log_statement,
904: L_DEBUG_KEY,
905: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
906: END IF;
907: x_return_status := l_return_status;
908: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
909: RAISE FND_API.G_EXC_ERROR;

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

1293:
1294: IF (l_log_statement >= l_log_current_level) THEN
1295: fnd_log.string(l_log_statement,
1296: L_DEBUG_KEY,
1297: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1298: END IF;
1299:
1300: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
1301: (x_check_project => l_chk_project,

Line 1300: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

1296: L_DEBUG_KEY,
1297: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1298: END IF;
1299:
1300: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
1301: (x_check_project => l_chk_project,
1302: x_return_status => l_return_status);
1303:
1304: IF (l_log_statement >= l_log_current_level) THEN

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

1303:
1304: IF (l_log_statement >= l_log_current_level) THEN
1305: fnd_log.string(l_log_statement,
1306: L_DEBUG_KEY,
1307: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);
1308: END IF;
1309:
1310: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1311: IF (l_log_statement >= l_log_current_level) THEN

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

1310: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1311: IF (l_log_statement >= l_log_current_level) THEN
1312: fnd_log.string(l_log_statement,
1313: L_DEBUG_KEY,
1314: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1315: END IF;
1316: x_return_status := l_return_status;
1317: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1318: RAISE FND_API.G_EXC_ERROR;

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

1696: -- RROY
1697: IF (l_log_statement >= l_log_current_level) THEN
1698: fnd_log.string(l_log_statement,
1699: L_DEBUG_KEY,
1700: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1701: END IF;
1702: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
1703: ( x_check_project => l_chk_project,
1704: x_return_status => l_return_status);

Line 1702: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

1698: fnd_log.string(l_log_statement,
1699: L_DEBUG_KEY,
1700: 'Before calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1701: END IF;
1702: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
1703: ( x_check_project => l_chk_project,
1704: x_return_status => l_return_status);
1705:
1706: IF (l_log_statement >= l_log_current_level) THEN

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

1705:
1706: IF (l_log_statement >= l_log_current_level) THEN
1707: fnd_log.string(l_log_statement,
1708: L_DEBUG_KEY,
1709: 'After calling AHL_VWP_RULES_PVT.Check_Proj_Responsibility. Return Status = ' || l_return_status);
1710: END IF;
1711:
1712: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1713: IF (l_log_statement >= l_log_current_level) THEN

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

1712: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1713: IF (l_log_statement >= l_log_current_level) THEN
1714: fnd_log.string(l_log_statement,
1715: L_DEBUG_KEY,
1716: 'Errors from AHL_VWP_RULES_PVT.Check_Proj_Responsibility');
1717: END IF;
1718: x_return_status := l_return_status;
1719: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1720: RAISE FND_API.G_EXC_ERROR;

Line 2075: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

2071:
2072: -- To check Project responsibilites
2073: -- Post 11.5.10
2074: -- RROY
2075: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
2076: (x_check_project => l_chk_project,
2077: x_return_status => l_return_status);
2078:
2079: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

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

2783: IF c_visit_rec.visit_type_code IS NOT NULL THEN
2784: IF (l_log_statement >= l_log_current_level) THEN
2785: fnd_log.string(l_log_statement,
2786: L_DEBUG_KEY,
2787: 'Before calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');
2788: END IF;
2789:
2790: AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID (
2791: p_lookup_type => 'AHL_PLANNING_VISIT_TYPE',

Line 2790: AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID (

2786: L_DEBUG_KEY,
2787: 'Before calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');
2788: END IF;
2789:
2790: AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID (
2791: p_lookup_type => 'AHL_PLANNING_VISIT_TYPE',
2792: p_lookup_code => trim(c_visit_rec.visit_type_code),
2793: p_meaning => NULL,
2794: p_check_id_flag => 'Y',

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

2797:
2798: IF (l_log_statement >= l_log_current_level) THEN
2799: fnd_log.string(l_log_statement,
2800: L_DEBUG_KEY,
2801: 'After calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');
2802: END IF;
2803:
2804: IF NVL(l_return_status, 'X') <> 'S' THEN
2805: Fnd_Message.SET_NAME('AHL','AHL_VWP_TYPE_CODE_NOT_EXISTS');

Line 2948: 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

2944: -- To check all task's serial number are still active
2945: IF c_visit_rec.Item_Instance_Id IS NOT NULL THEN
2946:
2947: --BEGIN: jeli added for bug 3777720
2948: 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
2949: --END: jeli added for bug 3777720
2950: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
2951: Fnd_Message.Set_Token('VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);
2952: Fnd_Msg_Pub.ADD;

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

2961: EXIT WHEN c_task%NOTFOUND;
2962: IF c_task_rec.INSTANCE_ID IS NOT NULL THEN
2963: -- IF l_check_flag = 'N' THEN
2964: --BEGIN: jeli added for bug 3777720
2965: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
2966: --END: jeli added for bug 3777720
2967: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
2968: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2969: Fnd_Msg_Pub.ADD;

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

4964: -- Earlier this code was in Release_Visit procedure
4965: -- was moved here as whenever the visit is pushed to production
4966: -- 'any_task_chg_flag' in Visit should always be 'N'
4967: -----------------------------------------------
4968: -- To call AHL_VWP_RULES_PVT.Update_Visit_Task_Flag to update any_task_chg_flag as 'N'
4969: IF (l_log_statement >= l_log_current_level) THEN
4970: fnd_log.string(l_log_statement,
4971: L_DEBUG_KEY,
4972: 'Before calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag.');

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

4968: -- To call AHL_VWP_RULES_PVT.Update_Visit_Task_Flag to update any_task_chg_flag as 'N'
4969: IF (l_log_statement >= l_log_current_level) THEN
4970: fnd_log.string(l_log_statement,
4971: L_DEBUG_KEY,
4972: 'Before calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag.');
4973: END IF;
4974:
4975: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
4976: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

Line 4976: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

4972: 'Before calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag.');
4973: END IF;
4974:
4975: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
4976: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
4977: (p_visit_id => p_visit_id,
4978: p_flag => 'N',
4979: x_return_status => x_return_status);
4980: END IF;

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

4981:
4982: IF (l_log_statement >= l_log_current_level) THEN
4983: fnd_log.string(l_log_statement,
4984: L_DEBUG_KEY,
4985: 'After calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag');
4986: END IF;
4987: -- End By Shbhanda 16th Feb 2004 -------------
4988:
4989: ---------------------------End of Body-------------------------------------

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

8097: object_version_number = object_version_number + 1
8098: WHERE visit_id = c_visit_rec.visit_id;
8099:
8100: IF (l_log_statement >= l_log_current_level) THEN
8101: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');
8102: END IF;
8103:
8104: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
8105: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

Line 8105: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

8101: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');
8102: END IF;
8103:
8104: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
8105: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
8106: (p_visit_id => c_visit_rec.visit_id,
8107: p_flag => 'N',
8108: x_return_status => x_return_status);
8109: END IF;

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

8108: x_return_status => x_return_status);
8109: END IF;
8110:
8111: IF (l_log_statement >= l_log_current_level) THEN
8112: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After AHL_VWP_RULES_PVT.Update_Visit_Task_Flag Call');
8113: END IF;
8114: END IF;
8115: ---------------------------End of Body-------------------------------------
8116: -- Standard check of p_commit.

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

8275:
8276: -- Begin changes by jaramana on Mar 4, 2008 for bug 6788115 (FP of 6759574)
8277: -- As per update from ravichandran.velusamy in Projects team in the bug 6759574,
8278: -- the call to PA_INTERFACE_UTILS_PUB.Set_Global_Info may be removed.
8279: -- AHL_VWP_RULES_PVT.Check_Proj_Responsibility calls PA_INTERFACE_UTILS_PUB.Set_Global_Info
8280: /***
8281: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
8282: (x_check_project => l_chk_project,
8283: x_return_status => l_return_status);

Line 8281: AHL_VWP_RULES_PVT.Check_Proj_Responsibility

8277: -- As per update from ravichandran.velusamy in Projects team in the bug 6759574,
8278: -- the call to PA_INTERFACE_UTILS_PUB.Set_Global_Info may be removed.
8279: -- AHL_VWP_RULES_PVT.Check_Proj_Responsibility calls PA_INTERFACE_UTILS_PUB.Set_Global_Info
8280: /***
8281: AHL_VWP_RULES_PVT.Check_Proj_Responsibility
8282: (x_check_project => l_chk_project,
8283: x_return_status => l_return_status);
8284:
8285: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 9495: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

9491: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before updating the task flag');
9492: END IF;
9493:
9494: IF c_visit_rec.any_task_chg_flag = 'Y' THEN
9495: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
9496: (p_visit_id => c_visit_rec.visit_id,
9497: p_flag => 'N',
9498: x_return_status => x_return_status);
9499: END IF;