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 817: FND_MSG_PUB.add;

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

Line 842: FND_MSG_PUB.add;

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;
845:
846: -- Added for Bug 13896396

Line 860: fnd_msg_pub.add;

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

Line 880: FND_MSG_PUB.add;

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

Line 893: FND_MSG_PUB.add;

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

Line 938: FND_MSG_PUB.add;

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

Line 976: FND_MSG_PUB.add;

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

Line 984: FND_MSG_PUB.add;

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

Line 1074: FND_MSG_PUB.add;

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

Line 1106: FND_MSG_PUB.add;

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;
1109: END IF; -- source flag chk = 'N'
1110:

Line 1117: FND_MSG_PUB.add;

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

Line 1176: FND_MSG_PUB.add;

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

Line 1200: FND_MSG_PUB.add;

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

Line 1421: FND_MSG_PUB.add;

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

Line 1434: FND_MSG_PUB.add;

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

Line 1578: fnd_msg_pub.add;

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

Line 1597: fnd_msg_pub.add;

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

Line 1613: fnd_msg_pub.add;

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

Line 1875: fnd_msg_pub.add;

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

Line 1899: fnd_msg_pub.add;

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

Line 1910: fnd_msg_pub.add;

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

Line 1953: fnd_msg_pub.add;

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

Line 1977: fnd_msg_pub.add;

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

Line 2091: FND_MSG_PUB.add;

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

Line 2102: FND_MSG_PUB.add;

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

Line 2125: FND_MSG_PUB.add;

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

Line 2207: FND_MSG_PUB.add;

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

Line 2227: FND_MSG_PUB.add;

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

Line 2245: FND_MSG_PUB.add;

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

Line 2316: FND_MSG_PUB.add;

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

Line 2322: FND_MSG_PUB.add;

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

Line 2371: fnd_msg_pub.add;

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

Line 2443: fnd_msg_pub.add;

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

Line 2518: fnd_msg_pub.add;

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