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 3518: fnd_msg_pub.add;

3514: WHEN no_data_found THEN
3515: x_return_status := fnd_api.g_ret_sts_error;
3516: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');
3517: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);
3518: fnd_msg_pub.add;
3519: END get_source_trx_dtls;
3520:
3521: PROCEDURE split_txn_dtls_with_qty( --Included the API for bug 4354267
3522: split_txn_dtl_id IN NUMBER,

Line 4826: fnd_msg_pub.add;

4822: EXCEPTION
4823: WHEN NO_DATA_FOUND THEN
4824: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4825: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4826: fnd_msg_pub.add;
4827: debug('Item being replaced belongs to a different configuration.');
4828: RAISE fnd_api.g_exc_error;
4829: WHEN OTHERS THEN
4830: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

Line 4832: fnd_msg_pub.add;

4828: RAISE fnd_api.g_exc_error;
4829: WHEN OTHERS THEN
4830: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4831: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4832: fnd_msg_pub.add;
4833: debug('Item being replaced belongs to a different configuration.');
4834: RAISE fnd_api.g_exc_error;
4835: END;
4836:

Line 4847: fnd_msg_pub.add;

4843: EXCEPTION
4844: WHEN OTHERS THEN
4845: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4846: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4847: fnd_msg_pub.add;
4848: debug('Item being replaced belongs to a different configuration.');
4849: RAISE fnd_api.g_exc_error;
4850: END;
4851: debug('Item location_type_code = '||l_location_type_code);

Line 4873: fnd_msg_pub.add;

4869: debug('l_item_status = '||l_item_status);
4870: IF l_item_status is null THEN
4871: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4872: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4873: fnd_msg_pub.add;
4874: debug('Item is in INVENTORY and relationship is Active');
4875: RAISE fnd_api.g_exc_error;
4876: ELSE
4877: /* Check if it is a repair */

Line 4970: fnd_msg_pub.add;

4966: IF check_instance_status%notfound THEN
4967: close check_instance_status;
4968: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4969: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
4970: fnd_msg_pub.add;
4971: debug('Check instance status - The item being replaced is no longer valid.');
4972: RAISE fnd_api.g_exc_error;
4973: ELSE
4974: close check_instance_status;

Line 4999: fnd_msg_pub.add;

4995: EXCEPTION
4996: WHEN NO_DATA_FOUND THEN
4997: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4998: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
4999: fnd_msg_pub.add;
5000: debug('No data found - Item being replaced is no longer valid.');
5001: RAISE fnd_api.g_exc_error;
5002: WHEN OTHERS THEN
5003: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

Line 5005: fnd_msg_pub.add;

5001: RAISE fnd_api.g_exc_error;
5002: WHEN OTHERS THEN
5003: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5004: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5005: fnd_msg_pub.add;
5006: debug('Others - Item being replaced is no longer valid');
5007: RAISE fnd_api.g_exc_error;
5008: END;
5009:

Line 5088: fnd_msg_pub.add;

5084: EXCEPTION
5085: WHEN NO_DATA_FOUND THEN
5086: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5087: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5088: fnd_msg_pub.add;
5089: debug('No data found - Item being replaced is no longer valid.');
5090: RAISE fnd_api.g_exc_error;
5091: WHEN OTHERS THEN
5092: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

Line 5094: fnd_msg_pub.add;

5090: RAISE fnd_api.g_exc_error;
5091: WHEN OTHERS THEN
5092: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5093: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5094: fnd_msg_pub.add;
5095: debug('Others - Item being replaced is no longer valid');
5096: RAISE fnd_api.g_exc_error;
5097: END;
5098: END IF;

Line 5180: fnd_msg_pub.add;

5176: EXCEPTION
5177: WHEN no_data_found THEN
5178: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
5179: fnd_message.set_token('INSTANCE_ID',l_instance_id);
5180: fnd_msg_pub.add;
5181: raise fnd_api.g_exc_error;
5182: END;
5183:
5184: IF x_upd_party_acct_tbl.count > 0 THEN

Line 5542: fnd_msg_pub.add;

5538: EXCEPTION
5539: WHEN no_data_found THEN
5540: fnd_message.set_name('CSI','CSI_INT_CUST_ROLEID_MISSING');
5541: fnd_message.set_token('CUST_ACCOUNT_ROLE_ID',p_cust_acct_role_id);
5542: fnd_msg_pub.add;
5543: x_return_status := fnd_api.g_ret_sts_error ;
5544: END derive_party_id;
5545:
5546: PROCEDURE get_party_owner(

Line 5929: fnd_msg_pub.add;

5925: EXCEPTION
5926: WHEN no_data_found THEN
5927: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
5928: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_txn_id);
5929: fnd_msg_pub.add;
5930: RAISE fnd_api.g_exc_error;
5931:
5932: END;
5933:

Line 5969: fnd_msg_pub.add;

5965: WHEN no_data_found THEN
5966: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');
5967: fnd_message.set_token('INVENTORY_ITEM_ID', l_item_control_rec.inventory_item_id);
5968: fnd_message.set_token('INV_ORGANZATION_ID', l_item_control_rec.organization_id);
5969: fnd_msg_pub.add;
5970: RAISE fnd_api.g_exc_error;
5971: END;
5972:
5973: BEGIN

Line 6188: fnd_msg_pub.add;

6184: And tld.txn_line_detail_id = l_orig_oe_tld;
6185: Exception when others Then
6186: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6187: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
6188: fnd_msg_pub.add;
6189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6190: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
6191: End;
6192:

Line 6565: fnd_msg_pub.add;

6561: IF l_instance_tbl(l_ind).quantity > p_quantity_ratio THEN
6562: fnd_message.set_name('CSI','CSI_INT_CHILD_RATIO_INVALID');
6563: fnd_message.set_token('CHILD_QTY',l_instance_tbl(l_ind).quantity);
6564: fnd_message.set_token('RATIO', p_quantity_ratio);
6565: fnd_msg_pub.add;
6566: debug ('The instance qty generated by the shipment interface '||
6567: l_instance_tbl(l_ind).quantity||' is greater than the MODEL/CHILD ratio '||
6568: p_quantity_ratio);
6569: