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

Line 65: FND_MSG_PUB.Initialize;

61: -- Standard start of API savepoint
62: SAVEPOINT Delete_Simulation_Plan;
63: -- Initialize message list if p_init_msg_list is set to TRUE
64: IF FND_API.To_Boolean(p_init_msg_list) THEN
65: FND_MSG_PUB.Initialize;
66: END IF;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 75: FND_MSG_PUB.ADD;

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

Line 131: FND_MSG_PUB.ADD;

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

Line 145: FND_MSG_PUB.ADD;

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

Line 169: FND_MSG_PUB.ADD;

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:
173: -- Standard check of p_commit

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

183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: ROLLBACK TO Delete_Simulation_Plan;
187: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: ROLLBACK TO Delete_Simulation_Plan;
191: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

187: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: ROLLBACK TO Delete_Simulation_Plan;
191: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: ROLLBACK TO Delete_Simulation_Plan;
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

191: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: ROLLBACK TO Delete_Simulation_Plan;
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
196: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Delete_Simulation_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
197: END IF;
198: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
199: END Delete_Simulation_Plan;

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

192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: ROLLBACK TO Delete_Simulation_Plan;
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
196: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Delete_Simulation_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
197: END IF;
198: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
199: END Delete_Simulation_Plan;
200:

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

194: ROLLBACK TO Delete_Simulation_Plan;
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
196: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Delete_Simulation_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
197: END IF;
198: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
199: END Delete_Simulation_Plan;
200:
201: ----------------------------------------- End of the procedure Delete_Simulation_Plan---------------------------------------------------------------------
202:

Line 293: FND_MSG_PUB.Initialize;

289: -- Standard start of API savepoint
290: SAVEPOINT Implement_Simulation_Plan;
291: -- Initialize message list if p_init_msg_list is set to TRUE
292: IF FND_API.To_Boolean(p_init_msg_list) THEN
293: FND_MSG_PUB.Initialize;
294: END IF;
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 303: FND_MSG_PUB.ADD;

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
307: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Implement_Simulation_Plan', 'For this API flow, Simulation Plan Id is mandatory but found null in input ' );

Line 472: FND_MSG_PUB.ADD;

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

Line 494: FND_MSG_PUB.ADD;

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;
498: -- End of processing UE rows

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

546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: ROLLBACK TO Implement_Simulation_Plan;
550: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: ROLLBACK TO Implement_Simulation_Plan;
554: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

550: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: ROLLBACK TO Implement_Simulation_Plan;
554: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
555: WHEN OTHERS THEN
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: ROLLBACK TO Implement_Simulation_Plan;
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

554: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
555: WHEN OTHERS THEN
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: ROLLBACK TO Implement_Simulation_Plan;
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
559: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Implement_Simulation_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
560: END IF;
561: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
562: END Implement_Simulation_Plan;

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

555: WHEN OTHERS THEN
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: ROLLBACK TO Implement_Simulation_Plan;
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
559: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Implement_Simulation_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
560: END IF;
561: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
562: END Implement_Simulation_Plan;
563:

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

557: ROLLBACK TO Implement_Simulation_Plan;
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
559: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Implement_Simulation_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
560: END IF;
561: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
562: END Implement_Simulation_Plan;
563:
564: -------------------------------------------------------- End of the procedure Implement_Simulation_Plan -----------------------------------------------------
565:

Line 618: FND_MSG_PUB.Initialize;

614: -- Standard start of API savepoint
615: SAVEPOINT Remove_Unit_From_Plan;
616: -- Initialize message list if p_init_msg_list is set to TRUE
617: IF FND_API.To_Boolean(p_init_msg_list) THEN
618: FND_MSG_PUB.Initialize;
619: END IF;
620: -- Standard call to check for call compatibility.
621: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 628: FND_MSG_PUB.ADD;

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

Line 651: FND_MSG_PUB.ADD;

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

Line 659: FND_MSG_PUB.ADD;

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

Line 667: FND_MSG_PUB.ADD;

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

Line 716: FND_MSG_PUB.ADD;

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
720: -- Remove ue records if no lock is there

Line 730: FND_MSG_PUB.ADD;

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

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

746: EXCEPTION
747: WHEN FND_API.G_EXC_ERROR THEN
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: ROLLBACK TO Remove_Unit_From_Plan;
750: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: ROLLBACK TO Remove_Unit_From_Plan;
754: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

750: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: ROLLBACK TO Remove_Unit_From_Plan;
754: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
755: WHEN OTHERS THEN
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: ROLLBACK TO Remove_Unit_From_Plan;
758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

754: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
755: WHEN OTHERS THEN
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: ROLLBACK TO Remove_Unit_From_Plan;
758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
759: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Remove_Unit_From_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
760: END IF;
761: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
762: END Remove_Unit_From_Plan;

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

755: WHEN OTHERS THEN
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: ROLLBACK TO Remove_Unit_From_Plan;
758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
759: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Remove_Unit_From_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
760: END IF;
761: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
762: END Remove_Unit_From_Plan;
763: -------------------------------------------------------------- End of procedure Remove_Unit_From_Plan ----------------------------------------------------------

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

757: ROLLBACK TO Remove_Unit_From_Plan;
758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
759: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Remove_Unit_From_Plan', p_error_text => SUBSTR(SQLERRM,1,500));
760: END IF;
761: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
762: END Remove_Unit_From_Plan;
763: -------------------------------------------------------------- End of procedure Remove_Unit_From_Plan ----------------------------------------------------------
764:
765: END Ahl_Simulation_Pvt;