APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_T_TXN_DETAILS_GRP

Line 330: csi_t_txn_details_grp.create_transaction_dtls(

326: debug(' l_c_t_oa_tbl.count :'||l_c_t_oa_tbl.count);
327: debug(' l_c_t_ea_tbl.count :'||l_c_t_ea_tbl.count);
328: debug(' l_c_t_sys_tbl.count :'||l_c_t_sys_tbl.count);
329:
330: csi_t_txn_details_grp.create_transaction_dtls(
331: p_api_version => 1.0,
332: p_commit => fnd_api.g_false,
333: p_init_msg_list => fnd_api.g_true,
334: p_validation_level => fnd_api.g_valid_level_none,

Line 714: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

710: l_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
711: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
712:
713: -- Check if txn details exist
714: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
715: p_txn_line_rec => l_txn_line_rec );
716:
717: IF l_trx_detail_exist THEN
718:

Line 770: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

766:
767: debug('Concurrency check - Is installation details copied already?' );
768:
769: -- Check if txn details exist
770: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
771: p_txn_line_rec => l_copy_txn_line_rec );
772:
773: IF l_copy_trx_detail_exist THEN
774:

Line 884: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

880:
881: debug('check if installation details are cascaded from the model ?');
882:
883: -- Check if txn details exist
884: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
885: p_txn_line_rec => l_txn_line_rec );
886:
887: IF l_trx_detail_exist THEN
888:

Line 929: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

925:
926: debug('concurrency check - is installation details copied already?' );
927:
928: -- Check if txn details exist
929: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
930: p_txn_line_rec => l_copy_txn_line_rec );
931:
932: IF l_copy_trx_detail_exist THEN
933: debug(' Yes it is.');

Line 1040: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

1036: l_copy_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
1037:
1038: debug('Check if copied installation details exist for the split order line?' );
1039:
1040: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
1041: p_txn_line_rec => l_copy_txn_line_rec );
1042:
1043: IF NOT(l_copy_trx_detail_exist) THEN
1044:

Line 1166: csi_t_txn_details_grp.get_transaction_details (

1162: /* read all the matched txn line dtls and all the child tables for final processing */
1163:
1164: debug('Installation details for the final process - Update Install Base.' );
1165:
1166: csi_t_txn_details_grp.get_transaction_details (
1167: p_api_version => 1.0,
1168: p_commit => fnd_api.g_false,
1169: p_init_msg_list => fnd_api.g_true,
1170: p_validation_level => fnd_api.g_valid_level_full,

Line 1199: g_api_name := 'csi_t_txn_details_grp.get_transaction_details';

1195: x_msg_count => l_msg_count,
1196: x_msg_data => l_msg_data);
1197:
1198: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1199: g_api_name := 'csi_t_txn_details_grp.get_transaction_details';
1200: raise fnd_api.g_exc_error;
1201: END IF;
1202:
1203: debug(' txn_line_detail_tbl.count :'|| l_txn_line_detail_tbl.count );

Line 2523: csi_t_txn_details_grp.get_transaction_details(

2519: l_txn_line_dtl_query_rec.processing_status := 'UNPROCESSED';
2520:
2521: debug('Getting installation details for matching with material transaction info.' );
2522:
2523: csi_t_txn_details_grp.get_transaction_details(
2524: p_api_version => 1.0,
2525: p_commit => fnd_api.g_false,
2526: p_init_msg_list => fnd_api.g_true,
2527: p_validation_level => fnd_api.g_valid_level_full,

Line 2669: csi_t_txn_details_grp.get_transaction_details(

2665: l_txn_line_dtl_query_rec.source_transaction_flag := 'Y';
2666:
2667: debug('Getting only matched txn line dtls ' );
2668:
2669: csi_t_txn_details_grp.get_transaction_details(
2670: p_api_version => 1.0
2671: ,p_commit => fnd_api.g_false
2672: ,p_init_msg_list => fnd_api.g_true
2673: ,p_validation_level => fnd_api.g_valid_level_full

Line 3696: csi_t_txn_details_grp.update_txn_line_dtls(

3692: IF l_upd_txn_line_dtl_tbl.count > 0 then
3693:
3694: /* update the txn dtls with the processing status */
3695:
3696: csi_t_txn_details_grp.update_txn_line_dtls(
3697: p_api_version => 1.0,
3698: p_commit => fnd_api.g_false,
3699: p_init_msg_list => fnd_api.g_true,
3700: p_validation_level => fnd_api.g_valid_level_none,

Line 3713: g_api_name := 'csi_t_txn_details_grp.update_txn_line_dtls';

3709: x_msg_count => x_msg_count,
3710: x_msg_data => x_msg_data);
3711:
3712: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3713: g_api_name := 'csi_t_txn_details_grp.update_txn_line_dtls';
3714: raise fnd_api.g_exc_error;
3715: END IF;
3716:
3717: debug('update_txn_line_dtls completed successfully');

Line 7134: csi_t_txn_details_grp.update_txn_line_dtls(

7130: IF p_txn_line_detail_tbl.count > 0 THEN
7131:
7132: debug('Updating the Transaction Details to reflect the processing status.' );
7133:
7134: csi_t_txn_details_grp.update_txn_line_dtls(
7135: p_api_version => 1.0,
7136: p_commit => fnd_api.g_false,
7137: p_init_msg_list => fnd_api.g_true,
7138: p_validation_level => fnd_api.g_valid_level_full,

Line 7151: g_api_name := 'csi_t_txn_details_grp.update_txn_line_dtls';

7147: x_msg_count => x_msg_count,
7148: x_msg_data => x_msg_data);
7149:
7150: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
7151: g_api_name := 'csi_t_txn_details_grp.update_txn_line_dtls';
7152: raise fnd_api.g_exc_error;
7153: END IF;
7154:
7155: END IF;

Line 7968: csi_t_txn_details_grp.create_transaction_dtls(

7964:
7965: debug(' transaction_line_id : '||l_trx_line_id);
7966: EXCEPTION
7967: WHEN no_data_found THEN
7968: csi_t_txn_details_grp.create_transaction_dtls(
7969: p_api_version => 1.0,
7970: p_commit => fnd_api.g_false,
7971: p_init_msg_list => fnd_api.g_true,
7972: p_validation_level => fnd_api.g_valid_level_none,