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.

[Home] [Help]

APPS.AHL_FLEET_FORECAST_PVT dependencies on FND_LOG

Line 8: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
5: ------------------------------------
6: -- Common constants and variables --
7: ------------------------------------
8: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
9: l_log_statement NUMBER := fnd_log.level_statement;
10: l_log_procedure NUMBER := fnd_log.level_procedure;
11: l_log_error NUMBER := fnd_log.level_error;
12: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 9: l_log_statement NUMBER := fnd_log.level_statement;

5: ------------------------------------
6: -- Common constants and variables --
7: ------------------------------------
8: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
9: l_log_statement NUMBER := fnd_log.level_statement;
10: l_log_procedure NUMBER := fnd_log.level_procedure;
11: l_log_error NUMBER := fnd_log.level_error;
12: l_log_unexpected NUMBER := fnd_log.level_unexpected;
13: -----------------------------------------------------------------

Line 10: l_log_procedure NUMBER := fnd_log.level_procedure;

6: -- Common constants and variables --
7: ------------------------------------
8: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
9: l_log_statement NUMBER := fnd_log.level_statement;
10: l_log_procedure NUMBER := fnd_log.level_procedure;
11: l_log_error NUMBER := fnd_log.level_error;
12: l_log_unexpected NUMBER := fnd_log.level_unexpected;
13: -----------------------------------------------------------------
14: ------------------ Locking Exception ----------------------------

Line 11: l_log_error NUMBER := fnd_log.level_error;

7: ------------------------------------
8: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
9: l_log_statement NUMBER := fnd_log.level_statement;
10: l_log_procedure NUMBER := fnd_log.level_procedure;
11: l_log_error NUMBER := fnd_log.level_error;
12: l_log_unexpected NUMBER := fnd_log.level_unexpected;
13: -----------------------------------------------------------------
14: ------------------ Locking Exception ----------------------------
15: record_locked EXCEPTION;

Line 12: l_log_unexpected NUMBER := fnd_log.level_unexpected;

8: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
9: l_log_statement NUMBER := fnd_log.level_statement;
10: l_log_procedure NUMBER := fnd_log.level_procedure;
11: l_log_error NUMBER := fnd_log.level_error;
12: l_log_unexpected NUMBER := fnd_log.level_unexpected;
13: -----------------------------------------------------------------
14: ------------------ Locking Exception ----------------------------
15: record_locked EXCEPTION;
16: pragma exception_init (record_locked, -54);

Line 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);

88: ---------------------------------------- Start of the procedure Remove_Fleet ----------------------------------------------------------------------
89: BEGIN
90: -- Logging
91: IF (l_log_procedure >= l_log_current_level) THEN
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

Line 111: fnd_log.string ( l_log_unexpected, 'ahl.plsql.', 'For this API flow, Fleet Id is mandatory but found null in input ' );

107: IF(p_fleet_id IS NULL) THEN
108: FND_MESSAGE.Set_Name('AHL','AHL_FLEET_NULL_FLT_ID');
109: FND_MSG_PUB.ADD;
110: IF (l_log_unexpected >= l_log_current_level) THEN
111: fnd_log.string ( l_log_unexpected, 'ahl.plsql.', 'For this API flow, Fleet Id is mandatory but found null in input ' );
112: END IF;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115: --Logging

Line 117: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_fleet_id sent from UI: '||p_fleet_id);

113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115: --Logging
116: IF (l_log_statement >= l_log_current_level) THEN
117: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_fleet_id sent from UI: '||p_fleet_id);
118: END IF;
119: -- Check for locks of the ue records
120: FOR i IN 1..2
121: LOOP

Line 137: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'All locks taken');

133: END;
134: END LOOP;
135: -- Logging
136: IF (l_log_statement >= l_log_current_level) THEN
137: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'All locks taken');
138: END IF;
139: -- All Locking complete
140: IF (l_locked_rows = 'N') THEN
141: -- Start processing

Line 154: fnd_log.string ( l_log_unexpected, 'ahl.plsql.', 'No matching fleet id in table' );

150: WHEN NO_DATA_FOUND THEN
151: FND_MESSAGE.Set_Name('AHL','AHL_FLEET_NULL_FLT_ID');
152: FND_MSG_PUB.ADD;
153: IF (l_log_unexpected >= l_log_current_level) THEN
154: fnd_log.string ( l_log_unexpected, 'ahl.plsql.', 'No matching fleet id in table' );
155: END IF;
156: RAISE FND_API.G_EXC_ERROR;
157: END;
158: IF (l_status = 'DELETED') THEN

Line 163: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'The fleet status is already DELETED' );

159: -- The record is already deleted
160: FND_MESSAGE.set_name('AHL','AHL_FLEET_RECORD_CHANGED');
161: FND_MSG_PUB.ADD;
162: IF (l_log_unexpected >= l_log_current_level) THEN
163: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'The fleet status is already DELETED' );
164: END IF;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167: -- Start processing

Line 174: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Fleet to be hard deleted');

170: FETCH applicable_draft_fleets INTO l_temp;
171: IF (applicable_draft_fleets%FOUND) THEN
172: -- Logging
173: IF (l_log_statement >= l_log_current_level) THEN
174: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Fleet to be hard deleted');
175: END IF;
176: -- MR association not there for the fleet. Can be hard deleted
177: DELETE
178: FROM AHL_FLEET_HEADERS_B

Line 218: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete in if');

214: DELETE
215: FROM AHL_FLEET_RECONFIG_MRS
216: WHERE fleet_header_id = p_fleet_id;
217: IF (l_log_statement >= l_log_current_level) THEN
218: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete in if');
219: END IF;
220: ELSE
221: -- Check if there exists association with complete MRs
222: IF (l_log_statement >= l_log_current_level) THEN

Line 223: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Opening applicable_fleets_complete_mr');

219: END IF;
220: ELSE
221: -- Check if there exists association with complete MRs
222: IF (l_log_statement >= l_log_current_level) THEN
223: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Opening applicable_fleets_complete_mr');
224: END IF;
225: OPEN applicable_fleets_complete_mr(p_fleet_id);
226: FETCH applicable_fleets_complete_mr
227: INTO l_temp;

Line 234: fnd_log.string ( l_log_statement, 'ahl.plsql.', 'Fleet is associated to completed MR and hence can not be deleted ' );

230: -- Fleet can not be deleted. Throw error
231: FND_MESSAGE.Set_Name('AHL','AHL_FLEET_COMPL_MR_ASSOC');
232: FND_MSG_PUB.ADD;
233: IF (l_log_statement >= l_log_current_level) THEN
234: fnd_log.string ( l_log_statement, 'ahl.plsql.', 'Fleet is associated to completed MR and hence can not be deleted ' );
235: END IF;
236: RAISE FND_API.G_EXC_ERROR;
237: ELSE
238: -- Fleet needs to be soft deleted

Line 240: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Fleet to be soft deleted');

236: RAISE FND_API.G_EXC_ERROR;
237: ELSE
238: -- Fleet needs to be soft deleted
239: IF (l_log_statement >= l_log_current_level) THEN
240: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Fleet to be soft deleted');
241: END IF;
242:
243: -- Pekambar Added to Close SR if Fleet is DELETED
244: -- Call the process_reconfig_mrs to Close the SRS which are already created

Line 289: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'The record has been already updated' );

285: IF ( SQL%ROWCOUNT = 0 ) THEN
286: FND_MESSAGE.set_name('AHL','AHL_FLEET_RECORD_CHANGED');
287: FND_MSG_PUB.add;
288: IF (l_log_unexpected >= l_log_current_level) THEN
289: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'The record has been already updated' );
290: END IF;
291: RAISE FND_API.G_EXC_ERROR;
292: END IF;
293: -- Delete UEs generated for the fleet

Line 329: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete in else');

325: DELETE
326: FROM AHL_FLEET_RECONFIG_MRS
327: WHERE fleet_header_id = p_fleet_id;*/
328: IF (l_log_statement >= l_log_current_level) THEN
329: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete in else');
330: END IF;
331:
332: IF (l_log_statement >= l_log_current_level) THEN
333: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete');

Line 333: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete');

329: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete in else');
330: END IF;
331:
332: IF (l_log_statement >= l_log_current_level) THEN
333: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete');
334: END IF;
335: END IF;
336: CLOSE applicable_fleets_complete_mr;
337:

Line 352: fnd_log.string ( l_log_procedure,L_DEBUG_KEY ||'.end','At the end of PLSQL procedure Remove_Fleet');

348: COMMIT;
349: END IF;
350: -- Logging
351: IF (l_log_procedure >= l_log_current_level) THEN
352: fnd_log.string ( l_log_procedure,L_DEBUG_KEY ||'.end','At the end of PLSQL procedure Remove_Fleet');
353: END IF;
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
356: IF (l_log_unexpected >= l_log_current_level) THEN

Line 357: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'G_EXC_ERROR');

353: END IF;
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
356: IF (l_log_unexpected >= l_log_current_level) THEN
357: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'G_EXC_ERROR');
358: END IF;
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: ROLLBACK TO Remove_Fleet;
361: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 364: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'G_EXC_UNEXPECTED_ERROR');

360: ROLLBACK TO Remove_Fleet;
361: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: IF (l_log_unexpected >= l_log_current_level) THEN
364: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'G_EXC_UNEXPECTED_ERROR');
365: END IF;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: ROLLBACK TO Remove_Fleet;
368: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 371: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'OTHERS');

367: ROLLBACK TO Remove_Fleet;
368: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
369: WHEN OTHERS THEN
370: IF (l_log_unexpected >= l_log_current_level) THEN
371: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Fleet', 'OTHERS');
372: END IF;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: ROLLBACK TO Remove_Fleet;
375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN