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 815: FND_MESSAGE.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');

811:
812: EXCEPTION
813: WHEN no_data_found THEN
814:
815: FND_MESSAGE.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
816: FND_MESSAGE.set_token('SUB_TYPE_ID',p_txn_line_dtl_tbl(l_td_ind).sub_type_id);
817: FND_MSG_PUB.add;
818: RAISE FND_API.g_exc_error;
819:

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

812: EXCEPTION
813: WHEN no_data_found THEN
814:
815: FND_MESSAGE.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
816: FND_MESSAGE.set_token('SUB_TYPE_ID',p_txn_line_dtl_tbl(l_td_ind).sub_type_id);
817: FND_MSG_PUB.add;
818: RAISE FND_API.g_exc_error;
819:
820: END;

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

834: END LOOP;
835: END IF;
836:
837: IF (l_owner_count > 1) THEN
838: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_OWNER');
839: FND_MESSAGE.set_token('INDEX',l_td_ind);
840: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
841: inventory_item_id);
842: FND_MSG_PUB.add;

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

835: END IF;
836:
837: IF (l_owner_count > 1) THEN
838: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_OWNER');
839: FND_MESSAGE.set_token('INDEX',l_td_ind);
840: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
841: inventory_item_id);
842: FND_MSG_PUB.add;
843: RAISE fnd_api.g_exc_error;

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

836:
837: IF (l_owner_count > 1) THEN
838: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_OWNER');
839: FND_MESSAGE.set_token('INDEX',l_td_ind);
840: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
841: inventory_item_id);
842: FND_MSG_PUB.add;
843: RAISE fnd_api.g_exc_error;
844: END IF;

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

853: EXCEPTION
854:
855: WHEN no_data_found THEN
856:
857: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
858: fnd_message.set_token('INVENTORY_ITEM_ID',p_txn_line_dtl_tbl(l_td_ind).inventory_item_id);
859: fnd_message.set_token('INV_ORGANIZATION_ID',p_txn_line_dtl_tbl(l_td_ind).INV_ORGANIZATION_ID);
860: fnd_msg_pub.add;
861:

Line 858: fnd_message.set_token('INVENTORY_ITEM_ID',p_txn_line_dtl_tbl(l_td_ind).inventory_item_id);

854:
855: WHEN no_data_found THEN
856:
857: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
858: fnd_message.set_token('INVENTORY_ITEM_ID',p_txn_line_dtl_tbl(l_td_ind).inventory_item_id);
859: fnd_message.set_token('INV_ORGANIZATION_ID',p_txn_line_dtl_tbl(l_td_ind).INV_ORGANIZATION_ID);
860: fnd_msg_pub.add;
861:
862: RAISE fnd_api.g_exc_error;

Line 859: fnd_message.set_token('INV_ORGANIZATION_ID',p_txn_line_dtl_tbl(l_td_ind).INV_ORGANIZATION_ID);

855: WHEN no_data_found THEN
856:
857: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
858: fnd_message.set_token('INVENTORY_ITEM_ID',p_txn_line_dtl_tbl(l_td_ind).inventory_item_id);
859: fnd_message.set_token('INV_ORGANIZATION_ID',p_txn_line_dtl_tbl(l_td_ind).INV_ORGANIZATION_ID);
860: fnd_msg_pub.add;
861:
862: RAISE fnd_api.g_exc_error;
863: END;

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

872: IF p_txn_line_dtl_tbl(l_td_ind).source_transaction_flag = 'Y' THEN
873: IF l_sub_type_rec.src_change_owner = 'Y' THEN
874:
875: IF (l_owner_count = 0) THEN
876: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
877: FND_MESSAGE.set_token('INDEX',l_td_ind);
878: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
879: inventory_item_id);
880: FND_MSG_PUB.add;

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

873: IF l_sub_type_rec.src_change_owner = 'Y' THEN
874:
875: IF (l_owner_count = 0) THEN
876: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
877: FND_MESSAGE.set_token('INDEX',l_td_ind);
878: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
879: inventory_item_id);
880: FND_MSG_PUB.add;
881: RAISE fnd_api.g_exc_error;

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

874:
875: IF (l_owner_count = 0) THEN
876: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
877: FND_MESSAGE.set_token('INDEX',l_td_ind);
878: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
879: inventory_item_id);
880: FND_MSG_PUB.add;
881: RAISE fnd_api.g_exc_error;
882: END IF;

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

885: ELSE
886: IF l_sub_type_rec.non_src_change_owner = 'Y' THEN
887:
888: IF (l_owner_count = 0) THEN
889: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
890: FND_MESSAGE.set_token('INDEX',l_td_ind);
891: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
892: inventory_item_id);
893: FND_MSG_PUB.add;

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

886: IF l_sub_type_rec.non_src_change_owner = 'Y' THEN
887:
888: IF (l_owner_count = 0) THEN
889: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
890: FND_MESSAGE.set_token('INDEX',l_td_ind);
891: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
892: inventory_item_id);
893: FND_MSG_PUB.add;
894: RAISE fnd_api.g_exc_error;

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

887:
888: IF (l_owner_count = 0) THEN
889: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
890: FND_MESSAGE.set_token('INDEX',l_td_ind);
891: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
892: inventory_item_id);
893: FND_MSG_PUB.add;
894: RAISE fnd_api.g_exc_error;
895: END IF;

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

932: IF p_iir_tbl(l_ind).subject_id = p_sub_obj_id THEN
933: IF ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type
934: AND p_iir_tbl(l_ind).subject_type = 'I' ) THEN --atleast one of them should be 'T'
935:
936: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
937: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
938: FND_MSG_PUB.add;
939: x_return_status := fnd_api.g_ret_sts_error;
940: exit;

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

933: IF ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type
934: AND p_iir_tbl(l_ind).subject_type = 'I' ) THEN --atleast one of them should be 'T'
935:
936: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
937: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
938: FND_MSG_PUB.add;
939: x_return_status := fnd_api.g_ret_sts_error;
940: exit;
941: END IF;

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

970: IF p_iir_tbl(l_ind).object_id = p_sub_obj_id THEN
971:
972: IF ( ( p_iir_tbl(l_ind).subject_type not in ('T','I') ) OR
973: ( p_iir_tbl(l_ind).object_type not in ('T','I') ) ) THEN
974: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
975: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
976: FND_MSG_PUB.add;
977: x_return_status := fnd_api.g_ret_sts_error;
978: exit;

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

971:
972: IF ( ( p_iir_tbl(l_ind).subject_type not in ('T','I') ) OR
973: ( p_iir_tbl(l_ind).object_type not in ('T','I') ) ) THEN
974: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
975: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
976: FND_MSG_PUB.add;
977: x_return_status := fnd_api.g_ret_sts_error;
978: exit;
979: ELSIF ( ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type) AND

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

978: exit;
979: ELSIF ( ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type) AND
980: (p_iir_tbl(l_ind).object_type = 'I' ) ) THEN --atleast one of them should be 'T'
981:
982: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
983: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
984: FND_MSG_PUB.add;
985: x_return_status := fnd_api.g_ret_sts_error;
986: exit;

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

979: ELSIF ( ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type) AND
980: (p_iir_tbl(l_ind).object_type = 'I' ) ) THEN --atleast one of them should be 'T'
981:
982: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
983: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
984: FND_MSG_PUB.add;
985: x_return_status := fnd_api.g_ret_sts_error;
986: exit;
987: END IF;

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

1067: l_object_yn := 'N';
1068: l_sub_obj_id := l_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1069:
1070: IF ( l_sub_obj_id = fnd_api.g_miss_num OR l_sub_obj_id = NULL ) THEN
1071: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');
1072: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);
1073: FND_MESSAGE.set_token('OBJECT_ID', NULL);
1074: FND_MSG_PUB.add;
1075: RAISE FND_API.g_exc_error;

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

1068: l_sub_obj_id := l_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1069:
1070: IF ( l_sub_obj_id = fnd_api.g_miss_num OR l_sub_obj_id = NULL ) THEN
1071: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');
1072: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);
1073: FND_MESSAGE.set_token('OBJECT_ID', NULL);
1074: FND_MSG_PUB.add;
1075: RAISE FND_API.g_exc_error;
1076: END IF;

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

1069:
1070: IF ( l_sub_obj_id = fnd_api.g_miss_num OR l_sub_obj_id = NULL ) THEN
1071: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');
1072: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);
1073: FND_MESSAGE.set_token('OBJECT_ID', NULL);
1074: FND_MSG_PUB.add;
1075: RAISE FND_API.g_exc_error;
1076: END IF;
1077: -- get the corresponding ii_rltns (where subject_id = line detail index / id)

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

1098: END IF;
1099: IF l_line_dtl_tbl(l_td_ind).source_transaction_flag = 'N' THEN
1100: IF l_src_dtl_count = 0 THEN
1101:
1102: FND_MESSAGE.set_name('CSI','CSI_TXN_NON_SRC_AND_NO_RLTN');
1103: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);
1104: FND_MESSAGE.set_token('ITEM_ID',
1105: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1106: FND_MSG_PUB.add;

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

1099: IF l_line_dtl_tbl(l_td_ind).source_transaction_flag = 'N' THEN
1100: IF l_src_dtl_count = 0 THEN
1101:
1102: FND_MESSAGE.set_name('CSI','CSI_TXN_NON_SRC_AND_NO_RLTN');
1103: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);
1104: FND_MESSAGE.set_token('ITEM_ID',
1105: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1106: FND_MSG_PUB.add;
1107: RAISE FND_API.g_exc_error;

Line 1104: FND_MESSAGE.set_token('ITEM_ID',

1100: IF l_src_dtl_count = 0 THEN
1101:
1102: FND_MESSAGE.set_name('CSI','CSI_TXN_NON_SRC_AND_NO_RLTN');
1103: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);
1104: FND_MESSAGE.set_token('ITEM_ID',
1105: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1106: FND_MSG_PUB.add;
1107: RAISE FND_API.g_exc_error;
1108: END IF;

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

1109: END IF; -- source flag chk = 'N'
1110:
1111: IF l_iir_tbl.COUNT > 1 THEN
1112: 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
1113: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_PARENT');
1114: FND_MESSAGE.set_token('INDEX',l_td_ind);
1115: FND_MESSAGE.set_token('ITEM_ID',
1116: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1117: FND_MSG_PUB.add;

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

1110:
1111: IF l_iir_tbl.COUNT > 1 THEN
1112: 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
1113: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_PARENT');
1114: FND_MESSAGE.set_token('INDEX',l_td_ind);
1115: FND_MESSAGE.set_token('ITEM_ID',
1116: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1117: FND_MSG_PUB.add;
1118: RAISE FND_API.g_exc_error;

Line 1115: FND_MESSAGE.set_token('ITEM_ID',

1111: IF l_iir_tbl.COUNT > 1 THEN
1112: 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
1113: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_PARENT');
1114: FND_MESSAGE.set_token('INDEX',l_td_ind);
1115: FND_MESSAGE.set_token('ITEM_ID',
1116: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1117: FND_MSG_PUB.add;
1118: RAISE FND_API.g_exc_error;
1119: END IF;

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

1169: x_txn_line_detail_rec => l_line_dtl_rec,
1170: x_return_status => l_return_status);
1171:
1172: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1173: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_INDEX_INVALID');
1174: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1175: subject_id);
1176: FND_MSG_PUB.add;
1177: RAISE FND_API.g_exc_error;

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

1170: x_return_status => l_return_status);
1171:
1172: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1173: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_INDEX_INVALID');
1174: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1175: subject_id);
1176: FND_MSG_PUB.add;
1177: RAISE FND_API.g_exc_error;
1178: END IF;

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

1193: x_return_status => l_return_status);
1194:
1195:
1196: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1197: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_INDEX_INVALID');
1198: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1199: object_id);
1200: FND_MSG_PUB.add;
1201: RAISE FND_API.g_exc_error;

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

1194:
1195:
1196: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1197: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_INDEX_INVALID');
1198: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1199: object_id);
1200: FND_MSG_PUB.add;
1201: RAISE FND_API.g_exc_error;
1202: END IF;

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

1415: WHERE attribute_value_id = p_attrib_source_id;
1416:
1417: ELSE
1418:
1419: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_TBL_INVALID');
1420: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1421: FND_MSG_PUB.add;
1422: RAISE FND_API.g_exc_error;
1423:

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

1416:
1417: ELSE
1418:
1419: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_TBL_INVALID');
1420: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1421: FND_MSG_PUB.add;
1422: RAISE FND_API.g_exc_error;
1423:
1424: END IF;

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

1427:
1428: EXCEPTION
1429: WHEN no_data_found THEN
1430:
1431: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_ID_INVALID');
1432: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1433: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);
1434: FND_MSG_PUB.add;
1435: x_return_status := fnd_api.g_ret_sts_error;

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

1428: EXCEPTION
1429: WHEN no_data_found THEN
1430:
1431: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_ID_INVALID');
1432: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1433: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);
1434: FND_MSG_PUB.add;
1435: x_return_status := fnd_api.g_ret_sts_error;
1436:

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

1429: WHEN no_data_found THEN
1430:
1431: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_ID_INVALID');
1432: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1433: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);
1434: FND_MSG_PUB.add;
1435: x_return_status := fnd_api.g_ret_sts_error;
1436:
1437: WHEN fnd_api.g_exc_error THEN

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

1571: IF l_instance_id is null THEN -- instance is not refernced
1572:
1573: IF p_level <> 'II_RLTNS' THEN
1574: --instance reference not allowed
1575: fnd_message.set_name('CSI','CSI_TXN_INST_REF_NOT_ALLOWED');
1576: fnd_message.set_token('LVL',p_level);
1577: fnd_message.set_token('LVL_DTL_ID',p_level_inst_ref_id);
1578: fnd_msg_pub.add;
1579:

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

1572:
1573: IF p_level <> 'II_RLTNS' THEN
1574: --instance reference not allowed
1575: fnd_message.set_name('CSI','CSI_TXN_INST_REF_NOT_ALLOWED');
1576: fnd_message.set_token('LVL',p_level);
1577: fnd_message.set_token('LVL_DTL_ID',p_level_inst_ref_id);
1578: fnd_msg_pub.add;
1579:
1580: raise fnd_api.g_exc_error;

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

1573: IF p_level <> 'II_RLTNS' THEN
1574: --instance reference not allowed
1575: fnd_message.set_name('CSI','CSI_TXN_INST_REF_NOT_ALLOWED');
1576: fnd_message.set_token('LVL',p_level);
1577: fnd_message.set_token('LVL_DTL_ID',p_level_inst_ref_id);
1578: fnd_msg_pub.add;
1579:
1580: raise fnd_api.g_exc_error;
1581: END IF;

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

1590: x_return_status => l_return_status);
1591:
1592: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1593:
1594: fnd_message.set_name('CSI','CSI_TXN_INST_PARTY_REF_INVALID');
1595: fnd_message.set_token('INST_ID',l_instance_id);
1596: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);
1597: fnd_msg_pub.add;
1598:

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

1591:
1592: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1593:
1594: fnd_message.set_name('CSI','CSI_TXN_INST_PARTY_REF_INVALID');
1595: fnd_message.set_token('INST_ID',l_instance_id);
1596: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);
1597: fnd_msg_pub.add;
1598:
1599: RAISE fnd_api.g_exc_error;

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

1592: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1593:
1594: fnd_message.set_name('CSI','CSI_TXN_INST_PARTY_REF_INVALID');
1595: fnd_message.set_token('INST_ID',l_instance_id);
1596: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);
1597: fnd_msg_pub.add;
1598:
1599: RAISE fnd_api.g_exc_error;
1600: END IF;

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

1606: p_instance_ou_id => p_level_inst_ref_id,
1607: x_return_status => l_return_status);
1608:
1609: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1610: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');
1611: fnd_message.set_token('INST_ID',l_instance_id);
1612: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);
1613: fnd_msg_pub.add;
1614: raise fnd_api.g_exc_error;

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

1607: x_return_status => l_return_status);
1608:
1609: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1610: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');
1611: fnd_message.set_token('INST_ID',l_instance_id);
1612: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);
1613: fnd_msg_pub.add;
1614: raise fnd_api.g_exc_error;
1615: END IF;

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

1608:
1609: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1610: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');
1611: fnd_message.set_token('INST_ID',l_instance_id);
1612: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);
1613: fnd_msg_pub.add;
1614: raise fnd_api.g_exc_error;
1615: END IF;
1616:

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

1868: AND organization_id = p_organization_id;
1869: EXCEPTION
1870: WHEN no_data_found THEN
1871:
1872: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1873: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1874: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1875: fnd_msg_pub.add;
1876:

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

1869: EXCEPTION
1870: WHEN no_data_found THEN
1871:
1872: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1873: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1874: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1875: fnd_msg_pub.add;
1876:
1877: RAISE fnd_api.g_exc_error;

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

1870: WHEN no_data_found THEN
1871:
1872: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1873: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1874: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1875: fnd_msg_pub.add;
1876:
1877: RAISE fnd_api.g_exc_error;
1878: END;

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

1893:
1894: EXCEPTION
1895:
1896: WHEN no_data_found THEN
1897: fnd_message.set_name('CSI','CSI_API_INVALID_LOT_NUM');
1898: fnd_message.set_token('LOT_NUMBER',p_lot_number);
1899: fnd_msg_pub.add;
1900: RAISE fnd_api.g_exc_error;
1901:

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

1894: EXCEPTION
1895:
1896: WHEN no_data_found THEN
1897: fnd_message.set_name('CSI','CSI_API_INVALID_LOT_NUM');
1898: fnd_message.set_token('LOT_NUMBER',p_lot_number);
1899: fnd_msg_pub.add;
1900: RAISE fnd_api.g_exc_error;
1901:
1902: -- adding this because I took of the organization check

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

1904: null;
1905: END;
1906:
1907: ELSE
1908: fnd_message.set_name('CSI', 'CSI_API_NOT_LOT_CONTROLLED');
1909: fnd_message.set_token('LOT_NUMBER', l_item_name);
1910: fnd_msg_pub.add;
1911: END IF;
1912:

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

1905: END;
1906:
1907: ELSE
1908: fnd_message.set_name('CSI', 'CSI_API_NOT_LOT_CONTROLLED');
1909: fnd_message.set_token('LOT_NUMBER', l_item_name);
1910: fnd_msg_pub.add;
1911: END IF;
1912:
1913: EXCEPTION

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

1946: EXCEPTION
1947:
1948: WHEN no_data_found THEN
1949:
1950: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1951: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1952: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1953: fnd_msg_pub.add;
1954:

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

1947:
1948: WHEN no_data_found THEN
1949:
1950: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1951: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1952: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1953: fnd_msg_pub.add;
1954:
1955: RAISE fnd_api.g_exc_error;

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

1948: WHEN no_data_found THEN
1949:
1950: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1951: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1952: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1953: fnd_msg_pub.add;
1954:
1955: RAISE fnd_api.g_exc_error;
1956: END;

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

1971:
1972: EXCEPTION
1973: WHEN no_data_found THEN
1974:
1975: fnd_message.set_name('CSI','CSI_API_INVALID_SERIAL_NUM');
1976: fnd_message.set_token('SERIAL_NUMBER',p_serial_number);
1977: fnd_msg_pub.add;
1978: RAISE fnd_api.g_exc_error;
1979:

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

1972: EXCEPTION
1973: WHEN no_data_found THEN
1974:
1975: fnd_message.set_name('CSI','CSI_API_INVALID_SERIAL_NUM');
1976: fnd_message.set_token('SERIAL_NUMBER',p_serial_number);
1977: fnd_msg_pub.add;
1978: RAISE fnd_api.g_exc_error;
1979:
1980: -- adding this because I took of the organization check

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

2084: p_txn_line_id2 => l_line_dtl_rec2.transaction_line_id,
2085: p_rel_type_code => l_ii_rltns_rec.relationship_type_code,
2086: x_return_status => l_return_status);
2087: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2088: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2089: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2090: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2091: FND_MSG_PUB.add;
2092: RAISE fnd_api.g_exc_error;

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

2085: p_rel_type_code => l_ii_rltns_rec.relationship_type_code,
2086: x_return_status => l_return_status);
2087: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2088: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2089: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2090: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2091: FND_MSG_PUB.add;
2092: RAISE fnd_api.g_exc_error;
2093: END IF;

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

2086: x_return_status => l_return_status);
2087: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2088: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2089: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2090: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2091: FND_MSG_PUB.add;
2092: RAISE fnd_api.g_exc_error;
2093: END IF;
2094: END IF ;

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

2095:
2096: IF ( l_line_dtl_rec1.transaction_line_id = l_line_dtl_rec2.transaction_line_id )
2097: AND l_ii_rltns_rec.relationship_type_code <> 'CONNECTED-TO' THEN
2098: IF l_line_dtl_rec1.source_transaction_flag = l_line_dtl_rec2.source_transaction_flag THEN
2099: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2100: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2101: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2102: FND_MSG_PUB.add;
2103: RAISE fnd_api.g_exc_error;

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

2096: IF ( l_line_dtl_rec1.transaction_line_id = l_line_dtl_rec2.transaction_line_id )
2097: AND l_ii_rltns_rec.relationship_type_code <> 'CONNECTED-TO' THEN
2098: IF l_line_dtl_rec1.source_transaction_flag = l_line_dtl_rec2.source_transaction_flag THEN
2099: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2100: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2101: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2102: FND_MSG_PUB.add;
2103: RAISE fnd_api.g_exc_error;
2104: END IF;

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

2097: AND l_ii_rltns_rec.relationship_type_code <> 'CONNECTED-TO' THEN
2098: IF l_line_dtl_rec1.source_transaction_flag = l_line_dtl_rec2.source_transaction_flag THEN
2099: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2100: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2101: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2102: FND_MSG_PUB.add;
2103: RAISE fnd_api.g_exc_error;
2104: END IF;
2105: END IF;

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

2120: AND l_ii_rltns_rec.subject_type = l_sub_type) THEN
2121: IF l_txn_relationship_id IS NOT NULL
2122: AND l_ii_rltns_rec.txn_relationship_id <> l_txn_relationship_id
2123: THEN
2124: FND_MESSAGE.set_name('CSI','CSI_TXN_DUP_RLTNS');
2125: FND_MSG_PUB.add;
2126: RAISE fnd_api.g_exc_error;
2127: END IF ;
2128: END IF;

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

2200: x_return_status := fnd_api.g_ret_sts_error;
2201: END ;
2202: IF l_iir_rec.relationship_type_code = 'COMPONENT-OF' THEN
2203: IF l_iir_rec.object_id <> l_object_id THEN
2204: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2205: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2206: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2207: FND_MSG_PUB.add;
2208: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB

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

2201: END ;
2202: IF l_iir_rec.relationship_type_code = 'COMPONENT-OF' THEN
2203: IF l_iir_rec.object_id <> l_object_id THEN
2204: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2205: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2206: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2207: FND_MSG_PUB.add;
2208: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB
2209: ELSIF (( l_iir_rec.subject_id <> l_subject_id ) OR

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

2202: IF l_iir_rec.relationship_type_code = 'COMPONENT-OF' THEN
2203: IF l_iir_rec.object_id <> l_object_id THEN
2204: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2205: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2206: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2207: FND_MSG_PUB.add;
2208: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB
2209: ELSIF (( l_iir_rec.subject_id <> l_subject_id ) OR
2210: ( l_line_dtl_rec.instance_id <> l_subject_id) OR

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

2220: WHEN OTHERS THEN
2221: x_return_status := fnd_api.g_ret_sts_error; -- unexpected error
2222: END;
2223: IF l_loc_type = 'INVENTORY' THEN
2224: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2225: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2226: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2227: FND_MSG_PUB.add;
2228: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory

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

2221: x_return_status := fnd_api.g_ret_sts_error; -- unexpected error
2222: END;
2223: IF l_loc_type = 'INVENTORY' THEN
2224: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2225: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2226: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2227: FND_MSG_PUB.add;
2228: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory
2229: END IF;

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

2222: END;
2223: IF l_loc_type = 'INVENTORY' THEN
2224: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2225: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2226: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2227: FND_MSG_PUB.add;
2228: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory
2229: END IF;
2230: END IF;

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

2239: WHERE instance_id = l_instance_id
2240: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2241: EXCEPTION
2242: WHEN no_data_found THEN
2243: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');
2244: FND_MESSAGE.set_token('INSTANCE_ID', l_instance_id);
2245: FND_MSG_PUB.add;
2246: x_return_status := fnd_api.g_ret_sts_error;
2247: END;

Line 2244: FND_MESSAGE.set_token('INSTANCE_ID', l_instance_id);

2240: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2241: EXCEPTION
2242: WHEN no_data_found THEN
2243: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');
2244: FND_MESSAGE.set_token('INSTANCE_ID', l_instance_id);
2245: FND_MSG_PUB.add;
2246: x_return_status := fnd_api.g_ret_sts_error;
2247: END;
2248:

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

2309: l_txn_hdr_id2 := fnd_api.g_miss_num;
2310: END IF;
2311: IF ( p_rel_type_code = 'CONNECTED-TO' AND
2312: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN
2313: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');
2314: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);
2315: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);
2316: FND_MSG_PUB.add;
2317: Raise fnd_api.g_exc_error;

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

2310: END IF;
2311: IF ( p_rel_type_code = 'CONNECTED-TO' AND
2312: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN
2313: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');
2314: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);
2315: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);
2316: FND_MSG_PUB.add;
2317: Raise fnd_api.g_exc_error;
2318: END IF;

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

2311: IF ( p_rel_type_code = 'CONNECTED-TO' AND
2312: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN
2313: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');
2314: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);
2315: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);
2316: FND_MSG_PUB.add;
2317: Raise fnd_api.g_exc_error;
2318: END IF;
2319:

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

2317: Raise fnd_api.g_exc_error;
2318: END IF;
2319:
2320: IF ((l_txn_hdr_id1 <> l_txn_hdr_id2 ) AND (l_txn_type_id1 = l_txn_type_id2) ) THEN
2321: FND_MESSAGE.set_name('CSI','CSI_TXN_RLT_XSO_NOT_ALLOWED');
2322: FND_MSG_PUB.add;
2323: Raise fnd_api.g_exc_error;
2324: END IF;
2325:

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

2363: CLOSE cz_config_dtl_cur ;
2364:
2365: IF l_config_hdr_id is NULL
2366: THEN
2367: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
2368: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2369: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2370: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2371: fnd_msg_pub.add;

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

2364:
2365: IF l_config_hdr_id is NULL
2366: THEN
2367: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
2368: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2369: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2370: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2371: fnd_msg_pub.add;
2372: RAISE fnd_api.g_exc_error;

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

2365: IF l_config_hdr_id is NULL
2366: THEN
2367: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
2368: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2369: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2370: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2371: fnd_msg_pub.add;
2372: RAISE fnd_api.g_exc_error;
2373: END IF ;

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

2366: THEN
2367: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_INST_KEY');
2368: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2369: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2370: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2371: fnd_msg_pub.add;
2372: RAISE fnd_api.g_exc_error;
2373: END IF ;
2374: END LOOP ;

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

2435:
2436: IF x_instance_id IS NULL
2437: AND x_txn_line_detail_id IS NULL
2438: THEN
2439: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2440: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2441: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2442: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2443: fnd_msg_pub.add;

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

2436: IF x_instance_id IS NULL
2437: AND x_txn_line_detail_id IS NULL
2438: THEN
2439: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2440: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2441: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2442: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2443: fnd_msg_pub.add;
2444: RAISE fnd_api.g_exc_error;

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

2437: AND x_txn_line_detail_id IS NULL
2438: THEN
2439: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2440: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2441: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2442: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2443: fnd_msg_pub.add;
2444: RAISE fnd_api.g_exc_error;
2445: END IF ;

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

2438: THEN
2439: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2440: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2441: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2442: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2443: fnd_msg_pub.add;
2444: RAISE fnd_api.g_exc_error;
2445: END IF ;
2446:

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

2510: CLOSE cz_config_cur ;
2511:
2512: IF l_config_session_hdr_id is NULL
2513: THEN
2514: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');
2515: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2516: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2517: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2518: fnd_msg_pub.add;

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

2511:
2512: IF l_config_session_hdr_id is NULL
2513: THEN
2514: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');
2515: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2516: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2517: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2518: fnd_msg_pub.add;
2519: RAISE fnd_api.g_exc_error;

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

2512: IF l_config_session_hdr_id is NULL
2513: THEN
2514: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');
2515: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2516: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2517: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2518: fnd_msg_pub.add;
2519: RAISE fnd_api.g_exc_error;
2520: END IF ;

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

2513: THEN
2514: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_SESSION_KEY');
2515: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2516: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2517: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2518: fnd_msg_pub.add;
2519: RAISE fnd_api.g_exc_error;
2520: END IF ;
2521: EXCEPTION