DBA Data[Home] [Help]

APPS.AHL_UTIL_UC_PKG dependencies on FND_MESSAGE

Line 340: FND_MESSAGE.Set_Name('AHL','AHL_UC_TXNCODE_INVALID');

336: -- get transaction_type_id .
337: OPEN csi_txn_types_csr(p_txn_code);
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;

Line 341: FND_MESSAGE.Set_Token('CODE',p_txn_code);

337: OPEN csi_txn_types_csr(p_txn_code);
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;

Line 376: FND_MESSAGE.Set_Name('AHL','AHL_UC_INST_STATUS_MISSING');

372:
373: OPEN csi_instance_statuses_csr(p_status_name);
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;

Line 377: FND_MESSAGE.Set_Token('CODE',p_status_name);

373: OPEN csi_instance_statuses_csr(p_status_name);
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;

Line 880: FND_MESSAGE.Set_Name('AHL','AHL_UC_INVGRP_MISMATCH');

876: l_pos_ref_meaning := l_pos_ref_code;
877: END IF;
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

Line 881: FND_MESSAGE.Set_Token('POSN_REF',l_pos_ref_meaning);

877: END IF;
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);

Line 1121: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');

1117: IF (csi_item_instance_csr%NOTFOUND) THEN
1118: l_instance_number := p_csi_item_instance_id;
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;

Line 1122: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);

1118: l_instance_number := p_csi_item_instance_id;
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;

Line 1161: FND_MESSAGE.Set_Name('AHL','AHL_UC_CHILD_DELETED');

1157: OPEN csi_item_instance_csr (l_part_tbl(i).subject_id);
1158: FETCH csi_item_instance_csr INTO l_inventory_item_id, l_inventory_org_id, l_quantity, l_uom_code,
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;

Line 1162: FND_MESSAGE.Set_Token('CHILD', l_part_tbl(i).subject_id);

1158: FETCH csi_item_instance_csr INTO l_inventory_item_id, l_inventory_org_id, l_quantity, l_uom_code,
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;

Line 1204: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');

1200: END LOOP;
1201:
1202: -- the count on parts table should be zero else, add message to error stack.
1203: IF (l_part_tbl.COUNT <> 0) OR (x_match_flag = FALSE) THEN
1204: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1205: -- Get instance number to display error message.
1206: OPEN csi_item_instance_csr (p_csi_item_instance_id);
1207: FETCH csi_item_instance_csr INTO l_inventory_item_id, l_inventory_org_id, l_quantity, l_uom_code,
1208: l_inventory_revision, l_instance_number;

Line 1213: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);

1209: IF (csi_item_instance_csr%NOTFOUND) THEN
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:

Line 1247: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');

1243: IF (csi_item_instance_csr%NOTFOUND) THEN
1244: l_instance_number := p_csi_item_instance_id;
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:

Line 1248: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);

1244: l_instance_number := p_csi_item_instance_id;
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

Line 1260: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');

1256: IF (csi_item_instance_csr%NOTFOUND) THEN
1257: l_instance_number := p_csi_item_instance_id;
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:

Line 1261: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);

1257: l_instance_number := p_csi_item_instance_id;
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:

Line 2117: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');

2113: l_uc_status_code,
2114: l_active_uc_status_code,
2115: l_uc_header_ovn;
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;

Line 2118: FND_MESSAGE.set_token('NAME', 'uc_header_id');

2114: l_active_uc_status_code,
2115: l_uc_header_ovn;
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;

Line 2119: FND_MESSAGE.set_token('VALUE', p_uc_header_id);

2115: l_uc_header_ovn;
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;

Line 2830: FND_MESSAGE.Set_Name('AHL','AHL_UC_DEL_INVALID');

2826: END IF;
2827:
2828: -- putting the error msg with the token in the stack
2829: IF (p_operator = 'D') THEN
2830: FND_MESSAGE.Set_Name('AHL','AHL_UC_DEL_INVALID');
2831: ELSIF (p_operator = 'U') THEN
2832: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2833: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
2834: END IF;

Line 2832: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');

2828: -- putting the error msg with the token in the stack
2829: IF (p_operator = 'D') THEN
2830: FND_MESSAGE.Set_Name('AHL','AHL_UC_DEL_INVALID');
2831: ELSIF (p_operator = 'U') THEN
2832: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2833: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
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);

Line 2833: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);

2829: IF (p_operator = 'D') THEN
2830: FND_MESSAGE.Set_Name('AHL','AHL_UC_DEL_INVALID');
2831: ELSIF (p_operator = 'U') THEN
2832: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2833: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
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);

Line 2835: FND_MESSAGE.Set_Token('UCLIST',l_valid_UC_lst);

2831: ELSIF (p_operator = 'U') THEN
2832: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2833: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
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;

Line 2836: FND_MESSAGE.Set_Token('ITNAME',l_instance_tbl(i).concatenated_segments);

2832: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2833: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
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:

Line 2837: FND_MESSAGE.Set_Token('ITREV',l_instance_tbl(i).revision);

2833: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
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