15: BEGIN
16:
17: IF (NVL(p_value,FND_API.g_miss_num) = FND_API.g_miss_num) THEN
18:
19: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
20: FND_MESSAGE.set_token('API_NAME',p_api_name);
21: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
22: FND_MSG_PUB.add;
23: RAISE FND_API.g_exc_error;
16:
17: IF (NVL(p_value,FND_API.g_miss_num) = FND_API.g_miss_num) THEN
18:
19: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
20: FND_MESSAGE.set_token('API_NAME',p_api_name);
21: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
22: FND_MSG_PUB.add;
23: RAISE FND_API.g_exc_error;
24:
17: IF (NVL(p_value,FND_API.g_miss_num) = FND_API.g_miss_num) THEN
18:
19: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
20: FND_MESSAGE.set_token('API_NAME',p_api_name);
21: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
22: FND_MSG_PUB.add;
23: RAISE FND_API.g_exc_error;
24:
25: END IF;
34: BEGIN
35:
36: IF (NVL(p_value,FND_API.g_miss_char) = FND_API.g_miss_char) THEN
37:
38: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
39: FND_MESSAGE.set_token('API_NAME',p_api_name);
40: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
41: FND_MSG_PUB.add;
42: RAISE FND_API.g_exc_error;
35:
36: IF (NVL(p_value,FND_API.g_miss_char) = FND_API.g_miss_char) THEN
37:
38: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
39: FND_MESSAGE.set_token('API_NAME',p_api_name);
40: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
41: FND_MSG_PUB.add;
42: RAISE FND_API.g_exc_error;
43:
36: IF (NVL(p_value,FND_API.g_miss_char) = FND_API.g_miss_char) THEN
37:
38: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
39: FND_MESSAGE.set_token('API_NAME',p_api_name);
40: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
41: FND_MSG_PUB.add;
42: RAISE FND_API.g_exc_error;
43:
44: END IF;
53: BEGIN
54:
55: IF (NVL(p_value,FND_API.g_miss_date) = FND_API.g_miss_date) THEN
56:
57: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
58: FND_MESSAGE.set_token('API_NAME',p_api_name);
59: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
60: FND_MSG_PUB.add;
61: RAISE FND_API.g_exc_error;
54:
55: IF (NVL(p_value,FND_API.g_miss_date) = FND_API.g_miss_date) THEN
56:
57: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
58: FND_MESSAGE.set_token('API_NAME',p_api_name);
59: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
60: FND_MSG_PUB.add;
61: RAISE FND_API.g_exc_error;
62:
55: IF (NVL(p_value,FND_API.g_miss_date) = FND_API.g_miss_date) THEN
56:
57: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
58: FND_MESSAGE.set_token('API_NAME',p_api_name);
59: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
60: FND_MSG_PUB.add;
61: RAISE FND_API.g_exc_error;
62:
63: END IF;
661: l_dtl_organization_id := l_inst_organization_id;
662:
663: EXCEPTION
664: WHEN no_data_found THEN
665: fnd_message.set_name('CSI', 'CSI_API_INVALID_INSTANCE_ID');
666: fnd_message.set_token('INSTANCE_ID',
667: p_txn_line_dtl_tbl(l_index).instance_id);
668: fnd_msg_pub.add;
669: RAISE fnd_api.g_exc_error;
662:
663: EXCEPTION
664: WHEN no_data_found THEN
665: fnd_message.set_name('CSI', 'CSI_API_INVALID_INSTANCE_ID');
666: fnd_message.set_token('INSTANCE_ID',
667: p_txn_line_dtl_tbl(l_index).instance_id);
668: fnd_msg_pub.add;
669: RAISE fnd_api.g_exc_error;
670: END;
677: ---for source lines only.
678: IF p_txn_line_dtl_tbl(l_index).source_transaction_flag = 'Y'
679: THEN
680: IF l_dtl_item_id <> l_src_item_id THEN
681: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_ITEM_CHK_FAILED');
682: FND_MESSAGE.set_token('SRC_ITEM_ID',l_src_item_id);
683: FND_MESSAGE.set_token('DTL_ITEM_ID',l_dtl_item_id);
684: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
685: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
678: IF p_txn_line_dtl_tbl(l_index).source_transaction_flag = 'Y'
679: THEN
680: IF l_dtl_item_id <> l_src_item_id THEN
681: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_ITEM_CHK_FAILED');
682: FND_MESSAGE.set_token('SRC_ITEM_ID',l_src_item_id);
683: FND_MESSAGE.set_token('DTL_ITEM_ID',l_dtl_item_id);
684: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
685: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
686: FND_MSG_PUB.add;
679: THEN
680: IF l_dtl_item_id <> l_src_item_id THEN
681: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_ITEM_CHK_FAILED');
682: FND_MESSAGE.set_token('SRC_ITEM_ID',l_src_item_id);
683: FND_MESSAGE.set_token('DTL_ITEM_ID',l_dtl_item_id);
684: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
685: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
686: FND_MSG_PUB.add;
687: RAISE fnd_api.g_exc_error;
680: IF l_dtl_item_id <> l_src_item_id THEN
681: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_ITEM_CHK_FAILED');
682: FND_MESSAGE.set_token('SRC_ITEM_ID',l_src_item_id);
683: FND_MESSAGE.set_token('DTL_ITEM_ID',l_dtl_item_id);
684: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
685: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
686: FND_MSG_PUB.add;
687: RAISE fnd_api.g_exc_error;
688: END IF;
681: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_ITEM_CHK_FAILED');
682: FND_MESSAGE.set_token('SRC_ITEM_ID',l_src_item_id);
683: FND_MESSAGE.set_token('DTL_ITEM_ID',l_dtl_item_id);
684: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
685: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
686: FND_MSG_PUB.add;
687: RAISE fnd_api.g_exc_error;
688: END IF;
689: END IF ;
726:
727: IF p_txn_line_dtl_tbl(l_index).location_type_code <> 'HZ_PARTY_SITES'
728: THEN
729:
730: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_LOC_INVALID');
731: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
732: FND_MESSAGE.set_token('LOC_code', p_txn_line_dtl_tbl(l_index).
733: location_type_code);
734:
727: IF p_txn_line_dtl_tbl(l_index).location_type_code <> 'HZ_PARTY_SITES'
728: THEN
729:
730: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_LOC_INVALID');
731: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
732: FND_MESSAGE.set_token('LOC_code', p_txn_line_dtl_tbl(l_index).
733: location_type_code);
734:
735: FND_MSG_PUB.add;
728: THEN
729:
730: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_LOC_INVALID');
731: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
732: FND_MESSAGE.set_token('LOC_code', p_txn_line_dtl_tbl(l_index).
733: location_type_code);
734:
735: FND_MSG_PUB.add;
736: RAISE fnd_api.g_exc_error;
739: END IF;
740: ELSE
741: IF nvl(p_txn_line_dtl_tbl(l_index).location_id, fnd_api.g_miss_num)<>
742: fnd_api.g_miss_num THEN
743: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
744: FND_MESSAGE.set_token('VALUE', p_txn_line_dtl_tbl(l_index).
745: location_id);
746: FND_MESSAGE.set_token('PARAM','LOCATION_ID');
747: FND_MESSAGE.set_token('REASON','This is not required for '||
740: ELSE
741: IF nvl(p_txn_line_dtl_tbl(l_index).location_id, fnd_api.g_miss_num)<>
742: fnd_api.g_miss_num THEN
743: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
744: FND_MESSAGE.set_token('VALUE', p_txn_line_dtl_tbl(l_index).
745: location_id);
746: FND_MESSAGE.set_token('PARAM','LOCATION_ID');
747: FND_MESSAGE.set_token('REASON','This is not required for '||
748: 'this transaction type '||p_txn_line_rec.source_transaction_table);
742: fnd_api.g_miss_num THEN
743: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
744: FND_MESSAGE.set_token('VALUE', p_txn_line_dtl_tbl(l_index).
745: location_id);
746: FND_MESSAGE.set_token('PARAM','LOCATION_ID');
747: FND_MESSAGE.set_token('REASON','This is not required for '||
748: 'this transaction type '||p_txn_line_rec.source_transaction_table);
749: FND_MSG_PUB.add;
750:
743: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
744: FND_MESSAGE.set_token('VALUE', p_txn_line_dtl_tbl(l_index).
745: location_id);
746: FND_MESSAGE.set_token('PARAM','LOCATION_ID');
747: FND_MESSAGE.set_token('REASON','This is not required for '||
748: 'this transaction type '||p_txn_line_rec.source_transaction_table);
749: FND_MSG_PUB.add;
750:
751: END IF;
753: END LOOP;
754: -- Added filter criteria for handling RMA cases bug 4244887
755: IF nvl(p_txn_line_rec.source_transaction_type_id,0) <> 53 and l_total_quantity <> l_src_quantity THEN
756:
757: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_QTY_CHK_FAILED');
758: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
759: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
760: FND_MESSAGE.set_token('SRC_QTY',l_src_quantity);
761: FND_MESSAGE.set_token('DTL_QTY',l_total_quantity);
754: -- Added filter criteria for handling RMA cases bug 4244887
755: IF nvl(p_txn_line_rec.source_transaction_type_id,0) <> 53 and l_total_quantity <> l_src_quantity THEN
756:
757: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_QTY_CHK_FAILED');
758: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
759: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
760: FND_MESSAGE.set_token('SRC_QTY',l_src_quantity);
761: FND_MESSAGE.set_token('DTL_QTY',l_total_quantity);
762: FND_MSG_PUB.add;
755: IF nvl(p_txn_line_rec.source_transaction_type_id,0) <> 53 and l_total_quantity <> l_src_quantity THEN
756:
757: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_QTY_CHK_FAILED');
758: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
759: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
760: FND_MESSAGE.set_token('SRC_QTY',l_src_quantity);
761: FND_MESSAGE.set_token('DTL_QTY',l_total_quantity);
762: FND_MSG_PUB.add;
763: IF p_validation_level = fnd_api.g_valid_level_full THEN
756:
757: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_QTY_CHK_FAILED');
758: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
759: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
760: FND_MESSAGE.set_token('SRC_QTY',l_src_quantity);
761: FND_MESSAGE.set_token('DTL_QTY',l_total_quantity);
762: FND_MSG_PUB.add;
763: IF p_validation_level = fnd_api.g_valid_level_full THEN
764: RAISE fnd_api.g_exc_error;
757: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_QTY_CHK_FAILED');
758: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
759: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
760: FND_MESSAGE.set_token('SRC_QTY',l_src_quantity);
761: FND_MESSAGE.set_token('DTL_QTY',l_total_quantity);
762: FND_MSG_PUB.add;
763: IF p_validation_level = fnd_api.g_valid_level_full THEN
764: RAISE fnd_api.g_exc_error;
765: END IF;
810:
811: EXCEPTION
812: WHEN no_data_found THEN
813:
814: FND_MESSAGE.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
815: FND_MESSAGE.set_token('SUB_TYPE_ID',p_txn_line_dtl_tbl(l_td_ind).sub_type_id);
816: FND_MSG_PUB.add;
817: RAISE FND_API.g_exc_error;
818:
811: EXCEPTION
812: WHEN no_data_found THEN
813:
814: FND_MESSAGE.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
815: FND_MESSAGE.set_token('SUB_TYPE_ID',p_txn_line_dtl_tbl(l_td_ind).sub_type_id);
816: FND_MSG_PUB.add;
817: RAISE FND_API.g_exc_error;
818:
819: END;
833: END LOOP;
834: END IF;
835:
836: IF (l_owner_count > 1) THEN
837: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_OWNER');
838: FND_MESSAGE.set_token('INDEX',l_td_ind);
839: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
840: inventory_item_id);
841: FND_MSG_PUB.add;
834: END IF;
835:
836: IF (l_owner_count > 1) THEN
837: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_OWNER');
838: FND_MESSAGE.set_token('INDEX',l_td_ind);
839: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
840: inventory_item_id);
841: FND_MSG_PUB.add;
842: RAISE fnd_api.g_exc_error;
835:
836: IF (l_owner_count > 1) THEN
837: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_OWNER');
838: FND_MESSAGE.set_token('INDEX',l_td_ind);
839: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
840: inventory_item_id);
841: FND_MSG_PUB.add;
842: RAISE fnd_api.g_exc_error;
843: END IF;
845: IF p_txn_line_dtl_tbl(l_td_ind).source_transaction_flag = 'Y' THEN
846: IF l_sub_type_rec.src_change_owner = 'Y' THEN
847:
848: IF (l_owner_count = 0) THEN
849: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
850: FND_MESSAGE.set_token('INDEX',l_td_ind);
851: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
852: inventory_item_id);
853: FND_MSG_PUB.add;
846: IF l_sub_type_rec.src_change_owner = 'Y' THEN
847:
848: IF (l_owner_count = 0) THEN
849: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
850: FND_MESSAGE.set_token('INDEX',l_td_ind);
851: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
852: inventory_item_id);
853: FND_MSG_PUB.add;
854: RAISE fnd_api.g_exc_error;
847:
848: IF (l_owner_count = 0) THEN
849: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
850: FND_MESSAGE.set_token('INDEX',l_td_ind);
851: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
852: inventory_item_id);
853: FND_MSG_PUB.add;
854: RAISE fnd_api.g_exc_error;
855: END IF;
858: ELSE
859: IF l_sub_type_rec.non_src_change_owner = 'Y' THEN
860:
861: IF (l_owner_count = 0) THEN
862: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
863: FND_MESSAGE.set_token('INDEX',l_td_ind);
864: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
865: inventory_item_id);
866: FND_MSG_PUB.add;
859: IF l_sub_type_rec.non_src_change_owner = 'Y' THEN
860:
861: IF (l_owner_count = 0) THEN
862: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
863: FND_MESSAGE.set_token('INDEX',l_td_ind);
864: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
865: inventory_item_id);
866: FND_MSG_PUB.add;
867: RAISE fnd_api.g_exc_error;
860:
861: IF (l_owner_count = 0) THEN
862: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
863: FND_MESSAGE.set_token('INDEX',l_td_ind);
864: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
865: inventory_item_id);
866: FND_MSG_PUB.add;
867: RAISE fnd_api.g_exc_error;
868: END IF;
905: IF p_iir_tbl(l_ind).subject_id = p_sub_obj_id THEN
906: IF ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type
907: AND p_iir_tbl(l_ind).subject_type = 'I' ) THEN --atleast one of them should be 'T'
908:
909: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
910: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
911: FND_MSG_PUB.add;
912: x_return_status := fnd_api.g_ret_sts_error;
913: exit;
906: IF ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type
907: AND p_iir_tbl(l_ind).subject_type = 'I' ) THEN --atleast one of them should be 'T'
908:
909: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
910: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
911: FND_MSG_PUB.add;
912: x_return_status := fnd_api.g_ret_sts_error;
913: exit;
914: END IF;
943: IF p_iir_tbl(l_ind).object_id = p_sub_obj_id THEN
944:
945: IF ( ( p_iir_tbl(l_ind).subject_type not in ('T','I') ) OR
946: ( p_iir_tbl(l_ind).object_type not in ('T','I') ) ) THEN
947: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
948: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
949: FND_MSG_PUB.add;
950: x_return_status := fnd_api.g_ret_sts_error;
951: exit;
944:
945: IF ( ( p_iir_tbl(l_ind).subject_type not in ('T','I') ) OR
946: ( p_iir_tbl(l_ind).object_type not in ('T','I') ) ) THEN
947: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
948: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
949: FND_MSG_PUB.add;
950: x_return_status := fnd_api.g_ret_sts_error;
951: exit;
952: ELSIF ( ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type) AND
951: exit;
952: ELSIF ( ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type) AND
953: (p_iir_tbl(l_ind).object_type = 'I' ) ) THEN --atleast one of them should be 'T'
954:
955: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
956: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
957: FND_MSG_PUB.add;
958: x_return_status := fnd_api.g_ret_sts_error;
959: exit;
952: ELSIF ( ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type) AND
953: (p_iir_tbl(l_ind).object_type = 'I' ) ) THEN --atleast one of them should be 'T'
954:
955: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
956: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
957: FND_MSG_PUB.add;
958: x_return_status := fnd_api.g_ret_sts_error;
959: exit;
960: END IF;
1040: l_object_yn := 'N';
1041: l_sub_obj_id := l_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1042:
1043: IF ( l_sub_obj_id = fnd_api.g_miss_num OR l_sub_obj_id = NULL ) THEN
1044: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');
1045: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);
1046: FND_MESSAGE.set_token('OBJECT_ID', NULL);
1047: FND_MSG_PUB.add;
1048: RAISE FND_API.g_exc_error;
1041: l_sub_obj_id := l_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1042:
1043: IF ( l_sub_obj_id = fnd_api.g_miss_num OR l_sub_obj_id = NULL ) THEN
1044: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');
1045: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);
1046: FND_MESSAGE.set_token('OBJECT_ID', NULL);
1047: FND_MSG_PUB.add;
1048: RAISE FND_API.g_exc_error;
1049: END IF;
1042:
1043: IF ( l_sub_obj_id = fnd_api.g_miss_num OR l_sub_obj_id = NULL ) THEN
1044: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');
1045: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);
1046: FND_MESSAGE.set_token('OBJECT_ID', NULL);
1047: FND_MSG_PUB.add;
1048: RAISE FND_API.g_exc_error;
1049: END IF;
1050: -- get the corresponding ii_rltns (where subject_id = line detail index / id)
1071: END IF;
1072: IF l_line_dtl_tbl(l_td_ind).source_transaction_flag = 'N' THEN
1073: IF l_src_dtl_count = 0 THEN
1074:
1075: FND_MESSAGE.set_name('CSI','CSI_TXN_NON_SRC_AND_NO_RLTN');
1076: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);
1077: FND_MESSAGE.set_token('ITEM_ID',
1078: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1079: FND_MSG_PUB.add;
1072: IF l_line_dtl_tbl(l_td_ind).source_transaction_flag = 'N' THEN
1073: IF l_src_dtl_count = 0 THEN
1074:
1075: FND_MESSAGE.set_name('CSI','CSI_TXN_NON_SRC_AND_NO_RLTN');
1076: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);
1077: FND_MESSAGE.set_token('ITEM_ID',
1078: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1079: FND_MSG_PUB.add;
1080: RAISE FND_API.g_exc_error;
1073: IF l_src_dtl_count = 0 THEN
1074:
1075: FND_MESSAGE.set_name('CSI','CSI_TXN_NON_SRC_AND_NO_RLTN');
1076: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);
1077: FND_MESSAGE.set_token('ITEM_ID',
1078: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1079: FND_MSG_PUB.add;
1080: RAISE FND_API.g_exc_error;
1081: END IF;
1082: END IF; -- source flag chk = 'N'
1083:
1084: IF l_iir_tbl.COUNT > 1 THEN
1085: IF l_return_status <> fnd_api.g_ret_sts_success THEN -- status set to error in the get iir routine when Multiple comp - of relationships are found for a given TLD
1086: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_PARENT');
1087: FND_MESSAGE.set_token('INDEX',l_td_ind);
1088: FND_MESSAGE.set_token('ITEM_ID',
1089: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1090: FND_MSG_PUB.add;
1083:
1084: IF l_iir_tbl.COUNT > 1 THEN
1085: IF l_return_status <> fnd_api.g_ret_sts_success THEN -- status set to error in the get iir routine when Multiple comp - of relationships are found for a given TLD
1086: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_PARENT');
1087: FND_MESSAGE.set_token('INDEX',l_td_ind);
1088: FND_MESSAGE.set_token('ITEM_ID',
1089: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1090: FND_MSG_PUB.add;
1091: RAISE FND_API.g_exc_error;
1084: IF l_iir_tbl.COUNT > 1 THEN
1085: IF l_return_status <> fnd_api.g_ret_sts_success THEN -- status set to error in the get iir routine when Multiple comp - of relationships are found for a given TLD
1086: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_PARENT');
1087: FND_MESSAGE.set_token('INDEX',l_td_ind);
1088: FND_MESSAGE.set_token('ITEM_ID',
1089: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1090: FND_MSG_PUB.add;
1091: RAISE FND_API.g_exc_error;
1092: END IF;
1142: x_txn_line_detail_rec => l_line_dtl_rec,
1143: x_return_status => l_return_status);
1144:
1145: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1146: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_INDEX_INVALID');
1147: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1148: subject_id);
1149: FND_MSG_PUB.add;
1150: RAISE FND_API.g_exc_error;
1143: x_return_status => l_return_status);
1144:
1145: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1146: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_INDEX_INVALID');
1147: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1148: subject_id);
1149: FND_MSG_PUB.add;
1150: RAISE FND_API.g_exc_error;
1151: END IF;
1166: x_return_status => l_return_status);
1167:
1168:
1169: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1170: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_INDEX_INVALID');
1171: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1172: object_id);
1173: FND_MSG_PUB.add;
1174: RAISE FND_API.g_exc_error;
1167:
1168:
1169: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1170: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_INDEX_INVALID');
1171: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1172: object_id);
1173: FND_MSG_PUB.add;
1174: RAISE FND_API.g_exc_error;
1175: END IF;
1388: WHERE attribute_value_id = p_attrib_source_id;
1389:
1390: ELSE
1391:
1392: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_TBL_INVALID');
1393: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1394: FND_MSG_PUB.add;
1395: RAISE FND_API.g_exc_error;
1396:
1389:
1390: ELSE
1391:
1392: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_TBL_INVALID');
1393: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1394: FND_MSG_PUB.add;
1395: RAISE FND_API.g_exc_error;
1396:
1397: END IF;
1400:
1401: EXCEPTION
1402: WHEN no_data_found THEN
1403:
1404: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_ID_INVALID');
1405: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1406: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);
1407: FND_MSG_PUB.add;
1408: x_return_status := fnd_api.g_ret_sts_error;
1401: EXCEPTION
1402: WHEN no_data_found THEN
1403:
1404: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_ID_INVALID');
1405: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1406: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);
1407: FND_MSG_PUB.add;
1408: x_return_status := fnd_api.g_ret_sts_error;
1409:
1402: WHEN no_data_found THEN
1403:
1404: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_ID_INVALID');
1405: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1406: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);
1407: FND_MSG_PUB.add;
1408: x_return_status := fnd_api.g_ret_sts_error;
1409:
1410: WHEN fnd_api.g_exc_error THEN
1544: IF l_instance_id is null THEN -- instance is not refernced
1545:
1546: IF p_level <> 'II_RLTNS' THEN
1547: --instance reference not allowed
1548: fnd_message.set_name('CSI','CSI_TXN_INST_REF_NOT_ALLOWED');
1549: fnd_message.set_token('LVL',p_level);
1550: fnd_message.set_token('LVL_DTL_ID',p_level_inst_ref_id);
1551: fnd_msg_pub.add;
1552:
1545:
1546: IF p_level <> 'II_RLTNS' THEN
1547: --instance reference not allowed
1548: fnd_message.set_name('CSI','CSI_TXN_INST_REF_NOT_ALLOWED');
1549: fnd_message.set_token('LVL',p_level);
1550: fnd_message.set_token('LVL_DTL_ID',p_level_inst_ref_id);
1551: fnd_msg_pub.add;
1552:
1553: raise fnd_api.g_exc_error;
1546: IF p_level <> 'II_RLTNS' THEN
1547: --instance reference not allowed
1548: fnd_message.set_name('CSI','CSI_TXN_INST_REF_NOT_ALLOWED');
1549: fnd_message.set_token('LVL',p_level);
1550: fnd_message.set_token('LVL_DTL_ID',p_level_inst_ref_id);
1551: fnd_msg_pub.add;
1552:
1553: raise fnd_api.g_exc_error;
1554: END IF;
1563: x_return_status => l_return_status);
1564:
1565: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1566:
1567: fnd_message.set_name('CSI','CSI_TXN_INST_PARTY_REF_INVALID');
1568: fnd_message.set_token('INST_ID',l_instance_id);
1569: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);
1570: fnd_msg_pub.add;
1571:
1564:
1565: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1566:
1567: fnd_message.set_name('CSI','CSI_TXN_INST_PARTY_REF_INVALID');
1568: fnd_message.set_token('INST_ID',l_instance_id);
1569: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);
1570: fnd_msg_pub.add;
1571:
1572: RAISE fnd_api.g_exc_error;
1565: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1566:
1567: fnd_message.set_name('CSI','CSI_TXN_INST_PARTY_REF_INVALID');
1568: fnd_message.set_token('INST_ID',l_instance_id);
1569: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);
1570: fnd_msg_pub.add;
1571:
1572: RAISE fnd_api.g_exc_error;
1573: END IF;
1579: p_instance_ou_id => p_level_inst_ref_id,
1580: x_return_status => l_return_status);
1581:
1582: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1583: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');
1584: fnd_message.set_token('INST_ID',l_instance_id);
1585: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);
1586: fnd_msg_pub.add;
1587: raise fnd_api.g_exc_error;
1580: x_return_status => l_return_status);
1581:
1582: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1583: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');
1584: fnd_message.set_token('INST_ID',l_instance_id);
1585: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);
1586: fnd_msg_pub.add;
1587: raise fnd_api.g_exc_error;
1588: END IF;
1581:
1582: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1583: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');
1584: fnd_message.set_token('INST_ID',l_instance_id);
1585: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);
1586: fnd_msg_pub.add;
1587: raise fnd_api.g_exc_error;
1588: END IF;
1589:
1841: AND organization_id = p_organization_id;
1842: EXCEPTION
1843: WHEN no_data_found THEN
1844:
1845: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1846: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1847: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1848: fnd_msg_pub.add;
1849:
1842: EXCEPTION
1843: WHEN no_data_found THEN
1844:
1845: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1846: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1847: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1848: fnd_msg_pub.add;
1849:
1850: RAISE fnd_api.g_exc_error;
1843: WHEN no_data_found THEN
1844:
1845: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1846: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1847: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1848: fnd_msg_pub.add;
1849:
1850: RAISE fnd_api.g_exc_error;
1851: END;
1866:
1867: EXCEPTION
1868:
1869: WHEN no_data_found THEN
1870: fnd_message.set_name('CSI','CSI_API_INVALID_LOT_NUM');
1871: fnd_message.set_token('LOT_NUMBER',p_lot_number);
1872: fnd_msg_pub.add;
1873: RAISE fnd_api.g_exc_error;
1874:
1867: EXCEPTION
1868:
1869: WHEN no_data_found THEN
1870: fnd_message.set_name('CSI','CSI_API_INVALID_LOT_NUM');
1871: fnd_message.set_token('LOT_NUMBER',p_lot_number);
1872: fnd_msg_pub.add;
1873: RAISE fnd_api.g_exc_error;
1874:
1875: -- adding this because I took of the organization check
1877: null;
1878: END;
1879:
1880: ELSE
1881: fnd_message.set_name('CSI', 'CSI_API_NOT_LOT_CONTROLLED');
1882: fnd_message.set_token('LOT_NUMBER', l_item_name);
1883: fnd_msg_pub.add;
1884: END IF;
1885:
1878: END;
1879:
1880: ELSE
1881: fnd_message.set_name('CSI', 'CSI_API_NOT_LOT_CONTROLLED');
1882: fnd_message.set_token('LOT_NUMBER', l_item_name);
1883: fnd_msg_pub.add;
1884: END IF;
1885:
1886: EXCEPTION
1919: EXCEPTION
1920:
1921: WHEN no_data_found THEN
1922:
1923: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1924: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1925: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1926: fnd_msg_pub.add;
1927:
1920:
1921: WHEN no_data_found THEN
1922:
1923: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1924: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1925: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1926: fnd_msg_pub.add;
1927:
1928: RAISE fnd_api.g_exc_error;
1921: WHEN no_data_found THEN
1922:
1923: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1924: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1925: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1926: fnd_msg_pub.add;
1927:
1928: RAISE fnd_api.g_exc_error;
1929: END;
1944:
1945: EXCEPTION
1946: WHEN no_data_found THEN
1947:
1948: fnd_message.set_name('CSI','CSI_API_INVALID_SERIAL_NUM');
1949: fnd_message.set_token('SERIAL_NUMBER',p_serial_number);
1950: fnd_msg_pub.add;
1951: RAISE fnd_api.g_exc_error;
1952:
1945: EXCEPTION
1946: WHEN no_data_found THEN
1947:
1948: fnd_message.set_name('CSI','CSI_API_INVALID_SERIAL_NUM');
1949: fnd_message.set_token('SERIAL_NUMBER',p_serial_number);
1950: fnd_msg_pub.add;
1951: RAISE fnd_api.g_exc_error;
1952:
1953: -- adding this because I took of the organization check
2057: p_txn_line_id2 => l_line_dtl_rec2.transaction_line_id,
2058: p_rel_type_code => l_ii_rltns_rec.relationship_type_code,
2059: x_return_status => l_return_status);
2060: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2061: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2062: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2063: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2064: FND_MSG_PUB.add;
2065: RAISE fnd_api.g_exc_error;
2058: p_rel_type_code => l_ii_rltns_rec.relationship_type_code,
2059: x_return_status => l_return_status);
2060: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2061: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2062: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2063: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2064: FND_MSG_PUB.add;
2065: RAISE fnd_api.g_exc_error;
2066: END IF;
2059: x_return_status => l_return_status);
2060: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2061: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2062: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2063: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2064: FND_MSG_PUB.add;
2065: RAISE fnd_api.g_exc_error;
2066: END IF;
2067: END IF ;
2068:
2069: IF ( l_line_dtl_rec1.transaction_line_id = l_line_dtl_rec2.transaction_line_id )
2070: AND l_ii_rltns_rec.relationship_type_code <> 'CONNECTED-TO' THEN
2071: IF l_line_dtl_rec1.source_transaction_flag = l_line_dtl_rec2.source_transaction_flag THEN
2072: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2073: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2074: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2075: FND_MSG_PUB.add;
2076: RAISE fnd_api.g_exc_error;
2069: IF ( l_line_dtl_rec1.transaction_line_id = l_line_dtl_rec2.transaction_line_id )
2070: AND l_ii_rltns_rec.relationship_type_code <> 'CONNECTED-TO' THEN
2071: IF l_line_dtl_rec1.source_transaction_flag = l_line_dtl_rec2.source_transaction_flag THEN
2072: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2073: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2074: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2075: FND_MSG_PUB.add;
2076: RAISE fnd_api.g_exc_error;
2077: END IF;
2070: AND l_ii_rltns_rec.relationship_type_code <> 'CONNECTED-TO' THEN
2071: IF l_line_dtl_rec1.source_transaction_flag = l_line_dtl_rec2.source_transaction_flag THEN
2072: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2073: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2074: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2075: FND_MSG_PUB.add;
2076: RAISE fnd_api.g_exc_error;
2077: END IF;
2078: END IF;
2093: AND l_ii_rltns_rec.subject_type = l_sub_type) THEN
2094: IF l_txn_relationship_id IS NOT NULL
2095: AND l_ii_rltns_rec.txn_relationship_id <> l_txn_relationship_id
2096: THEN
2097: FND_MESSAGE.set_name('CSI','CSI_TXN_DUP_RLTNS');
2098: FND_MSG_PUB.add;
2099: RAISE fnd_api.g_exc_error;
2100: END IF ;
2101: END IF;
2173: x_return_status := fnd_api.g_ret_sts_error;
2174: END ;
2175: IF l_iir_rec.relationship_type_code = 'COMPONENT-OF' THEN
2176: IF l_iir_rec.object_id <> l_object_id THEN
2177: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2178: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2179: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2180: FND_MSG_PUB.add;
2181: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB
2174: END ;
2175: IF l_iir_rec.relationship_type_code = 'COMPONENT-OF' THEN
2176: IF l_iir_rec.object_id <> l_object_id THEN
2177: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2178: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2179: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2180: FND_MSG_PUB.add;
2181: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB
2182: ELSIF (( l_iir_rec.subject_id <> l_subject_id ) OR
2175: IF l_iir_rec.relationship_type_code = 'COMPONENT-OF' THEN
2176: IF l_iir_rec.object_id <> l_object_id THEN
2177: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2178: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2179: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2180: FND_MSG_PUB.add;
2181: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB
2182: ELSIF (( l_iir_rec.subject_id <> l_subject_id ) OR
2183: ( l_line_dtl_rec.instance_id <> l_subject_id) OR
2193: WHEN OTHERS THEN
2194: x_return_status := fnd_api.g_ret_sts_error; -- unexpected error
2195: END;
2196: IF l_loc_type = 'INVENTORY' THEN
2197: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2198: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2199: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2200: FND_MSG_PUB.add;
2201: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory
2194: x_return_status := fnd_api.g_ret_sts_error; -- unexpected error
2195: END;
2196: IF l_loc_type = 'INVENTORY' THEN
2197: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2198: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2199: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2200: FND_MSG_PUB.add;
2201: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory
2202: END IF;
2195: END;
2196: IF l_loc_type = 'INVENTORY' THEN
2197: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2198: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2199: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2200: FND_MSG_PUB.add;
2201: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory
2202: END IF;
2203: END IF;
2212: WHERE instance_id = l_instance_id
2213: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2214: EXCEPTION
2215: WHEN no_data_found THEN
2216: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');
2217: FND_MESSAGE.set_token('INSTANCE_ID', l_instance_id);
2218: FND_MSG_PUB.add;
2219: x_return_status := fnd_api.g_ret_sts_error;
2220: END;
2213: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2214: EXCEPTION
2215: WHEN no_data_found THEN
2216: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');
2217: FND_MESSAGE.set_token('INSTANCE_ID', l_instance_id);
2218: FND_MSG_PUB.add;
2219: x_return_status := fnd_api.g_ret_sts_error;
2220: END;
2221:
2282: l_txn_hdr_id2 := fnd_api.g_miss_num;
2283: END IF;
2284: IF ( p_rel_type_code = 'CONNECTED-TO' AND
2285: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN
2286: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');
2287: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);
2288: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);
2289: FND_MSG_PUB.add;
2290: Raise fnd_api.g_exc_error;
2283: END IF;
2284: IF ( p_rel_type_code = 'CONNECTED-TO' AND
2285: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN
2286: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');
2287: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);
2288: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);
2289: FND_MSG_PUB.add;
2290: Raise fnd_api.g_exc_error;
2291: END IF;
2284: IF ( p_rel_type_code = 'CONNECTED-TO' AND
2285: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN
2286: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');
2287: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);
2288: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);
2289: FND_MSG_PUB.add;
2290: Raise fnd_api.g_exc_error;
2291: END IF;
2292:
2290: Raise fnd_api.g_exc_error;
2291: END IF;
2292:
2293: IF ((l_txn_hdr_id1 <> l_txn_hdr_id2 ) AND (l_txn_type_id1 = l_txn_type_id2) ) THEN
2294: FND_MESSAGE.set_name('CSI','CSI_TXN_RLT_XSO_NOT_ALLOWED');
2295: FND_MSG_PUB.add;
2296: Raise fnd_api.g_exc_error;
2297: END IF;
2298:
2336: CLOSE cz_config_dtl_cur ;
2337:
2338: IF l_config_hdr_id is NULL
2339: THEN
2340: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
2341: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2342: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2343: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2344: fnd_msg_pub.add;
2337:
2338: IF l_config_hdr_id is NULL
2339: THEN
2340: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
2341: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2342: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2343: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2344: fnd_msg_pub.add;
2345: RAISE fnd_api.g_exc_error;
2338: IF l_config_hdr_id is NULL
2339: THEN
2340: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
2341: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2342: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2343: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2344: fnd_msg_pub.add;
2345: RAISE fnd_api.g_exc_error;
2346: END IF ;
2339: THEN
2340: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
2341: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2342: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2343: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2344: fnd_msg_pub.add;
2345: RAISE fnd_api.g_exc_error;
2346: END IF ;
2347: END LOOP ;
2408:
2409: IF x_instance_id IS NULL
2410: AND x_txn_line_detail_id IS NULL
2411: THEN
2412: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2413: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2414: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2415: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2416: fnd_msg_pub.add;
2409: IF x_instance_id IS NULL
2410: AND x_txn_line_detail_id IS NULL
2411: THEN
2412: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2413: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2414: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2415: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2416: fnd_msg_pub.add;
2417: RAISE fnd_api.g_exc_error;
2410: AND x_txn_line_detail_id IS NULL
2411: THEN
2412: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2413: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2414: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2415: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2416: fnd_msg_pub.add;
2417: RAISE fnd_api.g_exc_error;
2418: END IF ;
2411: THEN
2412: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2413: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2414: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2415: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2416: fnd_msg_pub.add;
2417: RAISE fnd_api.g_exc_error;
2418: END IF ;
2419:
2483: CLOSE cz_config_cur ;
2484:
2485: IF l_config_session_hdr_id is NULL
2486: THEN
2487: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');
2488: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2489: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2490: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2491: fnd_msg_pub.add;
2484:
2485: IF l_config_session_hdr_id is NULL
2486: THEN
2487: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');
2488: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2489: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2490: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2491: fnd_msg_pub.add;
2492: RAISE fnd_api.g_exc_error;
2485: IF l_config_session_hdr_id is NULL
2486: THEN
2487: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');
2488: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2489: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2490: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2491: fnd_msg_pub.add;
2492: RAISE fnd_api.g_exc_error;
2493: END IF ;
2486: THEN
2487: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');
2488: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2489: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2490: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2491: fnd_msg_pub.add;
2492: RAISE fnd_api.g_exc_error;
2493: END IF ;
2494: EXCEPTION