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

Line 15: csi_t_gen_utility_pvt.add(p_message);

11: PROCEDURE debug(
12: p_message in varchar2)
13: IS
14: BEGIN
15: csi_t_gen_utility_pvt.add(p_message);
16: END debug;
17:
18: FUNCTION check_txn_details_exist(
19: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec)

Line 36: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

32: l_value number;
33:
34: BEGIN
35:
36: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
37:
38: csi_t_gen_utility_pvt.dump_api_info(
39: p_pkg_name => g_pkg_name,
40: p_api_name => l_api_name);

Line 38: csi_t_gen_utility_pvt.dump_api_info(

34: BEGIN
35:
36: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
37:
38: csi_t_gen_utility_pvt.dump_api_info(
39: p_pkg_name => g_pkg_name,
40: p_api_name => l_api_name);
41:
42: IF l_debug_level > 1 THEN

Line 43: csi_t_gen_utility_pvt.dump_txn_line_rec(

39: p_pkg_name => g_pkg_name,
40: p_api_name => l_api_name);
41:
42: IF l_debug_level > 1 THEN
43: csi_t_gen_utility_pvt.dump_txn_line_rec(
44: p_txn_line_rec => p_txn_line_rec);
45: END IF;
46:
47: l_txn_line_query_rec.transaction_line_id := p_txn_line_rec.transaction_line_id;

Line 64: csi_t_gen_utility_pvt.add(' Select Stmt:'||l_select_stmt);

60: l_select_stmt :=
61: 'select 1 l_value from csi_t_transaction_lines where '||l_lines_where_clause;
62:
63: IF l_debug_level > 10 THEN
64: csi_t_gen_utility_pvt.add(' Select Stmt:'||l_select_stmt);
65: END IF;
66:
67: l_cursor_id := dbms_sql.open_cursor;
68:

Line 115: csi_t_gen_utility_pvt.set_debug_off;

111: dbms_sql.close_cursor(l_cursor_id);
112:
113: END IF;
114:
115: csi_t_gen_utility_pvt.set_debug_off;
116:
117: IF l_found THEN
118: debug('Transaction Details found.');
119: ELSE

Line 206: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

202:
203: END IF;
204:
205: -- debug messages
206: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
207:
208: csi_t_gen_utility_pvt.dump_api_info(
209: p_pkg_name => g_pkg_name,
210: p_api_name => l_api_name);

Line 208: csi_t_gen_utility_pvt.dump_api_info(

204:
205: -- debug messages
206: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
207:
208: csi_t_gen_utility_pvt.dump_api_info(
209: p_pkg_name => g_pkg_name,
210: p_api_name => l_api_name);
211:
212: csi_t_gen_utility_pvt.add(

Line 212: csi_t_gen_utility_pvt.add(

208: csi_t_gen_utility_pvt.dump_api_info(
209: p_pkg_name => g_pkg_name,
210: p_api_name => l_api_name);
211:
212: csi_t_gen_utility_pvt.add(
213: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
214:
215: IF l_debug_level > 1 then
216:

Line 217: csi_t_gen_utility_pvt.dump_txn_line_rec(

213: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
214:
215: IF l_debug_level > 1 then
216:
217: csi_t_gen_utility_pvt.dump_txn_line_rec(
218: p_txn_line_rec => px_txn_line_rec);
219:
220: END IF;
221:

Line 286: csi_t_gen_utility_pvt.add('Validating against CZ view ');

282: -- Added for CZ Integration (Begin)
283: -- validate against CZ view
284: IF NVL(px_txn_line_rec.config_session_hdr_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
285: THEN
286: csi_t_gen_utility_pvt.add('Validating against CZ view ');
287: csi_t_vldn_routines_pvt.check_cz_session_keys(
288: p_config_session_hdr_id => px_txn_line_rec.config_session_hdr_id,
289: p_config_session_rev_num => px_txn_line_rec.config_session_rev_num,
290: p_config_session_item_id => px_txn_line_rec.config_session_item_id,

Line 330: csi_t_gen_utility_pvt.add('Validating source integrity.');

326: -- Added for CZ Integration
327: -- Bypass this check for Configurator, Mass edit as it is for OM.
328: IF px_txn_line_rec.source_transaction_type_id not in (401,3)
329: THEN
330: csi_t_gen_utility_pvt.add('Validating source integrity.');
331:
332: csi_t_vldn_routines_pvt.check_source_integrity(
333: p_validation_level => p_validation_level,
334: p_txn_line_rec => px_txn_line_rec,

Line 341: csi_t_gen_utility_pvt.add('Validating party integrity.');

337:
338: IF l_return_status <> fnd_api.g_ret_sts_success THEN
339: RAISE fnd_api.g_exc_error;
340: END IF;
341: csi_t_gen_utility_pvt.add('Validating party integrity.');
342:
343: csi_t_vldn_routines_pvt.check_party_integrity(
344: p_txn_line_rec => px_txn_line_rec,
345: p_txn_line_dtl_tbl => px_txn_line_detail_tbl,

Line 354: csi_t_gen_utility_pvt.add('End of business object validations.');

350: RAISE fnd_api.g_exc_error;
351: END IF;
352:
353: -- end of business object validation
354: csi_t_gen_utility_pvt.add('End of business object validations.');
355:
356: END IF ; ---<>401,3
357: END IF;
358:

Line 367: csi_t_gen_utility_pvt.dump_api_info(

363:
364: IF l_skip_tl_create <> 'Y' THEN
365: -- call table handler to populate the csi_t_transaction_lines table
366:
367: csi_t_gen_utility_pvt.dump_api_info(
368: p_api_name => 'insert_row',
369: p_pkg_name => 'csi_t_transaction_lines_pkg');
370:
371: BEGIN

Line 568: csi_t_gen_utility_pvt.add('Calling get_cz_inst_or_tld_id for subject ');

564: = fnd_api.g_miss_num)
565: THEN
566: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.
567:
568: csi_t_gen_utility_pvt.add('Calling get_cz_inst_or_tld_id for subject ');
569: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
570: p_config_inst_hdr_id => px_txn_ii_rltns_tbl(i).sub_config_inst_hdr_id,
571: p_config_inst_rev_num => px_txn_ii_rltns_tbl(i).sub_config_inst_rev_num,
572: p_config_inst_item_id => px_txn_ii_rltns_tbl(i).sub_config_inst_item_id ,

Line 598: csi_t_gen_utility_pvt.add('tld/instance id for subject ' || l_sub_instance_id || l_sub_tld_id);

594: px_txn_ii_rltns_tbl(i).subject_id := l_sub_tld_id;
595: px_txn_ii_rltns_tbl(i).subject_type := 'T' ;
596: px_txn_ii_rltns_tbl(i).subject_index_flag := 'N' ;
597: END IF ;
598: csi_t_gen_utility_pvt.add('tld/instance id for subject ' || l_sub_instance_id || l_sub_tld_id);
599: END IF ; ---Subject_id is NULL
600:
601: IF (NVL(px_txn_ii_rltns_tbl(i).obj_config_inst_hdr_id , fnd_api.g_miss_num)
602: <> fnd_api.g_miss_num

Line 606: csi_t_gen_utility_pvt.add('Calling get_cz_inst_or_tld_id for OBJECT');

602: <> fnd_api.g_miss_num
603: AND NVL(px_txn_ii_rltns_tbl(i).object_id, fnd_api.g_miss_num)
604: = fnd_api.g_miss_num)
605: THEN
606: csi_t_gen_utility_pvt.add('Calling get_cz_inst_or_tld_id for OBJECT');
607:
608: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
609: p_config_inst_hdr_id => px_txn_ii_rltns_tbl(i).obj_config_inst_hdr_id,
610: p_config_inst_rev_num => px_txn_ii_rltns_tbl(i).obj_config_inst_rev_num,

Line 637: csi_t_gen_utility_pvt.add('tld/instance id for OBJECT' || l_obj_instance_id || l_obj_tld_id);

633: AND l_obj_tld_id IS NULL
634: THEN
635: RAISE fnd_api.g_exc_error ;
636: END IF ;
637: csi_t_gen_utility_pvt.add('tld/instance id for OBJECT' || l_obj_instance_id || l_obj_tld_id);
638: END IF ; --object is null
639: END LOOP ; --px_txn_ii_rltns_tbl loop
640: END IF ; ---px_txn_ii_rltns_tbl.count > 0
641: -- Added for CZ Integration (End)

Line 676: csi_t_gen_utility_pvt.dump_txn_tables(

672: */
673:
674: debug( 'create_txn pvt Dumping all the processing tables...');
675:
676: csi_t_gen_utility_pvt.dump_txn_tables(
677: p_ids_or_index_based => 'I',
678: p_line_detail_tbl => px_txn_line_detail_tbl,
679: p_party_detail_tbl => px_txn_party_detail_tbl,
680: p_pty_acct_tbl => px_txn_pty_acct_detail_tbl,

Line 696: csi_t_gen_utility_pvt.add('Validating relations integrity.');

692:
693: -- Added M-M changes The check rltns integrity has now been moved here .
694: /* this routine checks the ii relationships data integrity*/
695:
696: csi_t_gen_utility_pvt.add('Validating relations integrity.');
697:
698: csi_t_vldn_routines_pvt.check_rltns_integrity(
699: p_txn_line_detail_tbl => px_txn_line_detail_tbl,
700: p_txn_ii_rltns_tbl => px_txn_ii_rltns_tbl,

Line 734: csi_t_gen_utility_pvt.add('transaction_line_id : '||l_txn_line_id);

730: IF FND_API.To_Boolean( p_commit ) THEN
731: COMMIT WORK;
732: END IF;
733:
734: csi_t_gen_utility_pvt.add('transaction_line_id : '||l_txn_line_id);
735: csi_t_gen_utility_pvt.add('Transaction details created successfully.');
736: csi_t_gen_utility_pvt.set_debug_off;
737:
738: -- Standard call to get message count and if count is get message info.

Line 735: csi_t_gen_utility_pvt.add('Transaction details created successfully.');

731: COMMIT WORK;
732: END IF;
733:
734: csi_t_gen_utility_pvt.add('transaction_line_id : '||l_txn_line_id);
735: csi_t_gen_utility_pvt.add('Transaction details created successfully.');
736: csi_t_gen_utility_pvt.set_debug_off;
737:
738: -- Standard call to get message count and if count is get message info.
739: FND_MSG_PUB.Count_And_Get(

Line 736: csi_t_gen_utility_pvt.set_debug_off;

732: END IF;
733:
734: csi_t_gen_utility_pvt.add('transaction_line_id : '||l_txn_line_id);
735: csi_t_gen_utility_pvt.add('Transaction details created successfully.');
736: csi_t_gen_utility_pvt.set_debug_off;
737:
738: -- Standard call to get message count and if count is get message info.
739: FND_MSG_PUB.Count_And_Get(
740: p_count => x_msg_count,

Line 751: csi_t_gen_utility_pvt.set_debug_off;

747: x_return_status := FND_API.G_RET_STS_ERROR ;
748: FND_MSG_PUB.Count_And_Get (
749: p_count => x_msg_count,
750: p_data => x_msg_data);
751: csi_t_gen_utility_pvt.set_debug_off;
752:
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754:
755: ROLLBACK TO create_transaction_dtls;

Line 761: csi_t_gen_utility_pvt.set_debug_off;

757:
758: FND_MSG_PUB.Count_And_Get(
759: p_count => x_msg_count,
760: p_data => x_msg_data);
761: csi_t_gen_utility_pvt.set_debug_off;
762:
763: WHEN OTHERS THEN
764:
765: ROLLBACK TO create_transaction_dtls;

Line 780: csi_t_gen_utility_pvt.set_debug_off;

776:
777: FND_MSG_PUB.Count_And_Get(
778: p_count => x_msg_count,
779: p_data => x_msg_data);
780: csi_t_gen_utility_pvt.set_debug_off;
781:
782: END create_transaction_dtls;
783:
784: /*

Line 886: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

882: RAISE FND_API.G_Exc_Unexpected_Error;
883: END IF;
884:
885: -- debug messages
886: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
887:
888: csi_t_gen_utility_pvt.dump_api_info(
889: p_pkg_name => g_pkg_name,
890: p_api_name => l_api_name);

Line 888: csi_t_gen_utility_pvt.dump_api_info(

884:
885: -- debug messages
886: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
887:
888: csi_t_gen_utility_pvt.dump_api_info(
889: p_pkg_name => g_pkg_name,
890: p_api_name => l_api_name);
891:
892: csi_t_gen_utility_pvt.add(

Line 892: csi_t_gen_utility_pvt.add(

888: csi_t_gen_utility_pvt.dump_api_info(
889: p_pkg_name => g_pkg_name,
890: p_api_name => l_api_name);
891:
892: csi_t_gen_utility_pvt.add(
893: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
894:
895: IF l_debug_level > 1 then
896: csi_t_gen_utility_pvt.dump_txn_line_rec(

Line 896: csi_t_gen_utility_pvt.dump_txn_line_rec(

892: csi_t_gen_utility_pvt.add(
893: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
894:
895: IF l_debug_level > 1 then
896: csi_t_gen_utility_pvt.dump_txn_line_rec(
897: p_txn_line_rec => p_txn_line_rec);
898: END IF;
899:
900: -- Main API code

Line 1102: csi_t_gen_utility_pvt.dump_line_detail_rec(

1098:
1099: ELSE
1100: l_u_tld_tbl(l_u_tld_ind) := px_txn_line_detail_tbl(i);
1101:
1102: csi_t_gen_utility_pvt.dump_line_detail_rec(
1103: p_line_detail_rec => l_u_tld_tbl(l_u_tld_ind));
1104:
1105: -- re-index the child pl/sql tables
1106: -- Transaction Party details table

Line 1111: csi_t_gen_utility_pvt.dump_party_detail_rec(px_txn_party_detail_tbl(pu_ind));

1107: IF px_txn_party_detail_tbl.count > 0 THEN
1108: FOR pu_ind IN px_txn_party_detail_tbl.FIRST .. px_txn_party_detail_tbl.LAST
1109: LOOP
1110: Debug('Upd Txn line detail, pu_ind: '|| pu_ind);
1111: csi_t_gen_utility_pvt.dump_party_detail_rec(px_txn_party_detail_tbl(pu_ind));
1112: IF nvl(px_txn_party_detail_tbl(pu_ind).txn_party_detail_id,fnd_api.g_miss_num)
1113: = fnd_api.g_miss_num -- New Party creation
1114: THEN
1115: Debug('Party ID: '|| px_txn_party_detail_tbl(pu_ind).party_source_id||'-'||pu_ind);

Line 1221: csi_t_gen_utility_pvt.dump_pty_acct_rec(px_txn_pty_acct_detail_tbl(pau_ind));

1217: IF nvl(px_txn_pty_acct_detail_tbl(pau_ind).txn_account_detail_id,fnd_api.g_miss_num)
1218: = fnd_api.g_miss_num THEN -- New account creation
1219:
1220: Debug('Upd Txn line detail Update Pty Crt Acct, pau_ind: '|| pau_ind);
1221: csi_t_gen_utility_pvt.dump_pty_acct_rec(px_txn_pty_acct_detail_tbl(pau_ind));
1222: IF px_txn_pty_acct_detail_tbl(pau_ind).txn_party_detail_id
1223: = px_txn_party_detail_tbl(pu_ind).txn_party_detail_id THEN
1224: IF l_u_pty_acct_tbl.count > 0 THEN
1225: l_exists := 'N';

Line 1397: csi_t_gen_utility_pvt.dump_txn_tables(

1393: END IF;
1394:
1395: IF l_u_tld_tbl.count > 0 THEN
1396:
1397: csi_t_gen_utility_pvt.dump_txn_tables(
1398: p_ids_or_index_based => 'I',
1399: p_line_detail_tbl => l_u_tld_tbl,
1400: p_party_detail_tbl => l_u_pty_tbl,
1401: p_pty_acct_tbl => l_u_pty_acct_tbl,

Line 1581: csi_t_gen_utility_pvt.add('Transaction details updated successfully.');

1577: IF FND_API.To_Boolean( p_commit ) THEN
1578: COMMIT WORK;
1579: END IF;
1580:
1581: csi_t_gen_utility_pvt.add('Transaction details updated successfully.');
1582: csi_t_gen_utility_pvt.set_debug_off;
1583:
1584: -- Standard call to get message count and if count is get message info.
1585: FND_MSG_PUB.Count_And_Get(

Line 1582: csi_t_gen_utility_pvt.set_debug_off;

1578: COMMIT WORK;
1579: END IF;
1580:
1581: csi_t_gen_utility_pvt.add('Transaction details updated successfully.');
1582: csi_t_gen_utility_pvt.set_debug_off;
1583:
1584: -- Standard call to get message count and if count is get message info.
1585: FND_MSG_PUB.Count_And_Get(
1586: p_count => x_msg_count,

Line 1597: csi_t_gen_utility_pvt.set_debug_off;

1593: x_return_status := FND_API.G_RET_STS_ERROR ;
1594: FND_MSG_PUB.Count_And_Get (
1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: csi_t_gen_utility_pvt.set_debug_off;
1598:
1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1600:
1601: ROLLBACK TO update_transaction_dtls;

Line 1607: csi_t_gen_utility_pvt.set_debug_off;

1603:
1604: FND_MSG_PUB.Count_And_Get(
1605: p_count => x_msg_count,
1606: p_data => x_msg_data);
1607: csi_t_gen_utility_pvt.set_debug_off;
1608:
1609: WHEN OTHERS THEN
1610:
1611: ROLLBACK TO update_transaction_dtls;

Line 1626: csi_t_gen_utility_pvt.set_debug_off;

1622:
1623: FND_MSG_PUB.Count_And_Get(
1624: p_count => x_msg_count,
1625: p_data => x_msg_data);
1626: csi_t_gen_utility_pvt.set_debug_off;
1627:
1628: END update_transaction_dtls;
1629:
1630: PROCEDURE delete_transaction_dtls(

Line 1759: csi_t_gen_utility_pvt.dump_api_info(

1755:
1756: END IF;
1757: -- debug messages
1758:
1759: csi_t_gen_utility_pvt.dump_api_info(
1760: p_pkg_name => g_pkg_name,
1761: p_api_name => l_api_name);
1762:
1763: csi_t_gen_utility_pvt.add(

Line 1763: csi_t_gen_utility_pvt.add(

1759: csi_t_gen_utility_pvt.dump_api_info(
1760: p_pkg_name => g_pkg_name,
1761: p_api_name => l_api_name);
1762:
1763: csi_t_gen_utility_pvt.add(
1764: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
1765:
1766: csi_t_gen_utility_pvt.add(' p_transaction_line_id: '||
1767: to_char(p_transaction_line_id));

Line 1766: csi_t_gen_utility_pvt.add(' p_transaction_line_id: '||

1762:
1763: csi_t_gen_utility_pvt.add(
1764: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
1765:
1766: csi_t_gen_utility_pvt.add(' p_transaction_line_id: '||
1767: to_char(p_transaction_line_id));
1768:
1769: csi_t_gen_utility_pvt.add(' p_txn_line_detail_id: '||
1770: to_char(p_txn_line_detail_id));

Line 1769: csi_t_gen_utility_pvt.add(' p_txn_line_detail_id: '||

1765:
1766: csi_t_gen_utility_pvt.add(' p_transaction_line_id: '||
1767: to_char(p_transaction_line_id));
1768:
1769: csi_t_gen_utility_pvt.add(' p_txn_line_detail_id: '||
1770: to_char(p_txn_line_detail_id));
1771:
1772: -- Main API code
1773: csi_t_vldn_routines_pvt.check_reqd_param(

Line 2083: csi_t_gen_utility_pvt.add('Transaction Details Deleted Successfully

2079: IF FND_API.To_Boolean( p_commit ) THEN
2080: COMMIT WORK;
2081: END IF;
2082:
2083: csi_t_gen_utility_pvt.add('Transaction Details Deleted Successfully
2084: for Transaction Line ID:'||to_char(p_transaction_line_id)||
2085: ' Txn line detail ID:'||to_char(p_txn_line_detail_id));
2086:
2087: -- Standard call to get message count and if count is get message info.

Line 2260: --csi_t_gen_utility_pvt.add(l_select_stmt);

2256: ' object_version_number '||
2257: 'from csi_t_txn_systems '||
2258: 'where transaction_system_id in '||p_txn_system_id_list;
2259:
2260: --csi_t_gen_utility_pvt.add(l_select_stmt);
2261:
2262: l_sys_cur_id := dbms_sql.open_cursor;
2263:
2264: dbms_sql.parse(l_sys_cur_id, l_select_stmt , dbms_sql.native);

Line 2349: csi_t_gen_utility_pvt.add(sqlerrm);

2345:
2346: EXCEPTION
2347: WHEN others THEN
2348:
2349: csi_t_gen_utility_pvt.add(sqlerrm);
2350:
2351: IF dbms_sql.is_open(l_sys_cur_id) THEN
2352: dbms_sql.close_cursor(l_sys_cur_id);
2353: END IF;

Line 2465: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

2461:
2462: END IF;
2463:
2464: -- debug messages
2465: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2466:
2467: csi_t_gen_utility_pvt.dump_api_info(
2468: p_pkg_name => g_pkg_name,
2469: p_api_name => l_api_name);

Line 2467: csi_t_gen_utility_pvt.dump_api_info(

2463:
2464: -- debug messages
2465: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2466:
2467: csi_t_gen_utility_pvt.dump_api_info(
2468: p_pkg_name => g_pkg_name,
2469: p_api_name => l_api_name);
2470:
2471: csi_t_gen_utility_pvt.add(

Line 2471: csi_t_gen_utility_pvt.add(

2467: csi_t_gen_utility_pvt.dump_api_info(
2468: p_pkg_name => g_pkg_name,
2469: p_api_name => l_api_name);
2470:
2471: csi_t_gen_utility_pvt.add(
2472: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
2473:
2474: IF l_debug_level > 1 THEN
2475:

Line 2476: csi_t_gen_utility_pvt.dump_txn_line_query_rec(

2472: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
2473:
2474: IF l_debug_level > 1 THEN
2475:
2476: csi_t_gen_utility_pvt.dump_txn_line_query_rec(
2477: p_txn_line_query_rec => p_txn_line_query_rec);
2478:
2479: csi_t_gen_utility_pvt.dump_txn_line_detail_query_rec(
2480: p_txn_line_detail_query_rec => p_txn_line_detail_query_rec);

Line 2479: csi_t_gen_utility_pvt.dump_txn_line_detail_query_rec(

2475:
2476: csi_t_gen_utility_pvt.dump_txn_line_query_rec(
2477: p_txn_line_query_rec => p_txn_line_query_rec);
2478:
2479: csi_t_gen_utility_pvt.dump_txn_line_detail_query_rec(
2480: p_txn_line_detail_query_rec => p_txn_line_detail_query_rec);
2481:
2482: END IF;
2483:

Line 2498: csi_t_gen_utility_pvt.add('l_txn_line_dtl_tbl.COUNT :'||l_txn_line_dtl_tbl.COUNT);

2494: -- by the transaction line details return by the csi_t_txn_line_dtls_pvt.get_txn_line_dtls API
2495: IF l_txn_line_dtl_tbl.COUNT > 0
2496: THEN
2497:
2498: csi_t_gen_utility_pvt.add('l_txn_line_dtl_tbl.COUNT :'||l_txn_line_dtl_tbl.COUNT);
2499:
2500: FOR i IN l_txn_line_dtl_tbl.FIRST .. l_txn_line_dtl_tbl.LAST
2501: LOOP
2502:

Line 2521: csi_t_gen_utility_pvt.add('Line Dtl ID'||i||': '||l_txn_line_dtl_tbl(i).txn_line_detail_id);

2517:
2518: -- End swap values for location_id and Install_location_id
2519: End comment for Bug 3419098 */
2520:
2521: csi_t_gen_utility_pvt.add('Line Dtl ID'||i||': '||l_txn_line_dtl_tbl(i).txn_line_detail_id);
2522: FOR txn_ii_rel_rec IN txn_ii_rel_cur(l_txn_line_dtl_tbl(i).txn_line_detail_id)
2523: LOOP
2524: l_relation_exists := FALSE ;
2525: IF x_txn_ii_rltns_tbl.COUNT > 0

Line 2579: csi_t_gen_utility_pvt.add('Transaction Relationship ID'||l_index||': '||x_txn_ii_rltns_tbl(l_index).txn_relationship_id);

2575: x_txn_ii_rltns_tbl(l_index).obj_config_inst_item_id := txn_ii_rel_rec.obj_config_inst_item_id ;
2576: x_txn_ii_rltns_tbl(l_index).target_commitment_date := txn_ii_rel_rec.target_commitment_date ;
2577: x_txn_ii_rltns_tbl(l_index).transfer_components_flag := txn_ii_rel_rec.transfer_components_flag ;
2578:
2579: csi_t_gen_utility_pvt.add('Transaction Relationship ID'||l_index||': '||x_txn_ii_rltns_tbl(l_index).txn_relationship_id);
2580:
2581: END IF ; --l_retaionhip_exists
2582: END LOOP ; --txn_ii_rel_rec IN txn_ii_rel_cur
2583: END LOOP ; --l_txn_line_dtl_tbl.FIRST .. l_txn_line_dtl_tbl.LAST

Line 2587: csi_t_gen_utility_pvt.add('csi_t_txn_line_dtls_pvt.get_txn_line_dtls failed');

2583: END LOOP ; --l_txn_line_dtl_tbl.FIRST .. l_txn_line_dtl_tbl.LAST
2584: END IF ; ---l_txn_line_dtl_tbl.COUNT>0
2585:
2586: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2587: csi_t_gen_utility_pvt.add('csi_t_txn_line_dtls_pvt.get_txn_line_dtls failed');
2588: RAISE fnd_api.g_exc_error;
2589: END IF;
2590:
2591: x_txn_line_detail_tbl := l_txn_line_dtl_tbl;

Line 2621: csi_t_gen_utility_pvt.add('Party Dtl IDs: '||l_party_dtl_id_list);

2617: p_txn_party_detial_tbl => l_txn_party_dtl_tbl,
2618: x_party_dtl_id_list => l_party_dtl_id_list,
2619: x_return_status => l_return_status);
2620:
2621: csi_t_gen_utility_pvt.add('Party Dtl IDs: '||l_party_dtl_id_list);
2622: */
2623:
2624: For tdp in l_txn_party_dtl_tbl.FIRST .. l_txn_party_dtl_tbl.LAST
2625: LOOP

Line 2628: csi_t_gen_utility_pvt.add('Party Dtl ID'||tdp||': '||l_txn_party_dtl_tbl(tdp).txn_party_detail_id);

2624: For tdp in l_txn_party_dtl_tbl.FIRST .. l_txn_party_dtl_tbl.LAST
2625: LOOP
2626: -- Displaying the TD Party Detail's resultset... Replacement for the Commented code below . Bug 2543266
2627:
2628: csi_t_gen_utility_pvt.add('Party Dtl ID'||tdp||': '||l_txn_party_dtl_tbl(tdp).txn_party_detail_id);
2629:
2630: END LOOP;
2631:
2632: IF p_get_pty_accts_flag = fnd_api.g_true THEN

Line 2737: csi_t_gen_utility_pvt.add('Txn System IDs List: '||l_txn_system_id_list);

2733: x_return_status => l_return_status);
2734:
2735: IF l_txn_system_id_list is not null then
2736:
2737: csi_t_gen_utility_pvt.add('Txn System IDs List: '||l_txn_system_id_list);
2738:
2739: get_txn_systems(
2740: p_txn_system_id_list => l_txn_system_id_list,
2741: x_txn_systems_tbl => l_txn_systems_tbl,

Line 2761: csi_t_gen_utility_pvt.add('Transaction System ID'||tds||': '||l_txn_systems_tbl(tds).transaction_system_id);

2757: For tds in l_txn_systems_tbl.FIRST .. l_txn_systems_tbl.LAST
2758: LOOP
2759: -- Displaying the TD Systems's resultset... Replacement for the Commented code below . Bug 2543266
2760:
2761: csi_t_gen_utility_pvt.add('Transaction System ID'||tds||': '||l_txn_systems_tbl(tds).transaction_system_id);
2762:
2763: END LOOP;
2764: END IF;
2765:

Line 2773: csi_t_gen_utility_pvt.add('Get Transaction Details Successful');

2769: IF FND_API.To_Boolean( p_commit ) THEN
2770: COMMIT WORK;
2771: END IF;
2772:
2773: csi_t_gen_utility_pvt.add('Get Transaction Details Successful');
2774:
2775: -- Standard call to get message count and if count is get message info.
2776: FND_MSG_PUB.Count_And_Get(
2777: p_count => x_msg_count,

Line 2924: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

2920:
2921: END IF;
2922:
2923: -- debug messages
2924: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2925:
2926: csi_t_gen_utility_pvt.dump_api_info(
2927: p_pkg_name => g_pkg_name,
2928: p_api_name => l_api_name);

Line 2926: csi_t_gen_utility_pvt.dump_api_info(

2922:
2923: -- debug messages
2924: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2925:
2926: csi_t_gen_utility_pvt.dump_api_info(
2927: p_pkg_name => g_pkg_name,
2928: p_api_name => l_api_name);
2929:
2930: csi_t_gen_utility_pvt.add(

Line 2930: csi_t_gen_utility_pvt.add(

2926: csi_t_gen_utility_pvt.dump_api_info(
2927: p_pkg_name => g_pkg_name,
2928: p_api_name => l_api_name);
2929:
2930: csi_t_gen_utility_pvt.add(
2931: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
2932:
2933: csi_t_gen_utility_pvt.add('p_upd_txn_line_rec');
2934:

Line 2933: csi_t_gen_utility_pvt.add('p_upd_txn_line_rec');

2929:
2930: csi_t_gen_utility_pvt.add(
2931: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
2932:
2933: csi_t_gen_utility_pvt.add('p_upd_txn_line_rec');
2934:
2935: IF l_debug_level > 1 THEN
2936:
2937: csi_t_gen_utility_pvt.dump_txn_line_rec(

Line 2937: csi_t_gen_utility_pvt.dump_txn_line_rec(

2933: csi_t_gen_utility_pvt.add('p_upd_txn_line_rec');
2934:
2935: IF l_debug_level > 1 THEN
2936:
2937: csi_t_gen_utility_pvt.dump_txn_line_rec(
2938: p_txn_line_rec => p_upd_txn_line_rec);
2939:
2940: END IF;
2941:

Line 3084: csi_t_gen_utility_pvt.dump_api_info(

3080: END IF;
3081:
3082: ELSE
3083:
3084: csi_t_gen_utility_pvt.dump_api_info(
3085: p_api_name => 'insert_row',
3086: p_pkg_name => 'csi_t_transaction_lines_pkg');
3087:
3088: csi_t_transaction_lines_pkg.insert_row(

Line 3256: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

3252: RAISE FND_API.G_Exc_Unexpected_Error;
3253:
3254: END IF;
3255: --debug messages
3256: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
3257:
3258: csi_t_gen_utility_pvt.dump_api_info(
3259: p_api_name => l_api_name,
3260: p_pkg_name => g_pkg_name);

Line 3258: csi_t_gen_utility_pvt.dump_api_info(

3254: END IF;
3255: --debug messages
3256: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
3257:
3258: csi_t_gen_utility_pvt.dump_api_info(
3259: p_api_name => l_api_name,
3260: p_pkg_name => g_pkg_name);
3261:
3262: csi_t_gen_utility_pvt.add(

Line 3262: csi_t_gen_utility_pvt.add(

3258: csi_t_gen_utility_pvt.dump_api_info(
3259: p_api_name => l_api_name,
3260: p_pkg_name => g_pkg_name);
3261:
3262: csi_t_gen_utility_pvt.add(
3263: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
3264:
3265: IF l_debug_level > 1 THEN
3266:

Line 3267: csi_t_gen_utility_pvt.add('Source transaction line record :');

3263: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
3264:
3265: IF l_debug_level > 1 THEN
3266:
3267: csi_t_gen_utility_pvt.add('Source transaction line record :');
3268:
3269: csi_t_gen_utility_pvt.dump_txn_line_rec(
3270: p_txn_line_rec => p_src_txn_line_rec);
3271:

Line 3269: csi_t_gen_utility_pvt.dump_txn_line_rec(

3265: IF l_debug_level > 1 THEN
3266:
3267: csi_t_gen_utility_pvt.add('Source transaction line record :');
3268:
3269: csi_t_gen_utility_pvt.dump_txn_line_rec(
3270: p_txn_line_rec => p_src_txn_line_rec);
3271:
3272: csi_t_gen_utility_pvt.add('Destination transaction line record :');
3273:

Line 3272: csi_t_gen_utility_pvt.add('Destination transaction line record :');

3268:
3269: csi_t_gen_utility_pvt.dump_txn_line_rec(
3270: p_txn_line_rec => p_src_txn_line_rec);
3271:
3272: csi_t_gen_utility_pvt.add('Destination transaction line record :');
3273:
3274: csi_t_gen_utility_pvt.dump_txn_line_rec(
3275: p_txn_line_rec => px_new_txn_line_rec);
3276:

Line 3274: csi_t_gen_utility_pvt.dump_txn_line_rec(

3270: p_txn_line_rec => p_src_txn_line_rec);
3271:
3272: csi_t_gen_utility_pvt.add('Destination transaction line record :');
3273:
3274: csi_t_gen_utility_pvt.dump_txn_line_rec(
3275: p_txn_line_rec => px_new_txn_line_rec);
3276:
3277: END IF;
3278:

Line 3322: csi_t_gen_utility_pvt.add('Getting the source transaction details for copy failed.');

3318: x_msg_count => l_msg_count,
3319: x_msg_data => l_msg_data);
3320:
3321: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3322: csi_t_gen_utility_pvt.add('Getting the source transaction details for copy failed.');
3323: raise fnd_api.g_exc_error;
3324: END IF;
3325: csi_t_gen_utility_pvt.add('II rltns count before copying : '||l_ii_rltns_tbl.count);
3326:

Line 3325: csi_t_gen_utility_pvt.add('II rltns count before copying : '||l_ii_rltns_tbl.count);

3321: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3322: csi_t_gen_utility_pvt.add('Getting the source transaction details for copy failed.');
3323: raise fnd_api.g_exc_error;
3324: END IF;
3325: csi_t_gen_utility_pvt.add('II rltns count before copying : '||l_ii_rltns_tbl.count);
3326:
3327: csi_t_gen_utility_pvt.add(l_txn_systems_tbl.count);
3328:
3329: IF l_txn_systems_tbl.count > 0 THEN

Line 3327: csi_t_gen_utility_pvt.add(l_txn_systems_tbl.count);

3323: raise fnd_api.g_exc_error;
3324: END IF;
3325: csi_t_gen_utility_pvt.add('II rltns count before copying : '||l_ii_rltns_tbl.count);
3326:
3327: csi_t_gen_utility_pvt.add(l_txn_systems_tbl.count);
3328:
3329: IF l_txn_systems_tbl.count > 0 THEN
3330: csi_t_gen_utility_pvt.dump_txn_systems_rec(l_txn_systems_tbl(1));
3331: END IF;

Line 3330: csi_t_gen_utility_pvt.dump_txn_systems_rec(l_txn_systems_tbl(1));

3326:
3327: csi_t_gen_utility_pvt.add(l_txn_systems_tbl.count);
3328:
3329: IF l_txn_systems_tbl.count > 0 THEN
3330: csi_t_gen_utility_pvt.dump_txn_systems_rec(l_txn_systems_tbl(1));
3331: END IF;
3332:
3333: --Kishor 05/15 set the source txn line detail id
3334: FOR i IN l_line_dtl_tbl.FIRST .. l_line_dtl_tbl.LAST

Line 3336: csi_t_gen_utility_pvt.add('Copying src txn line detail id');

3332:
3333: --Kishor 05/15 set the source txn line detail id
3334: FOR i IN l_line_dtl_tbl.FIRST .. l_line_dtl_tbl.LAST
3335: LOOP
3336: csi_t_gen_utility_pvt.add('Copying src txn line detail id');
3337: l_line_dtl_tbl(i).source_txn_line_detail_id := l_line_dtl_tbl(i).txn_line_detail_id ;
3338: csi_t_gen_utility_pvt.add('l_line_dtl_tbl(i).source_txn_line_detail_id :'|| l_line_dtl_tbl(i).source_txn_line_detail_id);
3339: END LOOP ;
3340:

Line 3338: csi_t_gen_utility_pvt.add('l_line_dtl_tbl(i).source_txn_line_detail_id :'|| l_line_dtl_tbl(i).source_txn_line_detail_id);

3334: FOR i IN l_line_dtl_tbl.FIRST .. l_line_dtl_tbl.LAST
3335: LOOP
3336: csi_t_gen_utility_pvt.add('Copying src txn line detail id');
3337: l_line_dtl_tbl(i).source_txn_line_detail_id := l_line_dtl_tbl(i).txn_line_detail_id ;
3338: csi_t_gen_utility_pvt.add('l_line_dtl_tbl(i).source_txn_line_detail_id :'|| l_line_dtl_tbl(i).source_txn_line_detail_id);
3339: END LOOP ;
3340:
3341: -- translate the ids in to index
3342: csi_t_utilities_pvt.convert_ids_to_index(

Line 3351: csi_t_gen_utility_pvt.add(l_txn_systems_tbl.count);

3347: px_org_assgn_tbl => l_org_assgn_tbl,
3348: px_ext_attrib_tbl => l_ext_attrib_tbl,
3349: px_txn_systems_tbl => l_txn_systems_tbl);
3350:
3351: csi_t_gen_utility_pvt.add(l_txn_systems_tbl.count);
3352: csi_t_gen_utility_pvt.add('II rltns count after converting ids to indexes: '||l_ii_rltns_tbl.count);
3353: csi_t_gen_utility_pvt.add('Line Dtl index :'|| l_line_dtl_tbl(1).txn_line_detail_id);
3354:
3355: IF l_txn_systems_tbl.count > 0 THEN

Line 3352: csi_t_gen_utility_pvt.add('II rltns count after converting ids to indexes: '||l_ii_rltns_tbl.count);

3348: px_ext_attrib_tbl => l_ext_attrib_tbl,
3349: px_txn_systems_tbl => l_txn_systems_tbl);
3350:
3351: csi_t_gen_utility_pvt.add(l_txn_systems_tbl.count);
3352: csi_t_gen_utility_pvt.add('II rltns count after converting ids to indexes: '||l_ii_rltns_tbl.count);
3353: csi_t_gen_utility_pvt.add('Line Dtl index :'|| l_line_dtl_tbl(1).txn_line_detail_id);
3354:
3355: IF l_txn_systems_tbl.count > 0 THEN
3356: csi_t_gen_utility_pvt.dump_txn_systems_rec(l_txn_systems_tbl(1));

Line 3353: csi_t_gen_utility_pvt.add('Line Dtl index :'|| l_line_dtl_tbl(1).txn_line_detail_id);

3349: px_txn_systems_tbl => l_txn_systems_tbl);
3350:
3351: csi_t_gen_utility_pvt.add(l_txn_systems_tbl.count);
3352: csi_t_gen_utility_pvt.add('II rltns count after converting ids to indexes: '||l_ii_rltns_tbl.count);
3353: csi_t_gen_utility_pvt.add('Line Dtl index :'|| l_line_dtl_tbl(1).txn_line_detail_id);
3354:
3355: IF l_txn_systems_tbl.count > 0 THEN
3356: csi_t_gen_utility_pvt.dump_txn_systems_rec(l_txn_systems_tbl(1));
3357: END IF;

Line 3356: csi_t_gen_utility_pvt.dump_txn_systems_rec(l_txn_systems_tbl(1));

3352: csi_t_gen_utility_pvt.add('II rltns count after converting ids to indexes: '||l_ii_rltns_tbl.count);
3353: csi_t_gen_utility_pvt.add('Line Dtl index :'|| l_line_dtl_tbl(1).txn_line_detail_id);
3354:
3355: IF l_txn_systems_tbl.count > 0 THEN
3356: csi_t_gen_utility_pvt.dump_txn_systems_rec(l_txn_systems_tbl(1));
3357: END IF;
3358:
3359: -- call the create transaction dtls api
3360: csi_t_txn_details_grp.create_transaction_dtls(

Line 3378: csi_t_gen_utility_pvt.add('Creating the transaction details for copy failed.');

3374: x_msg_count => l_msg_count,
3375: x_msg_data => l_msg_data);
3376:
3377: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3378: csi_t_gen_utility_pvt.add('Creating the transaction details for copy failed.');
3379: raise fnd_api.g_exc_error;
3380: END IF;
3381:
3382: csi_t_gen_utility_pvt.add('Transaction details copied successfully.');

Line 3382: csi_t_gen_utility_pvt.add('Transaction details copied successfully.');

3378: csi_t_gen_utility_pvt.add('Creating the transaction details for copy failed.');
3379: raise fnd_api.g_exc_error;
3380: END IF;
3381:
3382: csi_t_gen_utility_pvt.add('Transaction details copied successfully.');
3383: csi_t_gen_utility_pvt.add('II rltns count after copying : '||l_ii_rltns_tbl.count);
3384:
3385: -- Standard check of p_commit.
3386: IF FND_API.To_Boolean( p_commit ) THEN

Line 3383: csi_t_gen_utility_pvt.add('II rltns count after copying : '||l_ii_rltns_tbl.count);

3379: raise fnd_api.g_exc_error;
3380: END IF;
3381:
3382: csi_t_gen_utility_pvt.add('Transaction details copied successfully.');
3383: csi_t_gen_utility_pvt.add('II rltns count after copying : '||l_ii_rltns_tbl.count);
3384:
3385: -- Standard check of p_commit.
3386: IF FND_API.To_Boolean( p_commit ) THEN
3387: COMMIT WORK;

Line 3501: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

3497:
3498: END IF;
3499:
3500: --debug messages
3501: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
3502:
3503: csi_t_gen_utility_pvt.dump_api_info(
3504: p_api_name => l_api_name,
3505: p_pkg_name => g_pkg_name);

Line 3503: csi_t_gen_utility_pvt.dump_api_info(

3499:
3500: --debug messages
3501: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
3502:
3503: csi_t_gen_utility_pvt.dump_api_info(
3504: p_api_name => l_api_name,
3505: p_pkg_name => g_pkg_name);
3506:
3507: csi_t_gen_utility_pvt.add(

Line 3507: csi_t_gen_utility_pvt.add(

3503: csi_t_gen_utility_pvt.dump_api_info(
3504: p_api_name => l_api_name,
3505: p_pkg_name => g_pkg_name);
3506:
3507: csi_t_gen_utility_pvt.add(
3508: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
3509:
3510: IF nvl(px_split_txn_line_rec.source_transaction_id,fnd_api.g_miss_num) = fnd_api.g_miss_num OR
3511: nvl(px_split_txn_line_rec.source_transaction_type_id,fnd_api.g_miss_num) = fnd_api.g_miss_num OR

Line 3522: csi_t_gen_utility_pvt.add('Source transaction line record :');

3518: END IF;
3519:
3520: IF l_debug_level > 1 THEN
3521:
3522: csi_t_gen_utility_pvt.add('Source transaction line record :');
3523:
3524: csi_t_gen_utility_pvt.dump_txn_line_rec(
3525: p_txn_line_rec => p_src_txn_line_rec);
3526:

Line 3524: csi_t_gen_utility_pvt.dump_txn_line_rec(

3520: IF l_debug_level > 1 THEN
3521:
3522: csi_t_gen_utility_pvt.add('Source transaction line record :');
3523:
3524: csi_t_gen_utility_pvt.dump_txn_line_rec(
3525: p_txn_line_rec => p_src_txn_line_rec);
3526:
3527: csi_t_gen_utility_pvt.add('Destination transaction line record :');
3528:

Line 3527: csi_t_gen_utility_pvt.add('Destination transaction line record :');

3523:
3524: csi_t_gen_utility_pvt.dump_txn_line_rec(
3525: p_txn_line_rec => p_src_txn_line_rec);
3526:
3527: csi_t_gen_utility_pvt.add('Destination transaction line record :');
3528:
3529: csi_t_gen_utility_pvt.dump_txn_line_rec(
3530: p_txn_line_rec => px_split_txn_line_rec);
3531:

Line 3529: csi_t_gen_utility_pvt.dump_txn_line_rec(

3525: p_txn_line_rec => p_src_txn_line_rec);
3526:
3527: csi_t_gen_utility_pvt.add('Destination transaction line record :');
3528:
3529: csi_t_gen_utility_pvt.dump_txn_line_rec(
3530: p_txn_line_rec => px_split_txn_line_rec);
3531:
3532: END IF;
3533:

Line 3716: csi_t_gen_utility_pvt.dump_txn_tables

3712: IF l_line_dtl_tbl.count > 0 THEN
3713: l_ii_rltns_tbl.delete;
3714:
3715: IF l_debug_level > 1 THEN
3716: csi_t_gen_utility_pvt.dump_txn_tables
3717: (
3718: p_ids_or_index_based => 'I'
3719: ,p_line_detail_tbl => px_line_dtl_tbl
3720: ,p_party_detail_tbl => x_pty_dtl_tbl