eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on FND_MSG_PUB

Line 22: FND_MSG_PUB.add;

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;
26:

Line 41: FND_MSG_PUB.add;

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;
45:

Line 60: FND_MSG_PUB.add;

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;
64:

Line 668: fnd_msg_pub.add;

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;
671:
672: END IF;

Line 686: FND_MSG_PUB.add;

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 ;
690: ---Added (End) for m-to-m enhancements

Line 735: FND_MSG_PUB.add;

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;
737:
738: END IF;
739: END IF;

Line 749: FND_MSG_PUB.add;

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;
752: END IF;
753: END LOOP;

Line 762: FND_MSG_PUB.add;

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

Line 816: FND_MSG_PUB.add;

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;
820:

Line 841: FND_MSG_PUB.add;

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;
844:
845: IF p_txn_line_dtl_tbl(l_td_ind).source_transaction_flag = 'Y' THEN

Line 853: FND_MSG_PUB.add;

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;
856:
857: END IF;

Line 866: FND_MSG_PUB.add;

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;
869:
870: END IF;

Line 911: FND_MSG_PUB.add;

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;
915:

Line 949: FND_MSG_PUB.add;

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
953: (p_iir_tbl(l_ind).object_type = 'I' ) ) THEN --atleast one of them should be 'T'

Line 957: FND_MSG_PUB.add;

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;
961:

Line 1047: FND_MSG_PUB.add;

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)
1051:

Line 1079: FND_MSG_PUB.add;

1075: FND_MESSAGE.set_name('CSI','CSI_TXN_NON_SRC_AND_NO_RLTN');
1076: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);
1077: FND_MESSAGE.set_token('ITEM_ID',
1078: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1079: FND_MSG_PUB.add;
1080: RAISE FND_API.g_exc_error;
1081: END IF;
1082: END IF; -- source flag chk = 'N'
1083:

Line 1090: FND_MSG_PUB.add;

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;
1093: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
1094: RAISE FND_API.g_exc_error;

Line 1149: FND_MSG_PUB.add;

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;
1152:
1153: l_ii_rltns_tbl(l_ii_ind).subject_id :=

Line 1173: FND_MSG_PUB.add;

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;
1176:
1177: l_ii_rltns_tbl(l_ii_ind).object_id :=

Line 1394: FND_MSG_PUB.add;

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;
1398:

Line 1407: FND_MSG_PUB.add;

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
1411:

Line 1551: fnd_msg_pub.add;

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;
1555:

Line 1570: fnd_msg_pub.add;

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;
1574:

Line 1586: fnd_msg_pub.add;

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:
1590: ELSIF p_level = 'ORG_ATTRIB' THEN

Line 1848: fnd_msg_pub.add;

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;
1852:

Line 1872: fnd_msg_pub.add;

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
1876: WHEN too_many_rows THEN

Line 1883: fnd_msg_pub.add;

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
1887: WHEN fnd_api.g_exc_error THEN

Line 1926: fnd_msg_pub.add;

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;
1930:

Line 1950: fnd_msg_pub.add;

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
1954: WHEN too_many_rows THEN

Line 2064: FND_MSG_PUB.add;

2060: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2061: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2062: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2063: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2064: FND_MSG_PUB.add;
2065: RAISE fnd_api.g_exc_error;
2066: END IF;
2067: END IF ;
2068:

Line 2075: FND_MSG_PUB.add;

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;
2079:

Line 2098: FND_MSG_PUB.add;

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

Line 2180: FND_MSG_PUB.add;

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
2184: ( l_active_end_date <> fnd_api.g_miss_date) ) THEN

Line 2200: FND_MSG_PUB.add;

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

Line 2218: FND_MSG_PUB.add;

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:
2222: BEGIN

Line 2289: FND_MSG_PUB.add;

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:
2293: IF ((l_txn_hdr_id1 <> l_txn_hdr_id2 ) AND (l_txn_type_id1 = l_txn_type_id2) ) THEN

Line 2295: FND_MSG_PUB.add;

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:
2299: EXCEPTION

Line 2344: fnd_msg_pub.add;

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 ;
2348: END IF ; ---p_txn_line_dtl_tbl.COUNT

Line 2416: fnd_msg_pub.add;

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:
2420: EXCEPTION

Line 2491: fnd_msg_pub.add;

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
2495: WHEN fnd_api.g_exc_error