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_UTL_PKG dependencies on FND_MSG_PUB

Line 80: fnd_msg_pub.add;

76: WHEN no_data_found THEN
77: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');
78: fnd_message.set_token('INSTANCE_ID',p_instance_id);
79: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );
80: fnd_msg_pub.add;
81: l_inst_pty_id := -1;
82: RETURN l_inst_pty_id;
83: WHEN others THEN
84: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');

Line 87: fnd_msg_pub.add;

83: WHEN others THEN
84: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');
85: fnd_message.set_token('INSTANCE_ID',p_instance_id);
86: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );
87: fnd_msg_pub.add;
88: l_inst_pty_id := -1;
89: RETURN l_inst_pty_id;
90: END get_curr_party;
91:

Line 110: fnd_msg_pub.add;

106: EXCEPTION
107: WHEN no_data_found THEN
108: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');
109: fnd_message.set_token('INSTANCE_OU_ID',p_instance_ou_id);
110: fnd_msg_pub.add;
111: l_obj_ver_num := -1;
112: RETURN l_obj_ver_num;
113: WHEN others THEN
114: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');

Line 116: fnd_msg_pub.add;

112: RETURN l_obj_ver_num;
113: WHEN others THEN
114: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');
115: fnd_message.set_token('INSTANCE_OU_ID',p_instance_ou_id);
116: fnd_msg_pub.add;
117: l_obj_ver_num := -1;
118: RETURN l_obj_ver_num;
119: END get_org_obj_ver_num;
120:

Line 143: fnd_msg_pub.add;

139: EXCEPTION
140: WHEN no_data_found THEN
141: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
142: fnd_message.set_token('RELATIONSHIP_ID',p_relationship_id);
143: fnd_msg_pub.add;
144: l_obj_ver_num := -1;
145: RETURN l_obj_ver_num;
146: WHEN others THEN
147: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');

Line 149: fnd_msg_pub.add;

145: RETURN l_obj_ver_num;
146: WHEN others THEN
147: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
148: fnd_message.set_token('RELATIONSHIP_ID',p_relationship_id);
149: fnd_msg_pub.add;
150: l_obj_ver_num := -1;
151: RETURN l_obj_ver_num;
152: END get_ii_obj_ver_num;
153:

Line 181: fnd_msg_pub.add;

177: WHEN no_data_found THEN
178: fnd_message.set_name('CSI','CSI_INT_INV_EXT_ATTR_ID');
179: fnd_message.set_token('INSTANCE_ID',p_instance_id);
180: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
181: fnd_msg_pub.add;
182: x_return_status := fnd_api.g_ret_sts_error;
183: WHEN too_many_rows THEN
184: fnd_message.set_name('CSI','CSI_INT_MANY_ATTR_FOUND');
185: fnd_message.set_token('INSTANCE_ID',p_instance_id);

Line 187: fnd_msg_pub.add;

183: WHEN too_many_rows THEN
184: fnd_message.set_name('CSI','CSI_INT_MANY_ATTR_FOUND');
185: fnd_message.set_token('INSTANCE_ID',p_instance_id);
186: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
187: fnd_msg_pub.add;
188: x_return_status := fnd_api.g_ret_sts_error;
189: END get_ext_attribs;
190:
191: PROCEDURE get_org_assign(

Line 219: fnd_msg_pub.add;

215: fnd_message.set_name('CSI','CSI_INT_INV_OU_ID');
216: fnd_message.set_token('INSTANCE_ID',p_instance_id);
217: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
218: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
219: fnd_msg_pub.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: WHEN too_many_rows THEN
222: fnd_message.set_name('CSI','CSI_INT_MANY_OU_FOUND');
223: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_id);

Line 226: fnd_msg_pub.add;

222: fnd_message.set_name('CSI','CSI_INT_MANY_OU_FOUND');
223: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_id);
224: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
225: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
226: fnd_msg_pub.add;
227: x_return_status := fnd_api.g_ret_sts_error;
228: END get_org_assign;
229:
230: PROCEDURE get_party_account(

Line 257: fnd_msg_pub.add;

253: WHEN no_data_found THEN
254: fnd_message.set_name('CSI','CSI_INT_INV_ACCT_ID');
255: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);
256: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_error;
259: WHEN too_many_rows THEN
260: fnd_message.set_name('CSI','CSI_INT_MANY_ACCT_FOUND');
261: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);

Line 263: fnd_msg_pub.add;

259: WHEN too_many_rows THEN
260: fnd_message.set_name('CSI','CSI_INT_MANY_ACCT_FOUND');
261: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);
262: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
263: fnd_msg_pub.add;
264: x_return_status := fnd_api.g_ret_sts_error;
265: END get_party_account;
266:
267: PROCEDURE get_instance_party(

Line 296: fnd_msg_pub.add;

292: WHEN no_data_found THEN
293: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
294: fnd_message.set_token('INSTANCE_ID',p_instance_id);
295: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;
298: WHEN too_many_rows THEN
299: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
300: fnd_message.set_token('INSTANCE_ID',p_instance_id);

Line 302: fnd_msg_pub.add;

298: WHEN too_many_rows THEN
299: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
300: fnd_message.set_token('INSTANCE_ID',p_instance_id);
301: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
302: fnd_msg_pub.add;
303: x_return_status := fnd_api.g_ret_sts_error;
304:
305: END get_instance_party;
306:

Line 334: fnd_msg_pub.add;

330: EXCEPTION
331: WHEN no_data_found THEN
332: fnd_message.set_name('CSI','CSI_INT_INV_INST_ID');
333: fnd_message.set_token('INSTANCE_ID',p_instance_id);
334: fnd_msg_pub.add;
335: x_return_status := fnd_api.g_ret_sts_error;
336: END get_instance;
337:
338: FUNCTION get_ext_obj_ver_num(

Line 358: fnd_msg_pub.add;

354: EXCEPTION
355: WHEN no_data_found THEN
356: fnd_message.set_name('CSI','CSI_INT_INV_ATTR_VALUE_ID');
357: fnd_message.set_token('ATTRIBUTE_VALUE_ID',p_attrib_value_id);
358: fnd_msg_pub.add;
359: l_obj_ver_num := -1;
360: RETURN l_obj_ver_num;
361: END get_ext_obj_ver_num;
362:

Line 383: fnd_msg_pub.add;

379: EXCEPTION
380: WHEN no_data_found THEN
381: fnd_message.set_name('CSI','CSI_INT_INST_PTY_MISSING');
382: fnd_message.set_token('INSTANCE_PARTY_ID',p_inst_pty_id);
383: fnd_msg_pub.add;
384: l_obj_ver_num := -1;
385: RETURN l_obj_ver_num;
386: END get_pty_obj_ver_num;
387:

Line 407: fnd_msg_pub.add;

403: EXCEPTION
404: WHEN no_data_found THEN
405: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');
406: fnd_message.set_token('IP_ACCOUNT_ID',p_ip_acct_id);
407: fnd_msg_pub.add;
408: l_obj_ver_num := -1;
409: RETURN l_obj_ver_num;
410: WHEN others THEN
411: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');

Line 413: fnd_msg_pub.add;

409: RETURN l_obj_ver_num;
410: WHEN others THEN
411: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');
412: fnd_message.set_token('IP_ACCOUNT_ID',p_ip_acct_id);
413: fnd_msg_pub.add;
414: l_obj_ver_num := -1;
415: RETURN l_obj_ver_num;
416: END get_acct_obj_ver_num;
417:

Line 442: fnd_msg_pub.add;

438:
439: WHEN no_data_found THEN
440: fnd_message.set_name('CSI', 'CSI_DFLT_SUB_TYPE_MISSING');
441: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_error;
444: WHEN too_many_rows THEN
445: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');
446: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);

Line 447: fnd_msg_pub.add;

443: x_return_status := fnd_api.g_ret_sts_error;
444: WHEN too_many_rows THEN
445: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');
446: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);
447: fnd_msg_pub.add;
448: x_return_status := fnd_api.g_ret_sts_error;
449: END get_dflt_sub_type_id;
450:
451: PROCEDURE get_dflt_inst_status_id(

Line 471: fnd_msg_pub.add;

467: EXCEPTION
468: WHEN no_data_found THEN
469: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');
470: fnd_message.set_token('INSTANCE_STATUS', l_status_name);
471: fnd_msg_pub.add;
472: x_return_status := fnd_api.g_ret_sts_error;
473: WHEN too_many_rows THEN
474: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');
475: fnd_message.set_token('INSTANCE_STATUS', l_status_name);

Line 476: fnd_msg_pub.add;

472: x_return_status := fnd_api.g_ret_sts_error;
473: WHEN too_many_rows THEN
474: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');
475: fnd_message.set_token('INSTANCE_STATUS', l_status_name);
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.g_ret_sts_error;
478: END get_dflt_inst_status_id;
479:
480: FUNCTION get_primay_uom(

Line 503: fnd_msg_pub.add;

499: WHEN no_data_found THEN
500: fnd_message.set_name('CSI','CSI_INT_INV_ITEM_ID');
501: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);
502: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);
503: fnd_msg_pub.add;
504: l_uom_code := '';
505: RETURN l_uom_code;
506: END get_primay_uom;
507:

Line 879: fnd_msg_pub.add;

875: EXCEPTION
876: WHEN no_data_found THEN
877: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
878: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);
879: fnd_msg_pub.add;
880: RAISE fnd_api.g_exc_error;
881: WHEN too_many_rows THEN
882: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
883: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);

Line 884: fnd_msg_pub.add;

880: RAISE fnd_api.g_exc_error;
881: WHEN too_many_rows THEN
882: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
883: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);
884: fnd_msg_pub.add;
885: RAISE fnd_api.g_exc_error;
886: END ;
887:
888: IF p_order_shipment_rec.ib_install_loc is not null

Line 905: fnd_msg_pub.add;

901: Exception
902: When no_data_found then
903: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
904: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_install_loc_id); -- ship_to_org_id);
905: fnd_msg_pub.add;
906: debug('Party_site_id not found');
907: raise fnd_api.g_exc_error;
908: when too_many_rows then
909: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 911: fnd_msg_pub.add;

907: raise fnd_api.g_exc_error;
908: when too_many_rows then
909: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
910: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_install_loc_id); -- ship_to_org_id);
911: fnd_msg_pub.add;
912: debug('Party_site_id not found');
913: raise fnd_api.g_exc_error;
914: end ;
915: END IF;

Line 1078: fnd_msg_pub.add;

1074: EXCEPTION
1075: WHEN no_data_found then
1076: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
1077: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);
1078: fnd_msg_pub.add;
1079: RAISE fnd_api.g_exc_error;
1080: WHEN too_many_rows then
1081: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
1082: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);

Line 1083: fnd_msg_pub.add;

1079: RAISE fnd_api.g_exc_error;
1080: WHEN too_many_rows then
1081: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
1082: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);
1083: fnd_msg_pub.add;
1084: RAISE fnd_api.g_exc_error;
1085: END;
1086:
1087: x_txn_line_dtl_rec.lot_number := p_order_shipment_rec.lot_number;

Line 1229: fnd_msg_pub.add;

1225: EXCEPTION
1226: WHEN no_data_found THEN
1227: fnd_message.set_name('CSI','CSI_INT_INV_CUST_ACCT_ID');
1228: fnd_message.set_token('CUST_ACCOUNT_ID', p_cust_acct_id);
1229: fnd_msg_pub.add;
1230: RAISE fnd_api.g_exc_error;
1231: END;
1232:
1233: EXCEPTION

Line 1268: fnd_msg_pub.add;

1264: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
1265: fnd_message.set_token('INSTANCE_ID', p_instance_id);
1266: fnd_message.set_token('INSTANCE_PARTY_ID', p_inst_party_id);
1267: fnd_message.set_token('RELATIONSHIP_TYPE_CODE', p_inst_party_id);
1268: fnd_msg_pub.add;
1269: RETURN l_ret_status;
1270: END validate_inst_party;
1271:
1272: FUNCTION get_instance(

Line 1290: fnd_msg_pub.add;

1286: EXCEPTION
1287: WHEN no_data_found THEN
1288: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');
1289: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1290: fnd_msg_pub.add;
1291: l_inst_id := -1;
1292: RETURN l_inst_id;
1293: WHEN others THEN
1294: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');

Line 1296: fnd_msg_pub.add;

1292: RETURN l_inst_id;
1293: WHEN others THEN
1294: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');
1295: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1296: fnd_msg_pub.add;
1297: l_inst_id := -1;
1298: RETURN l_inst_id;
1299: END get_instance;
1300:

Line 1348: fnd_msg_pub.add;

1344: EXCEPTION
1345: WHEN no_data_found THEN
1346: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1347: fnd_message.set_token('INSTANCE_ID',p_instance_id);
1348: fnd_msg_pub.add;
1349: l_inst_party_id := -1;
1350: RETURN l_inst_party_id;
1351: -- Added for 3185043
1352: WHEN too_many_rows THEN

Line 1355: fnd_msg_pub.add;

1351: -- Added for 3185043
1352: WHEN too_many_rows THEN
1353: fnd_message.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');
1354: fnd_message.set_token('INSTANCE_ID',p_instance_id);
1355: fnd_msg_pub.add;
1356: l_inst_party_id := -1;
1357: RETURN l_inst_party_id;
1358: WHEN others THEN
1359: -- fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');

Line 1363: fnd_msg_pub.add;

1359: -- fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1360: -- fnd_message.set_token('INSTANCE_ID',p_instance_id);
1361: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1362: fnd_message.set_token('SQL_ERROR',SQLERRM);
1363: fnd_msg_pub.add;
1364: l_inst_party_id := -1;
1365: RETURN l_inst_party_id;
1366: END get_instance_party_id;
1367:

Line 1388: fnd_msg_pub.add;

1384: exception
1385: when others then
1386: fnd_message.set_name('CSI','CSI_INT_INV_TRX_LINE_ID');
1387: fnd_message.set_token('TRX_LINE_ID',p_trx_line_id);
1388: fnd_msg_pub.add;
1389: l_trx_type_id := -1;
1390: RETURN l_trx_type_id;
1391:
1392: END Get_trx_type_id;

Line 1416: fnd_msg_pub.add;

1412: when others then
1413: fnd_message.set_name('CSI','CSI_INT_INV_SRC_TRX_ID');
1414: fnd_message.set_token('SOURCE_TRANSACTION_ID',p_src_trx_id);
1415: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',p_src_table_name);
1416: fnd_msg_pub.add;
1417: l_trx_line_id := -1;
1418: RETURN l_trx_line_id;
1419: END Get_trx_line_id;
1420:

Line 1444: fnd_msg_pub.add;

1440: exception
1441: when others then
1442: fnd_message.set_name('CSI','CSI_INT_OWNER_ACCT_MISSING');
1443: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_party_id);
1444: fnd_msg_pub.add;
1445: l_ip_acct_id := -1;
1446: RETURN l_ip_acct_id;
1447: END get_ip_account_id;
1448:

Line 1475: fnd_msg_pub.add;

1471: EXCEPTION
1472: WHEN no_data_found THEN
1473: fnd_message.set_name('CSI','CSI_INT_MSTR_ORG_MISSING');
1474: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
1475: fnd_msg_pub.add;
1476: x_return_status := l_fnd_error;
1477: WHEN others THEN
1478: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1479: fnd_message.set_token('SQL_ERROR',SQLERRM);

Line 1480: fnd_msg_pub.add;

1476: x_return_status := l_fnd_error;
1477: WHEN others THEN
1478: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1479: fnd_message.set_token('SQL_ERROR',SQLERRM);
1480: fnd_msg_pub.add;
1481: x_return_status := l_fnd_unexpected;
1482: END get_master_organization;
1483:
1484: PROCEDURE get_int_party

Line 1504: fnd_msg_pub.add;

1500: x_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
1501:
1502: IF x_int_party_id IS NULL THEN
1503: fnd_message.set_name('CSI','CSI_INT_INT_PTY_ID_MISSING');
1504: fnd_msg_pub.add;
1505: x_return_status := fnd_api.g_ret_sts_error;
1506: ELSE
1507: x_return_status := fnd_api.g_ret_sts_success;
1508: END IF;

Line 1513: fnd_msg_pub.add;

1509:
1510: exception
1511: when others then
1512: fnd_message.set_name('CSI','CSI_INT_INT_PTY_ID_MISSING');
1513: fnd_msg_pub.add;
1514: x_return_status := fnd_api.g_ret_sts_error;
1515: END get_int_party;
1516:
1517: FUNCTION get_serial_contl_code

Line 1548: fnd_msg_pub.add;

1544: when others then
1545: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1546: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);
1547: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);
1548: fnd_msg_pub.add;
1549: l_serial_code := -1;
1550: RETURN l_serial_code;
1551: END get_serial_contl_code;
1552:

Line 1667: fnd_msg_pub.add;

1663: EXCEPTION
1664: WHEN no_data_found THEN
1665: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
1666: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);
1667: fnd_msg_pub.add;
1668: RAISE fnd_api.g_exc_error;
1669: WHEN too_many_rows THEN
1670: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
1671: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);

Line 1672: fnd_msg_pub.add;

1668: RAISE fnd_api.g_exc_error;
1669: WHEN too_many_rows THEN
1670: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
1671: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);
1672: fnd_msg_pub.add;
1673: RAISE fnd_api.g_exc_error;
1674: END;
1675:
1676: debug(' order_number : '||l_order_line_rec.order_number);

Line 1698: fnd_msg_pub.add;

1694: THEN
1695: l_order_line_rec.ib_owner := 'END_CUSTOMER';
1696: IF l_partner_rec.END_CUSTOMER_ID is null Then
1697: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1698: fnd_msg_pub.add;
1699: raise fnd_api.g_exc_error;
1700: ELSE
1701: l_order_line_rec.end_customer_id := l_partner_rec.end_customer_id;
1702: END IF;

Line 1719: fnd_msg_pub.add;

1715: THEN
1716: IF l_partner_rec.end_customer_site_use_id is null
1717: THEN
1718: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1719: fnd_msg_pub.add;
1720: raise fnd_api.g_exc_error;
1721: ELSE
1722: l_order_line_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;
1723: END IF;

Line 1729: fnd_msg_pub.add;

1725: THEN
1726: IF l_order_line_rec.ship_to_org_id is null
1727: THEN
1728: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1729: fnd_msg_pub.add;
1730: raise fnd_api.g_exc_error;
1731: ELSE
1732: l_order_line_rec.ib_install_loc_id := l_order_line_rec.ship_to_org_id;
1733: END IF;

Line 1739: fnd_msg_pub.add;

1735: THEN
1736: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 l_order_line_rec.sold_to_org_id is null
1737: THEN
1738: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1739: fnd_msg_pub.add;
1740: raise fnd_api.g_exc_error;
1741: ELSE
1742: l_order_line_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 l_order_line_rec.sold_to_org_id;
1743: END IF;

Line 1749: fnd_msg_pub.add;

1745: THEN
1746: IF l_order_line_rec.deliver_to_org_id is null
1747: THEN
1748: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1749: fnd_msg_pub.add;
1750: raise fnd_api.g_exc_error;
1751: ELSE
1752: l_order_line_rec.ib_install_loc_id := l_order_line_rec.deliver_to_org_id;
1753: END IF;

Line 1759: fnd_msg_pub.add;

1755: THEN
1756: IF l_order_line_rec.invoice_to_org_id is null
1757: THEN
1758: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1759: fnd_msg_pub.add;
1760: raise fnd_api.g_exc_error;
1761: ELSE
1762: l_order_line_rec.ib_install_loc_id := l_order_line_rec.invoice_to_org_id;
1763: END IF;

Line 1780: fnd_msg_pub.add;

1776: THEN
1777: IF l_partner_rec.end_customer_site_use_id is null
1778: THEN
1779: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1780: fnd_msg_pub.add;
1781: raise fnd_api.g_exc_error;
1782: ELSE
1783: l_order_line_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;
1784: END IF;

Line 1790: fnd_msg_pub.add;

1786: THEN
1787: IF l_order_line_rec.ship_to_org_id is null
1788: THEN
1789: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1790: fnd_msg_pub.add;
1791: raise fnd_api.g_exc_error;
1792: ELSE
1793: l_order_line_rec.ib_current_loc_id := l_order_line_rec.ship_to_org_id;
1794: END IF;

Line 1800: fnd_msg_pub.add;

1796: THEN
1797: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 l_order_line_rec.sold_to_org_id is null
1798: THEN
1799: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1800: fnd_msg_pub.add;
1801: raise fnd_api.g_exc_error;
1802: ELSE
1803: l_order_line_rec.ib_current_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 l_order_line_rec.sold_to_org_id;
1804: END IF;

Line 1810: fnd_msg_pub.add;

1806: THEN
1807: IF l_order_line_rec.deliver_to_org_id is null
1808: THEN
1809: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1810: fnd_msg_pub.add;
1811: raise fnd_api.g_exc_error;
1812: ELSE
1813: l_order_line_rec.ib_current_loc_id := l_order_line_rec.deliver_to_org_id;
1814: END IF;

Line 1820: fnd_msg_pub.add;

1816: THEN
1817: IF l_order_line_rec.invoice_to_org_id is null
1818: THEN
1819: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1820: fnd_msg_pub.add;
1821: raise fnd_api.g_exc_error;
1822: ELSE
1823: l_order_line_rec.ib_current_loc_id := l_order_line_rec.invoice_to_org_id;
1824: END IF;

Line 1866: fnd_msg_pub.add;

1862: x_return_status := fnd_api.g_ret_sts_error;
1863: WHEN others THEN
1864: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');
1865: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);
1866: fnd_msg_pub.add;
1867: x_return_status := fnd_api.g_ret_sts_error;
1868:
1869: END get_order_line_dtls;
1870:

Line 1899: fnd_msg_pub.add;

1895: x_return_status := fnd_api.g_ret_sts_success;
1896: WHEN others THEN
1897: fnd_message.set_name('CSI','CSI_INT_SPL_ORD_LINE_MISSING');
1898: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1899: fnd_msg_pub.add;
1900: x_return_status := fnd_api.g_ret_sts_error;
1901: END get_split_order_line;
1902:
1903: PROCEDURE get_sub_type_rec(

Line 1945: fnd_msg_pub.add;

1941: WHEN others THEN
1942: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
1943: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
1944: fnd_message.set_token('TRANSACTION_TYPE_ID', p_trx_type_id);
1945: fnd_msg_pub.add;
1946: x_return_status := fnd_api.g_ret_sts_error;
1947: END get_sub_type_rec;
1948:
1949: PROCEDURE get_inst_relation

Line 1976: fnd_msg_pub.add;

1972: exception
1973: when others then
1974: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
1975: fnd_message.set_token('RELATIONSHIP_ID', p_ii_relationship_id);
1976: fnd_msg_pub.add;
1977: x_return_status := fnd_api.g_ret_sts_error;
1978: END get_inst_relation;
1979:
1980: PROCEDURE get_model_inst_lst(

Line 2046: fnd_msg_pub.add;

2042: EXCEPTION
2043: WHEN no_data_found THEN
2044: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2045: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2046: fnd_msg_pub.add;
2047: l_ordered_quantity := 0;
2048: WHEN others THEN
2049: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2050: fnd_message.set_token('LINE_ID',p_link_to_line_id);

Line 2051: fnd_msg_pub.add;

2047: l_ordered_quantity := 0;
2048: WHEN others THEN
2049: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2050: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2051: fnd_msg_pub.add;
2052: l_ordered_quantity := 0;
2053: END ;
2054: ELSE
2055: l_order_line_qty := p_order_line_qty;

Line 2069: fnd_msg_pub.add;

2065: EXCEPTION
2066: WHEN no_data_found THEN
2067: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2068: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2069: fnd_msg_pub.add;
2070: l_ordered_quantity := 0;
2071: WHEN others THEN
2072: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2073: fnd_message.set_token('LINE_ID',p_link_to_line_id);

Line 2074: fnd_msg_pub.add;

2070: l_ordered_quantity := 0;
2071: WHEN others THEN
2072: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2073: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2074: fnd_msg_pub.add;
2075: l_ordered_quantity := 0;
2076: END ;
2077:
2078: -- Begin Fix for Bug 3419252

Line 2099: fnd_msg_pub.add;

2095: Exception
2096: WHEN no_data_found THEN
2097: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2098: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2099: fnd_msg_pub.add;
2100: l_ordered_quantity := 0;
2101: End;
2102:
2103: IF l_parent_line_id is null

Line 2171: fnd_msg_pub.add;

2167: when no_data_found then --fix for bug5045398--
2168: debug('Passed link_to_line_id '||x_link_to_line_id||' does not exists in oe order lines');
2169: fnd_message.set_name('CSI','CSI_OE_LINK_TO_LINE_ID_INVALID');
2170: fnd_message.set_token('OE_LINK_TO_LINE_ID', x_link_to_line_id);
2171: fnd_msg_pub.add;
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: l_found := TRUE;
2174: --end of fix--
2175: end;

Line 2179: fnd_msg_pub.add;

2175: end;
2176: WHEN others THEN
2177: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2178: fnd_message.set_token('LINE_ID',x_link_to_line_id);
2179: fnd_msg_pub.add;
2180: END ;
2181:
2182: END LOOP; --end of while loop
2183:

Line 3560: fnd_msg_pub.add;

3556: WHEN no_data_found THEN
3557: x_return_status := fnd_api.g_ret_sts_error;
3558: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');
3559: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);
3560: fnd_msg_pub.add;
3561: END get_source_trx_dtls;
3562:
3563: PROCEDURE split_txn_dtls_with_qty( --Included the API for bug 4354267
3564: split_txn_dtl_id IN NUMBER,

Line 4868: fnd_msg_pub.add;

4864: EXCEPTION
4865: WHEN NO_DATA_FOUND THEN
4866: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4867: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4868: fnd_msg_pub.add;
4869: debug('Item being replaced belongs to a different configuration.');
4870: RAISE fnd_api.g_exc_error;
4871: WHEN OTHERS THEN
4872: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

Line 4874: fnd_msg_pub.add;

4870: RAISE fnd_api.g_exc_error;
4871: WHEN OTHERS THEN
4872: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4873: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4874: fnd_msg_pub.add;
4875: debug('Item being replaced belongs to a different configuration.');
4876: RAISE fnd_api.g_exc_error;
4877: END;
4878:

Line 4889: fnd_msg_pub.add;

4885: EXCEPTION
4886: WHEN OTHERS THEN
4887: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4888: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4889: fnd_msg_pub.add;
4890: debug('Item being replaced belongs to a different configuration.');
4891: RAISE fnd_api.g_exc_error;
4892: END;
4893: debug('Item location_type_code = '||l_location_type_code);

Line 4915: fnd_msg_pub.add;

4911: debug('l_item_status = '||l_item_status);
4912: IF l_item_status is null THEN
4913: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4914: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4915: fnd_msg_pub.add;
4916: debug('Item is in INVENTORY and relationship is Active');
4917: RAISE fnd_api.g_exc_error;
4918: ELSE
4919: /* Check if it is a repair */

Line 5012: fnd_msg_pub.add;

5008: IF check_instance_status%notfound THEN
5009: close check_instance_status;
5010: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5011: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5012: fnd_msg_pub.add;
5013: debug('Check instance status - The item being replaced is no longer valid.');
5014: RAISE fnd_api.g_exc_error;
5015: ELSE
5016: close check_instance_status;

Line 5043: fnd_msg_pub.add;

5039: EXCEPTION
5040: WHEN NO_DATA_FOUND THEN
5041: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5042: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5043: fnd_msg_pub.add;
5044: debug('No data found - Item being replaced is no longer valid.');
5045: RAISE fnd_api.g_exc_error;
5046: WHEN OTHERS THEN
5047: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

Line 5049: fnd_msg_pub.add;

5045: RAISE fnd_api.g_exc_error;
5046: WHEN OTHERS THEN
5047: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5048: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5049: fnd_msg_pub.add;
5050: debug('Others - Item being replaced is no longer valid');
5051: RAISE fnd_api.g_exc_error;
5052: END;
5053:

Line 5132: fnd_msg_pub.add;

5128: EXCEPTION
5129: WHEN NO_DATA_FOUND THEN
5130: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5131: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5132: fnd_msg_pub.add;
5133: debug('No data found - Item being replaced is no longer valid.');
5134: RAISE fnd_api.g_exc_error;
5135: WHEN OTHERS THEN
5136: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

Line 5138: fnd_msg_pub.add;

5134: RAISE fnd_api.g_exc_error;
5135: WHEN OTHERS THEN
5136: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5137: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5138: fnd_msg_pub.add;
5139: debug('Others - Item being replaced is no longer valid');
5140: RAISE fnd_api.g_exc_error;
5141: END;
5142: END IF;

Line 5226: fnd_msg_pub.add;

5222: EXCEPTION
5223: WHEN no_data_found THEN
5224: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
5225: fnd_message.set_token('INSTANCE_ID',l_instance_id);
5226: fnd_msg_pub.add;
5227: raise fnd_api.g_exc_error;
5228: END;
5229:
5230: IF x_upd_party_acct_tbl.count > 0 THEN

Line 5621: fnd_msg_pub.add;

5617: EXCEPTION
5618: WHEN no_data_found THEN
5619: fnd_message.set_name('CSI','CSI_INT_CUST_ROLEID_MISSING');
5620: fnd_message.set_token('CUST_ACCOUNT_ROLE_ID',p_cust_acct_role_id);
5621: fnd_msg_pub.add;
5622: x_return_status := fnd_api.g_ret_sts_error ;
5623: END derive_party_id;
5624:
5625: PROCEDURE get_party_owner(

Line 6008: fnd_msg_pub.add;

6004: EXCEPTION
6005: WHEN no_data_found THEN
6006: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
6007: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_txn_id);
6008: fnd_msg_pub.add;
6009: RAISE fnd_api.g_exc_error;
6010:
6011: END;
6012:

Line 6048: fnd_msg_pub.add;

6044: WHEN no_data_found THEN
6045: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');
6046: fnd_message.set_token('INVENTORY_ITEM_ID', l_item_control_rec.inventory_item_id);
6047: fnd_message.set_token('INV_ORGANZATION_ID', l_item_control_rec.organization_id);
6048: fnd_msg_pub.add;
6049: RAISE fnd_api.g_exc_error;
6050: END;
6051:
6052: BEGIN

Line 6267: fnd_msg_pub.add;

6263: And tld.txn_line_detail_id = l_orig_oe_tld;
6264: Exception when others Then
6265: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6266: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
6267: fnd_msg_pub.add;
6268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6269: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
6270: End;
6271:

Line 6647: fnd_msg_pub.add;

6643: IF p_split_flag = 'Y' THEN -- Bug 14471544
6644: fnd_message.set_name('CSI','CSI_INT_CHILD_RATIO_INVALID');
6645: fnd_message.set_token('CHILD_QTY',l_instance_tbl(l_ind).quantity);
6646: fnd_message.set_token('RATIO', p_quantity_ratio);
6647: fnd_msg_pub.add;
6648: debug ('The instance qty generated by the shipment interface '||
6649: l_instance_tbl(l_ind).quantity||' is greater than the MODEL/CHILD ratio '||
6650: p_quantity_ratio);
6651: