DBA Data[Home] [Help]

APPS.AHL_SIMULATION_PVT dependencies on FND_MESSAGE

Line 74: FND_MESSAGE.Set_Name('AHL','AHL_SIM_NULL_SIM_PLAN_ID');

70: END IF;
71:
72: -- Check for Required Parameters
73: IF(p_simulation_plan_id IS NULL) THEN
74: FND_MESSAGE.Set_Name('AHL','AHL_SIM_NULL_SIM_PLAN_ID');
75: FND_MSG_PUB.ADD;
76: IF (l_log_unexpected >= l_log_current_level) THEN
77: fnd_log.string ( l_log_unexpected, 'ahl.plsql.', 'For this API flow, Simulation Plan Id is mandatory but found null in input ' );
78: END IF;

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

126: FROM AHL_UE_SIMULATIONS
127: WHERE simulation_plan_id = p_simulation_plan_id;
128: ELSE
129: ROLLBACK TO Delete_Simulation_Plan;
130: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');
131: FND_MSG_PUB.ADD;
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134: -- End of processing for Sim Ues

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

140: FROM AHL_FLEET_UNIT_ASSOCS
141: WHERE simulation_plan_id = p_simulation_plan_id;
142: ELSE
143: ROLLBACK TO Delete_Simulation_Plan;
144: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');
145: FND_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148: -- End of processing for Fleet unit association

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

164: WHERE simulation_plan_id = p_simulation_plan_id
165: AND object_type = 'SIM';
166: ELSE
167: ROLLBACK TO Delete_Simulation_Plan;
168: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');
169: FND_MSG_PUB.ADD;
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:

Line 302: FND_MESSAGE.Set_Name('AHL','AHL_SIM_NULL_SIM_PLAN_ID');

298: END IF;
299:
300: -- Check for Required Parameters
301: IF(p_simulation_plan_id IS NULL) THEN
302: FND_MESSAGE.Set_Name('AHL','AHL_SIM_NULL_SIM_PLAN_ID');
303: FND_MSG_PUB.ADD;
304:
305: -- Logging
306: IF (l_log_unexpected >= l_log_current_level) THEN

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

467: END IF;
468: ELSE
469: -- Already lock exists on the rows
470: ROLLBACK TO Implement_Simulation_Plan;
471: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');
472: FND_MSG_PUB.ADD;
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475: -- End of processing fleet unit assocs rows

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

489: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Updates mades in ue table');
490: END IF;
491: ELSE
492: ROLLBACK TO Implement_Simulation_Plan;
493: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');
494: FND_MSG_PUB.ADD;
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;
497: END IF;

Line 627: FND_MESSAGE.Set_Name('AHL','AHL_SIM_NULL_SIM_PLAN_ID');

623: END IF;
624:
625: -- Check for Required Parameters
626: IF(p_simulation_ue_id IS NULL) THEN
627: FND_MESSAGE.Set_Name('AHL','AHL_SIM_NULL_SIM_PLAN_ID');
628: FND_MSG_PUB.ADD;
629: IF (l_log_unexpected >= l_log_current_level) THEN
630: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Unit_From_Plan', 'For this API flow, Simulation Ue Id is mandatory but found null in input ' );
631: END IF;

Line 650: FND_MESSAGE.Set_Name('AHL','AHL_SIM_INVALID_SIM_UE_ID');

646: FROM ahl_simulation_forecast_v
647: WHERE simulation_ue_id = p_simulation_ue_id;
648: EXCEPTION
649: WHEN NO_DATA_FOUND THEN
650: FND_MESSAGE.Set_Name('AHL','AHL_SIM_INVALID_SIM_UE_ID');
651: FND_MSG_PUB.ADD;
652: IF (l_log_unexpected >= l_log_current_level) THEN
653: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Unit_From_Plan', 'There are no rows for the selected simulation effectivity id' );
654: END IF;

Line 658: FND_MESSAGE.Set_Name('AHL','AHL_SIM_INVALID_SIM_PLAN_ID');

654: END IF;
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END;
657: IF (l_sim_plan_id IS NULL) THEN
658: FND_MESSAGE.Set_Name('AHL','AHL_SIM_INVALID_SIM_PLAN_ID');
659: FND_MSG_PUB.ADD;
660: IF (l_log_unexpected >= l_log_current_level)THEN
661: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Unit_From_Plan', 'NULL Simulation Plan id ' );
662: END IF;

Line 666: FND_MESSAGE.Set_Name('AHL','AHL_SIM_INVALID_UNIT_HEADER_ID');

662: END IF;
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665: IF (l_unit_config_header_id IS NULL) THEN
666: FND_MESSAGE.Set_Name('AHL','AHL_SIM_INVALID_UNIT_HEADER_ID');
667: FND_MSG_PUB.ADD;
668: IF (l_log_unexpected >= l_log_current_level) THEN
669: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Remove_Unit_From_Plan', 'NULL Unit id ' );
670: END IF;

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

711: WHERE unit_config_header_id = l_unit_config_header_id
712: AND simulation_plan_id = l_sim_plan_id;
713: ELSE
714: ROLLBACK TO Remove_Unit_From_Plan;
715: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');
716: FND_MSG_PUB.ADD;
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;
719: -- Processed assocs table records

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

725: WHERE unit_config_header_id = l_unit_config_header_id
726: AND simulation_plan_id = l_sim_plan_id;
727: ELSE
728: ROLLBACK TO Remove_Unit_From_Plan;
729: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');
730: FND_MSG_PUB.ADD;
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733: -- End of processing for ue records