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_FLEET_FORECAST_PVT dependencies on FND_MSG_PUB

Line 100: FND_MSG_PUB.Initialize;

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

Line 109: FND_MSG_PUB.ADD;

105: END IF;
106: -- Check for Required Parameters
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;

Line 152: FND_MSG_PUB.ADD;

148: WHERE fleet_header_id = p_fleet_id;
149: EXCEPTION
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;

Line 161: FND_MSG_PUB.ADD;

157: END;
158: IF (l_status = 'DELETED') THEN
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;

Line 232: FND_MSG_PUB.ADD;

228:
229: IF (applicable_fleets_complete_mr%FOUND) THEN
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;

Line 287: FND_MSG_PUB.add;

283: AND object_version_number = p_obj_version_no;
284: -- rowcount will be 0 when ovn does not match
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;

Line 343: FND_MSG_PUB.ADD;

339: CLOSE applicable_draft_fleets;
340: ELSE
341: ROLLBACK TO Remove_Fleet;
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

Line 361: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

Line 368: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

Line 375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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
376: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Remove_Fleet', p_error_text => SUBSTR(SQLERRM,1,500));
377: END IF;
378: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
379: END Remove_Fleet;

Line 376: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Remove_Fleet', p_error_text => SUBSTR(SQLERRM,1,500));

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
376: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Remove_Fleet', p_error_text => SUBSTR(SQLERRM,1,500));
377: END IF;
378: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
379: END Remove_Fleet;
380:

Line 378: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

374: ROLLBACK TO Remove_Fleet;
375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
376: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Remove_Fleet', p_error_text => SUBSTR(SQLERRM,1,500));
377: END IF;
378: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
379: END Remove_Fleet;
380:
381:
382: /*-----------------------------------------------------

Line 586: FND_MSG_PUB.initialize;

582: END IF;
583:
584: -- Initialize message list if p_init_msg_list is set to TRUE.
585: IF FND_API.to_boolean( p_init_msg_list ) THEN
586: FND_MSG_PUB.initialize;
587: END IF;
588:
589: IF G_DEBUG = 'Y' THEN
590: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Input Parameters::' );

Line 618: FND_MSG_PUB.ADD;

614: THEN
615: CLOSE get_sr_details;
616: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');
617: FND_MESSAGE.set_token('INC_ID', l_cur_sr_details.incident_id);
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;
621: CLOSE get_sr_details;
622:

Line 968: FND_MSG_PUB.ADD;

964: IF (get_sr_details%NOTFOUND) THEN
965: CLOSE get_sr_details;
966: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');
967: FND_MESSAGE.set_token('INC_ID', l_nr_task_rec.incident_id);
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971: CLOSE get_sr_details;
972:

Line 1035: FND_MSG_PUB.ADD;

1031: IF (SQL%NOTFOUND)
1032: THEN
1033: FND_MESSAGE.set_name('AHL', 'AHL_FLT_UNIT_ASS_MOD');
1034: FND_MESSAGE.set_token('ASS_ID', l_fleet_unit_asso_rec.fleet_unit_assoc_id);
1035: FND_MSG_PUB.ADD;
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: END IF;
1038:
1039: IF G_DEBUG = 'Y' THEN

Line 1062: FND_MSG_PUB.ADD;

1058: IF (get_sr_details%NOTFOUND) THEN
1059: CLOSE get_sr_details;
1060: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');
1061: FND_MESSAGE.set_token('INC_ID', l_nr_task_rec.incident_id);
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: END IF;
1065: CLOSE get_sr_details;
1066:

Line 1400: FND_MSG_PUB.ADD;

1396: IF (SQL%NOTFOUND)
1397: THEN
1398: FND_MESSAGE.set_name('AHL', 'AHL_FLT_UNIT_ASS_MOD');
1399: FND_MESSAGE.set_token('ASS_ID', l_fleet_unit_asso_rec.fleet_unit_assoc_id);
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1402: END IF;
1403:
1404: fnd_file.put_line(FND_FILE.LOG, 'SR Closed for Unit ::'||l_cur_item_instance_det.name);

Line 1415: fnd_file.put_line(FND_FILE.LOG, 'Message Count '||FND_MSG_PUB.Count_Msg);

1411: EXCEPTION
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);

Line 1417: l_msg_count := FND_MSG_PUB.Count_Msg;

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);
1421:

Line 1423: FND_MSG_PUB.get (

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);
1421:
1422: FOR i IN 1..l_msg_count LOOP
1423: FND_MSG_PUB.get (
1424: p_msg_index => i,
1425: p_encoded => FND_API.G_FALSE,
1426: p_data => l_msg_data,
1427: p_msg_index_out => j );

Line 1454: FND_MSG_PUB.count_and_get

1450: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');
1451: END IF;
1452:
1453: -- Count and Get messages
1454: FND_MSG_PUB.count_and_get
1455: ( p_encoded => fnd_api.g_false,
1456: p_count => x_msg_count,
1457: p_data => x_msg_data
1458: );

Line 1469: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1465: EXCEPTION
1466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1467: ROLLBACK TO process_reconfig_mrs_sp;
1468: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1470: p_count => x_msg_count,
1471: p_data => x_msg_data);
1472:
1473: WHEN FND_API.G_EXC_ERROR THEN

Line 1476: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1472:
1473: WHEN FND_API.G_EXC_ERROR THEN
1474: ROLLBACK TO process_reconfig_mrs_sp;
1475: X_return_status := FND_API.G_RET_STS_ERROR;
1476: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1477: p_count => x_msg_count,
1478: p_data => X_msg_data);
1479: WHEN OTHERS THEN
1480: ROLLBACK TO process_reconfig_mrs_sp;

Line 1483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1479: WHEN OTHERS THEN
1480: ROLLBACK TO process_reconfig_mrs_sp;
1481: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482:
1483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1484: THEN
1485: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FLEET_FORECAST_PVT',
1486: p_procedure_name => 'PROCESS_RECONFIG_MRS',
1487: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1485: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FLEET_FORECAST_PVT',

1481: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482:
1483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1484: THEN
1485: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FLEET_FORECAST_PVT',
1486: p_procedure_name => 'PROCESS_RECONFIG_MRS',
1487: p_error_text => SUBSTR(SQLERRM,1,240));
1488: END IF;
1489: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 1489: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1485: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FLEET_FORECAST_PVT',
1486: p_procedure_name => 'PROCESS_RECONFIG_MRS',
1487: p_error_text => SUBSTR(SQLERRM,1,240));
1488: END IF;
1489: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1490: p_count => x_msg_count,
1491: p_data => X_msg_data);
1492:
1493: END process_reconfig_mrs;

Line 1519: FND_MSG_PUB.Initialize;

1515: --set the operating unit.
1516: mo_global.init('AHL');
1517:
1518: -- Initialize error message stack by default
1519: FND_MSG_PUB.Initialize;
1520:
1521: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1522: fnd_file.put_line(fnd_file.log, 'API inputs p_fleet_id -> '||p_fleet_id);
1523: fnd_file.put_line(fnd_file.log, 'API inputs p_unit_config_id -> '||p_unit_config_id);

Line 1542: l_msg_count := FND_MSG_PUB.Count_Msg;

1538: p_fleet_unit_asso_id => NULL,
1539: p_delete_sr_flag => 'N'
1540: );
1541:
1542: l_msg_count := FND_MSG_PUB.Count_Msg;
1543: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1544: THEN
1545: retcode := 2; -- error based only on return status
1546: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)