APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on FND_API

Line 61: , p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE

57: *********************************************************************/
58:
59: PROCEDURE Check_Shortage
60: (p_api_version IN NUMBER
61: , p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE
62: , p_commit IN VARCHAR2 := FND_API.G_FALSE
63: , x_return_status OUT NOCOPY VARCHAR2
64: , x_msg_count OUT NOCOPY NUMBER
65: , x_msg_data OUT NOCOPY VARCHAR2

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

58:
59: PROCEDURE Check_Shortage
60: (p_api_version IN NUMBER
61: , p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE
62: , p_commit IN VARCHAR2 := FND_API.G_FALSE
63: , x_return_status OUT NOCOPY VARCHAR2
64: , x_msg_count OUT NOCOPY NUMBER
65: , x_msg_data OUT NOCOPY VARCHAR2
66: , p_wip_entity_id IN NUMBER

Line 152: IF NOT FND_API.Compatible_API_Call (l_api_version

148:
149: -- Standard Start of API savepoint
150: SAVEPOINT Check_Shortage_Start;
151:
152: IF NOT FND_API.Compatible_API_Call (l_api_version
153: ,p_api_version
154: ,l_api_name
155: ,G_PKG_NAME)
156: THEN

Line 157: x_return_status := FND_API.g_ret_sts_unexp_error;

153: ,p_api_version
154: ,l_api_name
155: ,G_PKG_NAME)
156: THEN
157: x_return_status := FND_API.g_ret_sts_unexp_error;
158: RAISE l_unexpected_excep;
159: END IF;
160:
161: -- Check p_init_msg_list

Line 162: IF FND_API.to_Boolean( p_init_msg_lst ) THEN

158: RAISE l_unexpected_excep;
159: END IF;
160:
161: -- Check p_init_msg_list
162: IF FND_API.to_Boolean( p_init_msg_lst ) THEN
163: FND_MSG_PUB.initialize;
164: END IF;
165:
166: -- Initialize API return status to success

Line 167: x_return_status := FND_API.G_RET_STS_SUCCESS;

163: FND_MSG_PUB.initialize;
164: END IF;
165:
166: -- Initialize API return status to success
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168: x_shortage_exists := 'N';
169:
170: OPEN wip_entity_name_csr(p_wip_entity_id);
171: FETCH wip_entity_name_csr INTO l_wip_entity_name;

Line 221: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

217: , p_is_serial_control => l_is_serial_control
218: , p_asset_sub_only => l_asset_sub_only
219: , x_tree_id => x_tree_id);
220:
221: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
222: RAISE l_unexpected_excep;
223: END IF;
224:
225: Inv_Quantity_Tree_Grp.query_tree

Line 245: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

241: , x_atr => x_atr
242: , p_transfer_subinventory_code => null
243: );
244:
245: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
246: RAISE l_unexpected_excep;
247: END IF;
248:
249: END IF;

Line 279: IF FND_API.To_Boolean( p_commit ) THEN

275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || to_char(p_materials_csr.open_quantity - x_att )|| '');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
277:
278: ELSE
279: IF FND_API.To_Boolean( p_commit ) THEN
280: COMMIT;
281: END IF;
282: RETURN;
283: END IF;

Line 329: IF FND_API.To_Boolean( p_commit ) THEN

325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.open_quantity || '');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
327:
328: ELSE
329: IF FND_API.To_Boolean( p_commit ) THEN
330: COMMIT;
331: END IF;
332: RETURN;
333: END IF;

Line 358: IF FND_API.To_Boolean( p_commit ) THEN

354: last_update_login = fnd_global.login_id
355: WHERE wip_entity_id = p_wip_entity_id;
356: END IF;
357:
358: IF FND_API.To_Boolean( p_commit ) THEN
359: COMMIT;
360: END IF;
361:
362: EXCEPTION

Line 363: WHEN FND_API.G_EXC_ERROR THEN

359: COMMIT;
360: END IF;
361:
362: EXCEPTION
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO Check_Shortage_Start;
365: FND_MSG_PUB.Count_And_Get
366: (p_count => x_msg_count,
367: p_data => x_msg_data

Line 369: x_return_status := FND_API.G_RET_STS_ERROR ;

365: FND_MSG_PUB.Count_And_Get
366: (p_count => x_msg_count,
367: p_data => x_msg_data
368: );
369: x_return_status := FND_API.G_RET_STS_ERROR ;
370:
371: IF (p_source_api = 'Concurrent') THEN
372: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
373: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');

Line 384: IF FND_API.To_Boolean( p_commit ) THEN

380: last_update_date = sysdate,
381: last_updated_by = fnd_global.user_id,
382: last_update_login = fnd_global.login_id
383: WHERE wip_entity_id = p_wip_entity_id;
384: IF FND_API.To_Boolean( p_commit ) THEN
385: COMMIT;
386: END IF;
387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

384: IF FND_API.To_Boolean( p_commit ) THEN
385: COMMIT;
386: END IF;
387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: ROLLBACK TO Check_Shortage_Start;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: (p_count => x_msg_count,

Line 390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

386: END IF;
387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: ROLLBACK TO Check_Shortage_Start;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: (p_count => x_msg_count,
393: p_data => x_msg_data
394: );

Line 408: IF FND_API.To_Boolean( p_commit ) THEN

404: last_update_date = sysdate,
405: last_updated_by = fnd_global.user_id,
406: last_update_login = fnd_global.login_id
407: WHERE wip_entity_id = p_wip_entity_id;
408: IF FND_API.To_Boolean( p_commit ) THEN
409: COMMIT;
410: END IF;
411: WHEN OTHERS THEN
412: ROLLBACK TO Check_Shortage_Start;

Line 413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

409: COMMIT;
410: END IF;
411: WHEN OTHERS THEN
412: ROLLBACK TO Check_Shortage_Start;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
414: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
415: FND_MSG_PUB.Add_Exc_Msg
416: (G_PKG_NAME,
417: l_api_name

Line 437: IF FND_API.To_Boolean( p_commit ) THEN

433: last_update_date = sysdate,
434: last_updated_by = fnd_global.user_id,
435: last_update_login = fnd_global.login_id
436: WHERE wip_entity_id = p_wip_entity_id;
437: IF FND_API.To_Boolean( p_commit ) THEN
438: COMMIT;
439: END IF;
440: END Check_Shortage;
441: