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 771: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

767: l_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
768: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
769:
770: -- Check if txn details exist
771: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
772: p_txn_line_rec => l_txn_line_rec );
773:
774: IF l_trx_detail_exist THEN
775:

Line 827: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

823:
824: debug('Concurrency check - Is installation details copied already?' );
825:
826: -- Check if txn details exist
827: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
828: p_txn_line_rec => l_copy_txn_line_rec );
829:
830: IF l_copy_trx_detail_exist THEN
831:

Line 941: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

937:
938: debug('check if installation details are cascaded from the model ?');
939:
940: -- Check if txn details exist
941: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
942: p_txn_line_rec => l_txn_line_rec );
943:
944: IF l_trx_detail_exist THEN
945:

Line 986: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

982:
983: debug('concurrency check - is installation details copied already?' );
984:
985: -- Check if txn details exist
986: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
987: p_txn_line_rec => l_copy_txn_line_rec );
988:
989: IF l_copy_trx_detail_exist THEN
990: debug(' Yes it is.');

Line 1097: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(

1093: l_copy_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
1094:
1095: debug('Check if copied installation details exist for the split order line?' );
1096:
1097: l_copy_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
1098: p_txn_line_rec => l_copy_txn_line_rec );
1099:
1100: IF NOT(l_copy_trx_detail_exist) THEN
1101:

Line 1223: csi_t_txn_details_grp.get_transaction_details (

1219: /* read all the matched txn line dtls and all the child tables for final processing */
1220:
1221: debug('Installation details for the final process - Update Install Base.' );
1222:
1223: csi_t_txn_details_grp.get_transaction_details (
1224: p_api_version => 1.0,
1225: p_commit => fnd_api.g_false,
1226: p_init_msg_list => fnd_api.g_true,
1227: p_validation_level => fnd_api.g_valid_level_full,

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

1252: x_msg_count => l_msg_count,
1253: x_msg_data => l_msg_data);
1254:
1255: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1256: g_api_name := 'csi_t_txn_details_grp.get_transaction_details';
1257: raise fnd_api.g_exc_error;
1258: END IF;
1259:
1260: debug(' txn_line_detail_tbl.count :'|| l_txn_line_detail_tbl.count );

Line 2582: csi_t_txn_details_grp.get_transaction_details(

2578: l_txn_line_dtl_query_rec.processing_status := 'UNPROCESSED';
2579:
2580: debug('Getting installation details for matching with material transaction info.' );
2581:
2582: csi_t_txn_details_grp.get_transaction_details(
2583: p_api_version => 1.0,
2584: p_commit => fnd_api.g_false,
2585: p_init_msg_list => fnd_api.g_true,
2586: p_validation_level => fnd_api.g_valid_level_full,

Line 2728: csi_t_txn_details_grp.get_transaction_details(

2724: l_txn_line_dtl_query_rec.source_transaction_flag := 'Y';
2725:
2726: debug('Getting only matched txn line dtls ' );
2727:
2728: csi_t_txn_details_grp.get_transaction_details(
2729: p_api_version => 1.0
2730: ,p_commit => fnd_api.g_false
2731: ,p_init_msg_list => fnd_api.g_true
2732: ,p_validation_level => fnd_api.g_valid_level_full

Line 3755: csi_t_txn_details_grp.update_txn_line_dtls(

3751: IF l_upd_txn_line_dtl_tbl.count > 0 then
3752:
3753: /* update the txn dtls with the processing status */
3754:
3755: csi_t_txn_details_grp.update_txn_line_dtls(
3756: p_api_version => 1.0,
3757: p_commit => fnd_api.g_false,
3758: p_init_msg_list => fnd_api.g_true,
3759: p_validation_level => fnd_api.g_valid_level_none,

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

3768: x_msg_count => x_msg_count,
3769: x_msg_data => x_msg_data);
3770:
3771: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3772: g_api_name := 'csi_t_txn_details_grp.update_txn_line_dtls';
3773: raise fnd_api.g_exc_error;
3774: END IF;
3775:
3776: debug('update_txn_line_dtls completed successfully');

Line 7453: csi_t_txn_details_grp.update_txn_line_dtls(

7449: IF p_txn_line_detail_tbl.count > 0 THEN
7450:
7451: debug('Updating the Transaction Details to reflect the processing status.' );
7452:
7453: csi_t_txn_details_grp.update_txn_line_dtls(
7454: p_api_version => 1.0,
7455: p_commit => fnd_api.g_false,
7456: p_init_msg_list => fnd_api.g_true,
7457: p_validation_level => fnd_api.g_valid_level_full,

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

7466: x_msg_count => x_msg_count,
7467: x_msg_data => x_msg_data);
7468:
7469: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
7470: g_api_name := 'csi_t_txn_details_grp.update_txn_line_dtls';
7471: raise fnd_api.g_exc_error;
7472: END IF;
7473:
7474: END IF;

Line 8287: csi_t_txn_details_grp.create_transaction_dtls(

8283:
8284: debug(' transaction_line_id : '||l_trx_line_id);
8285: EXCEPTION
8286: WHEN no_data_found THEN
8287: csi_t_txn_details_grp.create_transaction_dtls(
8288: p_api_version => 1.0,
8289: p_commit => fnd_api.g_false,
8290: p_init_msg_list => fnd_api.g_true,
8291: p_validation_level => fnd_api.g_valid_level_none,