APPS.AHL_FLEET_FORECAST_PVT dependencies on STANDARD

Line 75: --Standard local variables

71: SELECT fleet_unit_assoc_id
72: FROM ahl_fleet_unit_assocs
73: WHERE fleet_header_id = c_fleet_id;
74:
75: --Standard local variables
76: L_API_NAME CONSTANT VARCHAR2(30) := 'Remove_Fleet';
77: L_API_VERSION CONSTANT NUMBER := 1.0;
78: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
79: l_msg_data VARCHAR2(2000);

Line 96: -- Standard start of API savepoint

92: fnd_log.string ( l_log_procedure, 'ahl.plsql.Remove_Fleet', 'Start of procedure. Input params p_fleet_id ='|| p_fleet_id||' p_obj_version_no ='||p_obj_version_no);
93: END IF;
94: -- initialize return status.
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96: -- Standard start of API savepoint
97: SAVEPOINT Remove_Fleet;
98: -- Initialize message list if p_init_msg_list is set to TRUE
99: IF FND_API.To_Boolean(p_init_msg_list) THEN
100: FND_MSG_PUB.Initialize;

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

98: -- Initialize message list if p_init_msg_list is set to TRUE
99: IF FND_API.To_Boolean(p_init_msg_list) THEN
100: FND_MSG_PUB.Initialize;
101: END IF;
102: -- Standard call to check for call compatibility.
103: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END IF;
106: -- Check for Required Parameters

Line 346: -- Standard check of p_commit

342: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');
343: FND_MSG_PUB.ADD;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346: -- Standard check of p_commit
347: IF FND_API.TO_BOOLEAN(p_commit) THEN
348: COMMIT;
349: END IF;
350: -- Logging

Line 569: -- Standard Start of API savepoint

565:
566: -- Initialize API return status to success
567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: -- Standard Start of API savepoint
570: SAVEPOINT process_reconfig_mrs_sp;
571:
572: -- Standard call to check for call compatibility.
573: IF NOT FND_API.compatible_api_call

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

568:
569: -- Standard Start of API savepoint
570: SAVEPOINT process_reconfig_mrs_sp;
571:
572: -- Standard call to check for call compatibility.
573: IF NOT FND_API.compatible_api_call
574: (
575: l_api_version,
576: p_api_version,

Line 1416: -- Standard call to get message count.

1412: WHEN OTHERS THEN
1413:
1414: fnd_file.put_line(FND_FILE.LOG, '**************************Warning Messages**********************');
1415: fnd_file.put_line(FND_FILE.LOG, 'Message Count '||FND_MSG_PUB.Count_Msg);
1416: -- Standard call to get message count.
1417: l_msg_count := FND_MSG_PUB.Count_Msg;
1418:
1419: fnd_file.put_line(FND_FILE.LOG, 'Exception occured for Unit ::'||l_cur_item_instance_det.name);
1420: fnd_file.put_line(FND_FILE.LOG, 'Exception occured for Fleet ::'||l_fleet_unit_asso_rec.name);

Line 1444: -- Standard check of p_commit

1440: END LOOP; -- End for get_fleet_unit_asso
1441:
1442: END IF;
1443:
1444: -- Standard check of p_commit
1445: IF FND_API.TO_BOOLEAN(p_commit) THEN
1446: COMMIT WORK;
1447: END IF;
1448: