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_API

Line 23: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

19: */
20: PROCEDURE Remove_Fleet
21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
24: p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
25: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
26: p_module_type IN VARCHAR2 := NULL,
27: p_fleet_id IN NUMBER,

Line 24: p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,

20: PROCEDURE Remove_Fleet
21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
24: p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
25: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
26: p_module_type IN VARCHAR2 := NULL,
27: p_fleet_id IN NUMBER,
28: p_obj_version_no IN NUMBER,

Line 25: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
24: p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
25: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
26: p_module_type IN VARCHAR2 := NULL,
27: p_fleet_id IN NUMBER,
28: p_obj_version_no IN NUMBER,
29: x_return_status OUT NOCOPY VARCHAR2,

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 99: IF FND_API.To_Boolean(p_init_msg_list) THEN

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

Line 103: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN

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
107: IF(p_fleet_id IS NULL) THEN

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
107: IF(p_fleet_id IS NULL) THEN
108: FND_MESSAGE.Set_Name('AHL','AHL_FLEET_NULL_FLT_ID');

Line 113: RAISE FND_API.G_EXC_ERROR;

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

Line 156: RAISE FND_API.G_EXC_ERROR;

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
159: -- The record is already deleted
160: FND_MESSAGE.set_name('AHL','AHL_FLEET_RECORD_CHANGED');

Line 165: RAISE FND_API.G_EXC_ERROR;

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
168: -- Open the cursor for draft fleet
169: OPEN applicable_draft_fleets(p_fleet_id);

Line 236: RAISE FND_API.G_EXC_ERROR;

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

Line 253: p_init_msg_list => FND_API.G_TRUE,

249: END IF;
250: process_reconfig_mrs
251: (
252: p_api_version => 1.0,
253: p_init_msg_list => FND_API.G_TRUE,
254: p_commit => FND_API.G_TRUE,
255: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
256: p_module_type => 'API',
257: x_return_status => l_return_status,

Line 254: p_commit => FND_API.G_TRUE,

250: process_reconfig_mrs
251: (
252: p_api_version => 1.0,
253: p_init_msg_list => FND_API.G_TRUE,
254: p_commit => FND_API.G_TRUE,
255: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
256: p_module_type => 'API',
257: x_return_status => l_return_status,
258: x_msg_count => l_msg_count,

Line 255: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

251: (
252: p_api_version => 1.0,
253: p_init_msg_list => FND_API.G_TRUE,
254: p_commit => FND_API.G_TRUE,
255: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
256: p_module_type => 'API',
257: x_return_status => l_return_status,
258: x_msg_count => l_msg_count,
259: x_msg_data => l_msg_data,

Line 266: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

262: p_fleet_unit_asso_id => l_close_sr.fleet_unit_assoc_id,
263: p_delete_sr_flag => 'Y'
264: );
265:
266: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
267: THEN
268: IF G_DEBUG = 'Y' THEN
269: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
270: END IF;

Line 271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

267: THEN
268: IF G_DEBUG = 'Y' THEN
269: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
270: END IF;
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273: END LOOP;
274:
275: -- fleet headers

Line 291: RAISE FND_API.G_EXC_ERROR;

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
294: DELETE
295: FROM AHL_UE_SIMULATIONS

Line 344: RAISE FND_API.G_EXC_ERROR;

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
348: COMMIT;

Line 347: IF FND_API.TO_BOOLEAN(p_commit) THEN

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
351: IF (l_log_procedure >= l_log_current_level) THEN

Line 355: WHEN FND_API.G_EXC_ERROR THEN

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

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

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);
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: IF (l_log_unexpected >= l_log_current_level) 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 362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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);
369: WHEN OTHERS THEN
370: IF (l_log_unexpected >= l_log_current_level) THEN

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 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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 394: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

390:
391: PROCEDURE process_reconfig_mrs
392: (
393: p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_module_type IN VARCHAR2,
398: x_return_status OUT NOCOPY VARCHAR2,

Line 395: p_commit IN VARCHAR2 := FND_API.G_FALSE,

391: PROCEDURE process_reconfig_mrs
392: (
393: p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_module_type IN VARCHAR2,
398: x_return_status OUT NOCOPY VARCHAR2,
399: x_msg_count OUT NOCOPY NUMBER,

Line 396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

392: (
393: p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
397: p_module_type IN VARCHAR2,
398: x_return_status OUT NOCOPY VARCHAR2,
399: x_msg_count OUT NOCOPY NUMBER,
400: x_msg_data OUT NOCOPY VARCHAR2,

Line 567: x_return_status := FND_API.G_RET_STS_SUCCESS;

563: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
564: END IF;
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:

Line 573: IF NOT FND_API.compatible_api_call

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,
577: l_api_name,

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: l_api_name,
578: G_PKG_NAME
579: )
580: THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 585: IF FND_API.to_boolean( p_init_msg_list ) THEN

581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
623: -- Get the csi_item_instance_id for given uc_id

Line 675: p_init_msg_list => FND_API.G_FALSE,

671:
672: AHL_UMP_SR_PVT.Process_SR_MR_Associations
673: (
674: p_api_version => 1.0,
675: p_init_msg_list => FND_API.G_FALSE,
676: p_commit => FND_API.G_FALSE,
677: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
678: x_return_status => l_return_status,
679: x_msg_count => l_msg_count,

Line 676: p_commit => FND_API.G_FALSE,

672: AHL_UMP_SR_PVT.Process_SR_MR_Associations
673: (
674: p_api_version => 1.0,
675: p_init_msg_list => FND_API.G_FALSE,
676: p_commit => FND_API.G_FALSE,
677: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
678: x_return_status => l_return_status,
679: x_msg_count => l_msg_count,
680: x_msg_data => l_msg_data,

Line 677: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

673: (
674: p_api_version => 1.0,
675: p_init_msg_list => FND_API.G_FALSE,
676: p_commit => FND_API.G_FALSE,
677: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
678: x_return_status => l_return_status,
679: x_msg_count => l_msg_count,
680: x_msg_data => l_msg_data,
681: p_user_id => fnd_global.user_id,

Line 689: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

685: p_request_number => null,
686: p_x_sr_mr_association_tbl => l_mr_sr_assoc_tbl
687: );
688:
689: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
690: THEN
691: IF G_DEBUG = 'Y' THEN
692: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations for Delete is Failed' );
693: END IF;

Line 694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

690: THEN
691: IF G_DEBUG = 'Y' THEN
692: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations for Delete is Failed' );
693: END IF;
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696: END IF;
697:
698: IF G_DEBUG = 'Y' THEN

Line 705: p_init_msg_list => FND_API.G_TRUE,

701:
702: AHL_UMP_NONROUTINES_PVT.Update_SR
703: (
704: p_api_version => 1.0,
705: p_init_msg_list => FND_API.G_TRUE,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: p_default => FND_API.G_FALSE,
709: p_module_type => p_module_type,

Line 706: p_commit => FND_API.G_FALSE,

702: AHL_UMP_NONROUTINES_PVT.Update_SR
703: (
704: p_api_version => 1.0,
705: p_init_msg_list => FND_API.G_TRUE,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: p_default => FND_API.G_FALSE,
709: p_module_type => p_module_type,
710: x_return_status => l_return_status,

Line 707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

703: (
704: p_api_version => 1.0,
705: p_init_msg_list => FND_API.G_TRUE,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: p_default => FND_API.G_FALSE,
709: p_module_type => p_module_type,
710: x_return_status => l_return_status,
711: x_msg_count => l_msg_count,

Line 708: p_default => FND_API.G_FALSE,

704: p_api_version => 1.0,
705: p_init_msg_list => FND_API.G_TRUE,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: p_default => FND_API.G_FALSE,
709: p_module_type => p_module_type,
710: x_return_status => l_return_status,
711: x_msg_count => l_msg_count,
712: x_msg_data => l_msg_data,

Line 716: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

712: x_msg_data => l_msg_data,
713: p_x_nonroutine_rec => l_nr_task_rec
714: );
715:
716: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
717: THEN
718: IF G_DEBUG = 'Y' THEN
719: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
720: END IF;

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: THEN
718: IF G_DEBUG = 'Y' THEN
719: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
720: END IF;
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: END IF;
724: CLOSE is_sr_planned;
725: END IF;

Line 739: RAISE FND_API.G_EXC_ERROR;

735: IF(is_fleet_valid%NOTFOUND)
736: THEN
737: FND_MESSAGE.set_name( 'AHL', 'AHL_FLT_INVLD_FLEET_ID' );
738: FND_MESSAGE.set_token('FIELD', p_fleet_id );
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741: CLOSE is_fleet_valid;
742: END IF;
743:

Line 752: RAISE FND_API.G_EXC_ERROR;

748: IF(is_unit_valid%NOTFOUND)
749: THEN
750: FND_MESSAGE.set_name( 'AHL', 'AHL_FLT_INVLD_UC_ID' );
751: FND_MESSAGE.set_token('FIELD', p_unit_config_id );
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754: CLOSE is_unit_valid;
755: END IF;
756:

Line 842: p_init_msg_list => FND_API.G_FALSE,

838: -- Get all the applicable MRs for Each Filtered Reconfiguration MR
839: AHL_FMP_PVT.GET_APPLICABLE_MRS
840: (
841: p_api_version => 1.0,
842: p_init_msg_list => FND_API.G_FALSE,
843: p_commit => FND_API.G_FALSE,
844: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
845: x_return_status => l_return_status,
846: x_msg_count => l_msg_count,

Line 843: p_commit => FND_API.G_FALSE,

839: AHL_FMP_PVT.GET_APPLICABLE_MRS
840: (
841: p_api_version => 1.0,
842: p_init_msg_list => FND_API.G_FALSE,
843: p_commit => FND_API.G_FALSE,
844: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
845: x_return_status => l_return_status,
846: x_msg_count => l_msg_count,
847: x_msg_data => l_msg_data,

Line 844: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

840: (
841: p_api_version => 1.0,
842: p_init_msg_list => FND_API.G_FALSE,
843: p_commit => FND_API.G_FALSE,
844: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
845: x_return_status => l_return_status,
846: x_msg_count => l_msg_count,
847: x_msg_data => l_msg_data,
848: p_item_instance_id => l_cur_item_instance_det.csi_item_instance_id ,

Line 857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

853: x_applicable_mr_tbl => l_applicable_mr_tbl
854: );
855:
856: -- Raise errors if exceptions occurs in get_applicable_mrs API
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
859: THEN
860: IF G_DEBUG = 'Y' THEN
861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_FMP_PVT.GET_APPLICABLE_MRS is Failed' );

Line 858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

854: );
855:
856: -- Raise errors if exceptions occurs in get_applicable_mrs API
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
859: THEN
860: IF G_DEBUG = 'Y' THEN
861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_FMP_PVT.GET_APPLICABLE_MRS is Failed' );
862: END IF;

Line 863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

859: THEN
860: IF G_DEBUG = 'Y' THEN
861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_FMP_PVT.GET_APPLICABLE_MRS is Failed' );
862: END IF;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
867: RAISE FND_API.G_EXC_ERROR;

Line 865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_FMP_PVT.GET_APPLICABLE_MRS is Failed' );
862: END IF;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;
869:

Line 866: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

862: END IF;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;
869:
870: IF G_DEBUG = 'Y' THEN

Line 867: RAISE FND_API.G_EXC_ERROR;

863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;
869:
870: IF G_DEBUG = 'Y' THEN
871: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Effective Reconfig MR '||'::Reconfig MR::'||i||':::' || l_applicable_mr_tbl.count );

Line 942: p_init_msg_list => FND_API.G_TRUE,

938: -- Call Create SR
939: AHL_UMP_NONROUTINES_PVT.Create_SR
940: (
941: p_api_version => 1.0,
942: p_init_msg_list => FND_API.G_TRUE,
943: p_commit => FND_API.G_FALSE,
944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
945: p_default => FND_API.G_FALSE,
946: p_module_type => p_module_type,

Line 943: p_commit => FND_API.G_FALSE,

939: AHL_UMP_NONROUTINES_PVT.Create_SR
940: (
941: p_api_version => 1.0,
942: p_init_msg_list => FND_API.G_TRUE,
943: p_commit => FND_API.G_FALSE,
944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
945: p_default => FND_API.G_FALSE,
946: p_module_type => p_module_type,
947: x_return_status => l_return_status,

Line 944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

940: (
941: p_api_version => 1.0,
942: p_init_msg_list => FND_API.G_TRUE,
943: p_commit => FND_API.G_FALSE,
944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
945: p_default => FND_API.G_FALSE,
946: p_module_type => p_module_type,
947: x_return_status => l_return_status,
948: x_msg_count => l_msg_count,

Line 945: p_default => FND_API.G_FALSE,

941: p_api_version => 1.0,
942: p_init_msg_list => FND_API.G_TRUE,
943: p_commit => FND_API.G_FALSE,
944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
945: p_default => FND_API.G_FALSE,
946: p_module_type => p_module_type,
947: x_return_status => l_return_status,
948: x_msg_count => l_msg_count,
949: x_msg_data => l_msg_data,

Line 953: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

949: x_msg_data => l_msg_data,
950: p_x_nonroutine_rec => l_nr_task_rec
951: );
952:
953: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
954: THEN
955: IF G_DEBUG = 'Y' THEN
956: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Create_SR is Failed' );
957: END IF;

Line 958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

954: THEN
955: IF G_DEBUG = 'Y' THEN
956: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Create_SR is Failed' );
957: END IF;
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960:
961: -- get object version number for the service request and the new ue id.
962: OPEN get_sr_details (l_nr_task_rec.incident_id);

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
973: -- Copy Inputs from l_new_reconfig_mr_id_tbl to l_mr_sr_assoc_tbl

Line 999: p_init_msg_list => FND_API.G_FALSE,

995: -- Call Process Associations
996: AHL_UMP_SR_PVT.Process_SR_MR_Associations
997: (
998: p_api_version => 1.0,
999: p_init_msg_list => FND_API.G_FALSE,
1000: p_commit => FND_API.G_FALSE,
1001: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1002: x_return_status => l_return_status,
1003: x_msg_count => l_msg_count,

Line 1000: p_commit => FND_API.G_FALSE,

996: AHL_UMP_SR_PVT.Process_SR_MR_Associations
997: (
998: p_api_version => 1.0,
999: p_init_msg_list => FND_API.G_FALSE,
1000: p_commit => FND_API.G_FALSE,
1001: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1002: x_return_status => l_return_status,
1003: x_msg_count => l_msg_count,
1004: x_msg_data => l_msg_data,

Line 1001: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

997: (
998: p_api_version => 1.0,
999: p_init_msg_list => FND_API.G_FALSE,
1000: p_commit => FND_API.G_FALSE,
1001: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1002: x_return_status => l_return_status,
1003: x_msg_count => l_msg_count,
1004: x_msg_data => l_msg_data,
1005: p_user_id => fnd_global.user_id,

Line 1013: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1009: p_request_number => null,
1010: p_x_sr_mr_association_tbl => l_mr_sr_assoc_tbl
1011: );
1012:
1013: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1014: THEN
1015: IF G_DEBUG = 'Y' THEN
1016: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1017: END IF;

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1014: THEN
1015: IF G_DEBUG = 'Y' THEN
1016: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1017: END IF;
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:
1021: -- Update Fleet - Unit Associtiaon Table with New SR_Incident_Id
1022: UPDATE ahl_fleet_unit_assocs

Line 1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
1040: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Fleet - Unit Assocition is Updated with SR_ID::'||l_nr_task_rec.incident_id );

Line 1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1067: -- Consolidating Input Params to Update SR

Line 1102: p_init_msg_list => FND_API.G_TRUE,

1098:
1099: AHL_UMP_NONROUTINES_PVT.Update_SR
1100: (
1101: p_api_version => 1.0,
1102: p_init_msg_list => FND_API.G_TRUE,
1103: p_commit => FND_API.G_FALSE,
1104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1105: p_default => FND_API.G_FALSE,
1106: p_module_type => p_module_type,

Line 1103: p_commit => FND_API.G_FALSE,

1099: AHL_UMP_NONROUTINES_PVT.Update_SR
1100: (
1101: p_api_version => 1.0,
1102: p_init_msg_list => FND_API.G_TRUE,
1103: p_commit => FND_API.G_FALSE,
1104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1105: p_default => FND_API.G_FALSE,
1106: p_module_type => p_module_type,
1107: x_return_status => l_return_status,

Line 1104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1100: (
1101: p_api_version => 1.0,
1102: p_init_msg_list => FND_API.G_TRUE,
1103: p_commit => FND_API.G_FALSE,
1104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1105: p_default => FND_API.G_FALSE,
1106: p_module_type => p_module_type,
1107: x_return_status => l_return_status,
1108: x_msg_count => l_msg_count,

Line 1105: p_default => FND_API.G_FALSE,

1101: p_api_version => 1.0,
1102: p_init_msg_list => FND_API.G_TRUE,
1103: p_commit => FND_API.G_FALSE,
1104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1105: p_default => FND_API.G_FALSE,
1106: p_module_type => p_module_type,
1107: x_return_status => l_return_status,
1108: x_msg_count => l_msg_count,
1109: x_msg_data => l_msg_data,

Line 1113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1109: x_msg_data => l_msg_data,
1110: p_x_nonroutine_rec => l_nr_task_rec
1111: );
1112:
1113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1114: THEN
1115: IF G_DEBUG = 'Y' THEN
1116: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
1117: END IF;

Line 1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1114: THEN
1115: IF G_DEBUG = 'Y' THEN
1116: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
1117: END IF;
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119: END IF;
1120: END IF;
1121:
1122: -- Get ALL the Mr_headers for alreadycreated SR

Line 1267: p_init_msg_list => FND_API.G_FALSE,

1263:
1264: AHL_UMP_SR_PVT.Process_SR_MR_Associations
1265: (
1266: p_api_version => 1.0,
1267: p_init_msg_list => FND_API.G_FALSE,
1268: p_commit => FND_API.G_FALSE,
1269: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1270: x_return_status => l_return_status,
1271: x_msg_count => l_msg_count,

Line 1268: p_commit => FND_API.G_FALSE,

1264: AHL_UMP_SR_PVT.Process_SR_MR_Associations
1265: (
1266: p_api_version => 1.0,
1267: p_init_msg_list => FND_API.G_FALSE,
1268: p_commit => FND_API.G_FALSE,
1269: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1270: x_return_status => l_return_status,
1271: x_msg_count => l_msg_count,
1272: x_msg_data => l_msg_data,

Line 1269: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1265: (
1266: p_api_version => 1.0,
1267: p_init_msg_list => FND_API.G_FALSE,
1268: p_commit => FND_API.G_FALSE,
1269: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1270: x_return_status => l_return_status,
1271: x_msg_count => l_msg_count,
1272: x_msg_data => l_msg_data,
1273: p_user_id => fnd_global.user_id,

Line 1281: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1277: p_request_number => null,
1278: p_x_sr_mr_association_tbl => l_mr_sr_assoc_tbl
1279: );
1280:
1281: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1282: THEN
1283: IF G_DEBUG = 'Y' THEN
1284: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1285: END IF;

Line 1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1282: THEN
1283: IF G_DEBUG = 'Y' THEN
1284: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1285: END IF;
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288: END IF;
1289:
1290: fnd_file.put_line(FND_FILE.LOG, 'SR Updated for Unit ::'||l_cur_item_instance_det.name);

Line 1340: p_init_msg_list => FND_API.G_FALSE,

1336: THEN
1337: AHL_UMP_SR_PVT.Process_SR_MR_Associations
1338: (
1339: p_api_version => 1.0,
1340: p_init_msg_list => FND_API.G_FALSE,
1341: p_commit => FND_API.G_FALSE,
1342: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1343: x_return_status => l_return_status,
1344: x_msg_count => l_msg_count,

Line 1341: p_commit => FND_API.G_FALSE,

1337: AHL_UMP_SR_PVT.Process_SR_MR_Associations
1338: (
1339: p_api_version => 1.0,
1340: p_init_msg_list => FND_API.G_FALSE,
1341: p_commit => FND_API.G_FALSE,
1342: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1343: x_return_status => l_return_status,
1344: x_msg_count => l_msg_count,
1345: x_msg_data => l_msg_data,

Line 1342: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1338: (
1339: p_api_version => 1.0,
1340: p_init_msg_list => FND_API.G_FALSE,
1341: p_commit => FND_API.G_FALSE,
1342: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1343: x_return_status => l_return_status,
1344: x_msg_count => l_msg_count,
1345: x_msg_data => l_msg_data,
1346: p_user_id => fnd_global.user_id,

Line 1354: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1350: p_request_number => null,
1351: p_x_sr_mr_association_tbl => l_mr_sr_assoc_tbl
1352: );
1353:
1354: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1355: THEN
1356: IF G_DEBUG = 'Y' THEN
1357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1358: END IF;

Line 1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1355: THEN
1356: IF G_DEBUG = 'Y' THEN
1357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1358: END IF;
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;
1361: END IF;
1362:
1363: AHL_UMP_NONROUTINES_PVT.Update_SR

Line 1366: p_init_msg_list => FND_API.G_TRUE,

1362:
1363: AHL_UMP_NONROUTINES_PVT.Update_SR
1364: (
1365: p_api_version => 1.0,
1366: p_init_msg_list => FND_API.G_TRUE,
1367: p_commit => FND_API.G_FALSE,
1368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1369: p_default => FND_API.G_FALSE,
1370: p_module_type => p_module_type,

Line 1367: p_commit => FND_API.G_FALSE,

1363: AHL_UMP_NONROUTINES_PVT.Update_SR
1364: (
1365: p_api_version => 1.0,
1366: p_init_msg_list => FND_API.G_TRUE,
1367: p_commit => FND_API.G_FALSE,
1368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1369: p_default => FND_API.G_FALSE,
1370: p_module_type => p_module_type,
1371: x_return_status => l_return_status,

Line 1368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1364: (
1365: p_api_version => 1.0,
1366: p_init_msg_list => FND_API.G_TRUE,
1367: p_commit => FND_API.G_FALSE,
1368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1369: p_default => FND_API.G_FALSE,
1370: p_module_type => p_module_type,
1371: x_return_status => l_return_status,
1372: x_msg_count => l_msg_count,

Line 1369: p_default => FND_API.G_FALSE,

1365: p_api_version => 1.0,
1366: p_init_msg_list => FND_API.G_TRUE,
1367: p_commit => FND_API.G_FALSE,
1368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1369: p_default => FND_API.G_FALSE,
1370: p_module_type => p_module_type,
1371: x_return_status => l_return_status,
1372: x_msg_count => l_msg_count,
1373: x_msg_data => l_msg_data,

Line 1377: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1373: x_msg_data => l_msg_data,
1374: p_x_nonroutine_rec => l_nr_task_rec
1375: );
1376:
1377: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1378: THEN
1379: IF G_DEBUG = 'Y' THEN
1380: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
1381: END IF;

Line 1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1378: THEN
1379: IF G_DEBUG = 'Y' THEN
1380: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
1381: END IF;
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END IF;
1384:
1385: -- Nullify reconfig_sr_id Fleet - Unit Association table
1386: -- Whenever SR is closed

Line 1401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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);
1405: fnd_file.put_line(FND_FILE.LOG, 'SR Closed for Fleet ::'||l_fleet_unit_asso_rec.name);

Line 1425: p_encoded => FND_API.G_FALSE,

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 );
1428:
1429: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||j||':' || l_msg_data);

Line 1445: IF FND_API.TO_BOOLEAN(p_commit) THEN

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:
1449: IF (G_DEBUG = 'Y') THEN

Line 1455: ( p_encoded => fnd_api.g_false,

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

Line 1466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1462: AHL_DEBUG_PUB.disable_debug;
1463: END IF;
1464:
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,

Line 1468: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1464:
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:

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 1473: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1475: X_return_status := FND_API.G_RET_STS_ERROR;

1471: p_data => x_msg_data);
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

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 1481: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1477: p_count => x_msg_count,
1478: p_data => X_msg_data);
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',

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 1529: p_init_msg_list => FND_API.G_TRUE,

1525:
1526: process_reconfig_mrs
1527: (
1528: p_api_version => 1.0,
1529: p_init_msg_list => FND_API.G_TRUE,
1530: p_commit => FND_API.G_TRUE,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_module_type => 'CCP',
1533: x_return_status => l_return_status,

Line 1530: p_commit => FND_API.G_TRUE,

1526: process_reconfig_mrs
1527: (
1528: p_api_version => 1.0,
1529: p_init_msg_list => FND_API.G_TRUE,
1530: p_commit => FND_API.G_TRUE,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_module_type => 'CCP',
1533: x_return_status => l_return_status,
1534: x_msg_count => l_msg_count,

Line 1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1527: (
1528: p_api_version => 1.0,
1529: p_init_msg_list => FND_API.G_TRUE,
1530: p_commit => FND_API.G_TRUE,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_module_type => 'CCP',
1533: x_return_status => l_return_status,
1534: x_msg_count => l_msg_count,
1535: x_msg_data => errbuf,

Line 1543: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

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)
1547: THEN

Line 1546: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)

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)
1547: THEN
1548: retcode := 1; -- warning based on return status + msg count
1549: ELSE
1550: retcode := 0;