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

Line 14: csi_t_gen_utility_pvt.add(p_message);

10: PROCEDURE debug(
11: p_message IN varchar2)
12: IS
13: BEGIN
14: csi_t_gen_utility_pvt.add(p_message);
15: END debug;
16:
17: PROCEDURE api_log(
18: p_api_name IN varchar2)

Line 21: csi_t_gen_utility_pvt.dump_api_info(

17: PROCEDURE api_log(
18: p_api_name IN varchar2)
19: IS
20: BEGIN
21: csi_t_gen_utility_pvt.dump_api_info(
22: p_pkg_name => 'csi_t_txn_parties_pvt',
23: p_api_name => p_api_name);
24: END api_log;
25:

Line 80: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

76:
77: END IF;
78:
79: -- debug messages
80: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
81:
82: csi_t_gen_utility_pvt.dump_api_info(
83: p_pkg_name => g_pkg_name,
84: p_api_name => l_api_name);

Line 82: csi_t_gen_utility_pvt.dump_api_info(

78:
79: -- debug messages
80: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
81:
82: csi_t_gen_utility_pvt.dump_api_info(
83: p_pkg_name => g_pkg_name,
84: p_api_name => l_api_name);
85:
86: IF l_debug_level > 1 then

Line 88: csi_t_gen_utility_pvt.add(

84: p_api_name => l_api_name);
85:
86: IF l_debug_level > 1 then
87:
88: csi_t_gen_utility_pvt.add(
89: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
90:
91: csi_t_gen_utility_pvt.dump_party_detail_rec(
92: p_party_detail_rec => p_txn_party_detail_rec);

Line 91: csi_t_gen_utility_pvt.dump_party_detail_rec(

87:
88: csi_t_gen_utility_pvt.add(
89: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
90:
91: csi_t_gen_utility_pvt.dump_party_detail_rec(
92: p_party_detail_rec => p_txn_party_detail_rec);
93:
94: END IF;
95:

Line 150: csi_t_gen_utility_pvt.add('Validate party source table failed.');

146: IF NOT
147: csi_instance_parties_vld_pvt.is_pty_source_tab_valid(
148: p_party_source_table => p_txn_party_detail_rec.party_source_table)
149: THEN
150: csi_t_gen_utility_pvt.add('Validate party source table failed.');
151: RAISE fnd_api.g_exc_error;
152: END IF;
153:
154: END IF;

Line 168: csi_t_gen_utility_pvt.add('Validate party source id failed.');

164: p_party_source_table => p_txn_party_detail_rec.party_source_table,
165: p_party_id => p_txn_party_detail_rec.party_source_id,
166: p_contact_flag => p_txn_party_detail_rec.contact_flag)
167: THEN
168: csi_t_gen_utility_pvt.add('Validate party source id failed.');
169: RAISE fnd_api.g_exc_error;
170: END IF;
171:
172: END IF;

Line 214: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');

210: csi_instance_parties_vld_pvt.is_pty_rel_type_valid(
211: p_party_rel_type_code => p_txn_party_detail_rec.relationship_type_code,
212: p_contact_flag => l_contact_flag)
213: THEN
214: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');
215: RAISE fnd_api.g_exc_error;
216: END IF;
217:
218: END IF;

Line 233: csi_t_gen_utility_pvt.add('Validate instance reference failed.');

229: p_level_inst_ref_id => p_txn_party_detail_rec.instance_party_id,
230: x_return_status => l_return_status);
231:
232: IF l_return_status <> fnd_api.g_ret_sts_error THEN
233: csi_t_gen_utility_pvt.add('Validate instance reference failed.');
234: RAISE fnd_api.g_exc_error;
235: END IF;
236:
237: END IF;

Line 277: csi_t_gen_utility_pvt.dump_api_info(

273: END IF;
274:
275: BEGIN
276:
277: csi_t_gen_utility_pvt.dump_api_info(
278: p_api_name => 'insert_row',
279: p_pkg_name => 'csi_t_party_detailss_pkg');
280:
281: csi_t_party_details_pkg.insert_row(

Line 355: csi_t_gen_utility_pvt.add('Create txn party accounts failed.');

351: x_msg_count => l_msg_count,
352: x_msg_data => l_msg_data);
353:
354: IF l_return_status <> fnd_api.g_ret_sts_success THEN
355: csi_t_gen_utility_pvt.add('Create txn party accounts failed.');
356: RAISE fnd_api.g_exc_error;
357: END IF;
358:
359: px_txn_pty_acct_detail_tbl(l_index).txn_party_detail_id :=

Line 374: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN

370: IF fnd_api.To_Boolean( p_commit ) THEN
371: COMMIT WORK;
372: END IF;
373:
374: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
375: csi_t_gen_utility_pvt.set_debug_off;
376: END IF;
377:
378: -- Standard call to get message count and if count is get message info.

Line 375: csi_t_gen_utility_pvt.set_debug_off;

371: COMMIT WORK;
372: END IF;
373:
374: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
375: csi_t_gen_utility_pvt.set_debug_off;
376: END IF;
377:
378: -- Standard call to get message count and if count is get message info.
379: FND_MSG_PUB.Count_And_Get(

Line 470: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

466:
467: END IF;
468:
469: -- Check the profile option debug_level for debug message reporting
470: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
471:
472: csi_t_gen_utility_pvt.dump_api_info(
473: p_pkg_name => g_pkg_name,
474: p_api_name => l_api_name);

Line 472: csi_t_gen_utility_pvt.dump_api_info(

468:
469: -- Check the profile option debug_level for debug message reporting
470: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
471:
472: csi_t_gen_utility_pvt.dump_api_info(
473: p_pkg_name => g_pkg_name,
474: p_api_name => l_api_name);
475:
476: IF l_debug_level > 1 THEN

Line 477: csi_t_gen_utility_pvt.add(

473: p_pkg_name => g_pkg_name,
474: p_api_name => l_api_name);
475:
476: IF l_debug_level > 1 THEN
477: csi_t_gen_utility_pvt.add(
478: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
479:
480: csi_t_gen_utility_pvt.dump_pty_acct_rec(
481: p_pty_acct_rec => p_txn_pty_acct_detail_rec);

Line 480: csi_t_gen_utility_pvt.dump_pty_acct_rec(

476: IF l_debug_level > 1 THEN
477: csi_t_gen_utility_pvt.add(
478: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
479:
480: csi_t_gen_utility_pvt.dump_pty_acct_rec(
481: p_pty_acct_rec => p_txn_pty_acct_detail_rec);
482: END IF;
483:
484: -- Main API code

Line 617: csi_t_gen_utility_pvt.dump_api_info(

613: l_txn_account_detail_id := p_txn_pty_acct_detail_rec.txn_account_detail_id;
614: END IF;
615:
616: begin
617: csi_t_gen_utility_pvt.dump_api_info(
618: p_api_name => 'insert_row',
619: p_pkg_name => 'csi_t_party_accounts_pkg');
620:
621: csi_t_party_accounts_pkg.insert_row(

Line 671: csi_t_gen_utility_pvt.set_debug_off;

667: IF fnd_api.To_Boolean( p_commit ) THEN
668: COMMIT WORK;
669: END IF;
670:
671: csi_t_gen_utility_pvt.set_debug_off;
672:
673: -- Standard call to get message count and if count is get message info.
674: FND_MSG_PUB.Count_And_Get(
675: p_count => x_msg_count,

Line 686: csi_t_gen_utility_pvt.set_debug_off;

682: x_return_status := fnd_api.G_RET_STS_ERROR ;
683: FND_MSG_PUB.Count_And_Get (
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686: csi_t_gen_utility_pvt.set_debug_off;
687:
688: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
689:
690: ROLLBACK TO Create_Txn_Pty_Acct_Dtls;

Line 696: csi_t_gen_utility_pvt.set_debug_off;

692:
693: FND_MSG_PUB.Count_And_Get(
694: p_count => x_msg_count,
695: p_data => x_msg_data);
696: csi_t_gen_utility_pvt.set_debug_off;
697:
698: WHEN OTHERS THEN
699:
700: ROLLBACK TO Create_Txn_Pty_Acct_Dtls;

Line 715: csi_t_gen_utility_pvt.set_debug_off;

711:
712: FND_MSG_PUB.Count_And_Get(
713: p_count => x_msg_count,
714: p_data => x_msg_data);
715: csi_t_gen_utility_pvt.set_debug_off;
716:
717: END create_txn_pty_acct_dtls;
718:
719: PROCEDURE update_txn_party_dtls(

Line 792: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

788:
789: END IF;
790:
791: -- debug messages
792: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
793:
794: csi_t_gen_utility_pvt.dump_api_info(
795: p_pkg_name => g_pkg_name,
796: p_api_name => l_api_name);

Line 794: csi_t_gen_utility_pvt.dump_api_info(

790:
791: -- debug messages
792: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
793:
794: csi_t_gen_utility_pvt.dump_api_info(
795: p_pkg_name => g_pkg_name,
796: p_api_name => l_api_name);
797:
798: csi_t_gen_utility_pvt.add(

Line 798: csi_t_gen_utility_pvt.add(

794: csi_t_gen_utility_pvt.dump_api_info(
795: p_pkg_name => g_pkg_name,
796: p_api_name => l_api_name);
797:
798: csi_t_gen_utility_pvt.add(
799: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
800:
801: -- Main API code
802:

Line 809: csi_t_gen_utility_pvt.dump_party_detail_rec(

805: FOR l_ind IN p_txn_party_detail_tbl.FIRST .. p_txn_party_detail_tbl.LAST
806: LOOP
807:
808: IF l_debug_level > 1 THEN
809: csi_t_gen_utility_pvt.dump_party_detail_rec(
810: p_party_detail_rec => p_txn_party_detail_tbl(l_ind));
811: END IF;
812:
813: l_pty_rec.txn_party_detail_id :=

Line 874: csi_t_gen_utility_pvt.add('Validate party source table failed.');

870: IF NOT
871: csi_instance_parties_vld_pvt.is_pty_source_tab_valid(
872: p_party_source_table => l_pty_rec.party_source_table)
873: THEN
874: csi_t_gen_utility_pvt.add('Validate party source table failed.');
875: RAISE fnd_api.g_exc_error;
876: END IF;
877:
878: END IF;

Line 901: csi_t_gen_utility_pvt.add('Validate party source table failed.');

897: p_party_source_table => l_pty_rec.party_source_table,
898: p_party_id => l_pty_rec.party_source_id,
899: p_contact_flag => l_pty_rec.contact_flag)
900: THEN
901: csi_t_gen_utility_pvt.add('Validate party source table failed.');
902: RAISE fnd_api.g_exc_error;
903: END IF;
904: END IF;
905:

Line 923: csi_t_gen_utility_pvt.add('Validate instance party id failed.');

919: p_level_inst_ref_id => l_pty_rec.instance_party_id,
920: x_return_status => l_return_status);
921:
922: IF l_return_status <> fnd_api.g_ret_sts_success THEN
923: csi_t_gen_utility_pvt.add('Validate instance party id failed.');
924: RAISE fnd_api.g_exc_error;
925: END IF;
926:
927: END IF;

Line 951: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');

947: csi_instance_parties_vld_pvt.is_pty_rel_type_valid(
948: p_party_rel_type_code => l_pty_rec.relationship_type_code,
949: p_contact_flag => l_contact_flag)
950: THEN
951: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');
952: RAISE fnd_api.g_exc_error;
953: END IF;
954:
955: END IF;

Line 1111: csi_t_gen_utility_pvt.dump_api_info(

1107: -- at the time of fixing it, code needs to be added here too
1108: debug('Party Contact needs to be preserved : '||cont_pty_rec.txn_party_detail_id);
1109: ELSE
1110: debug('Deleting the Party Contact, must not be preserved : '||cont_pty_rec.txn_party_detail_id);
1111: csi_t_gen_utility_pvt.dump_api_info(
1112: p_api_name => 'delete_row',
1113: p_pkg_name => 'csi_t_party_details_pkg');
1114:
1115: csi_t_party_details_pkg.delete_row(

Line 1124: csi_t_gen_utility_pvt.dump_api_info(

1120:
1121: END IF;
1122:
1123: begin
1124: csi_t_gen_utility_pvt.dump_api_info(
1125: p_api_name => 'update_row',
1126: p_pkg_name => 'csi_t_party_details_pkg');
1127:
1128: csi_t_party_details_pkg.update_row(

Line 1507: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

1503:
1504: END IF;
1505:
1506: -- debug messages
1507: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
1508:
1509: csi_t_gen_utility_pvt.dump_api_info(
1510: p_pkg_name => g_pkg_name,
1511: p_api_name => l_api_name);

Line 1509: csi_t_gen_utility_pvt.dump_api_info(

1505:
1506: -- debug messages
1507: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
1508:
1509: csi_t_gen_utility_pvt.dump_api_info(
1510: p_pkg_name => g_pkg_name,
1511: p_api_name => l_api_name);
1512:
1513: csi_t_gen_utility_pvt.add(

Line 1513: csi_t_gen_utility_pvt.add(

1509: csi_t_gen_utility_pvt.dump_api_info(
1510: p_pkg_name => g_pkg_name,
1511: p_api_name => l_api_name);
1512:
1513: csi_t_gen_utility_pvt.add(
1514: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
1515:
1516: -- Main API code
1517:

Line 1524: csi_t_gen_utility_pvt.dump_pty_acct_rec(

1520: p_txn_pty_acct_detail_tbl.LAST
1521: LOOP
1522:
1523: IF l_debug_level > 1 THEN
1524: csi_t_gen_utility_pvt.dump_pty_acct_rec(
1525: p_pty_acct_rec => p_txn_pty_acct_detail_tbl(l_ind));
1526: END IF;
1527:
1528: l_pa_rec.txn_account_detail_id :=

Line 1581: csi_t_gen_utility_pvt.add('Validate ip account id failed.');

1577: --validate ip_account_id
1578: IF NOT csi_instance_parties_vld_pvt.is_ip_account_valid(
1579: p_ip_account_id => l_pa_rec.ip_account_id) THEN
1580: RAISE fnd_api.g_exc_error;
1581: csi_t_gen_utility_pvt.add('Validate ip account id failed.');
1582: END IF;
1583:
1584: END IF;
1585:

Line 1617: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');

1613: csi_instance_parties_vld_pvt.is_pty_rel_type_valid(
1614: p_party_rel_type_code => l_pa_rec.relationship_type_code,
1615: p_contact_flag => 'A')
1616: THEN
1617: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');
1618: RAISE fnd_api.g_exc_error;
1619: END IF;
1620:
1621: END IF;

Line 1657: csi_t_gen_utility_pvt.dump_api_info(

1653: p_txn_pty_acct_detail_tbl(l_ind).context;
1654:
1655: begin
1656:
1657: csi_t_gen_utility_pvt.dump_api_info(
1658: p_api_name => 'update_row',
1659: p_pkg_name => 'csi_t_party_details_pkg');
1660:
1661: csi_t_party_accounts_pkg.update_row (

Line 1827: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

1823:
1824: l_pty_acc_ind := 0;
1825:
1826: -- debug messages
1827: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
1828:
1829: csi_t_gen_utility_pvt.dump_api_info(
1830: p_pkg_name => g_pkg_name,
1831: p_api_name => l_api_name);

Line 1829: csi_t_gen_utility_pvt.dump_api_info(

1825:
1826: -- debug messages
1827: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
1828:
1829: csi_t_gen_utility_pvt.dump_api_info(
1830: p_pkg_name => g_pkg_name,
1831: p_api_name => l_api_name);
1832:
1833: csi_t_gen_utility_pvt.add(

Line 1833: csi_t_gen_utility_pvt.add(

1829: csi_t_gen_utility_pvt.dump_api_info(
1830: p_pkg_name => g_pkg_name,
1831: p_api_name => l_api_name);
1832:
1833: csi_t_gen_utility_pvt.add(
1834: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
1835:
1836: -- Main API code
1837: IF p_txn_party_ids_tbl.COUNT > 0 THEN

Line 1892: csi_t_gen_utility_pvt.dump_api_info(

1888: FOR cont_pty_rec in cont_pty_cur(l_pty_dtl_id)
1889: LOOP
1890:
1891: debug('Deleting Party Contact rec: '||cont_pty_rec.txn_party_detail_id);
1892: csi_t_gen_utility_pvt.dump_api_info(
1893: p_api_name => 'delete_row',
1894: p_pkg_name => 'csi_t_party_details_pkg');
1895:
1896: csi_t_party_details_pkg.delete_row(

Line 1901: csi_t_gen_utility_pvt.dump_api_info(

1897: p_txn_party_detail_id => cont_pty_rec.txn_party_detail_id);
1898:
1899: END LOOP;
1900:
1901: csi_t_gen_utility_pvt.dump_api_info(
1902: p_api_name => 'delete_row',
1903: p_pkg_name => 'csi_t_party_details_pkg');
1904:
1905: csi_t_party_details_pkg.delete_row(

Line 1966: csi_t_gen_utility_pvt.dump_api_info(

1962: FOR cont_pty_rec in cont_pty_cur(l_pty_dtl_id)
1963: LOOP
1964:
1965: debug('Deleting Party Contact rec: '||cont_pty_rec.txn_party_detail_id);
1966: csi_t_gen_utility_pvt.dump_api_info(
1967: p_api_name => 'delete_row',
1968: p_pkg_name => 'csi_t_party_details_pkg');
1969:
1970: csi_t_party_details_pkg.delete_row(

Line 1975: csi_t_gen_utility_pvt.dump_api_info(

1971: p_txn_party_detail_id => cont_pty_rec.txn_party_detail_id);
1972:
1973: END LOOP;
1974:
1975: csi_t_gen_utility_pvt.dump_api_info(
1976: p_api_name => 'delete_row',
1977: p_pkg_name => 'csi_t_party_details_pkg');
1978:
1979: csi_t_party_details_pkg.delete_row(

Line 2087: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

2083:
2084: END IF;
2085:
2086: -- debug messages
2087: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2088:
2089: csi_t_gen_utility_pvt.dump_api_info(
2090: p_pkg_name => g_pkg_name,
2091: p_api_name => l_api_name);

Line 2089: csi_t_gen_utility_pvt.dump_api_info(

2085:
2086: -- debug messages
2087: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2088:
2089: csi_t_gen_utility_pvt.dump_api_info(
2090: p_pkg_name => g_pkg_name,
2091: p_api_name => l_api_name);
2092:
2093: csi_t_gen_utility_pvt.add(

Line 2093: csi_t_gen_utility_pvt.add(

2089: csi_t_gen_utility_pvt.dump_api_info(
2090: p_pkg_name => g_pkg_name,
2091: p_api_name => l_api_name);
2092:
2093: csi_t_gen_utility_pvt.add(
2094: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
2095:
2096: -- Main API code
2097: IF p_txn_pty_acct_ids_tbl.COUNT > 0 THEN

Line 2120: csi_t_gen_utility_pvt.dump_api_info(

2116: RAISE fnd_api.g_exc_error;
2117:
2118: END IF;
2119:
2120: csi_t_gen_utility_pvt.dump_api_info(
2121: p_api_name => 'delete_row',
2122: p_pkg_name => 'csi_t_party_accounts_pkg');
2123:
2124: csi_t_party_accounts_pkg.delete_row(

Line 2148: csi_t_gen_utility_pvt.dump_api_info(

2144:
2145: FOR pty_acc_rec in pty_acc_cur (l_pty_dtl_id)
2146: LOOP
2147:
2148: csi_t_gen_utility_pvt.dump_api_info(
2149: p_api_name => 'delete_row',
2150: p_pkg_name => 'csi_t_party_accounts_pkg');
2151:
2152: csi_t_party_accounts_pkg.delete_row(