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

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

27: -- Pre-reqs :
28: -- Parameters :
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
34: --
35: -- Standard OUT Parameters :

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

28: -- Parameters :
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
34: --
35: -- Standard OUT Parameters :
36: -- x_return_status OUT VARCHAR2 Required

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

29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
34: --
35: -- Standard OUT Parameters :
36: -- x_return_status OUT VARCHAR2 Required
37: -- x_msg_count OUT NUMBER Required

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

50: -- End of Comments --
51:
52:
53: PROCEDURE PROCESS_ITEM_GROUP(p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_commit IN VARCHAR2 := FND_API.G_FALSE,
56: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
57: p_module_type IN VARCHAR2 := NULL,
58: x_return_status OUT NOCOPY VARCHAR2,

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

51:
52:
53: PROCEDURE PROCESS_ITEM_GROUP(p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_commit IN VARCHAR2 := FND_API.G_FALSE,
56: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
57: p_module_type IN VARCHAR2 := NULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,

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

52:
53: PROCEDURE PROCESS_ITEM_GROUP(p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_commit IN VARCHAR2 := FND_API.G_FALSE,
56: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
57: p_module_type IN VARCHAR2 := NULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,

Line 99: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

95: -- Standard start of API savepoint
96: SAVEPOINT Process_Item_group_Pub;
97:
98: -- Standard call to check for call compatibility
99: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
100: G_PKG_NAME) THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

97:
98: -- Standard call to check for call compatibility
99: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
100: G_PKG_NAME) THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:
104: -- Initialize message list if p_init_msg_list is set to TRUE
105: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 105: IF FND_API.To_Boolean(p_init_msg_list) THEN

101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:
104: -- Initialize message list if p_init_msg_list is set to TRUE
105: IF FND_API.To_Boolean(p_init_msg_list) THEN
106: FND_MSG_PUB.Initialize;
107: END IF;
108:
109: -- Initialize API return status to success

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: FND_MSG_PUB.Initialize;
107: END IF;
108:
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
113: THEN
114: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 202: AND l_item_group_rec.status_code <> FND_API.G_MISS_CHAR

198:
199: END IF;
200:
201: IF l_item_group_rec.status_code IS NOT NULL
202: AND l_item_group_rec.status_code <> FND_API.G_MISS_CHAR
203: AND l_item_group_rec.status_code <> 'DRAFT'
204: THEN
205: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_CRE_DRAFT');
206: FND_MSG_PUB.ADD;

Line 235: (l_item_group_rec.item_group_id = FND_API.G_MISS_NUM)

231:
232: IF (l_item_group_rec.OPERATION_FLAG in ('M','D')) THEN
233: -- Convert group name to ID for Item_group_rec.
234: IF (l_item_group_rec.item_group_id IS NULL) OR
235: (l_item_group_rec.item_group_id = FND_API.G_MISS_NUM)
236: THEN
237: -- Check if group name exists.
238: IF (l_item_group_rec.name IS NOT NULL) AND
239: (l_item_group_rec.name <> FND_API.G_MISS_CHAR) THEN

Line 239: (l_item_group_rec.name <> FND_API.G_MISS_CHAR) THEN

235: (l_item_group_rec.item_group_id = FND_API.G_MISS_NUM)
236: THEN
237: -- Check if group name exists.
238: IF (l_item_group_rec.name IS NOT NULL) AND
239: (l_item_group_rec.name <> FND_API.G_MISS_CHAR) THEN
240: OPEN ahl_item_group_csr(l_item_group_rec.name);
241: FETCH ahl_item_group_csr INTO l_item_group_id,l_type_code;
242: IF (ahl_item_group_csr%FOUND) THEN
243: p_x_item_group_rec.item_group_id := l_item_group_id;

Line 293: (p_x_items_tbl(i).item_group_id = FND_API.G_MISS_NUM)

289: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
290:
291: -- For group name.
292: IF (p_x_items_tbl(i).item_group_id IS NULL) OR
293: (p_x_items_tbl(i).item_group_id = FND_API.G_MISS_NUM)
294: THEN
295: -- Check if assoc group name same as group_rec name.
296: IF (p_x_items_tbl(i).item_group_name = l_item_group_rec.name) THEN
297: p_x_items_tbl(i).item_group_id := p_x_item_group_rec.item_group_id;

Line 301: (p_x_items_tbl(i).item_group_name <> FND_API.G_MISS_CHAR) THEN

297: p_x_items_tbl(i).item_group_id := p_x_item_group_rec.item_group_id;
298: ELSE
299: -- if group name exists then it does not match group_rec.
300: IF (p_x_items_tbl(i).item_group_name IS NOT NULL) AND
301: (p_x_items_tbl(i).item_group_name <> FND_API.G_MISS_CHAR) THEN
302: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');
303: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
304: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_name);
305: FND_MSG_PUB.ADD;

Line 324: RAISE FND_API.G_EXC_ERROR;

320:
321: -- Check Error Message stack.
322: x_msg_count := FND_MSG_PUB.count_msg;
323: IF x_msg_count > 0 THEN
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326:
327:
328: IF p_x_item_group_rec.operation_flag ='C' THEN

Line 391: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

387: x_msg_data => x_msg_data );
388:
389: END IF;
390:
391: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: RAISE FND_API.G_EXC_ERROR;
393: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;

Line 392: RAISE FND_API.G_EXC_ERROR;

388:
389: END IF;
390:
391: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: RAISE FND_API.G_EXC_ERROR;
393: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:

Line 393: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

389: END IF;
390:
391: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: RAISE FND_API.G_EXC_ERROR;
393: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397: -- Standard check of p_commit

Line 394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

390:
391: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: RAISE FND_API.G_EXC_ERROR;
393: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397: -- Standard check of p_commit
398: IF FND_API.To_Boolean(p_commit) THEN

Line 398: IF FND_API.To_Boolean(p_commit) THEN

394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397: -- Standard check of p_commit
398: IF FND_API.To_Boolean(p_commit) THEN
399: COMMIT WORK;
400: END IF;
401:
402: -- Standard call to get message count and if count is 1, get message

Line 406: p_encoded => fnd_api.g_false);

402: -- Standard call to get message count and if count is 1, get message
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count,
405: p_data => x_msg_data,
406: p_encoded => fnd_api.g_false);
407:
408: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
409: THEN
410: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 416: WHEN FND_API.G_EXC_ERROR THEN

412: END IF;
413:
414: --
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: Rollback to Process_Item_group_Pub;
419: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
420: p_data => x_msg_data,

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413:
414: --
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: Rollback to Process_Item_group_Pub;
419: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
420: p_data => x_msg_data,
421: p_encoded => fnd_api.g_false);

Line 421: p_encoded => fnd_api.g_false);

417: x_return_status := FND_API.G_RET_STS_ERROR;
418: Rollback to Process_Item_group_Pub;
419: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
420: p_data => x_msg_data,
421: p_encoded => fnd_api.g_false);
422:
423: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
424: THEN
425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

426: 'ahl_mc_itemgroup_pub.process_item_group', 'Error in process_item_group');
427: END IF;
428:
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: Rollback to Process_Item_group_Pub;
433: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
434: p_data => x_msg_data,

Line 431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

427: END IF;
428:
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: Rollback to Process_Item_group_Pub;
433: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => fnd_api.g_false);

Line 435: p_encoded => fnd_api.g_false);

431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: Rollback to Process_Item_group_Pub;
433: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => fnd_api.g_false);
436: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
437: THEN
438: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
439: 'ahl_mc_itemgroup_pub.process_item_group', 'Unexpected Error in process_item_group');

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: 'ahl_mc_itemgroup_pub.process_item_group', 'Unexpected Error in process_item_group');
440: END IF;
441:
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: Rollback to Process_Item_group_Pub;
445: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
446: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
447: p_procedure_name => 'Process_Item_group',

Line 452: p_encoded => fnd_api.g_false);

448: p_error_text => SQLERRM);
449: END IF;
450: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
451: p_data => x_msg_data,
452: p_encoded => fnd_api.g_false);
453: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
454: THEN
455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
456: 'ahl_mc_itemgroup_pub.process_item_group', 'Unknown Error in process_item_group');

Line 528: (l_item_assoc_rec.inventory_org_id = FND_API.G_MISS_NUM)

524:
525:
526: -- For Inventory Organization Code.
527: IF (l_item_assoc_rec.inventory_org_id IS NULL) OR
528: (l_item_assoc_rec.inventory_org_id = FND_API.G_MISS_NUM)
529: THEN
530: -- if code is present.
531: IF (l_item_assoc_rec.inventory_org_code IS NOT NULL) AND
532: (l_item_assoc_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN

Line 532: (l_item_assoc_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN

528: (l_item_assoc_rec.inventory_org_id = FND_API.G_MISS_NUM)
529: THEN
530: -- if code is present.
531: IF (l_item_assoc_rec.inventory_org_code IS NOT NULL) AND
532: (l_item_assoc_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN
533: OPEN mtl_parameters_csr (l_item_assoc_rec.inventory_org_code);
534: FETCH mtl_parameters_csr INTO l_inventory_org_id;
535: IF (mtl_parameters_csr%FOUND) THEN
536: l_item_assoc_rec.inventory_org_id := l_inventory_org_id;

Line 553: (l_item_assoc_rec.inventory_item_id = FND_API.G_MISS_NUM)

549: END IF;
550:
551: -- For Inventory item.
552: IF (l_item_assoc_rec.inventory_item_id IS NULL) OR
553: (l_item_assoc_rec.inventory_item_id = FND_API.G_MISS_NUM)
554: THEN
555: -- check if name exists.
556: IF (l_item_assoc_rec.inventory_item_name IS NOT NULL) AND
557: (l_item_assoc_rec.inventory_item_name <> FND_API.G_MISS_CHAR) THEN

Line 557: (l_item_assoc_rec.inventory_item_name <> FND_API.G_MISS_CHAR) THEN

553: (l_item_assoc_rec.inventory_item_id = FND_API.G_MISS_NUM)
554: THEN
555: -- check if name exists.
556: IF (l_item_assoc_rec.inventory_item_name IS NOT NULL) AND
557: (l_item_assoc_rec.inventory_item_name <> FND_API.G_MISS_CHAR) THEN
558:
559: OPEN mtl_system_items_csr(l_item_assoc_rec.inventory_item_name,
560: l_item_assoc_rec.inventory_org_id);
561: FETCH mtl_system_items_csr INTO l_inventory_id;

Line 594: l_item_assoc_rec.priority = FND_API.G_MISS_NUM)

590: END IF;
591:
592: -- For priority
593: IF (l_item_assoc_rec.priority IS NULL OR
594: l_item_assoc_rec.priority = FND_API.G_MISS_NUM)
595: THEN
596: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_NULL');
597: FND_MESSAGE.Set_Token('INV_ITEM',l_item_assoc_rec.inventory_item_name);
598: FND_MSG_PUB.ADD;

Line 609: l_item_assoc_rec.item_association_id = FND_API.G_MISS_NUM) THEN

605:
606: -- Check if item association id exists; if not populate it.
607: IF (l_item_assoc_rec.operation_flag <> 'C') THEN
608: IF (l_item_assoc_rec.item_association_id IS NULL OR
609: l_item_assoc_rec.item_association_id = FND_API.G_MISS_NUM) THEN
610: OPEN ahl_item_associations_csr(l_item_assoc_rec.item_group_id,
611: l_item_assoc_rec.inventory_org_id,
612: l_item_assoc_rec.inventory_item_id);
613:

Line 626: (l_item_assoc_rec.interchange_type_code = FND_API.G_MISS_CHAR)

622: END IF; /* operation flag */
623:
624: -- For Interchange_type_meaning.
625: IF (l_item_assoc_rec.interchange_type_code IS NULL) OR
626: (l_item_assoc_rec.interchange_type_code = FND_API.G_MISS_CHAR)
627: THEN
628: -- Check if meaning exists.
629: IF (l_item_assoc_rec.Interchange_type_meaning IS NOT NULL) AND
630: (l_item_assoc_rec.Interchange_type_meaning <> FND_API.G_MISS_CHAR) THEN

Line 630: (l_item_assoc_rec.Interchange_type_meaning <> FND_API.G_MISS_CHAR) THEN

626: (l_item_assoc_rec.interchange_type_code = FND_API.G_MISS_CHAR)
627: THEN
628: -- Check if meaning exists.
629: IF (l_item_assoc_rec.Interchange_type_meaning IS NOT NULL) AND
630: (l_item_assoc_rec.Interchange_type_meaning <> FND_API.G_MISS_CHAR) THEN
631: AHL_UTIL_MC_PKG.Convert_To_LookupCode('AHL_INTERCHANGE_ITEM_TYPE',
632: l_item_assoc_rec.Interchange_type_meaning,
633: l_lookup_code,
634: l_return_val);