DBA Data[Home] [Help]

APPS.AHL_UTIL_UC_PKG dependencies on FND_MSG_PUB

Line 342: FND_MSG_PUB.ADD;

338: FETCH csi_txn_types_csr INTO l_txn_type_id;
339: IF (csi_txn_types_csr%NOTFOUND) THEN
340: FND_MESSAGE.Set_Name('AHL','AHL_UC_TXNCODE_INVALID');
341: FND_MESSAGE.Set_Token('CODE',p_txn_code);
342: FND_MSG_PUB.ADD;
343: --dbms_output.put_line('Transaction code not found');
344: l_return_val := FALSE;
345: END IF;
346: CLOSE csi_txn_types_csr;

Line 378: FND_MSG_PUB.ADD;

374: FETCH csi_instance_statuses_csr INTO l_instance_status_id;
375: IF (csi_instance_statuses_csr%NOTFOUND) THEN
376: FND_MESSAGE.Set_Name('AHL','AHL_UC_INST_STATUS_MISSING');
377: FND_MESSAGE.Set_Token('CODE',p_status_name);
378: FND_MSG_PUB.ADD;
379: --dbms_output.put_line('Status code not found');
380: l_return_val := FALSE;
381: END IF;
382: CLOSE csi_instance_statuses_csr;

Line 882: FND_MSG_PUB.ADD;

878: END IF;
879:
880: FND_MESSAGE.Set_Name('AHL','AHL_UC_INVGRP_MISMATCH');
881: FND_MESSAGE.Set_Token('POSN_REF',l_pos_ref_meaning);
882: FND_MSG_PUB.ADD;
883:
884: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
885: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item invalid for l_pos_ref_meaning => '||l_pos_ref_meaning);
886: END IF;

Line 954: FND_MSG_PUB.Initialize;

950:
951: BEGIN
952:
953: -- Initialize the message stack.
954: FND_MSG_PUB.Initialize;
955:
956: -- Call Validate for position procedure.
957: Validate_for_Position(p_mc_relationship_id => p_mc_relationship_id,
958: p_Inventory_id => p_Inventory_id,

Line 967: l_msg_count := FND_MSG_PUB.count_msg;

963: p_position_ref_meaning => NULL,
964: x_item_assoc_id => l_item_assoc_id);
965:
966: -- Check Error Message stack.
967: l_msg_count := FND_MSG_PUB.count_msg;
968: IF l_msg_count > 0 THEN
969: RETURN 0;
970: ELSE
971: RETURN l_item_assoc_id;

Line 1123: FND_MSG_PUB.ADD;

1119: END IF;
1120: CLOSE csi_item_instance_csr;
1121: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1122: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1123: FND_MSG_PUB.ADD;
1124: x_match_flag := FALSE;
1125: RETURN;
1126: END IF;
1127:

Line 1163: FND_MSG_PUB.ADD;

1159: l_inventory_revision, l_instance_number;
1160: IF (csi_item_instance_csr%NOTFOUND) THEN
1161: FND_MESSAGE.Set_Name('AHL','AHL_UC_CHILD_DELETED');
1162: FND_MESSAGE.Set_Token('CHILD', l_part_tbl(i).subject_id);
1163: FND_MSG_PUB.ADD;
1164: CLOSE csi_item_instance_csr;
1165: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167:

Line 1214: FND_MSG_PUB.ADD;

1210: l_instance_number := p_csi_item_instance_id;
1211: END IF;
1212: CLOSE csi_item_instance_csr;
1213: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1214: FND_MSG_PUB.ADD;
1215: x_match_flag := FALSE;
1216: END IF;
1217:
1218: -- set return parameters.

Line 1249: FND_MSG_PUB.ADD;

1245: END IF;
1246: CLOSE csi_item_instance_csr;
1247: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1248: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1249: FND_MSG_PUB.ADD;
1250: x_match_flag := FALSE;
1251:
1252: WHEN VALUE_ERROR THEN
1253: OPEN csi_item_instance_csr (p_csi_item_instance_id);

Line 1262: FND_MSG_PUB.ADD;

1258: END IF;
1259: CLOSE csi_item_instance_csr;
1260: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1261: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1262: FND_MSG_PUB.ADD;
1263: x_match_flag := FALSE;
1264:
1265:
1266: END Match_Tree_Components;

Line 1405: FND_MSG_PUB.Initialize;

1401: END IF;
1402:
1403: -- Initialize message list if p_init_msg_list is set to TRUE
1404: IF FND_API.To_Boolean(p_init_msg_list) THEN
1405: FND_MSG_PUB.Initialize;
1406: END IF;
1407:
1408: -- Initialize API return status to success
1409: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1509: x_msg_count := FND_MSG_PUB.count_msg;

1505:
1506: --Completed Processing
1507:
1508: -- Check Error Message stack.
1509: x_msg_count := FND_MSG_PUB.count_msg;
1510: IF x_msg_count > 0 THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:

Line 1516: FND_MSG_PUB.Count_And_Get

1512: END IF;
1513:
1514:
1515: -- Standard call to get message count and if count is 1, get message info
1516: FND_MSG_PUB.Count_And_Get
1517: ( p_count => x_msg_count,
1518: p_data => x_msg_data,
1519: p_encoded => fnd_api.g_false
1520: );

Line 1532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1528: EXCEPTION
1529: WHEN FND_API.G_EXC_ERROR THEN
1530: x_return_status := FND_API.G_RET_STS_ERROR;
1531: Rollback to Invalidate_Instance;
1532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1533: p_data => x_msg_data,
1534: p_encoded => fnd_api.g_false);
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1538: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1534: p_encoded => fnd_api.g_false);
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: Rollback to Invalidate_Instance;
1538: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1539: p_data => x_msg_data,
1540: p_encoded => fnd_api.g_false);
1541: WHEN OTHERS THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1544: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

1540: p_encoded => fnd_api.g_false);
1541: WHEN OTHERS THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: Rollback to Invalidate_Instance;
1544: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1545: p_procedure_name => 'Invalidate_Instance',
1546: p_error_text => SQLERRM);
1547:
1548: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1548: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1544: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1545: p_procedure_name => 'Invalidate_Instance',
1546: p_error_text => SQLERRM);
1547:
1548: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1549: p_data => x_msg_data,
1550: p_encoded => fnd_api.g_false);
1551: END Invalidate_Instance;
1552:

Line 2120: FND_MSG_PUB.add;

2116: IF get_top_unit%NOTFOUND THEN
2117: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
2118: FND_MESSAGE.set_token('NAME', 'uc_header_id');
2119: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
2120: FND_MSG_PUB.add;
2121: END IF;
2122: CLOSE get_top_unit;
2123: x_uc_header_id := l_uc_header_id;
2124: x_instance_id := l_instance_id;

Line 2729: FND_MSG_PUB.Initialize;

2725: END IF;
2726:
2727: -- Initialize message list if p_init_msg_list is set to TRUE
2728: IF FND_API.To_Boolean(p_init_msg_list) THEN
2729: FND_MSG_PUB.Initialize;
2730: END IF;
2731:
2732: -- Initialize API return status to success
2733: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2838: FND_MSG_PUB.ADD;

2834: END IF;
2835: FND_MESSAGE.Set_Token('UCLIST',l_valid_UC_lst);
2836: FND_MESSAGE.Set_Token('ITNAME',l_instance_tbl(i).concatenated_segments);
2837: FND_MESSAGE.Set_Token('ITREV',l_instance_tbl(i).revision);
2838: FND_MSG_PUB.ADD;
2839: END IF;
2840:
2841: END IF; -- c_check_item_group_csr%FOUND
2842: CLOSE c_check_item_group_csr;

Line 2854: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2850:
2851: EXCEPTION
2852: WHEN FND_API.G_EXC_ERROR THEN
2853: x_return_status := FND_API.G_RET_STS_ERROR;
2854: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2855: p_data => x_msg_data,
2856: p_encoded => fnd_api.g_false);
2857:
2858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2856: p_encoded => fnd_api.g_false);
2857:
2858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2861: p_data => x_msg_data,
2862: p_encoded => fnd_api.g_false);
2863:
2864: WHEN OTHERS THEN

Line 2866: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

2862: p_encoded => fnd_api.g_false);
2863:
2864: WHEN OTHERS THEN
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
2867: p_procedure_name => 'Check_Invalidate_Instance',
2868: p_error_text => SQLERRM);
2869:
2870: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2870: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2866: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
2867: p_procedure_name => 'Check_Invalidate_Instance',
2868: p_error_text => SQLERRM);
2869:
2870: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2871: p_data => x_msg_data,
2872: p_encoded => fnd_api.g_false);
2873:
2874: END Check_Invalidate_Instance;