DBA Data[Home] [Help]

APPS.AHL_UTIL_UC_PKG dependencies on FND_MESSAGE

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

331: -- get transaction_type_id .
332: OPEN csi_txn_types_csr(p_txn_code);
333: FETCH csi_txn_types_csr INTO l_txn_type_id;
334: IF (csi_txn_types_csr%NOTFOUND) THEN
335: FND_MESSAGE.Set_Name('AHL','AHL_UC_TXNCODE_INVALID');
336: FND_MESSAGE.Set_Token('CODE',p_txn_code);
337: FND_MSG_PUB.ADD;
338: --dbms_output.put_line('Transaction code not found');
339: l_return_val := FALSE;

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

332: OPEN csi_txn_types_csr(p_txn_code);
333: FETCH csi_txn_types_csr INTO l_txn_type_id;
334: IF (csi_txn_types_csr%NOTFOUND) THEN
335: FND_MESSAGE.Set_Name('AHL','AHL_UC_TXNCODE_INVALID');
336: FND_MESSAGE.Set_Token('CODE',p_txn_code);
337: FND_MSG_PUB.ADD;
338: --dbms_output.put_line('Transaction code not found');
339: l_return_val := FALSE;
340: END IF;

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

367:
368: OPEN csi_instance_statuses_csr(p_status_name);
369: FETCH csi_instance_statuses_csr INTO l_instance_status_id;
370: IF (csi_instance_statuses_csr%NOTFOUND) THEN
371: FND_MESSAGE.Set_Name('AHL','AHL_UC_INST_STATUS_MISSING');
372: FND_MESSAGE.Set_Token('CODE',p_status_name);
373: FND_MSG_PUB.ADD;
374: --dbms_output.put_line('Status code not found');
375: l_return_val := FALSE;

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

368: OPEN csi_instance_statuses_csr(p_status_name);
369: FETCH csi_instance_statuses_csr INTO l_instance_status_id;
370: IF (csi_instance_statuses_csr%NOTFOUND) THEN
371: FND_MESSAGE.Set_Name('AHL','AHL_UC_INST_STATUS_MISSING');
372: FND_MESSAGE.Set_Token('CODE',p_status_name);
373: FND_MSG_PUB.ADD;
374: --dbms_output.put_line('Status code not found');
375: l_return_val := FALSE;
376: END IF;

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

871: l_pos_ref_meaning := l_pos_ref_code;
872: END IF;
873: END IF;
874:
875: FND_MESSAGE.Set_Name('AHL','AHL_UC_INVGRP_MISMATCH');
876: FND_MESSAGE.Set_Token('POSN_REF',l_pos_ref_meaning);
877: FND_MSG_PUB.ADD;
878:
879: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

872: END IF;
873: END IF;
874:
875: FND_MESSAGE.Set_Name('AHL','AHL_UC_INVGRP_MISMATCH');
876: FND_MESSAGE.Set_Token('POSN_REF',l_pos_ref_meaning);
877: FND_MSG_PUB.ADD;
878:
879: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
880: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item invalid for l_pos_ref_meaning => '||l_pos_ref_meaning);

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

1112: IF (csi_item_instance_csr%NOTFOUND) THEN
1113: l_instance_number := p_csi_item_instance_id;
1114: END IF;
1115: CLOSE csi_item_instance_csr;
1116: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1117: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1118: FND_MSG_PUB.ADD;
1119: x_match_flag := FALSE;
1120: RETURN;

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

1113: l_instance_number := p_csi_item_instance_id;
1114: END IF;
1115: CLOSE csi_item_instance_csr;
1116: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1117: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1118: FND_MSG_PUB.ADD;
1119: x_match_flag := FALSE;
1120: RETURN;
1121: END IF;

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

1152: OPEN csi_item_instance_csr (l_part_tbl(i).subject_id);
1153: FETCH csi_item_instance_csr INTO l_inventory_item_id, l_inventory_org_id, l_quantity, l_uom_code,
1154: l_inventory_revision, l_instance_number;
1155: IF (csi_item_instance_csr%NOTFOUND) THEN
1156: FND_MESSAGE.Set_Name('AHL','AHL_UC_CHILD_DELETED');
1157: FND_MESSAGE.Set_Token('CHILD', l_part_tbl(i).subject_id);
1158: FND_MSG_PUB.ADD;
1159: CLOSE csi_item_instance_csr;
1160: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

1153: FETCH csi_item_instance_csr INTO l_inventory_item_id, l_inventory_org_id, l_quantity, l_uom_code,
1154: l_inventory_revision, l_instance_number;
1155: IF (csi_item_instance_csr%NOTFOUND) THEN
1156: FND_MESSAGE.Set_Name('AHL','AHL_UC_CHILD_DELETED');
1157: FND_MESSAGE.Set_Token('CHILD', l_part_tbl(i).subject_id);
1158: FND_MSG_PUB.ADD;
1159: CLOSE csi_item_instance_csr;
1160: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;

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

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

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

1204: IF (csi_item_instance_csr%NOTFOUND) THEN
1205: l_instance_number := p_csi_item_instance_id;
1206: END IF;
1207: CLOSE csi_item_instance_csr;
1208: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1209: FND_MSG_PUB.ADD;
1210: x_match_flag := FALSE;
1211: END IF;
1212:

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

1238: IF (csi_item_instance_csr%NOTFOUND) THEN
1239: l_instance_number := p_csi_item_instance_id;
1240: END IF;
1241: CLOSE csi_item_instance_csr;
1242: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1243: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1244: FND_MSG_PUB.ADD;
1245: x_match_flag := FALSE;
1246:

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

1239: l_instance_number := p_csi_item_instance_id;
1240: END IF;
1241: CLOSE csi_item_instance_csr;
1242: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1243: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1244: FND_MSG_PUB.ADD;
1245: x_match_flag := FALSE;
1246:
1247: WHEN VALUE_ERROR THEN

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

1251: IF (csi_item_instance_csr%NOTFOUND) THEN
1252: l_instance_number := p_csi_item_instance_id;
1253: END IF;
1254: CLOSE csi_item_instance_csr;
1255: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1256: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1257: FND_MSG_PUB.ADD;
1258: x_match_flag := FALSE;
1259:

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

1252: l_instance_number := p_csi_item_instance_id;
1253: END IF;
1254: CLOSE csi_item_instance_csr;
1255: FND_MESSAGE.Set_Name('AHL','AHL_UC_SUBTREE_MISMATCH');
1256: FND_MESSAGE.Set_Token('INSTANCE',l_instance_number);
1257: FND_MSG_PUB.ADD;
1258: x_match_flag := FALSE;
1259:
1260:

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

2108: l_uc_status_code,
2109: l_active_uc_status_code,
2110: l_uc_header_ovn;
2111: IF get_top_unit%NOTFOUND THEN
2112: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
2113: FND_MESSAGE.set_token('NAME', 'uc_header_id');
2114: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
2115: FND_MSG_PUB.add;
2116: END IF;

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

2109: l_active_uc_status_code,
2110: l_uc_header_ovn;
2111: IF get_top_unit%NOTFOUND THEN
2112: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
2113: FND_MESSAGE.set_token('NAME', 'uc_header_id');
2114: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
2115: FND_MSG_PUB.add;
2116: END IF;
2117: CLOSE get_top_unit;

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

2110: l_uc_header_ovn;
2111: IF get_top_unit%NOTFOUND THEN
2112: FND_MESSAGE.set_name( 'AHL','AHL_UC_API_PARAMETER_INVALID');
2113: FND_MESSAGE.set_token('NAME', 'uc_header_id');
2114: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
2115: FND_MSG_PUB.add;
2116: END IF;
2117: CLOSE get_top_unit;
2118: x_uc_header_id := l_uc_header_id;

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

2821: END IF;
2822:
2823: -- putting the error msg with the token in the stack
2824: IF (p_operator = 'D') THEN
2825: FND_MESSAGE.Set_Name('AHL','AHL_UC_DEL_INVALID');
2826: ELSIF (p_operator = 'U') THEN
2827: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2828: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
2829: END IF;

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

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

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

2824: IF (p_operator = 'D') THEN
2825: FND_MESSAGE.Set_Name('AHL','AHL_UC_DEL_INVALID');
2826: ELSIF (p_operator = 'U') THEN
2827: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2828: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
2829: END IF;
2830: FND_MESSAGE.Set_Token('UCLIST',l_valid_UC_lst);
2831: FND_MESSAGE.Set_Token('ITNAME',l_instance_tbl(i).concatenated_segments);
2832: FND_MESSAGE.Set_Token('ITREV',l_instance_tbl(i).revision);

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

2826: ELSIF (p_operator = 'U') THEN
2827: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2828: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
2829: END IF;
2830: FND_MESSAGE.Set_Token('UCLIST',l_valid_UC_lst);
2831: FND_MESSAGE.Set_Token('ITNAME',l_instance_tbl(i).concatenated_segments);
2832: FND_MESSAGE.Set_Token('ITREV',l_instance_tbl(i).revision);
2833: FND_MSG_PUB.ADD;
2834: END IF;

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

2827: FND_MESSAGE.Set_Name('AHL','AHL_UC_UPD_INVALID');
2828: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
2829: END IF;
2830: FND_MESSAGE.Set_Token('UCLIST',l_valid_UC_lst);
2831: FND_MESSAGE.Set_Token('ITNAME',l_instance_tbl(i).concatenated_segments);
2832: FND_MESSAGE.Set_Token('ITREV',l_instance_tbl(i).revision);
2833: FND_MSG_PUB.ADD;
2834: END IF;
2835:

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

2828: FND_MESSAGE.Set_Token('INTCHG',l_instance_tbl(i).interchange_type);
2829: END IF;
2830: FND_MESSAGE.Set_Token('UCLIST',l_valid_UC_lst);
2831: FND_MESSAGE.Set_Token('ITNAME',l_instance_tbl(i).concatenated_segments);
2832: FND_MESSAGE.Set_Token('ITREV',l_instance_tbl(i).revision);
2833: FND_MSG_PUB.ADD;
2834: END IF;
2835:
2836: END IF; -- c_check_item_group_csr%FOUND