DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on FND_MESSAGE

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

624: l_order_line_rec.ib_current_loc_id := l_party_site_id;
625:
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

Line 629: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ib_current_loc_id);

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

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

647: l_order_line_rec.ib_install_loc_id := l_party_install_site_id;
648:
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

Line 652: fnd_message.set_token('LOCATION_ID',l_order_line_rec.ib_install_loc_id);

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

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

839: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
840:
841: EXCEPTION
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;

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

840:
841: EXCEPTION
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;

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

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

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

995: WHERE source_transaction_id = l_copy_txn_line_rec.source_transaction_id
996: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
997: EXCEPTION
998: WHEN no_data_found THEN
999: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');
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);

Line 1000: fnd_message.set_token('SOURCE_TRANSACTION_ID',

996: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
997: EXCEPTION
998: WHEN no_data_found THEN
999: fnd_message.set_name('CSI','CSI_INT_TRX_LINE_MISSING');
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;

Line 1002: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4305:
4306: EXCEPTION
4307: WHEN no_data_found THEN
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;

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

4306: EXCEPTION
4307: WHEN no_data_found THEN
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;

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

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

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

4731: EXCEPTION
4732: WHEN no_data_found THEN
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;

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

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

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

5348: debug(' txn_systems_tbl.count :'||p_txn_systems_tbl.count);
5349:
5350: IF p_txn_line_detail_tbl.count <= 0
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6168: l_ownership_flag:=
6169: NVL(csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn,'N');
6170:
6171: IF l_ownership_flag = 'N' Then
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;

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

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

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

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

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

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

Line 6910: fnd_message.set_name('CSI','CSI_INT_PTY_OWNER_REC_MISSING');

6906:
6907: -- Bug 13572608
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;

Line 6911: fnd_message.set_token('TXN_LINE_DETAIL_ID',l_tld_rec.txn_line_detail_id);

6907: -- Bug 13572608
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:

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

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

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

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

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

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

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

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

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

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

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

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

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

7824: END IF;
7825:
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

7999: p_txn_party_detail_tbl(j).instance_party_id,
8000: p_txn_party_detail_tbl(j).relationship_type_code);
8001:
8002: IF NOT(l_found) THEN
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

8092: (p_txn_line_detail_tbl(i).instance_id,
8093: p_txn_party_detail_tbl(j).instance_party_id,
8094: p_txn_party_detail_tbl(j).relationship_type_code);
8095: IF NOT(l_found) THEN
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;

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

8093: p_txn_party_detail_tbl(j).instance_party_id,
8094: p_txn_party_detail_tbl(j).relationship_type_code);
8095: IF NOT(l_found) THEN
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

8707: END IF;
8708:
8709: EXCEPTION
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;

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

8708:
8709: EXCEPTION
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;

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

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

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

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

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

8716: x_return_status := l_fnd_unexpected;
8717:
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;

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

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

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

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

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

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