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_MASS_EDIT_PUB dependencies on CSI_T_GEN_UTILITY_PVT

Line 20: csi_t_gen_utility_pvt.add(p_message);

16: p_message IN varchar2)
17: IS
18: BEGIN
19: FND_FILE.PUT_LINE (FND_FILE.LOG, p_message );
20: csi_t_gen_utility_pvt.add(p_message);
21: END debug;
22:
23: PROCEDURE debug_out(
24: p_message IN varchar2)

Line 779: csi_t_gen_utility_pvt.dump_txn_tables(

775: debug(' ext_attrib_tbl.count :'||d_ext_attrib_tbl.count);
776:
777: debug('Dump Txn Details Information .....');
778:
779: csi_t_gen_utility_pvt.dump_txn_tables(
780: p_ids_or_index_based => 'I',
781: p_line_detail_tbl => d_line_dtl_tbl,
782: p_party_detail_tbl => d_pty_dtl_tbl,
783: p_pty_acct_tbl => d_pty_acct_tbl,

Line 1086: csi_t_gen_utility_pvt.dump_csi_instance_tbl(n_instance_tbl);

1082: debug(' Extendedattr_tbl '||n_ext_attrib_values_tbl.count);
1083: IF n_instance_tbl.count > 0
1084: THEN
1085:
1086: csi_t_gen_utility_pvt.dump_csi_instance_tbl(n_instance_tbl);
1087: csi_t_gen_utility_pvt.dump_csi_party_tbl(n_party_tbl);
1088: csi_t_gen_utility_pvt.dump_csi_account_tbl(n_party_account_tbl);
1089: debug('Source Transaction Date in Transaction: '||n_txn_rec.source_transaction_date);
1090: debug('Transaction Date in Transaction: '||n_txn_rec.transaction_date);

Line 1087: csi_t_gen_utility_pvt.dump_csi_party_tbl(n_party_tbl);

1083: IF n_instance_tbl.count > 0
1084: THEN
1085:
1086: csi_t_gen_utility_pvt.dump_csi_instance_tbl(n_instance_tbl);
1087: csi_t_gen_utility_pvt.dump_csi_party_tbl(n_party_tbl);
1088: csi_t_gen_utility_pvt.dump_csi_account_tbl(n_party_account_tbl);
1089: debug('Source Transaction Date in Transaction: '||n_txn_rec.source_transaction_date);
1090: debug('Transaction Date in Transaction: '||n_txn_rec.transaction_date);
1091:

Line 1088: csi_t_gen_utility_pvt.dump_csi_account_tbl(n_party_account_tbl);

1084: THEN
1085:
1086: csi_t_gen_utility_pvt.dump_csi_instance_tbl(n_instance_tbl);
1087: csi_t_gen_utility_pvt.dump_csi_party_tbl(n_party_tbl);
1088: csi_t_gen_utility_pvt.dump_csi_account_tbl(n_party_account_tbl);
1089: debug('Source Transaction Date in Transaction: '||n_txn_rec.source_transaction_date);
1090: debug('Transaction Date in Transaction: '||n_txn_rec.transaction_date);
1091:
1092: csi_item_instance_grp.update_item_instance (

Line 1525: csi_t_gen_utility_pvt.add('API Being Executed : CREATE_MASS_EDIT_BATCH_PUB');

1521: Begin
1522: -- Standard Start of API savepoint
1523: SAVEPOINT create_mass_edit_pub;
1524:
1525: csi_t_gen_utility_pvt.add('API Being Executed : CREATE_MASS_EDIT_BATCH_PUB');
1526: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1527:
1528: -- Initialize message list if p_init_msg_list is set to TRUE.
1529: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1526: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1522: -- Standard Start of API savepoint
1523: SAVEPOINT create_mass_edit_pub;
1524:
1525: csi_t_gen_utility_pvt.add('API Being Executed : CREATE_MASS_EDIT_BATCH_PUB');
1526: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1527:
1528: -- Initialize message list if p_init_msg_list is set to TRUE.
1529: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1530: FND_MSG_PUB.Initialize;

Line 1594: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1590: (p_count => x_msg_count,
1591: p_data => x_msg_data
1592: );
1593:
1594: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1595: EXCEPTION
1596: WHEN FND_API.G_EXC_ERROR THEN
1597: ROLLBACK TO create_mass_edit_pub;
1598: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1690: csi_t_gen_utility_pvt.add('API Being Executed : UPDATE_MASS_EDIT_BATCH_PUB');

1686:
1687: -- Standard Start of API savepoint
1688: SAVEPOINT update_mass_edit_pub;
1689:
1690: csi_t_gen_utility_pvt.add('API Being Executed : UPDATE_MASS_EDIT_BATCH_PUB');
1691: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1692:
1693: -- Initialize message list if p_init_msg_list is set to TRUE.
1694: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1691: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1687: -- Standard Start of API savepoint
1688: SAVEPOINT update_mass_edit_pub;
1689:
1690: csi_t_gen_utility_pvt.add('API Being Executed : UPDATE_MASS_EDIT_BATCH_PUB');
1691: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1692:
1693: -- Initialize message list if p_init_msg_list is set to TRUE.
1694: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1695: FND_MSG_PUB.Initialize;

Line 1728: csi_t_gen_utility_pvt.add('px_txn_line_detail_tbl.count: '||px_mass_edit_inst_tbl.count);

1724: RAISE FND_API.g_exc_error;
1725: END IF;
1726:
1727: -- call API to run
1728: csi_t_gen_utility_pvt.add('px_txn_line_detail_tbl.count: '||px_mass_edit_inst_tbl.count);
1729:
1730:
1731: csi_mass_edit_pvt.update_mass_edit_batch
1732: (

Line 1760: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1756: IF FND_API.To_Boolean( p_commit ) THEN
1757: COMMIT WORK;
1758: END IF;
1759:
1760: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1761: EXCEPTION
1762: WHEN FND_API.G_EXC_ERROR THEN
1763: ROLLBACK TO update_mass_edit_pub;
1764: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1818: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCH');

1814:
1815: -- Standard Start of API savepoint
1816: SAVEPOINT delete_mass_edit_batch;
1817:
1818: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCH');
1819: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1820:
1821: -- Initialize message list if p_init_msg_list is set to TRUE.
1822: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1819: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1815: -- Standard Start of API savepoint
1816: SAVEPOINT delete_mass_edit_batch;
1817:
1818: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCH');
1819: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1820:
1821: -- Initialize message list if p_init_msg_list is set to TRUE.
1822: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1823: FND_MSG_PUB.Initialize;

Line 1883: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batch');

1879: (p_count => x_msg_count,
1880: p_data => x_msg_data
1881: );
1882:
1883: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batch');
1884: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1885:
1886: csi_t_gen_utility_pvt.set_debug_off;
1887:

Line 1884: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1880: p_data => x_msg_data
1881: );
1882:
1883: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batch');
1884: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1885:
1886: csi_t_gen_utility_pvt.set_debug_off;
1887:
1888: EXCEPTION

Line 1886: csi_t_gen_utility_pvt.set_debug_off;

1882:
1883: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batch');
1884: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1885:
1886: csi_t_gen_utility_pvt.set_debug_off;
1887:
1888: EXCEPTION
1889: WHEN FND_API.G_EXC_ERROR THEN
1890:

Line 1897: csi_t_gen_utility_pvt.set_debug_off;

1893: FND_MSG_PUB.Count_And_Get (
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:
1897: csi_t_gen_utility_pvt.set_debug_off;
1898:
1899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1900:
1901: ROLLBACK TO Delete_Mass_Edit_Batch;

Line 1908: csi_t_gen_utility_pvt.set_debug_off;

1904: FND_MSG_PUB.Count_And_Get(
1905: p_count => x_msg_count,
1906: p_data => x_msg_data);
1907:
1908: csi_t_gen_utility_pvt.set_debug_off;
1909:
1910: WHEN OTHERS THEN
1911:
1912: ROLLBACK TO Delete_Mass_Edit_Batch;

Line 1928: csi_t_gen_utility_pvt.set_debug_off;

1924: FND_MSG_PUB.Count_And_Get(
1925: p_count => x_msg_count,
1926: p_data => x_msg_data);
1927:
1928: csi_t_gen_utility_pvt.set_debug_off;
1929:
1930: END Delete_Mass_Edit_Batch;
1931:
1932: /* This is the wrapper API to handle multiple batch deletes. Calls the DELETE_MASS_EDIT_BATCH */

Line 1958: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCHES');

1954:
1955: -- Standard Start of API savepoint
1956: SAVEPOINT delete_mass_edit_batches;
1957:
1958: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCHES');
1959: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1960:
1961: -- Initialize message list if p_init_msg_list is set to TRUE.
1962: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1959: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1955: -- Standard Start of API savepoint
1956: SAVEPOINT delete_mass_edit_batches;
1957:
1958: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCHES');
1959: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1960:
1961: -- Initialize message list if p_init_msg_list is set to TRUE.
1962: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1963: FND_MSG_PUB.Initialize;

Line 2027: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batches');

2023: (p_count => x_msg_count,
2024: p_data => x_msg_data
2025: );
2026:
2027: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batches');
2028: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2029:
2030: csi_t_gen_utility_pvt.set_debug_off;
2031:

Line 2028: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

2024: p_data => x_msg_data
2025: );
2026:
2027: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batches');
2028: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2029:
2030: csi_t_gen_utility_pvt.set_debug_off;
2031:
2032: EXCEPTION

Line 2030: csi_t_gen_utility_pvt.set_debug_off;

2026:
2027: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batches');
2028: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2029:
2030: csi_t_gen_utility_pvt.set_debug_off;
2031:
2032: EXCEPTION
2033: WHEN FND_API.G_EXC_ERROR THEN
2034:

Line 2041: csi_t_gen_utility_pvt.set_debug_off;

2037: FND_MSG_PUB.Count_And_Get (
2038: p_count => x_msg_count,
2039: p_data => x_msg_data);
2040:
2041: csi_t_gen_utility_pvt.set_debug_off;
2042:
2043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2044:
2045: ROLLBACK TO Delete_Mass_Edit_Batches;

Line 2052: csi_t_gen_utility_pvt.set_debug_off;

2048: FND_MSG_PUB.Count_And_Get(
2049: p_count => x_msg_count,
2050: p_data => x_msg_data);
2051:
2052: csi_t_gen_utility_pvt.set_debug_off;
2053:
2054: WHEN OTHERS THEN
2055:
2056: ROLLBACK TO Delete_Mass_Edit_Batches;

Line 2071: csi_t_gen_utility_pvt.set_debug_off;

2067: FND_MSG_PUB.Count_And_Get(
2068: p_count => x_msg_count,
2069: p_data => x_msg_data);
2070:
2071: csi_t_gen_utility_pvt.set_debug_off;
2072:
2073: END Delete_Mass_Edit_Batches;
2074:
2075: /*

Line 2106: csi_t_gen_utility_pvt.add('API Being Executed : GET_MASS_EDIT_DETAILS');

2102:
2103: -- Standard Start of API savepoint
2104: SAVEPOINT get_mass_edit_details;
2105:
2106: csi_t_gen_utility_pvt.add('API Being Executed : GET_MASS_EDIT_DETAILS');
2107: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2108:
2109: -- Initialize message list if p_init_msg_list is set to TRUE.
2110: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 2107: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

2103: -- Standard Start of API savepoint
2104: SAVEPOINT get_mass_edit_details;
2105:
2106: csi_t_gen_utility_pvt.add('API Being Executed : GET_MASS_EDIT_DETAILS');
2107: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2108:
2109: -- Initialize message list if p_init_msg_list is set to TRUE.
2110: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2111: FND_MSG_PUB.Initialize;

Line 2178: csi_t_gen_utility_pvt.add('API Executed : Get Mass Edit Details');

2174: (p_count => x_msg_count,
2175: p_data => x_msg_data
2176: );
2177:
2178: csi_t_gen_utility_pvt.add('API Executed : Get Mass Edit Details');
2179: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2180:
2181: csi_t_gen_utility_pvt.set_debug_off;
2182:

Line 2179: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

2175: p_data => x_msg_data
2176: );
2177:
2178: csi_t_gen_utility_pvt.add('API Executed : Get Mass Edit Details');
2179: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2180:
2181: csi_t_gen_utility_pvt.set_debug_off;
2182:
2183: EXCEPTION

Line 2181: csi_t_gen_utility_pvt.set_debug_off;

2177:
2178: csi_t_gen_utility_pvt.add('API Executed : Get Mass Edit Details');
2179: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2180:
2181: csi_t_gen_utility_pvt.set_debug_off;
2182:
2183: EXCEPTION
2184: WHEN FND_API.G_EXC_ERROR THEN
2185:

Line 2192: csi_t_gen_utility_pvt.set_debug_off;

2188: FND_MSG_PUB.Count_And_Get (
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191:
2192: csi_t_gen_utility_pvt.set_debug_off;
2193:
2194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2195:
2196: ROLLBACK TO Get_mass_edit_details;

Line 2203: csi_t_gen_utility_pvt.set_debug_off;

2199: FND_MSG_PUB.Count_And_Get(
2200: p_count => x_msg_count,
2201: p_data => x_msg_data);
2202:
2203: csi_t_gen_utility_pvt.set_debug_off;
2204:
2205: WHEN OTHERS THEN
2206:
2207: ROLLBACK TO Get_mass_edit_details;

Line 2223: csi_t_gen_utility_pvt.set_debug_off;

2219: FND_MSG_PUB.Count_And_Get(
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222:
2223: csi_t_gen_utility_pvt.set_debug_off;
2224:
2225: END Get_mass_edit_details;
2226:
2227: /*----------------------------------------------------*/