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_MESSAGE

Line 786: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');

782: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
783:
784: EXCEPTION
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;

Line 787: fnd_message.set_token('SOURCE_TRANSACTION_ID', l_copy_txn_line_rec.SOURCE_TRANSACTION_ID);

783:
784: EXCEPTION
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;

Line 788: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',l_copy_txn_line_rec.SOURCE_TRANSACTION_TABLE);

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

Line 942: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');

938: WHERE source_transaction_id = l_copy_txn_line_rec.source_transaction_id
939: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
940: EXCEPTION
941: WHEN no_data_found THEN
942: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');
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);

Line 943: fnd_message.set_token('SOURCE_TRANSACTION_ID',

939: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
940: EXCEPTION
941: WHEN no_data_found THEN
942: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');
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;

Line 945: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',

941: WHEN no_data_found THEN
942: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');
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;

Line 1831: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

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

Line 1853: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1849: IF mmt_rec.ib_install_loc = 'END_CUSTOMER'
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;

Line 1863: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1859: ELSIF mmt_rec.ib_install_loc = 'SHIP_TO'
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;

Line 1873: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1869: ELSIF mmt_rec.ib_install_loc = 'SOLD_TO'
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;

Line 1883: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1879: ELSIF mmt_rec.ib_install_loc = 'DELIVER_TO'
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;

Line 1893: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1889: ELSIF mmt_rec.ib_install_loc = 'BILL_TO'
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;

Line 1914: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1910: IF mmt_rec.ib_current_loc = 'END_CUSTOMER'
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;

Line 1924: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1920: ELSIF mmt_rec.ib_current_loc = 'SHIP_TO'
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;

Line 1934: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1930: ELSIF mmt_rec.ib_current_loc = 'SOLD_TO'
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;

Line 1944: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1940: ELSIF mmt_rec.ib_current_loc = 'DELIVER_TO'
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;

Line 1954: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1950: ELSIF mmt_rec.ib_current_loc = 'BILL_TO'
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;

Line 2206: fnd_message.SET_NAME('CSI','CSI_INT_NO_INST_FOUND');

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

Line 2215: fnd_message.SET_NAME('CSI','CSI_INT_MANY_INST_FOUND');

2211: -- Bug 2767338
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:

Line 4230: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');

4226:
4227: EXCEPTION
4228: WHEN no_data_found THEN
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;

Line 4231: fnd_message.set_token('SITE_USE_ID',l_order_line_rec.ship_to_org_id);

4227: EXCEPTION
4228: WHEN no_data_found THEN
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;

Line 4232: fnd_message.set_token('SITE_USE_CODE','SHIP_TO');

4228: WHEN no_data_found THEN
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:

Line 4656: fnd_message.set_name('CSI','CSI_INT_MUL_SYS_FOUND');

4652: EXCEPTION
4653: WHEN no_data_found THEN
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;

Line 4657: fnd_message.set_token('SYSTEM_NUMBER',px_txn_systems_tbl(ind).system_number);

4653: WHEN no_data_found THEN
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:

Line 5136: fnd_message.set_name('CSI', 'CSI_CANNOT_UPDATE');

5132: debug(' txn_systems_tbl.count :'||p_txn_systems_tbl.count);
5133:
5134: IF p_txn_line_detail_tbl.count <= 0
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;

Line 5137: fnd_message.set_token('OBJECT_ID','');

5133:
5134: IF p_txn_line_detail_tbl.count <= 0
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;

Line 5138: fnd_message.set_token('RELATIONSHIP_TYPE_CODE','');

5134: IF p_txn_line_detail_tbl.count <= 0
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:

Line 5368: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

5364: AND u.site_use_id = p_order_line_rec.ib_current_loc_id; -- ship_to_org_id;
5365:
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

Line 5369: fnd_message.set_token('LOCATION_ID', l_tld_rec.location_id);

5365:
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');

Line 5396: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

5392: AND u.site_use_id = p_order_line_rec.ib_install_loc_id; -- ship_to_org_id;
5393:
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

Line 5397: fnd_message.set_token('LOCATION_ID',p_order_line_rec.ib_install_loc_id);--5147603

5393:
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');

Line 5623: fnd_message.set_name('CSI', 'CSI_ORG_NO_NEG_QTY');

5619: END IF;
5620: l_quantity1 := (l_curr_instance_qty - l_tld_rec.quantity );
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;

Line 5624: fnd_message.set_token('ORG_ID',l_tld_rec.inv_organization_id);

5620: l_quantity1 := (l_curr_instance_qty - l_tld_rec.quantity );
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

Line 5912: fnd_message.set_name('CSI','CSI_SHIP_OWNER_MISMATCH');

5908: l_ownership_flag:=
5909: NVL(csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn,'N');
5910:
5911: IF l_ownership_flag = 'N' Then
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;

Line 5913: fnd_message.set_token('OLD_PARTY_ID',l_owner_party_id);

5909: NVL(csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn,'N');
5910:
5911: IF l_ownership_flag = 'N' Then
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;

Line 5914: fnd_message.set_token('NEW_PARTY_ID',l_upd_party_tbl(1).party_id);

5910:
5911: IF l_ownership_flag = 'N' Then
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

Line 5915: fnd_message.set_token('INSTANCE_ID',l_upd_party_tbl(1).instance_id);

5911: IF l_ownership_flag = 'N' Then
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:

Line 7257: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

7253: p_count => x_msg_count,
7254: p_data => x_msg_data );
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 ;

Line 7258: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));

7254: p_data => x_msg_data );
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:

Line 7486: fnd_message.set_name('CSI','CSI_INT_MULTIPLE_OWNER');

7482: END IF;--p_txn_party_detail_tbl.COUNT > 0
7483:
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;

Line 7487: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);

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

Line 7495: fnd_message.set_name('CSI','CSI_INT_PTY_OWNER_MISSING');

7491:
7492: /* If src_change_owner = Y and owner party does not exist then raise error */
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;

Line 7496: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);

7492: /* If src_change_owner = Y and owner party does not exist then raise error */
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;

Line 7509: fnd_message.set_name('CSI','CSI_INT_MULTI_ACCT_OWNER');

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

Line 7510: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);

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

Line 7518: fnd_message.set_name('CSI','CSI_INT_ACCT_OWNER_MISSING');

7514:
7515: /* If src_change_owner = Y and owner party does not exist then raise error */
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;

Line 7519: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);

7515: /* If src_change_owner = Y and owner party does not exist then raise error */
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;

Line 7591: fnd_message.set_name('CSI','CSI_OWNER_PARTY_MISMATCH');

7587: IF l_owner_pty_accounts = 'Y'
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

Line 7653: fnd_message.set_name('CSI','CSI_INT_INST_REF_MISSING');

7649: IF x_txn_sub_type_rec.src_reference_reqd = 'Y'
7650: AND
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;

Line 7654: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);

7650: AND
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:

Line 7664: fnd_message.set_name('CSI','CSI_INT_RET_DATE_MISSING');

7660: IF x_txn_sub_type_rec.src_return_reqd = 'Y'
7661: AND
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;

Line 7665: fnd_message.set_token('TXN_LINE_DETAIL_ID', p_txn_line_detail_tbl(i).txn_line_detail_id);

7661: AND
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:

Line 7684: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');

7680: p_txn_party_detail_tbl(j).instance_party_id,
7681: p_txn_party_detail_tbl(j).relationship_type_code);
7682:
7683: IF NOT(l_found) THEN
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;

Line 7685: fnd_message.set_token('INSTANCE_ID',p_txn_line_detail_tbl(i).instance_id);

7681: p_txn_party_detail_tbl(j).relationship_type_code);
7682:
7683: IF NOT(l_found) THEN
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;

Line 7686: fnd_message.set_token('INSTANCE_PARTY_ID',p_txn_party_detail_tbl(j).instance_party_id);

7682:
7683: IF NOT(l_found) THEN
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;

Line 7687: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_detail_tbl(j).relationship_type_code);

7683: IF NOT(l_found) THEN
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;

Line 7702: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');

7698:
7699: /* if change_owner = Y and chg_owner_code = E then party id should
7700: be external party id */
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;

Line 7703: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);

7699: /* if change_owner = Y and chg_owner_code = E then party id should
7700: be external party id */
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;

Line 7704: fnd_message.set_token('INTERNAL_PARTY_ID',p_order_line_rec.internal_party_id);

7700: be external party id */
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

Line 7712: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');

7708: ELSE
7709: /* if change_owner = N and chg_owner_code <> E then party id should
7710: be external party id */
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;

Line 7713: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);

7709: /* if change_owner = N and chg_owner_code <> E then party id should
7710: be external party id */
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;

Line 7714: fnd_message.set_token('INTERNAL_PARTY_ID',p_order_line_rec.internal_party_id);

7710: be external party id */
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;

Line 7733: fnd_message.set_name('CSI','CSI_INT_INST_REF_MISSING');

7729: IF x_txn_sub_type_rec.nsrc_reference_reqd = 'Y'
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:

Line 7744: fnd_message.set_name('CSI','CSI_INT_RET_DATE_MISSING');

7740: IF x_txn_sub_type_rec.nsrc_return_reqd = 'Y'
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:

Line 7757: fnd_message.set_name('CSI','CSI_INT_NSRC_REL_MISSING');

7753: NOT(csi_utl_pkg.check_relation_exists(
7754: p_txn_ii_rltns_tbl,
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;

Line 7758: fnd_message.set_token('TXN_LINE_DETAIL_ID',p_txn_line_detail_tbl(i).txn_line_detail_id );

7754: p_txn_ii_rltns_tbl,
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:

Line 7777: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');

7773: (p_txn_line_detail_tbl(i).instance_id,
7774: p_txn_party_detail_tbl(j).instance_party_id,
7775: p_txn_party_detail_tbl(j).relationship_type_code);
7776: IF NOT(l_found) THEN
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;

Line 7778: fnd_message.set_token('INSTANCE_ID',p_txn_line_detail_tbl(i).instance_id);

7774: p_txn_party_detail_tbl(j).instance_party_id,
7775: p_txn_party_detail_tbl(j).relationship_type_code);
7776: IF NOT(l_found) THEN
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;

Line 7779: fnd_message.set_token('INSTANCE_PARTY_ID',p_txn_party_detail_tbl(j).instance_party_id);

7775: p_txn_party_detail_tbl(j).relationship_type_code);
7776: IF NOT(l_found) THEN
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;

Line 7780: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_detail_tbl(j).relationship_type_code);

7776: IF NOT(l_found) THEN
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;

Line 7794: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');

7790:
7791: /* if change_owner = Y and chg_owner_code = E then party id should
7792: be external party id */
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;

Line 7795: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);

7791: /* if change_owner = Y and chg_owner_code = E then party id should
7792: be external party id */
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;

Line 7796: fnd_message.set_token('INSTANCE_PARTY_ID',p_order_line_rec.internal_party_id);

7792: be external party id */
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

Line 7806: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');

7802: /* if change_owner = N and chg_owner_code <> E then party id should
7803: be external party id */
7804:
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;

Line 7807: fnd_message.set_token('PARTY_ID',p_txn_party_detail_tbl(j).party_source_id);

7803: be external party id */
7804:
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;

Line 7808: fnd_message.set_token('INSTANCE_PARTY_ID',p_order_line_rec.internal_party_id);

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

Line 7838: fnd_message.set_name('CSI','CSI_INT_II_REL_MISSING');

7834: x_subject_id => l_curr_subject_id,
7835: x_return_status => x_return_status);
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;

Line 7839: fnd_message.set_token('II_RELATIONSHIP_ID',p_txn_ii_rltns_tbl(j).csi_inst_relationship_id);

7835: x_return_status => x_return_status);
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:

Line 7856: fnd_message.set_name('CSI','CSI_INT_OBJ_ID_NOT_ALLOW_UPD');

7852:
7853: /* Check if the object id is being updated, if so raise error */
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;

Line 7857: fnd_message.set_token('OBJECT_ID',l_object_inst_id);

7853: /* Check if the object id is being updated, if so raise error */
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:

Line 8033: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

8029: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8030: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id; -- ship_to_org_id;
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;

Line 8034: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id); -- ship_to_org_id);

8030: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id; -- ship_to_org_id;
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

Line 8039: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

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');
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;

Line 8040: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id); -- ship_to_org_id);

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');
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 ;

Line 8061: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

8057: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8058: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id; -- ship_to_org_id;
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;

Line 8062: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id); -- ship_to_org_id);

8058: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id; -- ship_to_org_id;
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

Line 8067: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

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');
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;

Line 8068: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id); -- ship_to_org_id);

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');
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 ;

Line 8392: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');

8388: END IF;
8389:
8390: EXCEPTION
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;

Line 8393: fnd_message.set_token('message_id',p_msg_header.message_id);

8389:
8390: EXCEPTION
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;

Line 8394: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);

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

Line 8400: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

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');
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;

Line 8401: fnd_message.set_token('API_NAME',l_api_name);

8397: x_return_status := l_fnd_unexpected;
8398:
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;

Line 8402: fnd_message.set_token('SQL_ERROR',SQLERRM);

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

Line 8672: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');

8668: px_trx_error_rec := l_error_rec;
8669: debug('Error(E) :'||l_error_rec.error_text);
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;

Line 8673: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 540));

8669: debug('Error(E) :'||l_error_rec.error_text);
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;