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_MATERIALS_GRP dependencies on FND_API

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

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

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

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

Line 47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

43:
44: PROCEDURE GET_WO_ALTERNATES
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,

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

44: PROCEDURE GET_WO_ALTERNATES
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,
52: p_wip_entity_id IN NUMBER,

Line 60: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

56: l_api_version CONSTANT NUMBER := 1.0;
57: l_api_name CONSTANT VARCHAR2(30) := 'get_wo_alternates';
58: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || l_api_name;
59:
60: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
61: l_prev_err_count NUMBER;
62: l_visit_task_id NUMBER;
63: l_alt_item_id NUMBER;
64: l_priority NUMBER;

Line 91: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )

87: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure. p_wip_entity_id = ' || p_wip_entity_id);
88: END IF;
89:
90: -- Standard call to check for call compatibility
91: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )
92: THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:

Line 93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89:
90: -- Standard call to check for call compatibility
91: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )
92: THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: -- Initialize message list if p_init_msg_list is set to TRUE
97: IF FND_API.To_Boolean(p_init_msg_list)

Line 97: IF FND_API.To_Boolean(p_init_msg_list)

93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: -- Initialize message list if p_init_msg_list is set to TRUE
97: IF FND_API.To_Boolean(p_init_msg_list)
98: THEN
99: FND_MSG_PUB.Initialize;
100: END IF;
101:

Line 105: x_return_status := FND_API.G_RET_STS_SUCCESS;

101:
102: l_prev_err_count := NVL(FND_MSG_PUB.count_msg, 0);
103:
104: -- Initialize API return status to success
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: -- Begin Processing
108: -- From AHL_WORKORDERS, get the visit_task_id for the wip_entity_id
109: OPEN get_visit_task_id_csr(p_wip_entity_id);

Line 138: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;

134: x_msg_data => x_msg_data);
135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || x_return_status);
137: END IF;
138: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
139: IF (l_alt_items IS NULL OR l_alt_items.COUNT = 0) THEN
140: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'No alternate items available for this requirement.');
142: END IF;

Line 179: RAISE FND_API.G_EXC_ERROR;

175: -- Check Error Message stack.
176: x_msg_count := FND_MSG_PUB.count_msg;
177:
178: IF x_msg_count - l_prev_err_count > 0 THEN
179: RAISE FND_API.G_EXC_ERROR;
180: END IF;
181:
182: -- Standard call to get message count and if count is 1, get message info
183: FND_MSG_PUB.Count_And_Get

Line 186: p_encoded => fnd_api.g_false

182: -- Standard call to get message count and if count is 1, get message info
183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count,
185: p_data => x_msg_data,
186: p_encoded => fnd_api.g_false
187: );
188:
189: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end. Number of rows in the Output table: ' || (l_tbl_index - 1), 'End Procedure');

Line 194: WHEN FND_API.G_EXC_ERROR THEN

190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end. Number of rows in the Output table: ' || (l_tbl_index - 1), 'End Procedure');
191: END IF;
192:
193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
197: p_data => x_msg_data,
198: p_encoded => fnd_api.g_false);

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: END IF;
192:
193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
197: p_data => x_msg_data,
198: p_encoded => fnd_api.g_false);
199: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 198: p_encoded => fnd_api.g_false);

194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
197: p_data => x_msg_data,
198: p_encoded => fnd_api.g_false);
199: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Error: ' || x_msg_data);
201: END IF;
202:

Line 203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

199: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Error: ' || x_msg_data);
201: END IF;
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
206: p_data => x_msg_data,
207: p_encoded => fnd_api.g_false);

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Error: ' || x_msg_data);
201: END IF;
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
206: p_data => x_msg_data,
207: p_encoded => fnd_api.g_false);
208:

Line 207: p_encoded => fnd_api.g_false);

203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
206: p_data => x_msg_data,
207: p_encoded => fnd_api.g_false);
208:
209: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
211: END IF;

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

210: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
211: END IF;
212:
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
216: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
217: p_procedure_name => l_api_name,
218: p_error_text => SUBSTR(SQLERRM,1,500));

Line 222: p_encoded => fnd_api.g_false);

218: p_error_text => SUBSTR(SQLERRM,1,500));
219: END IF;
220: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
221: p_data => x_msg_data,
222: p_encoded => fnd_api.g_false);
223:
224: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Other Exception: ' || x_msg_data);
226: END IF;

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

235: -- Parameters :
236: --
237: -- Standard IN Parameters :
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
240: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
242: --
243: -- Standard OUT Parameters :

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

236: --
237: -- Standard IN Parameters :
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
240: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
242: --
243: -- Standard OUT Parameters :
244: -- x_return_status OUT VARCHAR2 Required

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

237: -- Standard IN Parameters :
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
240: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
242: --
243: -- Standard OUT Parameters :
244: -- x_return_status OUT VARCHAR2 Required
245: -- x_msg_count OUT NUMBER Required

Line 262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

258:
259: PROCEDURE UPDATE_WO_MATERIALS
260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,

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

259: PROCEDURE UPDATE_WO_MATERIALS
260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,

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

260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_wip_entity_id IN NUMBER,

Line 276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

272: l_api_version CONSTANT NUMBER := 1.0;
273: l_api_name CONSTANT VARCHAR2(30) := 'update_wo_materials';
274: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || l_api_name;
275:
276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
277: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
278: l_commit VARCHAR2(1) := FND_API.G_FALSE;
279: l_prev_err_count NUMBER;
280: l_requested_date DATE;

Line 277: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

273: l_api_name CONSTANT VARCHAR2(30) := 'update_wo_materials';
274: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || l_api_name;
275:
276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
277: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
278: l_commit VARCHAR2(1) := FND_API.G_FALSE;
279: l_prev_err_count NUMBER;
280: l_requested_date DATE;
281: l_scheduled_material_id NUMBER;

Line 278: l_commit VARCHAR2(1) := FND_API.G_FALSE;

274: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || l_api_name;
275:
276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
277: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
278: l_commit VARCHAR2(1) := FND_API.G_FALSE;
279: l_prev_err_count NUMBER;
280: l_requested_date DATE;
281: l_scheduled_material_id NUMBER;
282: i NUMBER;

Line 324: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )

320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure. p_wip_entity_id = ' || p_wip_entity_id);
321: END IF;
322:
323: -- Standard call to check for call compatibility
324: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )
325: THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:

Line 326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

322:
323: -- Standard call to check for call compatibility
324: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME )
325: THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329: -- Initialize message list if p_init_msg_list is set to TRUE
330: IF FND_API.To_Boolean(p_init_msg_list)

Line 330: IF FND_API.To_Boolean(p_init_msg_list)

326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329: -- Initialize message list if p_init_msg_list is set to TRUE
330: IF FND_API.To_Boolean(p_init_msg_list)
331: THEN
332: FND_MSG_PUB.Initialize;
333: END IF;
334:

Line 338: x_return_status := FND_API.G_RET_STS_SUCCESS;

334:
335: l_prev_err_count := NVL(FND_MSG_PUB.count_msg,0);
336:
337: -- Initialize API return status to success
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:
340: -- Begin Processing
341: -- Get the scheduled start date for the given wip_entity_id into l_requested_date
342: OPEN get_scheduled_start_date;

Line 350: RAISE FND_API.G_EXC_ERROR;

346: -- then the wip entity id passed to this procedure is invalid
347: IF l_requested_date IS NULL THEN
348: Fnd_Message.SET_NAME('AHL','AHL_LTP_WIP_ENTITY_ID_INVLD');
349: Fnd_Msg_Pub.ADD;
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352:
353: IF (p_alt_item_tbl IS NULL OR p_alt_item_tbl.COUNT = 0) THEN
354: -- Only Date Change, No Item Change

Line 386: p_init_msg_list => FND_API.G_FALSE,

382: -- This API updates all the reservation dates, if l_requested_date
383: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different
384: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
385: p_api_version => 1.0,
386: p_init_msg_list => FND_API.G_FALSE,
387: p_commit => FND_API.G_FALSE,
388: p_module_type => NULL,
389: x_return_status => l_return_status,
390: x_msg_count => x_msg_count,

Line 387: p_commit => FND_API.G_FALSE,

383: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different
384: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
385: p_api_version => 1.0,
386: p_init_msg_list => FND_API.G_FALSE,
387: p_commit => FND_API.G_FALSE,
388: p_module_type => NULL,
389: x_return_status => l_return_status,
390: x_msg_count => x_msg_count,
391: x_msg_data => x_msg_data,

Line 394: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

390: x_msg_count => x_msg_count,
391: x_msg_data => x_msg_data,
392: p_scheduled_material_id => l_scheduled_material_id,
393: p_requested_date => l_requested_date);
394: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned success from AHL_RSV_RESERVATIONS_PVT.Update_Reservation');
397: END IF;
398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

394: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned success from AHL_RSV_RESERVATIONS_PVT.Update_Reservation');
397: END IF;
398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
399: RAISE FND_API.G_EXC_ERROR;
400: ELSE
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;

Line 399: RAISE FND_API.G_EXC_ERROR;

395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned success from AHL_RSV_RESERVATIONS_PVT.Update_Reservation');
397: END IF;
398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
399: RAISE FND_API.G_EXC_ERROR;
400: ELSE
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

397: END IF;
398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
399: RAISE FND_API.G_EXC_ERROR;
400: ELSE
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date
405: UPDATE AHL_SCHEDULE_MATERIALS

Line 463: RAISE FND_API.G_EXC_ERROR;

459: -- Check Error Message stack.
460: x_msg_count := FND_MSG_PUB.count_msg;
461:
462: IF x_msg_count - l_prev_err_count > 0 THEN
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;
465:
466: -- Standard check of p_commit
467: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 467: IF FND_API.TO_BOOLEAN(p_commit) THEN

463: RAISE FND_API.G_EXC_ERROR;
464: END IF;
465:
466: -- Standard check of p_commit
467: IF FND_API.TO_BOOLEAN(p_commit) THEN
468: COMMIT WORK;
469: END IF;
470:
471: -- Standard call to get message count and if count is 1, get message info

Line 475: p_encoded => fnd_api.g_false

471: -- Standard call to get message count and if count is 1, get message info
472: FND_MSG_PUB.Count_And_Get
473: ( p_count => x_msg_count,
474: p_data => x_msg_data,
475: p_encoded => fnd_api.g_false
476: );
477:
478: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
480: END IF;
481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: Rollback to update_wo_materials_pvt;
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
487: p_data => x_msg_data,

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: Rollback to update_wo_materials_pvt;
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
487: p_data => x_msg_data,
488: p_encoded => fnd_api.g_false);
489: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 488: p_encoded => fnd_api.g_false);

484: Rollback to update_wo_materials_pvt;
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
487: p_data => x_msg_data,
488: p_encoded => fnd_api.g_false);
489: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Error: ' || x_msg_data);
491: END IF;
492:

Line 493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

489: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Error: ' || x_msg_data);
491: END IF;
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: Rollback to update_wo_materials_pvt;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
497: p_data => x_msg_data,

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

491: END IF;
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: Rollback to update_wo_materials_pvt;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
497: p_data => x_msg_data,
498: p_encoded => fnd_api.g_false);
499: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 498: p_encoded => fnd_api.g_false);

494: Rollback to update_wo_materials_pvt;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
497: p_data => x_msg_data,
498: p_encoded => fnd_api.g_false);
499: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
501: END IF;
502:

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

501: END IF;
502:
503: WHEN OTHERS THEN
504: Rollback to update_wo_materials_pvt;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
507: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
508: p_procedure_name => l_api_name,
509: p_error_text => SUBSTR(SQLERRM,1,500));

Line 513: p_encoded => fnd_api.g_false);

509: p_error_text => SUBSTR(SQLERRM,1,500));
510: END IF;
511: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
512: p_data => x_msg_data,
513: p_encoded => fnd_api.g_false);
514: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
515: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Other Exception: ' || x_msg_data);
516: END IF;
517: