DBA Data[Home] [Help]

APPS.CSI_T_TXN_DETAILS_PVT dependencies on CSI_T_VLDN_ROUTINES_PVT

Line 234: csi_t_vldn_routines_pvt.check_reqd_param(

230: END IF;--Added for bug5194812
231: END IF ;
232:
233: -- check for the required parameters
234: csi_t_vldn_routines_pvt.check_reqd_param(
235: p_value => px_txn_line_rec.source_transaction_table,
236: p_param_name => 'px_txn_line_rec.source_transaction_table',
237: p_api_name => l_api_name);
238:

Line 240: csi_t_vldn_routines_pvt.check_reqd_param(

236: p_param_name => 'px_txn_line_rec.source_transaction_table',
237: p_api_name => l_api_name);
238:
239: IF px_txn_line_rec.source_transaction_type_id <> 401 THEN
240: csi_t_vldn_routines_pvt.check_reqd_param(
241: p_value => px_txn_line_rec.source_transaction_id,
242: p_param_name => 'px_txn_line_rec.source_transaction_id',
243: p_api_name => l_api_name);
244:

Line 247: csi_t_vldn_routines_pvt.check_reqd_param(

243: p_api_name => l_api_name);
244:
245: END IF;
246:
247: csi_t_vldn_routines_pvt.check_reqd_param(
248: p_value => px_txn_line_rec.source_transaction_type_id,
249: p_param_name => 'px_txn_line_rec.source_transaction_type_id',
250: p_api_name => l_api_name);
251:

Line 266: csi_t_vldn_routines_pvt.check_duplicate(

262: END IF;
263:
264: IF l_skip_tl_create <> 'Y' AND
265: px_txn_line_rec.source_transaction_type_id <> 401 THEN
266: csi_t_vldn_routines_pvt.check_duplicate(
267: p_txn_line_rec => px_txn_line_rec,
268: x_return_status => l_return_status);
269:
270: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 287: csi_t_vldn_routines_pvt.check_cz_session_keys(

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,
291: x_return_status => l_return_status);

Line 296: csi_t_vldn_routines_pvt.check_exists_in_cz(

292: IF l_return_status <> fnd_api.g_ret_sts_success THEN
293: RAISE FND_API.g_exc_error;
294: END IF;
295:
296: csi_t_vldn_routines_pvt.check_exists_in_cz(
297: p_txn_line_dtl_tbl => px_txn_line_detail_tbl,
298: x_return_status => l_return_status);
299:
300: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 332: csi_t_vldn_routines_pvt.check_source_integrity(

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,
335: p_txn_line_dtl_tbl => px_txn_line_detail_tbl,
336: x_return_status => l_return_status);

Line 343: csi_t_vldn_routines_pvt.check_party_integrity(

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,
346: p_party_dtl_tbl => px_txn_party_detail_tbl,
347: x_return_status => l_return_status);

Line 490: csi_t_vldn_routines_pvt.get_txn_system_id(

486:
487: IF nvl(l_line_dtl_rec.txn_systems_index, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
488:
489: -- convert txn_systems_index in to txn_system_id
490: csi_t_vldn_routines_pvt.get_txn_system_id(
491: p_txn_systems_index => l_line_dtl_rec.txn_systems_index,
492: p_txn_systems_tbl => px_txn_systems_tbl,
493: x_txn_system_id => l_line_dtl_rec.transaction_system_id,
494: x_return_status => l_return_status);

Line 569: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

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 ,
573: x_instance_id => l_sub_instance_id ,

Line 608: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

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,
611: p_config_inst_item_id => px_txn_ii_rltns_tbl(i).obj_config_inst_item_id ,
612: x_instance_id => l_obj_instance_id ,

Line 685: csi_t_vldn_routines_pvt.convert_rltns_index_to_ids(

681: p_ii_rltns_tbl => px_txn_ii_rltns_tbl,
682: p_org_assgn_tbl => px_txn_org_assgn_tbl,
683: p_ea_vals_tbl => px_txn_ext_attrib_vals_tbl);
684:
685: csi_t_vldn_routines_pvt.convert_rltns_index_to_ids(
686: p_line_dtl_tbl => px_txn_line_detail_tbl,
687: px_ii_rltns_tbl => px_txn_ii_rltns_tbl,
688: x_return_status => l_return_status);
689: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 698: csi_t_vldn_routines_pvt.check_rltns_integrity(

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,
701: x_return_status => l_return_status);
702:

Line 1773: csi_t_vldn_routines_pvt.check_reqd_param(

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(
1774: p_value => p_transaction_line_id,
1775: p_param_name => 'p_transaction_line_id',
1776: p_api_name => l_api_name);
1777:

Line 1779: csi_t_vldn_routines_pvt.validate_transaction_line_id(

1775: p_param_name => 'p_transaction_line_id',
1776: p_api_name => l_api_name);
1777:
1778: -- validate transaction line id
1779: csi_t_vldn_routines_pvt.validate_transaction_line_id(
1780: p_transaction_line_id => p_transaction_line_id,
1781: x_transaction_line_rec => l_txn_line_rec,-- Added for Mass update R12
1782: x_return_status => l_return_status);
1783:

Line 1806: csi_t_vldn_routines_pvt.check_ib_creation(

1802: IF p_validation_level <> 999 THEN
1803: IF l_txn_line_rec.source_transaction_type_id <> 3 THEN -- Added for Mass update R12
1804: -- excluding the Mass Update Transactions
1805:
1806: csi_t_vldn_routines_pvt.check_ib_creation(
1807: p_transaction_line_id => p_transaction_line_id,
1808: x_return_status => l_return_status);
1809:
1810: IF l_return_status = fnd_api.g_true THEN

Line 1900: csi_t_vldn_routines_pvt.check_ib_creation(

1896: l_transaction_line_id := txn_hdr_rec.transaction_line_id;
1897:
1898: IF l_transaction_line_id <> p_transaction_line_id THEN
1899:
1900: csi_t_vldn_routines_pvt.check_ib_creation(
1901: p_transaction_line_id => l_transaction_line_id,
1902: x_return_status => l_return_status);
1903:
1904: IF l_return_status = fnd_api.g_true THEN

Line 1926: csi_t_vldn_routines_pvt.check_ib_creation(

1922:
1923:
1924: IF l_transaction_line_id <> p_transaction_line_id THEN
1925:
1926: csi_t_vldn_routines_pvt.check_ib_creation(
1927: p_transaction_line_id => l_transaction_line_id,
1928: x_return_status => l_return_status);
1929:
1930: IF l_return_status = fnd_api.g_true THEN