DBA Data[Home] [Help]

APPS.AHL_FLEET_FORECAST_PVT dependencies on FND_MESSAGE

Line 108: FND_MESSAGE.Set_Name('AHL','AHL_FLEET_NULL_FLT_ID');

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

Line 151: FND_MESSAGE.Set_Name('AHL','AHL_FLEET_NULL_FLT_ID');

147: FROM AHL_FLEET_HEADERS_B
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;

Line 160: FND_MESSAGE.set_name('AHL','AHL_FLEET_RECORD_CHANGED');

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

Line 231: FND_MESSAGE.Set_Name('AHL','AHL_FLEET_COMPL_MR_ASSOC');

227: INTO l_temp;
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;

Line 286: FND_MESSAGE.set_name('AHL','AHL_FLEET_RECORD_CHANGED');

282: WHERE fleet_header_id = p_fleet_id
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;

Line 342: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');

338: END IF;
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

Line 616: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');

612: FETCH get_sr_details INTO l_cur_sr_details;
613: IF (get_sr_details%NOTFOUND)
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;

Line 617: FND_MESSAGE.set_token('INC_ID', l_cur_sr_details.incident_id);

613: IF (get_sr_details%NOTFOUND)
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;

Line 737: FND_MESSAGE.set_name( 'AHL', 'AHL_FLT_INVLD_FLEET_ID' );

733: OPEN is_fleet_valid(p_fleet_id);
734: FETCH is_fleet_valid INTO l_dummy;
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;

Line 738: FND_MESSAGE.set_token('FIELD', p_fleet_id );

734: FETCH is_fleet_valid INTO l_dummy;
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;

Line 750: FND_MESSAGE.set_name( 'AHL', 'AHL_FLT_INVLD_UC_ID' );

746: OPEN is_unit_valid(p_unit_config_id);
747: FETCH is_unit_valid INTO l_dummy;
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;

Line 751: FND_MESSAGE.set_token('FIELD', p_unit_config_id );

747: FETCH is_unit_valid INTO l_dummy;
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;

Line 902: FND_MESSAGE.Set_Name('AHL','AHL_FLT_RECON_MR_SUMM');

898: -- Resolution Date for SR is l_max_compliance_lead_time (days) ahead of unit association Start date
899: l_resoultion_date := l_fleet_unit_asso_rec.association_start - l_max_compliance_lead_time;
900:
901: --Problem Summary
902: FND_MESSAGE.Set_Name('AHL','AHL_FLT_RECON_MR_SUMM');
903: FND_MESSAGE.Set_Token('UNIT',l_cur_item_instance_det.name);
904: FND_MESSAGE.Set_Token('FLEET',l_fleet_unit_asso_rec.name);
905:
906: IF(l_fleet_unit_asso_rec.reconfig_sr_id IS NULL)

Line 903: FND_MESSAGE.Set_Token('UNIT',l_cur_item_instance_det.name);

899: l_resoultion_date := l_fleet_unit_asso_rec.association_start - l_max_compliance_lead_time;
900:
901: --Problem Summary
902: FND_MESSAGE.Set_Name('AHL','AHL_FLT_RECON_MR_SUMM');
903: FND_MESSAGE.Set_Token('UNIT',l_cur_item_instance_det.name);
904: FND_MESSAGE.Set_Token('FLEET',l_fleet_unit_asso_rec.name);
905:
906: IF(l_fleet_unit_asso_rec.reconfig_sr_id IS NULL)
907: THEN

Line 904: FND_MESSAGE.Set_Token('FLEET',l_fleet_unit_asso_rec.name);

900:
901: --Problem Summary
902: FND_MESSAGE.Set_Name('AHL','AHL_FLT_RECON_MR_SUMM');
903: FND_MESSAGE.Set_Token('UNIT',l_cur_item_instance_det.name);
904: FND_MESSAGE.Set_Token('FLEET',l_fleet_unit_asso_rec.name);
905:
906: IF(l_fleet_unit_asso_rec.reconfig_sr_id IS NULL)
907: THEN
908: IF G_DEBUG = 'Y' THEN

Line 924: l_nr_task_rec.problem_summary := FND_MESSAGE.GET;

920: l_nr_task_rec.type_id := FND_PROFILE.VALUE('AHL_SER_REQ_TYP_FOR_RECON_MR');
921: l_nr_task_rec.customer_type := 'ORGANIZATION';
922: l_nr_task_rec.customer_id := NVL(l_cur_item_instance_det.owner_party_id, -1);
923: l_nr_task_rec.severity_id := FND_PROFILE.VALUE('AHL_PRD_SR_SEVERITY');
924: l_nr_task_rec.problem_summary := FND_MESSAGE.GET;
925: l_nr_task_rec.unit_config_header_id := l_fleet_unit_asso_rec.unit_config_header_id;
926: l_nr_task_rec.incident_date := SYSDATE;
927: l_nr_task_rec.expected_resolution_date := l_resoultion_date;
928:

Line 966: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');

962: OPEN get_sr_details (l_nr_task_rec.incident_id);
963: FETCH get_sr_details INTO l_cur_sr_details;
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;

Line 967: FND_MESSAGE.set_token('INC_ID', l_nr_task_rec.incident_id);

963: FETCH get_sr_details INTO l_cur_sr_details;
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;

Line 1033: FND_MESSAGE.set_name('AHL', 'AHL_FLT_UNIT_ASS_MOD');

1029: AND object_version_number = l_fleet_unit_asso_rec.object_version_number;
1030:
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;

Line 1034: FND_MESSAGE.set_token('ASS_ID', l_fleet_unit_asso_rec.fleet_unit_assoc_id);

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

Line 1060: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');

1056: OPEN get_sr_details (l_fleet_unit_asso_rec.reconfig_sr_id);
1057: FETCH get_sr_details INTO l_cur_sr_details;
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;

Line 1061: FND_MESSAGE.set_token('INC_ID', l_nr_task_rec.incident_id);

1057: FETCH get_sr_details INTO l_cur_sr_details;
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;

Line 1398: FND_MESSAGE.set_name('AHL', 'AHL_FLT_UNIT_ASS_MOD');

1394: AND object_version_number = l_fleet_unit_asso_rec.object_version_number;
1395:
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;

Line 1399: FND_MESSAGE.set_token('ASS_ID', l_fleet_unit_asso_rec.fleet_unit_assoc_id);

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