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

Line 630: fnd_msg_pub.add;

626: EXCEPTION
627: WHEN no_data_found then
628: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
629: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ib_current_loc_id);
630: fnd_msg_pub.add;
631: raise fnd_api.g_exc_error;
632: WHEN too_many_rows then
633: debug('Many Party sites found');
634: raise fnd_api.g_exc_error;

Line 653: fnd_msg_pub.add;

649: EXCEPTION
650: WHEN no_data_found then
651: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
652: fnd_message.set_token('LOCATION_ID',l_order_line_rec.ib_install_loc_id);
653: fnd_msg_pub.add;
654: raise fnd_api.g_exc_error;
655: WHEN too_many_rows then
656: debug('Many Party sites found');
657: raise fnd_api.g_exc_error;

Line 846: fnd_msg_pub.add;

842: WHEN no_data_found THEN
843: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');
844: fnd_message.set_token('SOURCE_TRANSACTION_ID', l_copy_txn_line_rec.SOURCE_TRANSACTION_ID);
845: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',l_copy_txn_line_rec.SOURCE_TRANSACTION_TABLE);
846: fnd_msg_pub.add;
847: raise fnd_api.g_exc_error;
848: END;
849:
850: ELSE

Line 1004: fnd_msg_pub.add;

1000: fnd_message.set_token('SOURCE_TRANSACTION_ID',
1001: l_copy_txn_line_rec.SOURCE_TRANSACTION_ID);
1002: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',
1003: l_copy_txn_line_rec.SOURCE_TRANSACTION_TABLE);
1004: fnd_msg_pub.add;
1005: raise fnd_api.g_exc_error;
1006: END;
1007: ELSE
1008:

Line 1891: fnd_msg_pub.add;

1887: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER'
1888: THEN
1889: IF l_partner_rec.END_CUSTOMER_ID is null Then
1890: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1891: fnd_msg_pub.add;
1892: raise fnd_api.g_exc_error;
1893: ELSE
1894: mmt_rec.ib_owner := l_partner_rec.ib_owner;
1895: mmt_rec.end_customer_id := l_partner_rec.end_customer_id;

Line 1913: fnd_msg_pub.add;

1909: THEN
1910: IF l_partner_rec.end_customer_site_use_id is null
1911: THEN
1912: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1913: fnd_msg_pub.add;
1914: raise fnd_api.g_exc_error;
1915: ELSE
1916: mmt_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;
1917: END IF;

Line 1923: fnd_msg_pub.add;

1919: THEN
1920: IF mmt_rec.ship_to_org_id is null
1921: THEN
1922: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1923: fnd_msg_pub.add;
1924: raise fnd_api.g_exc_error;
1925: ELSE
1926: mmt_rec.ib_install_loc_id := mmt_rec.ship_to_org_id;
1927: END IF;

Line 1933: fnd_msg_pub.add;

1929: THEN
1930: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
1931: THEN
1932: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1933: fnd_msg_pub.add;
1934: raise fnd_api.g_exc_error;
1935: ELSE
1936: mmt_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;
1937: END IF;

Line 1943: fnd_msg_pub.add;

1939: THEN
1940: IF mmt_rec.deliver_to_org_id is null
1941: THEN
1942: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1943: fnd_msg_pub.add;
1944: raise fnd_api.g_exc_error;
1945: ELSE
1946: mmt_rec.ib_install_loc_id := mmt_rec.deliver_to_org_id;
1947: END IF;

Line 1953: fnd_msg_pub.add;

1949: THEN
1950: IF mmt_rec.invoice_to_org_id is null
1951: THEN
1952: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1953: fnd_msg_pub.add;
1954: raise fnd_api.g_exc_error;
1955: ELSE
1956: mmt_rec.ib_install_loc_id := mmt_rec.invoice_to_org_id;
1957: END IF;

Line 1974: fnd_msg_pub.add;

1970: THEN
1971: IF l_partner_rec.end_customer_site_use_id is null
1972: THEN
1973: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1974: fnd_msg_pub.add;
1975: raise fnd_api.g_exc_error;
1976: ELSE
1977: mmt_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;
1978: END IF;

Line 1984: fnd_msg_pub.add;

1980: THEN
1981: IF mmt_rec.ship_to_org_id is null
1982: THEN
1983: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1984: fnd_msg_pub.add;
1985: raise fnd_api.g_exc_error;
1986: ELSE
1987: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;
1988: END IF;

Line 1994: fnd_msg_pub.add;

1990: THEN
1991: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
1992: THEN
1993: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1994: fnd_msg_pub.add;
1995: raise fnd_api.g_exc_error;
1996: ELSE
1997: mmt_rec.ib_current_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;
1998: END IF;

Line 2004: fnd_msg_pub.add;

2000: THEN
2001: IF mmt_rec.deliver_to_org_id is null
2002: THEN
2003: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2004: fnd_msg_pub.add;
2005: raise fnd_api.g_exc_error;
2006: ELSE
2007: mmt_rec.ib_current_loc_id := mmt_rec.deliver_to_org_id;
2008: END IF;

Line 2014: fnd_msg_pub.add;

2010: THEN
2011: IF mmt_rec.invoice_to_org_id is null
2012: THEN
2013: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2014: fnd_msg_pub.add;
2015: raise fnd_api.g_exc_error;
2016: ELSE
2017: mmt_rec.ib_current_loc_id := mmt_rec.invoice_to_org_id;
2018: END IF;

Line 2266: fnd_msg_pub.add;

2262: px_error_rec.instance_id := l_zero_instance_rec.instance_id;
2263:
2264: ELSE
2265: fnd_message.SET_NAME('CSI','CSI_INT_NO_INST_FOUND');
2266: fnd_msg_pub.add;
2267: raise fnd_api.g_exc_error;
2268: END IF;
2269: END IF;
2270: -- Bug 2767338

Line 2275: fnd_msg_pub.add;

2271: -- End Fix for negative quantity option set at Org Level
2272:
2273: IF l_instance_header_tbl.count > 1 THEN
2274: fnd_message.SET_NAME('CSI','CSI_INT_MANY_INST_FOUND');
2275: fnd_msg_pub.add;
2276: raise fnd_api.g_exc_error;
2277: END IF;
2278:
2279: debug('Unique inventory instance found.....!');

Line 4312: fnd_msg_pub.add;

4308:
4309: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
4310: fnd_message.set_token('SITE_USE_ID',l_order_line_rec.ship_to_org_id);
4311: fnd_message.set_token('SITE_USE_CODE','SHIP_TO');
4312: fnd_msg_pub.add;
4313: raise fnd_api.g_exc_error;
4314: END;
4315:
4316: END IF;

Line 4737: fnd_msg_pub.add;

4733: l_system_exist := FALSE;
4734: WHEN too_many_rows THEN
4735: fnd_message.set_name('CSI','CSI_INT_MUL_SYS_FOUND');
4736: fnd_message.set_token('SYSTEM_NUMBER',px_txn_systems_tbl(ind).system_number);
4737: fnd_msg_pub.add;
4738: RAISE fnd_api.g_exc_error;
4739: END;
4740:
4741: IF NOT(l_system_exist) THEN

Line 5325: fnd_msg_pub.initialize;

5321: api_log('update_install_base');
5322:
5323: /* Initialize message list if p_init_msg_list is set to TRUE. */
5324: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5325: fnd_msg_pub.initialize;
5326: END IF;
5327:
5328: /* Initialize API return status to success */
5329: x_return_status := fnd_api.g_ret_sts_success;

Line 5355: fnd_msg_pub.add;

5351: THEN
5352: fnd_message.set_name('CSI', 'CSI_CANNOT_UPDATE');
5353: fnd_message.set_token('OBJECT_ID','');
5354: fnd_message.set_token('RELATIONSHIP_TYPE_CODE','');
5355: fnd_msg_pub.add;
5356: Raise fnd_api.g_exc_error;
5357: END IF;
5358:
5359: /* get the profile value for CSI default install date */

Line 5594: fnd_msg_pub.add;

5590: EXCEPTION
5591: WHEN no_data_found then
5592: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
5593: fnd_message.set_token('LOCATION_ID', l_tld_rec.location_id);
5594: fnd_msg_pub.add;
5595: raise fnd_api.g_exc_error;
5596: WHEN too_many_rows then
5597: debug('Many Party sites found');
5598: raise fnd_api.g_exc_error;

Line 5624: fnd_msg_pub.add;

5620: EXCEPTION
5621: WHEN no_data_found then
5622: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
5623: fnd_message.set_token('LOCATION_ID',p_order_line_rec.ib_install_loc_id);--5147603
5624: fnd_msg_pub.add;
5625: raise fnd_api.g_exc_error;
5626: WHEN too_many_rows then
5627: debug('Many Party sites found');
5628: raise fnd_api.g_exc_error;

Line 5882: fnd_msg_pub.add;

5878: l_quantity2 := l_tld_rec.quantity ;
5879: ELSE
5880: fnd_message.set_name('CSI', 'CSI_ORG_NO_NEG_QTY');
5881: fnd_message.set_token('ORG_ID',l_tld_rec.inv_organization_id);
5882: fnd_msg_pub.add;
5883: Raise fnd_api.g_exc_error;
5884: END IF;
5885: ELSE
5886: l_quantity1 := (l_curr_instance_qty - l_tld_rec.quantity );

Line 6176: fnd_msg_pub.add;

6172: fnd_message.set_name('CSI','CSI_SHIP_OWNER_MISMATCH');
6173: fnd_message.set_token('OLD_PARTY_ID',l_owner_party_id);
6174: fnd_message.set_token('NEW_PARTY_ID',l_upd_party_tbl(1).party_id);
6175: fnd_message.set_token('INSTANCE_ID',l_upd_party_tbl(1).instance_id);
6176: fnd_msg_pub.add;
6177: raise fnd_api.g_exc_error;
6178: Else
6179:
6180: /* Changing the Owner to Internal Before shipping to New Customer */

Line 6912: fnd_msg_pub.add;

6908:
6909: IF (l_cre_party_tbl.count = 0 AND l_upd_party_tbl.count = 0 AND NVL(x_trx_sub_type_rec.src_change_owner,'N') = 'N') THEN
6910: fnd_message.set_name('CSI','CSI_INT_PTY_OWNER_REC_MISSING');
6911: fnd_message.set_token('TXN_LINE_DETAIL_ID',l_tld_rec.txn_line_detail_id);
6912: fnd_msg_pub.add;
6913: raise fnd_api.g_exc_error;
6914: END IF;
6915:
6916: -- End Bug 13572608

Line 7557: fnd_msg_pub.count_and_get(

7553: IF FND_API.To_Boolean(p_commit) THEN
7554: COMMIT WORK;
7555: END IF;
7556:
7557: fnd_msg_pub.count_and_get(
7558: p_count => x_msg_count ,
7559: p_data => x_msg_data );
7560:
7561: EXCEPTION

Line 7565: fnd_msg_pub.count_and_get(

7561: EXCEPTION
7562: WHEN FND_API.G_EXC_ERROR THEN
7563: ROLLBACK TO update_install_base;
7564: x_return_status := FND_API.G_RET_STS_ERROR ;
7565: fnd_msg_pub.count_and_get(
7566: p_count => x_msg_count,
7567: p_data => x_msg_data );
7568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7569: ROLLBACK TO update_install_base;

Line 7571: fnd_msg_pub.count_and_get(

7567: p_data => x_msg_data );
7568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7569: ROLLBACK TO update_install_base;
7570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7571: fnd_msg_pub.count_and_get(
7572: p_count => x_msg_count,
7573: p_data => x_msg_data );
7574: WHEN others THEN
7575:

Line 7578: fnd_msg_pub.add;

7574: WHEN others THEN
7575:
7576: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7577: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
7578: fnd_msg_pub.add;
7579:
7580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7581:
7582: fnd_msg_pub.count_and_get(

Line 7582: fnd_msg_pub.count_and_get(

7578: fnd_msg_pub.add;
7579:
7580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7581:
7582: fnd_msg_pub.count_and_get(
7583: p_count => x_msg_count,
7584: p_data => x_msg_data );
7585:
7586: END update_install_base;

Line 7807: fnd_msg_pub.add;

7803: /* If multiple owner exists then raise error */
7804: IF (l_owner_count > 1) THEN
7805: fnd_message.set_name('CSI','CSI_INT_MULTIPLE_OWNER');
7806: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7807: fnd_msg_pub.add;
7808: raise fnd_api.g_exc_error;
7809: END IF;
7810:
7811: /* If src_change_owner = Y and owner party does not exist then raise error */

Line 7816: fnd_msg_pub.add;

7812: IF x_txn_sub_type_rec.src_change_owner = 'Y' THEN
7813: IF (l_owner_count = 0) THEN
7814: fnd_message.set_name('CSI','CSI_INT_PTY_OWNER_MISSING');
7815: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7816: fnd_msg_pub.add;
7817: raise fnd_api.g_exc_error;
7818: END IF;
7819: END IF;
7820:

Line 7830: fnd_msg_pub.add;

7826: /* If multiple owner exists then raise error */
7827: IF (l_acct_owner_count > 1) THEN
7828: fnd_message.set_name('CSI','CSI_INT_MULTI_ACCT_OWNER');
7829: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7830: fnd_msg_pub.add;
7831: raise fnd_api.g_exc_error;
7832: END IF;
7833:
7834: /* If src_change_owner = Y and owner party does not exist then raise error */

Line 7839: fnd_msg_pub.add;

7835: IF x_txn_sub_type_rec.src_change_owner = 'Y' THEN
7836: IF (l_acct_owner_count = 0) THEN
7837: fnd_message.set_name('CSI','CSI_INT_ACCT_OWNER_MISSING');
7838: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7839: fnd_msg_pub.add;
7840: raise fnd_api.g_exc_error;
7841: END IF;
7842: END IF;
7843:

Line 7911: fnd_msg_pub.add;

7907: OR
7908: l_owner_pty_contacts = 'Y'
7909: THEN
7910: fnd_message.set_name('CSI','CSI_OWNER_PARTY_MISMATCH');
7911: fnd_msg_pub.add;
7912: RAISE fnd_api.g_exc_error;
7913: END IF;
7914: -- End porting for 3625218
7915: debug('Party_id on txn_dtls is not same as Shipment Party_id ');

Line 7974: fnd_msg_pub.add;

7970: NVL(p_txn_line_detail_tbl(i).instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
7971: THEN
7972: fnd_message.set_name('CSI','CSI_INT_INST_REF_MISSING');
7973: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7974: fnd_msg_pub.add;
7975: raise fnd_api.g_exc_error;
7976: END IF;
7977:
7978: /* If the src_return_reqd = "Y" then check if the return_by_date is not null */

Line 7985: fnd_msg_pub.add;

7981: NVL(p_txn_line_detail_tbl(i).return_by_date, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE
7982: THEN
7983: fnd_message.set_name('CSI','CSI_INT_RET_DATE_MISSING');
7984: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7985: fnd_msg_pub.add;
7986: raise fnd_api.g_exc_error;
7987: END IF;
7988:
7989: IF p_txn_party_detail_tbl.count > 0 THEN

Line 8007: fnd_msg_pub.add;

8003: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
8004: fnd_message.set_token('INSTANCE_ID',p_txn_line_detail_tbl(i).instance_id);
8005: fnd_message.set_token('INSTANCE_PARTY_ID',p_txn_party_detail_tbl(j).instance_party_id);
8006: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_detail_tbl(j).relationship_type_code);
8007: fnd_msg_pub.add;
8008: raise fnd_api.g_exc_error;
8009: END IF;
8010: END IF;
8011:

Line 8024: fnd_msg_pub.add;

8020: IF p_txn_party_detail_tbl(j).party_source_id = p_order_line_rec.internal_party_id THEN
8021: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
8022: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);
8023: fnd_message.set_token('INTERNAL_PARTY_ID',p_order_line_rec.internal_party_id);
8024: fnd_msg_pub.add;
8025: raise fnd_api.g_exc_error;
8026: END IF;
8027: ELSE
8028: /* if change_owner = N and chg_owner_code <> E then party id should

Line 8034: fnd_msg_pub.add;

8030: IF p_txn_party_detail_tbl(j).party_source_id <> p_order_line_rec.internal_party_id THEN
8031: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
8032: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);
8033: fnd_message.set_token('INTERNAL_PARTY_ID',p_order_line_rec.internal_party_id);
8034: fnd_msg_pub.add;
8035: raise fnd_api.g_exc_error;
8036: END IF;
8037: END IF;
8038: END IF;

Line 8053: fnd_msg_pub.add;

8049: AND
8050: NVL(p_txn_line_detail_tbl(i).instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
8051: THEN
8052: fnd_message.set_name('CSI','CSI_INT_INST_REF_MISSING');
8053: fnd_msg_pub.add;
8054: raise fnd_api.g_exc_error;
8055: END IF;
8056:
8057: /* If the src_return_reqd = "Y" then check if the return_by_date is not null */

Line 8064: fnd_msg_pub.add;

8060: AND
8061: NVL(p_txn_line_detail_tbl(i).return_by_date, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE
8062: THEN
8063: fnd_message.set_name('CSI','CSI_INT_RET_DATE_MISSING');
8064: fnd_msg_pub.add;
8065: raise fnd_api.g_exc_error;
8066: END IF;
8067:
8068: /* If src_reference_reqd = 'Y' then the relationship should be defined in the txn_ii_rltns_tbl */

Line 8078: fnd_msg_pub.add;

8074: p_txn_line_detail_tbl(i).txn_line_detail_id))
8075: THEN
8076: fnd_message.set_name('CSI','CSI_INT_NSRC_REL_MISSING');
8077: fnd_message.set_token('TXN_LINE_DETAIL_ID',p_txn_line_detail_tbl(i).txn_line_detail_id );
8078: fnd_msg_pub.add;
8079: raise fnd_api.g_exc_error;
8080: END IF;
8081:
8082: IF p_txn_party_detail_tbl.count > 0 THEN

Line 8100: fnd_msg_pub.add;

8096: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
8097: fnd_message.set_token('INSTANCE_ID',p_txn_line_detail_tbl(i).instance_id);
8098: fnd_message.set_token('INSTANCE_PARTY_ID',p_txn_party_detail_tbl(j).instance_party_id);
8099: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_detail_tbl(j).relationship_type_code);
8100: fnd_msg_pub.add;
8101: raise fnd_api.g_exc_error;
8102: END IF;
8103: END IF;
8104:

Line 8116: fnd_msg_pub.add;

8112: IF p_txn_party_detail_tbl(j).party_source_id = p_order_line_rec.internal_party_id THEN
8113: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
8114: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);
8115: fnd_message.set_token('INSTANCE_PARTY_ID',p_order_line_rec.internal_party_id);
8116: fnd_msg_pub.add;
8117: raise fnd_api.g_exc_error;
8118: END IF;
8119: ELSE
8120:

Line 8128: fnd_msg_pub.add;

8124: IF p_txn_party_detail_tbl(j).party_source_id <> p_order_line_rec.internal_party_id THEN
8125: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
8126: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);
8127: fnd_message.set_token('INSTANCE_PARTY_ID',p_order_line_rec.internal_party_id);
8128: fnd_msg_pub.add;
8129: raise fnd_api.g_exc_error;
8130: END IF;
8131: END IF;
8132: END IF;

Line 8159: fnd_msg_pub.add;

8155:
8156: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
8157: fnd_message.set_name('CSI','CSI_INT_II_REL_MISSING');
8158: fnd_message.set_token('II_RELATIONSHIP_ID',p_txn_ii_rltns_tbl(j).csi_inst_relationship_id);
8159: fnd_msg_pub.add;
8160: raise fnd_api.g_exc_error;
8161: END IF;
8162:
8163: IF p_txn_line_detail_tbl.count > 0 THEN

Line 8177: fnd_msg_pub.add;

8173:
8174: IF l_curr_object_id <> l_object_inst_id THEN
8175: fnd_message.set_name('CSI','CSI_INT_OBJ_ID_NOT_ALLOW_UPD');
8176: fnd_message.set_token('OBJECT_ID',l_object_inst_id);
8177: fnd_msg_pub.add;
8178: raise fnd_api.g_exc_error;
8179: END IF;
8180:
8181: END IF;

Line 8354: fnd_msg_pub.add;

8350: Exception
8351: When no_data_found then
8352: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8353: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id); -- ship_to_org_id);
8354: fnd_msg_pub.add;
8355: debug('Party_site_id not found');
8356: raise fnd_api.g_exc_error;
8357: when too_many_rows then
8358: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 8360: fnd_msg_pub.add;

8356: raise fnd_api.g_exc_error;
8357: when too_many_rows then
8358: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
8359: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id); -- ship_to_org_id);
8360: fnd_msg_pub.add;
8361: debug('Party_site_id not found');
8362: raise fnd_api.g_exc_error;
8363: END ;
8364:

Line 8382: fnd_msg_pub.add;

8378: Exception
8379: When no_data_found then
8380: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8381: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id); -- ship_to_org_id);
8382: fnd_msg_pub.add;
8383: debug('Party_site_id not found');
8384: raise fnd_api.g_exc_error;
8385: when too_many_rows then
8386: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 8388: fnd_msg_pub.add;

8384: raise fnd_api.g_exc_error;
8385: when too_many_rows then
8386: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
8387: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id); -- ship_to_org_id);
8388: fnd_msg_pub.add;
8389: debug('Party_site_id not found');
8390: raise fnd_api.g_exc_error;
8391: end ;
8392: END IF;

Line 8714: fnd_msg_pub.add;

8710: WHEN fnd_api.g_exc_error THEN
8711: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
8712: fnd_message.set_token('message_id',p_msg_header.message_id);
8713: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
8714: fnd_msg_pub.add;
8715: x_error_message := fnd_msg_pub.get;
8716: x_return_status := l_fnd_unexpected;
8717:
8718: WHEN others THEN

Line 8715: x_error_message := fnd_msg_pub.get;

8711: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
8712: fnd_message.set_token('message_id',p_msg_header.message_id);
8713: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
8714: fnd_msg_pub.add;
8715: x_error_message := fnd_msg_pub.get;
8716: x_return_status := l_fnd_unexpected;
8717:
8718: WHEN others THEN
8719: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

Line 8722: fnd_msg_pub.add;

8718: WHEN others THEN
8719: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
8720: fnd_message.set_token('API_NAME',l_api_name);
8721: fnd_message.set_token('SQL_ERROR',SQLERRM);
8722: fnd_msg_pub.add;
8723: x_error_message := fnd_msg_pub.get;
8724: x_return_status := l_fnd_unexpected;
8725: END decode_message;
8726:

Line 8723: x_error_message := fnd_msg_pub.get;

8719: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
8720: fnd_message.set_token('API_NAME',l_api_name);
8721: fnd_message.set_token('SQL_ERROR',SQLERRM);
8722: fnd_msg_pub.add;
8723: x_error_message := fnd_msg_pub.get;
8724: x_return_status := l_fnd_unexpected;
8725: END decode_message;
8726:
8727: PROCEDURE oke_shipment(

Line 8994: fnd_msg_pub.add;

8990: WHEN others THEN
8991: rollback to oke_shipment;
8992: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
8993: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 540));
8994: fnd_msg_pub.add;
8995: x_return_status := fnd_api.g_ret_sts_error;
8996: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
8997: px_trx_error_rec := l_error_rec;
8998: debug('Error(O) :'||l_error_rec.error_text);