DBA Data[Home] [Help]

APPS.CSI_UTILITY_GRP dependencies on CSI_T_TXN_DETAILS_GRP

Line 1643: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Detail: '||r_migrated_recs.transaction_line_id);

1639: debug_con_log(' Order found and the Flow Status is: '||l_order_status);
1640:
1641: IF l_order_status in ('CLOSED','CANCELLED') THEN
1642:
1643: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Detail: '||r_migrated_recs.transaction_line_id);
1644:
1645: csi_t_txn_details_grp.delete_transaction_dtls (
1646: p_api_version => 1.0
1647: ,p_commit => fnd_api.g_false

Line 1645: csi_t_txn_details_grp.delete_transaction_dtls (

1641: IF l_order_status in ('CLOSED','CANCELLED') THEN
1642:
1643: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Detail: '||r_migrated_recs.transaction_line_id);
1644:
1645: csi_t_txn_details_grp.delete_transaction_dtls (
1646: p_api_version => 1.0
1647: ,p_commit => fnd_api.g_false
1648: ,p_init_msg_list => fnd_api.g_false
1649: ,p_validation_level => fnd_api.g_valid_level_full

Line 1656: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Details');

1652: ,x_return_status => l_return_status
1653: ,x_msg_count => l_msg_count
1654: ,x_msg_data => l_msg_data);
1655:
1656: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Details');
1657: debug_con_log(' Return Status is :'||l_return_status||' for Txn Line '||r_migrated_recs.transaction_line_id);
1658:
1659: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1660: debug_con_log(' l_msg_data: '||l_msg_data);

Line 1670: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Detail: '||r_migrated_recs.transaction_line_id);

1666: EXCEPTION
1667: WHEN no_data_found THEN
1668: -- No Order Data is found it must have been purged..Txn Details can be removed.
1669: debug_con_log(' No Order found so OM data must have been purged. Remove Txn Detail data');
1670: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Detail: '||r_migrated_recs.transaction_line_id);
1671:
1672: csi_t_txn_details_grp.delete_transaction_dtls (
1673: p_api_version => 1.0
1674: ,p_commit => fnd_api.g_false

Line 1672: csi_t_txn_details_grp.delete_transaction_dtls (

1668: -- No Order Data is found it must have been purged..Txn Details can be removed.
1669: debug_con_log(' No Order found so OM data must have been purged. Remove Txn Detail data');
1670: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Detail: '||r_migrated_recs.transaction_line_id);
1671:
1672: csi_t_txn_details_grp.delete_transaction_dtls (
1673: p_api_version => 1.0
1674: ,p_commit => fnd_api.g_false
1675: ,p_init_msg_list => fnd_api.g_false
1676: ,p_validation_level => fnd_api.g_valid_level_full

Line 1683: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Details');

1679: ,x_return_status => l_return_status
1680: ,x_msg_count => l_msg_count
1681: ,x_msg_data => l_msg_data);
1682:
1683: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Details');
1684: debug_con_log(' Return Status is :'||l_return_status||' for Txn Line '||r_migrated_recs.transaction_line_id);
1685:
1686: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1687: debug_con_log(' l_msg_data: '||l_msg_data);

Line 1722: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls');

1718: -- There are only source records so we can delete the Transaction Details for this
1719: -- Transaction Line
1720:
1721: debug_con_log(' There are no Non Source Lines so remove the Txn Detail: '||r_processed_recs.transaction_line_id);
1722: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls');
1723:
1724: csi_t_txn_details_grp.delete_transaction_dtls (
1725: p_api_version => 1.0
1726: ,p_commit => fnd_api.g_false

Line 1724: csi_t_txn_details_grp.delete_transaction_dtls (

1720:
1721: debug_con_log(' There are no Non Source Lines so remove the Txn Detail: '||r_processed_recs.transaction_line_id);
1722: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls');
1723:
1724: csi_t_txn_details_grp.delete_transaction_dtls (
1725: p_api_version => 1.0
1726: ,p_commit => fnd_api.g_false
1727: ,p_init_msg_list => fnd_api.g_false
1728: ,p_validation_level => fnd_api.g_valid_level_full

Line 1735: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls');

1731: ,x_return_status => l_return_status
1732: ,x_msg_count => l_msg_count
1733: ,x_msg_data => l_msg_data);
1734:
1735: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls');
1736: debug_con_log(' Return Status is :'||l_return_status||' for Txn Line '||r_processed_recs.transaction_line_id);
1737:
1738: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1739: debug_con_log(' l_msg_data: '||l_msg_data);