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.

[Home] [Help]

APPS.AHL_LTP_MATERIALS_GRP dependencies on FND_API

Line 25: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

21: -- Parameters :
22: --
23: -- Standard IN Parameters :
24: -- p_api_version IN NUMBER Required
25: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
28: --
29: -- Standard OUT Parameters :

Line 26: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

22: --
23: -- Standard IN Parameters :
24: -- p_api_version IN NUMBER Required
25: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
28: --
29: -- Standard OUT Parameters :
30: -- x_return_status OUT VARCHAR2 Required

Line 27: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

23: -- Standard IN Parameters :
24: -- p_api_version IN NUMBER Required
25: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
28: --
29: -- Standard OUT Parameters :
30: -- x_return_status OUT VARCHAR2 Required
31: -- x_msg_count OUT NUMBER Required

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: -- Standard start of API savepoint
84: SAVEPOINT Update_mtl_resv_dates_grp;
85:
86: -- Initialize return status to success before any code logic/validation
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: -- Standard call to check for call compatibility
90: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
91: THEN

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

86: -- Initialize return status to success before any code logic/validation
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: -- Standard call to check for call compatibility
90: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
91: THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88:
89: -- Standard call to check for call compatibility
90: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
91: THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
96: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 95: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

91: THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
96: IF FND_API.TO_BOOLEAN(p_init_msg_list)
97: THEN
98: FND_MSG_PUB.INITIALIZE;
99: END IF;

Line 96: IF FND_API.TO_BOOLEAN(p_init_msg_list)

92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
96: IF FND_API.TO_BOOLEAN(p_init_msg_list)
97: THEN
98: FND_MSG_PUB.INITIALIZE;
99: END IF;
100:

Line 120: RAISE FND_API.G_EXC_ERROR;

116: -- then the wip entity id passed to this procedure is invalid
117: IF l_requested_date IS NULL THEN
118: Fnd_Message.SET_NAME('AHL','AHL_LTP_WIP_ENTITY_ID_INVLD');
119: Fnd_Msg_Pub.ADD;
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:
123: OPEN get_scheduled_material_id(p_wip_entity_id, l_requested_date);
124: i:=1;

Line 144: p_init_msg_list => FND_API.G_FALSE,

140: -- This API updates all the reservation dates, if l_requested_date
141: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different
142: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
143: p_api_version => 1.0,
144: p_init_msg_list => FND_API.G_FALSE,
145: p_commit => FND_API.G_FALSE,
146: p_module_type => NULL,
147: x_return_status => l_return_status,
148: x_msg_count => x_msg_count,

Line 145: p_commit => FND_API.G_FALSE,

141: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different
142: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
143: p_api_version => 1.0,
144: p_init_msg_list => FND_API.G_FALSE,
145: p_commit => FND_API.G_FALSE,
146: p_module_type => NULL,
147: x_return_status => l_return_status,
148: x_msg_count => x_msg_count,
149: x_msg_data => x_msg_data,

Line 153: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

149: x_msg_data => x_msg_data,
150: p_scheduled_material_id => l_scheduled_material_id,
151: p_requested_date => l_requested_date);
152:
153: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
154: IF (l_log_statement >= l_log_current_level)THEN
155: fnd_log.string
156: (
157: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

Line 161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

157: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
158: 'Returned success from AHL_RSV_RESERVATIONS_PVT.Update_Reservation'
159: );
160: END IF;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: ELSE
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;

Line 162: RAISE FND_API.G_EXC_ERROR;

158: 'Returned success from AHL_RSV_RESERVATIONS_PVT.Update_Reservation'
159: );
160: END IF;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: ELSE
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

160: END IF;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: ELSE
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date
168: UPDATE AHL_SCHEDULE_MATERIALS

Line 199: RAISE FND_API.G_EXC_ERROR;

195:
196: -- Check Error Message stack.
197: x_msg_count := FND_MSG_PUB.count_msg;
198: IF x_msg_count > 0 THEN
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: -- Commit if p_commit = FND_API.G_TRUE
203: IF FND_API.TO_BOOLEAN(p_commit)

Line 202: -- Commit if p_commit = FND_API.G_TRUE

198: IF x_msg_count > 0 THEN
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: -- Commit if p_commit = FND_API.G_TRUE
203: IF FND_API.TO_BOOLEAN(p_commit)
204: THEN
205: COMMIT WORK;
206: IF (l_log_statement >= l_log_current_level) THEN

Line 203: IF FND_API.TO_BOOLEAN(p_commit)

199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: -- Commit if p_commit = FND_API.G_TRUE
203: IF FND_API.TO_BOOLEAN(p_commit)
204: THEN
205: COMMIT WORK;
206: IF (l_log_statement >= l_log_current_level) THEN
207: fnd_log.string

Line 222: p_encoded => FND_API.G_FALSE

218: FND_MSG_PUB.count_and_get
219: (
220: p_count => x_msg_count,
221: p_data => x_msg_data,
222: p_encoded => FND_API.G_FALSE
223: );
224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN

Line 226: WHEN FND_API.G_EXC_ERROR THEN

222: p_encoded => FND_API.G_FALSE
223: );
224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO Update_mtl_resv_dates_grp;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: FND_MSG_PUB.count_and_get
230: (

Line 228: x_return_status := FND_API.G_RET_STS_ERROR;

224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO Update_mtl_resv_dates_grp;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: FND_MSG_PUB.count_and_get
230: (
231: p_count => x_msg_count,
232: p_data => x_msg_data,

Line 233: p_encoded => FND_API.G_FALSE

229: FND_MSG_PUB.count_and_get
230: (
231: p_count => x_msg_count,
232: p_data => x_msg_data,
233: p_encoded => FND_API.G_FALSE
234: );
235:
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO Update_mtl_resv_dates_grp;

Line 236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

232: p_data => x_msg_data,
233: p_encoded => FND_API.G_FALSE
234: );
235:
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO Update_mtl_resv_dates_grp;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.count_and_get
240: (

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234: );
235:
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO Update_mtl_resv_dates_grp;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.count_and_get
240: (
241: p_count => x_msg_count,
242: p_data => x_msg_data,

Line 243: p_encoded => FND_API.G_FALSE

239: FND_MSG_PUB.count_and_get
240: (
241: p_count => x_msg_count,
242: p_data => x_msg_data,
243: p_encoded => FND_API.G_FALSE
244: );
245:
246: WHEN OTHERS THEN
247: ROLLBACK TO Update_mtl_resv_dates_grp;

Line 248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

244: );
245:
246: WHEN OTHERS THEN
247: ROLLBACK TO Update_mtl_resv_dates_grp;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.add_exc_msg
252: (

Line 262: p_encoded => FND_API.G_FALSE

258: FND_MSG_PUB.count_and_get
259: (
260: p_count => x_msg_count,
261: p_data => x_msg_data,
262: p_encoded => FND_API.G_FALSE
263: );
264: END Update_mtl_resv_dates;
265:
266: