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

785: WHEN no_data_found THEN
786: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');
787: fnd_message.set_token('SOURCE_TRANSACTION_ID', l_copy_txn_line_rec.SOURCE_TRANSACTION_ID);
788: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',l_copy_txn_line_rec.SOURCE_TRANSACTION_TABLE);
789: fnd_msg_pub.add;
790: raise fnd_api.g_exc_error;
791: END;
792:
793: ELSE

Line 947: fnd_msg_pub.add;

943: fnd_message.set_token('SOURCE_TRANSACTION_ID',
944: l_copy_txn_line_rec.SOURCE_TRANSACTION_ID);
945: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',
946: l_copy_txn_line_rec.SOURCE_TRANSACTION_TABLE);
947: fnd_msg_pub.add;
948: raise fnd_api.g_exc_error;
949: END;
950: ELSE
951:

Line 1832: fnd_msg_pub.add;

1828: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER'
1829: THEN
1830: IF l_partner_rec.END_CUSTOMER_ID is null Then
1831: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1832: fnd_msg_pub.add;
1833: raise fnd_api.g_exc_error;
1834: ELSE
1835: mmt_rec.ib_owner := l_partner_rec.ib_owner;
1836: mmt_rec.end_customer_id := l_partner_rec.end_customer_id;

Line 1854: fnd_msg_pub.add;

1850: THEN
1851: IF l_partner_rec.end_customer_site_use_id is null
1852: THEN
1853: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1854: fnd_msg_pub.add;
1855: raise fnd_api.g_exc_error;
1856: ELSE
1857: mmt_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;
1858: END IF;

Line 1864: fnd_msg_pub.add;

1860: THEN
1861: IF mmt_rec.ship_to_org_id is null
1862: THEN
1863: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1864: fnd_msg_pub.add;
1865: raise fnd_api.g_exc_error;
1866: ELSE
1867: mmt_rec.ib_install_loc_id := mmt_rec.ship_to_org_id;
1868: END IF;

Line 1874: fnd_msg_pub.add;

1870: THEN
1871: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
1872: THEN
1873: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1874: fnd_msg_pub.add;
1875: raise fnd_api.g_exc_error;
1876: ELSE
1877: mmt_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;
1878: END IF;

Line 1884: fnd_msg_pub.add;

1880: THEN
1881: IF mmt_rec.deliver_to_org_id is null
1882: THEN
1883: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1884: fnd_msg_pub.add;
1885: raise fnd_api.g_exc_error;
1886: ELSE
1887: mmt_rec.ib_install_loc_id := mmt_rec.deliver_to_org_id;
1888: END IF;

Line 1894: fnd_msg_pub.add;

1890: THEN
1891: IF mmt_rec.invoice_to_org_id is null
1892: THEN
1893: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1894: fnd_msg_pub.add;
1895: raise fnd_api.g_exc_error;
1896: ELSE
1897: mmt_rec.ib_install_loc_id := mmt_rec.invoice_to_org_id;
1898: END IF;

Line 1915: fnd_msg_pub.add;

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

Line 1925: fnd_msg_pub.add;

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

Line 1935: fnd_msg_pub.add;

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

Line 1945: fnd_msg_pub.add;

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

Line 1955: fnd_msg_pub.add;

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

Line 2207: fnd_msg_pub.add;

2203: px_error_rec.instance_id := l_zero_instance_rec.instance_id;
2204:
2205: ELSE
2206: fnd_message.SET_NAME('CSI','CSI_INT_NO_INST_FOUND');
2207: fnd_msg_pub.add;
2208: raise fnd_api.g_exc_error;
2209: END IF;
2210: END IF;
2211: -- Bug 2767338

Line 2216: fnd_msg_pub.add;

2212: -- End Fix for negative quantity option set at Org Level
2213:
2214: IF l_instance_header_tbl.count > 1 THEN
2215: fnd_message.SET_NAME('CSI','CSI_INT_MANY_INST_FOUND');
2216: fnd_msg_pub.add;
2217: raise fnd_api.g_exc_error;
2218: END IF;
2219:
2220: debug('Unique inventory instance found.....!');

Line 4233: fnd_msg_pub.add;

4229:
4230: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
4231: fnd_message.set_token('SITE_USE_ID',l_order_line_rec.ship_to_org_id);
4232: fnd_message.set_token('SITE_USE_CODE','SHIP_TO');
4233: fnd_msg_pub.add;
4234: raise fnd_api.g_exc_error;
4235: END;
4236:
4237: END IF;

Line 4658: fnd_msg_pub.add;

4654: l_system_exist := FALSE;
4655: WHEN too_many_rows THEN
4656: fnd_message.set_name('CSI','CSI_INT_MUL_SYS_FOUND');
4657: fnd_message.set_token('SYSTEM_NUMBER',px_txn_systems_tbl(ind).system_number);
4658: fnd_msg_pub.add;
4659: RAISE fnd_api.g_exc_error;
4660: END;
4661:
4662: IF NOT(l_system_exist) THEN

Line 5119: fnd_msg_pub.initialize;

5115: api_log('update_install_base');
5116:
5117: /* Initialize message list if p_init_msg_list is set to TRUE. */
5118: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5119: fnd_msg_pub.initialize;
5120: END IF;
5121:
5122: /* Initialize API return status to success */
5123: x_return_status := fnd_api.g_ret_sts_success;

Line 5139: fnd_msg_pub.add;

5135: THEN
5136: fnd_message.set_name('CSI', 'CSI_CANNOT_UPDATE');
5137: fnd_message.set_token('OBJECT_ID','');
5138: fnd_message.set_token('RELATIONSHIP_TYPE_CODE','');
5139: fnd_msg_pub.add;
5140: Raise fnd_api.g_exc_error;
5141: END IF;
5142:
5143: /* get the profile value for CSI default install date */

Line 5370: fnd_msg_pub.add;

5366: EXCEPTION
5367: WHEN no_data_found then
5368: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
5369: fnd_message.set_token('LOCATION_ID', l_tld_rec.location_id);
5370: fnd_msg_pub.add;
5371: raise fnd_api.g_exc_error;
5372: WHEN too_many_rows then
5373: debug('Many Party sites found');
5374: raise fnd_api.g_exc_error;

Line 5398: fnd_msg_pub.add;

5394: EXCEPTION
5395: WHEN no_data_found then
5396: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
5397: fnd_message.set_token('LOCATION_ID',p_order_line_rec.ib_install_loc_id);--5147603
5398: fnd_msg_pub.add;
5399: raise fnd_api.g_exc_error;
5400: WHEN too_many_rows then
5401: debug('Many Party sites found');
5402: raise fnd_api.g_exc_error;

Line 5625: fnd_msg_pub.add;

5621: l_quantity2 := l_tld_rec.quantity ;
5622: ELSE
5623: fnd_message.set_name('CSI', 'CSI_ORG_NO_NEG_QTY');
5624: fnd_message.set_token('ORG_ID',l_tld_rec.inv_organization_id);
5625: fnd_msg_pub.add;
5626: Raise fnd_api.g_exc_error;
5627: END IF;
5628: ELSE
5629: l_quantity1 := (l_curr_instance_qty - l_tld_rec.quantity );

Line 5916: fnd_msg_pub.add;

5912: fnd_message.set_name('CSI','CSI_SHIP_OWNER_MISMATCH');
5913: fnd_message.set_token('OLD_PARTY_ID',l_owner_party_id);
5914: fnd_message.set_token('NEW_PARTY_ID',l_upd_party_tbl(1).party_id);
5915: fnd_message.set_token('INSTANCE_ID',l_upd_party_tbl(1).instance_id);
5916: fnd_msg_pub.add;
5917: raise fnd_api.g_exc_error;
5918: Else
5919:
5920: /* Changing the Owner to Internal Before shipping to New Customer */

Line 7238: fnd_msg_pub.count_and_get(

7234: IF FND_API.To_Boolean(p_commit) THEN
7235: COMMIT WORK;
7236: END IF;
7237:
7238: fnd_msg_pub.count_and_get(
7239: p_count => x_msg_count ,
7240: p_data => x_msg_data );
7241:
7242: EXCEPTION

Line 7246: fnd_msg_pub.count_and_get(

7242: EXCEPTION
7243: WHEN FND_API.G_EXC_ERROR THEN
7244: ROLLBACK TO update_install_base;
7245: x_return_status := FND_API.G_RET_STS_ERROR ;
7246: fnd_msg_pub.count_and_get(
7247: p_count => x_msg_count,
7248: p_data => x_msg_data );
7249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7250: ROLLBACK TO update_install_base;

Line 7252: fnd_msg_pub.count_and_get(

7248: p_data => x_msg_data );
7249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7250: ROLLBACK TO update_install_base;
7251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7252: fnd_msg_pub.count_and_get(
7253: p_count => x_msg_count,
7254: p_data => x_msg_data );
7255: WHEN others THEN
7256:

Line 7259: fnd_msg_pub.add;

7255: WHEN others THEN
7256:
7257: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7258: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
7259: fnd_msg_pub.add;
7260:
7261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7262:
7263: fnd_msg_pub.count_and_get(

Line 7263: fnd_msg_pub.count_and_get(

7259: fnd_msg_pub.add;
7260:
7261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7262:
7263: fnd_msg_pub.count_and_get(
7264: p_count => x_msg_count,
7265: p_data => x_msg_data );
7266:
7267: END update_install_base;

Line 7488: fnd_msg_pub.add;

7484: /* If multiple owner exists then raise error */
7485: IF (l_owner_count > 1) THEN
7486: fnd_message.set_name('CSI','CSI_INT_MULTIPLE_OWNER');
7487: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7488: fnd_msg_pub.add;
7489: raise fnd_api.g_exc_error;
7490: END IF;
7491:
7492: /* If src_change_owner = Y and owner party does not exist then raise error */

Line 7497: fnd_msg_pub.add;

7493: IF x_txn_sub_type_rec.src_change_owner = 'Y' THEN
7494: IF (l_owner_count = 0) THEN
7495: fnd_message.set_name('CSI','CSI_INT_PTY_OWNER_MISSING');
7496: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7497: fnd_msg_pub.add;
7498: raise fnd_api.g_exc_error;
7499: END IF;
7500: END IF;
7501:

Line 7511: fnd_msg_pub.add;

7507: /* If multiple owner exists then raise error */
7508: IF (l_acct_owner_count > 1) THEN
7509: fnd_message.set_name('CSI','CSI_INT_MULTI_ACCT_OWNER');
7510: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7511: fnd_msg_pub.add;
7512: raise fnd_api.g_exc_error;
7513: END IF;
7514:
7515: /* If src_change_owner = Y and owner party does not exist then raise error */

Line 7520: fnd_msg_pub.add;

7516: IF x_txn_sub_type_rec.src_change_owner = 'Y' THEN
7517: IF (l_acct_owner_count = 0) THEN
7518: fnd_message.set_name('CSI','CSI_INT_ACCT_OWNER_MISSING');
7519: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7520: fnd_msg_pub.add;
7521: raise fnd_api.g_exc_error;
7522: END IF;
7523: END IF;
7524:

Line 7592: fnd_msg_pub.add;

7588: OR
7589: l_owner_pty_contacts = 'Y'
7590: THEN
7591: fnd_message.set_name('CSI','CSI_OWNER_PARTY_MISMATCH');
7592: fnd_msg_pub.add;
7593: RAISE fnd_api.g_exc_error;
7594: END IF;
7595: -- End porting for 3625218
7596: debug('Party_id on txn_dtls is not same as Shipment Party_id ');

Line 7655: fnd_msg_pub.add;

7651: NVL(p_txn_line_detail_tbl(i).instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
7652: THEN
7653: fnd_message.set_name('CSI','CSI_INT_INST_REF_MISSING');
7654: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7655: fnd_msg_pub.add;
7656: raise fnd_api.g_exc_error;
7657: END IF;
7658:
7659: /* If the src_return_reqd = "Y" then check if the return_by_date is not null */

Line 7666: fnd_msg_pub.add;

7662: NVL(p_txn_line_detail_tbl(i).return_by_date, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE
7663: THEN
7664: fnd_message.set_name('CSI','CSI_INT_RET_DATE_MISSING');
7665: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);
7666: fnd_msg_pub.add;
7667: raise fnd_api.g_exc_error;
7668: END IF;
7669:
7670: IF p_txn_party_detail_tbl.count > 0 THEN

Line 7688: fnd_msg_pub.add;

7684: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
7685: fnd_message.set_token('INSTANCE_ID',p_txn_line_detail_tbl(i).instance_id);
7686: fnd_message.set_token('INSTANCE_PARTY_ID',p_txn_party_detail_tbl(j).instance_party_id);
7687: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_detail_tbl(j).relationship_type_code);
7688: fnd_msg_pub.add;
7689: raise fnd_api.g_exc_error;
7690: END IF;
7691: END IF;
7692:

Line 7705: fnd_msg_pub.add;

7701: IF p_txn_party_detail_tbl(j).party_source_id = p_order_line_rec.internal_party_id THEN
7702: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
7703: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);
7704: fnd_message.set_token('INTERNAL_PARTY_ID',p_order_line_rec.internal_party_id);
7705: fnd_msg_pub.add;
7706: raise fnd_api.g_exc_error;
7707: END IF;
7708: ELSE
7709: /* if change_owner = N and chg_owner_code <> E then party id should

Line 7715: fnd_msg_pub.add;

7711: IF p_txn_party_detail_tbl(j).party_source_id <> p_order_line_rec.internal_party_id THEN
7712: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
7713: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);
7714: fnd_message.set_token('INTERNAL_PARTY_ID',p_order_line_rec.internal_party_id);
7715: fnd_msg_pub.add;
7716: raise fnd_api.g_exc_error;
7717: END IF;
7718: END IF;
7719: END IF;

Line 7734: fnd_msg_pub.add;

7730: AND
7731: NVL(p_txn_line_detail_tbl(i).instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
7732: THEN
7733: fnd_message.set_name('CSI','CSI_INT_INST_REF_MISSING');
7734: fnd_msg_pub.add;
7735: raise fnd_api.g_exc_error;
7736: END IF;
7737:
7738: /* If the src_return_reqd = "Y" then check if the return_by_date is not null */

Line 7745: fnd_msg_pub.add;

7741: AND
7742: NVL(p_txn_line_detail_tbl(i).return_by_date, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE
7743: THEN
7744: fnd_message.set_name('CSI','CSI_INT_RET_DATE_MISSING');
7745: fnd_msg_pub.add;
7746: raise fnd_api.g_exc_error;
7747: END IF;
7748:
7749: /* If src_reference_reqd = 'Y' then the relationship should be defined in the txn_ii_rltns_tbl */

Line 7759: fnd_msg_pub.add;

7755: p_txn_line_detail_tbl(i).txn_line_detail_id))
7756: THEN
7757: fnd_message.set_name('CSI','CSI_INT_NSRC_REL_MISSING');
7758: fnd_message.set_token('TXN_LINE_DETAIL_ID',p_txn_line_detail_tbl(i).txn_line_detail_id );
7759: fnd_msg_pub.add;
7760: raise fnd_api.g_exc_error;
7761: END IF;
7762:
7763: IF p_txn_party_detail_tbl.count > 0 THEN

Line 7781: fnd_msg_pub.add;

7777: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
7778: fnd_message.set_token('INSTANCE_ID',p_txn_line_detail_tbl(i).instance_id);
7779: fnd_message.set_token('INSTANCE_PARTY_ID',p_txn_party_detail_tbl(j).instance_party_id);
7780: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_detail_tbl(j).relationship_type_code);
7781: fnd_msg_pub.add;
7782: raise fnd_api.g_exc_error;
7783: END IF;
7784: END IF;
7785:

Line 7797: fnd_msg_pub.add;

7793: IF p_txn_party_detail_tbl(j).party_source_id = p_order_line_rec.internal_party_id THEN
7794: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
7795: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);
7796: fnd_message.set_token('INSTANCE_PARTY_ID',p_order_line_rec.internal_party_id);
7797: fnd_msg_pub.add;
7798: raise fnd_api.g_exc_error;
7799: END IF;
7800: ELSE
7801:

Line 7809: fnd_msg_pub.add;

7805: IF p_txn_party_detail_tbl(j).party_source_id <> p_order_line_rec.internal_party_id THEN
7806: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
7807: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);
7808: fnd_message.set_token('INSTANCE_PARTY_ID',p_order_line_rec.internal_party_id);
7809: fnd_msg_pub.add;
7810: raise fnd_api.g_exc_error;
7811: END IF;
7812: END IF;
7813: END IF;

Line 7840: fnd_msg_pub.add;

7836:
7837: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
7838: fnd_message.set_name('CSI','CSI_INT_II_REL_MISSING');
7839: fnd_message.set_token('II_RELATIONSHIP_ID',p_txn_ii_rltns_tbl(j).csi_inst_relationship_id);
7840: fnd_msg_pub.add;
7841: raise fnd_api.g_exc_error;
7842: END IF;
7843:
7844: IF p_txn_line_detail_tbl.count > 0 THEN

Line 7858: fnd_msg_pub.add;

7854:
7855: IF l_curr_object_id <> l_object_inst_id THEN
7856: fnd_message.set_name('CSI','CSI_INT_OBJ_ID_NOT_ALLOW_UPD');
7857: fnd_message.set_token('OBJECT_ID',l_object_inst_id);
7858: fnd_msg_pub.add;
7859: raise fnd_api.g_exc_error;
7860: END IF;
7861:
7862: END IF;

Line 8035: fnd_msg_pub.add;

8031: Exception
8032: When no_data_found then
8033: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8034: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id); -- ship_to_org_id);
8035: fnd_msg_pub.add;
8036: debug('Party_site_id not found');
8037: raise fnd_api.g_exc_error;
8038: when too_many_rows then
8039: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 8041: fnd_msg_pub.add;

8037: raise fnd_api.g_exc_error;
8038: when too_many_rows then
8039: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
8040: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id); -- ship_to_org_id);
8041: fnd_msg_pub.add;
8042: debug('Party_site_id not found');
8043: raise fnd_api.g_exc_error;
8044: END ;
8045:

Line 8063: fnd_msg_pub.add;

8059: Exception
8060: When no_data_found then
8061: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8062: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id); -- ship_to_org_id);
8063: fnd_msg_pub.add;
8064: debug('Party_site_id not found');
8065: raise fnd_api.g_exc_error;
8066: when too_many_rows then
8067: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 8069: fnd_msg_pub.add;

8065: raise fnd_api.g_exc_error;
8066: when too_many_rows then
8067: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
8068: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id); -- ship_to_org_id);
8069: fnd_msg_pub.add;
8070: debug('Party_site_id not found');
8071: raise fnd_api.g_exc_error;
8072: end ;
8073: END IF;

Line 8395: fnd_msg_pub.add;

8391: WHEN fnd_api.g_exc_error THEN
8392: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
8393: fnd_message.set_token('message_id',p_msg_header.message_id);
8394: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
8395: fnd_msg_pub.add;
8396: x_error_message := fnd_msg_pub.get;
8397: x_return_status := l_fnd_unexpected;
8398:
8399: WHEN others THEN

Line 8396: x_error_message := fnd_msg_pub.get;

8392: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
8393: fnd_message.set_token('message_id',p_msg_header.message_id);
8394: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
8395: fnd_msg_pub.add;
8396: x_error_message := fnd_msg_pub.get;
8397: x_return_status := l_fnd_unexpected;
8398:
8399: WHEN others THEN
8400: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

Line 8403: fnd_msg_pub.add;

8399: WHEN others THEN
8400: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
8401: fnd_message.set_token('API_NAME',l_api_name);
8402: fnd_message.set_token('SQL_ERROR',SQLERRM);
8403: fnd_msg_pub.add;
8404: x_error_message := fnd_msg_pub.get;
8405: x_return_status := l_fnd_unexpected;
8406: END decode_message;
8407:

Line 8404: x_error_message := fnd_msg_pub.get;

8400: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
8401: fnd_message.set_token('API_NAME',l_api_name);
8402: fnd_message.set_token('SQL_ERROR',SQLERRM);
8403: fnd_msg_pub.add;
8404: x_error_message := fnd_msg_pub.get;
8405: x_return_status := l_fnd_unexpected;
8406: END decode_message;
8407:
8408: PROCEDURE oke_shipment(

Line 8674: fnd_msg_pub.add;

8670: WHEN others THEN
8671: rollback to oke_shipment;
8672: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
8673: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 540));
8674: fnd_msg_pub.add;
8675: x_return_status := fnd_api.g_ret_sts_error;
8676: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
8677: px_trx_error_rec := l_error_rec;
8678: debug('Error(O) :'||l_error_rec.error_text);