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_RULES_PVT dependencies on STANDARD

Line 3813: -- Standard variables

3809: p_instance_id IN NUMBER,
3810: p_service_req_id IN NUMBER := NULL,
3811: x_warranty_entl_tbl OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type
3812: ) IS
3813: -- Standard variables
3814: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Warranty_Rec_for_Create';
3815: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3816: -- Local variables defined for the procedure
3817: l_mr_template NUMBER;

Line 4012: -- Standard variables

4008: PROCEDURE Get_Warranty_Rec_for_Update(
4009: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
4010: x_warranty_entl_tbl OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type
4011: ) IS
4012: -- Standard variables
4013: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Warranty_Rec_for_Update';
4014: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
4015: -- Local variables defined for the procedure
4016: l_contract_id NUMBER := null;

Line 4356: -- Standard call to check for call compatibility.

4352:
4353: -- Initialize API return status to success
4354: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4355:
4356: -- Standard call to check for call compatibility.
4357: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
4358: p_api_version,
4359: l_api_name,G_PKG_NAME)
4360: THEN

Line 4639: -- Standard call to check for call compatibility.

4635:
4636: -- Initialize API return status to success
4637: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4638:
4639: -- Standard call to check for call compatibility.
4640: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
4641: p_api_version,
4642: l_api_name,G_PKG_NAME)
4643: THEN

Line 4703: -- MANESING::Component Maintenance Planning Project, 07-Aug-2011, added standard check for commit

4699: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4700: END IF;
4701: END LOOP;
4702:
4703: -- MANESING::Component Maintenance Planning Project, 07-Aug-2011, added standard check for commit
4704: -- Standard check of p_commit
4705: IF FND_API.to_boolean(p_commit) THEN
4706: COMMIT WORK;
4707: END IF;

Line 4704: -- Standard check of p_commit

4700: END IF;
4701: END LOOP;
4702:
4703: -- MANESING::Component Maintenance Planning Project, 07-Aug-2011, added standard check for commit
4704: -- Standard check of p_commit
4705: IF FND_API.to_boolean(p_commit) THEN
4706: COMMIT WORK;
4707: END IF;
4708:

Line 4840: -- Standard Start of API savepoint

4836: l_first_task_flag VARCHAR2(1) := 'Y';
4837:
4838: BEGIN
4839:
4840: -- Standard Start of API savepoint
4841: SAVEPOINT add_rts_sp;
4842:
4843: IF (l_log_procedure >= l_log_current_level) THEN
4844: FND_LOG.string(FND_LOG.level_procedure, L_DEBUG || '.begin','At the start of PLSQL procedure');

Line 4855: -- Standard call to check for call compatibility.

4851:
4852: -- Initialize API return status to success
4853: x_return_status := FND_API.G_RET_STS_SUCCESS;
4854:
4855: -- Standard call to check for call compatibility.
4856: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4858: END IF;
4859:

Line 5022: --Standard check for commit

5018: -- Kasridha: Changes for Component Maintenance Planning Project Ends
5019:
5020: END LOOP;
5021:
5022: --Standard check for commit
5023: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5024: COMMIT;
5025: END IF;
5026:

Line 5109: -- Standard Start of API savepoint

5105: l_task_rec get_task_prelim_details%ROWTYPE;
5106:
5107: BEGIN
5108:
5109: -- Standard Start of API savepoint
5110: SAVEPOINT remove_rts_sp;
5111:
5112: IF (l_log_procedure >= l_log_current_level) THEN
5113: FND_LOG.string(FND_LOG.level_procedure, L_DEBUG || '.begin','At the start of PLSQL procedure');

Line 5124: -- Standard call to check for call compatibility.

5120:
5121: -- Initialize API return status to success
5122: x_return_status := FND_API.G_RET_STS_SUCCESS;
5123:
5124: -- Standard call to check for call compatibility.
5125: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5127: END IF;
5128:

Line 5189: --Standard check for commit

5185: END IF;
5186: END IF;
5187:
5188: END LOOP;
5189: --Standard check for commit
5190: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5191: COMMIT;
5192: END IF;
5193:

Line 5301: -- Standard call to check for call compatibility.

5297:
5298: -- Initialize API return status to success
5299: x_return_status := FND_API.G_RET_STS_SUCCESS;
5300:
5301: -- Standard call to check for call compatibility.
5302: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5304: END IF;
5305:

Line 5522: -- Standard start of API savepoint

5518: WHERE TSK.VISIT_TASK_ID = c_task_id
5519: AND TSK.STATUS_CODE <> 'DELETED';
5520:
5521: BEGIN
5522: -- Standard start of API savepoint
5523: SAVEPOINT Flag_Duplicate_Task;
5524: IF (l_log_procedure >= l_log_current_level) THEN
5525: FND_LOG.string(l_log_procedure, L_DEBUG_KEY || '.begin', 'At the start of the PLSQL procedure Flag_Duplicate_Task. p_task_rec.COUNT ->' || p_task_rec_tbl.COUNT);
5526: END IF;

Line 5533: -- Standard call to check for call compatibility.

5529: FND_MSG_PUB.Initialize;
5530: END IF;
5531: -- Initialize API return status to success
5532: x_return_status := FND_API.G_RET_STS_SUCCESS;
5533: -- Standard call to check for call compatibility.
5534: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
5535: IF (l_log_statement >= l_log_current_level) THEN
5536: fnd_log.string(l_log_statement,L_DEBUG_KEY||'UNEXPECTED ERROR', 'l_api_version :' || l_api_version || 'p_api_version :' || p_api_version );
5537: END IF;

Line 5629: -- Standard check of p_commit.

5625: WHERE VISIT_TASK_ID = p_task_rec_tbl(i).Visit_Task_Id;
5626: END IF;
5627: END LOOP;
5628: ---------------------------End of Body-------------------------------------
5629: -- Standard check of p_commit.
5630: IF Fnd_Api.To_Boolean ( p_commit ) THEN
5631: COMMIT WORK;
5632: END IF;
5633: IF (l_log_procedure >= l_log_current_level)THEN

Line 5718: -- Standard start of API savepoint

5714: update_task_rec update_visit_task_csr%ROWTYPE;
5715:
5716:
5717: BEGIN
5718: -- Standard start of API savepoint
5719: SAVEPOINT Remove_Duplicate_Task_Flag;
5720: IF (l_log_procedure >= l_log_current_level) THEN
5721: FND_LOG.string(l_log_procedure, L_DEBUG_KEY || '.begin', 'At the start of the PLSQL procedure Remove_Duplicate_Task_Flag. p_task_rec.COUNT ->' || p_task_rec_tbl.COUNT);
5722: END IF;

Line 5729: -- Standard call to check for call compatibility.

5725: FND_MSG_PUB.Initialize;
5726: END IF;
5727: -- Initialize API return status to success
5728: x_return_status := FND_API.G_RET_STS_SUCCESS;
5729: -- Standard call to check for call compatibility.
5730: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
5731: IF (l_log_statement >= l_log_current_level) THEN
5732: fnd_log.string(l_log_statement,L_DEBUG_KEY||'UNEXPECTED ERROR', 'l_api_version :' || l_api_version || 'p_api_version :' || p_api_version );
5733: END IF;

Line 5799: -- Standard check of p_commit.

5795: END IF;
5796: END LOOP;
5797: ---------------------------End of Body-------------------------------------
5798:
5799: -- Standard check of p_commit.
5800: IF Fnd_Api.To_Boolean ( p_commit ) THEN
5801: COMMIT WORK;
5802: END IF;
5803: IF (l_log_procedure >= l_log_current_level)THEN

Line 5834: -- Standard IN Parameters :

5830: -- Type : Private
5831: -- Function : Procedure to cancel planning tasks corresponding to a given UE
5832: -- Parameters :
5833: --
5834: -- Standard IN Parameters :
5835: -- p_api_version IN NUMBER Required
5836: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
5837: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
5838: --

Line 5839: -- Standard OUT Parameters :

5835: -- p_api_version IN NUMBER Required
5836: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
5837: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
5838: --
5839: -- Standard OUT Parameters :
5840: -- x_return_status OUT VARCHAR2 Required
5841: -- x_msg_count OUT NUMBER Required
5842: -- x_msg_data OUT VARCHAR2 Required
5843: --

Line 5859: -- Standard in/out parameters

5855: x_msg_data OUT NOCOPY VARCHAR2)IS
5856:
5857: -- Local Variables
5858:
5859: -- Standard in/out parameters
5860: l_api_name CONSTANT VARCHAR2(30) := 'Cancel_Planning_tasks';
5861: l_api_version CONSTANT NUMBER := 1.0;
5862: l_debug CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
5863: l_msg_count NUMBER;

Line 5901: -- Standard start of API savepoint

5897: 'At the start of PLSQL procedure, ue ID : ' || p_ue_id
5898: );
5899: END IF;
5900:
5901: -- Standard start of API savepoint
5902: SAVEPOINT Cancel_Planning_tasks_pvt;
5903:
5904: -- Initialize message list if p_init_msg_list is set to TRUE
5905:

Line 5913: -- Standard call to check for call compatibility.

5909:
5910: -- Initialize API return status to success
5911: x_return_status := FND_API.G_RET_STS_SUCCESS;
5912:
5913: -- Standard call to check for call compatibility.
5914: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
5915: p_api_version,
5916: l_api_name,G_PKG_NAME)
5917: THEN

Line 5996: -- Standard check of p_commit.

5992:
5993:
5994: ---------------------------End of Body-------------------------------------
5995: -- END of API body.
5996: -- Standard check of p_commit.
5997:
5998: IF Fnd_Api.To_Boolean (p_commit) THEN
5999: COMMIT WORK;
6000: END IF;