DBA Data[Home] [Help]

APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on FND_MESSAGE

Line 19: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');

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;

Line 20: FND_MESSAGE.set_token('API_NAME',p_api_name);

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:

Line 21: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);

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;

Line 38: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');

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;

Line 39: FND_MESSAGE.set_token('API_NAME',p_api_name);

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:

Line 40: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);

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;

Line 57: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');

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;

Line 58: FND_MESSAGE.set_token('API_NAME',p_api_name);

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:

Line 59: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);

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;

Line 665: fnd_message.set_name('CSI', 'CSI_API_INVALID_INSTANCE_ID');

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;

Line 666: fnd_message.set_token('INSTANCE_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;
670: END;

Line 681: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_ITEM_CHK_FAILED');

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);

Line 682: FND_MESSAGE.set_token('SRC_ITEM_ID',l_src_item_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;

Line 683: FND_MESSAGE.set_token('DTL_ITEM_ID',l_dtl_item_id);

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;

Line 684: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);

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;

Line 685: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);

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 ;

Line 730: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_LOC_INVALID');

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:

Line 731: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);

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;

Line 732: FND_MESSAGE.set_token('LOC_code', p_txn_line_dtl_tbl(l_index).

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;

Line 743: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');

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 '||

Line 744: FND_MESSAGE.set_token('VALUE', p_txn_line_dtl_tbl(l_index).

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);

Line 746: FND_MESSAGE.set_token('PARAM','LOCATION_ID');

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:

Line 747: FND_MESSAGE.set_token('REASON','This is not required for '||

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;

Line 757: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_QTY_CHK_FAILED');

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);

Line 758: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);

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;

Line 759: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);

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

Line 760: FND_MESSAGE.set_token('SRC_QTY',l_src_quantity);

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;

Line 761: FND_MESSAGE.set_token('DTL_QTY',l_total_quantity);

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;

Line 814: FND_MESSAGE.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');

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:

Line 815: FND_MESSAGE.set_token('SUB_TYPE_ID',p_txn_line_dtl_tbl(l_td_ind).sub_type_id);

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;

Line 837: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_OWNER');

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;

Line 838: FND_MESSAGE.set_token('INDEX',l_td_ind);

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;

Line 839: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).

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;

Line 849: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');

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;

Line 850: FND_MESSAGE.set_token('INDEX',l_td_ind);

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;

Line 851: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).

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;

Line 862: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');

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;

Line 863: FND_MESSAGE.set_token('INDEX',l_td_ind);

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;

Line 864: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).

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;

Line 909: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');

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;

Line 910: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);

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;

Line 947: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');

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;

Line 948: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);

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

Line 955: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');

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;

Line 956: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);

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;

Line 1044: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');

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;

Line 1045: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);

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;

Line 1046: FND_MESSAGE.set_token('OBJECT_ID', NULL);

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)

Line 1075: FND_MESSAGE.set_name('CSI','CSI_TXN_NON_SRC_AND_NO_RLTN');

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;

Line 1076: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);

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;

Line 1077: FND_MESSAGE.set_token('ITEM_ID',

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;

Line 1086: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_PARENT');

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;

Line 1087: FND_MESSAGE.set_token('INDEX',l_td_ind);

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;

Line 1088: FND_MESSAGE.set_token('ITEM_ID',

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;

Line 1146: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_INDEX_INVALID');

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;

Line 1147: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).

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;

Line 1170: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_INDEX_INVALID');

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;

Line 1171: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).

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;

Line 1392: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_TBL_INVALID');

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:

Line 1393: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);

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;

Line 1404: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_ID_INVALID');

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;

Line 1405: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);

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:

Line 1406: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);

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

Line 1548: fnd_message.set_name('CSI','CSI_TXN_INST_REF_NOT_ALLOWED');

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:

Line 1549: fnd_message.set_token('LVL',p_level);

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;

Line 1550: fnd_message.set_token('LVL_DTL_ID',p_level_inst_ref_id);

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;

Line 1567: fnd_message.set_name('CSI','CSI_TXN_INST_PARTY_REF_INVALID');

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:

Line 1568: fnd_message.set_token('INST_ID',l_instance_id);

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;

Line 1569: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);

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;

Line 1583: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');

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;

Line 1584: fnd_message.set_token('INST_ID',l_instance_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;
1588: END IF;

Line 1585: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);

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:

Line 1845: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');

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:

Line 1846: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_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:
1850: RAISE fnd_api.g_exc_error;

Line 1847: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);

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;

Line 1870: fnd_message.set_name('CSI','CSI_API_INVALID_LOT_NUM');

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:

Line 1871: fnd_message.set_token('LOT_NUMBER',p_lot_number);

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

Line 1881: fnd_message.set_name('CSI', 'CSI_API_NOT_LOT_CONTROLLED');

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:

Line 1882: fnd_message.set_token('LOT_NUMBER', l_item_name);

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

Line 1923: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');

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:

Line 1924: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);

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;

Line 1925: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);

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;

Line 1948: fnd_message.set_name('CSI','CSI_API_INVALID_SERIAL_NUM');

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:

Line 1949: fnd_message.set_token('SERIAL_NUMBER',p_serial_number);

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

Line 2061: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');

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;

Line 2062: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_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;
2066: END IF;

Line 2063: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);

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 ;

Line 2072: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');

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;

Line 2073: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);

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;

Line 2074: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_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;
2078: END IF;

Line 2097: FND_MESSAGE.set_name('CSI','CSI_TXN_DUP_RLTNS');

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;

Line 2177: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');

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

Line 2178: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);

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

Line 2179: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);

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

Line 2197: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');

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

Line 2198: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);

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;

Line 2199: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);

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;

Line 2216: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');

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;

Line 2217: FND_MESSAGE.set_token('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;
2221:

Line 2286: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');

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;

Line 2287: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);

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;

Line 2288: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);

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:

Line 2294: FND_MESSAGE.set_name('CSI','CSI_TXN_RLT_XSO_NOT_ALLOWED');

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:

Line 2340: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');

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;

Line 2341: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);

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;

Line 2342: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);

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 ;

Line 2343: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);

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 ;

Line 2412: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');

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;

Line 2413: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);

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;

Line 2414: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);

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 ;

Line 2415: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);

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:

Line 2487: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');

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;

Line 2488: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);

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;

Line 2489: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);

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 ;

Line 2490: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);

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