DBA Data[Home] [Help]

APPS.CSI_RMA_RECEIPT_PUB dependencies on CSI_T_GEN_UTILITY_PVT

Line 9: csi_t_gen_utility_pvt.add(p_message);

5: PROCEDURE debug(
6: p_message IN varchar2)
7: IS
8: BEGIN
9: csi_t_gen_utility_pvt.add(p_message);
10: END debug;
11:
12: /* local api log procedure */
13: PROCEDURE api_log(

Line 17: csi_t_gen_utility_pvt.dump_api_info(

13: PROCEDURE api_log(
14: p_api_name IN varchar2)
15: IS
16: BEGIN
17: csi_t_gen_utility_pvt.dump_api_info(
18: p_api_name => p_api_name,
19: p_pkg_name => 'csi_rma_receipt_pub');
20: END api_log;
21:

Line 639: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

635: x_return_status := fnd_api.g_ret_sts_success;
636:
637: api_log('get_mtl_txn_recs');
638:
639: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
640:
641: get_src_order_info(
642: p_mtl_txn_id => p_mtl_txn_id,
643: x_src_order_rec => l_src_order_rec,

Line 900: csi_t_gen_utility_pvt.dump_instance_query_rec(

896: x_party_query_rec := l_party_query_rec;
897:
898: debug('Instance query criteria for the customer product.');
899:
900: csi_t_gen_utility_pvt.dump_instance_query_rec(
901: p_instance_query_rec => x_instance_query_rec);
902:
903: debug('party query criteria :');
904: debug(' party_id :'||l_party_query_rec.party_id);

Line 956: csi_t_gen_utility_pvt.dump_api_info(

952:
953: debug(' Bring expired instances Flag :'||l_qry_exp_inst);
954: */ -- shegde removing this check since referencing an instance should not be a pre-requisite.
955:
956: csi_t_gen_utility_pvt.dump_api_info(
957: p_api_name => 'get_item_instances',
958: p_pkg_name => 'csi_item_instance_pub');
959:
960: csi_item_instance_pub.get_item_instances(

Line 2691: csi_t_gen_utility_pvt.build_file_name(

2687: fnd_msg_pub.initialize;
2688:
2689: x_return_status := fnd_api.g_ret_sts_success;
2690:
2691: csi_t_gen_utility_pvt.build_file_name(
2692: p_file_segment1 => 'csirmarc',
2693: p_file_segment2 => p_mtl_txn_id);
2694:
2695: api_log('rma_receipt');

Line 3005: csi_t_gen_utility_pvt.dump_api_info(

3001:
3002: l_txn_rec.split_reason_code := 'PARTIAL_RETURN';
3003: l_txn_rec.transaction_action_code := 'MULT_ITEM_SRL_CONTROL'; -- temporarily setting a unique identifier
3004:
3005: csi_t_gen_utility_pvt.dump_api_info(
3006: p_pkg_name => 'csi_item_instance_pvt',
3007: p_api_name => 'split_item_instance');
3008:
3009: csi_t_gen_utility_pvt.dump_csi_instance_rec(

Line 3009: csi_t_gen_utility_pvt.dump_csi_instance_rec(

3005: csi_t_gen_utility_pvt.dump_api_info(
3006: p_pkg_name => 'csi_item_instance_pvt',
3007: p_api_name => 'split_item_instance');
3008:
3009: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3010: p_csi_instance_rec => l_split_nsrc_inst_rec);
3011:
3012: csi_item_instance_pvt.split_item_instance (
3013: p_api_version => 1.0,

Line 3082: csi_t_gen_utility_pvt.dump_api_info(

3078: l_u_instance_rec.last_txn_line_detail_id := l_upd_inst_tbl(n).last_txn_line_detail_id;
3079: l_u_instance_rec.object_version_number := l_upd_inst_tbl(n).object_version_number;
3080: l_txn_rec.transaction_action_code := 'MULT_ITEM_SRL_CONTROL'; -- temporarily setting a unique identifier
3081:
3082: csi_t_gen_utility_pvt.dump_api_info(
3083: p_pkg_name => 'csi_item_instance_pub',
3084: p_api_name => 'update_item_instance');
3085:
3086: csi_t_gen_utility_pvt.dump_csi_instance_rec(

Line 3086: csi_t_gen_utility_pvt.dump_csi_instance_rec(

3082: csi_t_gen_utility_pvt.dump_api_info(
3083: p_pkg_name => 'csi_item_instance_pub',
3084: p_api_name => 'update_item_instance');
3085:
3086: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3087: p_csi_instance_rec => l_u_instance_rec);
3088:
3089: csi_item_instance_pub.update_item_instance(
3090: p_api_version => 1.0,

Line 3345: csi_t_gen_utility_pvt.dump_api_info(

3341: l_upd_pty_accts_tbl(1).relationship_type_code := 'OWNER';
3342: l_upd_pty_accts_tbl(1).call_contracts := fnd_api.g_false;
3343:
3344: /* Commented the call as part of fix for Bug 2733128. Added call to Update_Item_Instance instead
3345: csi_t_gen_utility_pvt.dump_api_info(
3346: p_pkg_name => 'csi_party_relationships_pub',
3347: p_api_name => 'update_inst_party_relationship');
3348:
3349: csi_party_relationships_pub.update_inst_party_relationship (

Line 3362: csi_t_gen_utility_pvt.dump_api_info(

3358: x_msg_count => l_msg_count,
3359: x_msg_data => l_msg_data);
3360: */
3361:
3362: csi_t_gen_utility_pvt.dump_api_info(
3363: p_pkg_name => 'csi_item_instance_pub',
3364: p_api_name => 'update_item_instance');
3365:
3366: csi_item_instance_pub.update_item_instance(

Line 3472: csi_t_gen_utility_pvt.dump_csi_instance_rec(

3468: l_crt_pty_accts_tbl(1).party_account_id := l_src_order_rec.customer_account_id;
3469: l_crt_pty_accts_tbl(1).relationship_type_code := 'OWNER';
3470: l_crt_pty_accts_tbl(1).call_contracts := fnd_api.g_false;
3471:
3472: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3473: p_csi_instance_rec => l_crt_instance_rec);
3474:
3475: csi_t_gen_utility_pvt.dump_api_info(
3476: p_pkg_name => 'csi_item_instance_pub',

Line 3475: csi_t_gen_utility_pvt.dump_api_info(

3471:
3472: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3473: p_csi_instance_rec => l_crt_instance_rec);
3474:
3475: csi_t_gen_utility_pvt.dump_api_info(
3476: p_pkg_name => 'csi_item_instance_pub',
3477: p_api_name => 'create_item_instance');
3478:
3479: csi_item_instance_pub.create_item_instance(

Line 3576: csi_t_gen_utility_pvt.dump_api_info(

3572: l_split_src_inst_rec.active_start_date := l_instances_tbl(i_ind).mtl_txn_creation_date;
3573:
3574: l_txn_rec.split_reason_code := 'PARTIAL_RETURN';
3575:
3576: csi_t_gen_utility_pvt.dump_api_info(
3577: p_pkg_name => 'csi_item_instance_pvt',
3578: p_api_name => 'split_item_instance');
3579:
3580: csi_item_instance_pvt.split_item_instance (

Line 3618: csi_t_gen_utility_pvt.dump_api_info(

3614: l_exp_instance_rec.call_contracts := fnd_api.g_false;
3615: l_exp_instance_rec.active_end_date := sysdate;
3616: l_exp_instance_rec.last_oe_rma_line_id := l_txn_rec.source_line_ref_id;
3617:
3618: csi_t_gen_utility_pvt.dump_api_info(
3619: p_pkg_name => 'csi_item_instance_pub',
3620: p_api_name => 'update_item_instance');
3621:
3622: csi_t_gen_utility_pvt.dump_csi_instance_rec(

Line 3622: csi_t_gen_utility_pvt.dump_csi_instance_rec(

3618: csi_t_gen_utility_pvt.dump_api_info(
3619: p_pkg_name => 'csi_item_instance_pub',
3620: p_api_name => 'update_item_instance');
3621:
3622: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3623: p_csi_instance_rec => l_exp_instance_rec);
3624:
3625: csi_item_instance_pub.update_item_instance(
3626: p_api_version => 1.0,

Line 3807: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;

3803:
3804: rollback to rma_receipt;
3805:
3806: x_return_status := fnd_api.g_ret_sts_error;
3807: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
3808: debug('Error:(E) '||l_error_rec.error_text);
3809: px_trx_error_rec := l_error_rec;
3810:
3811: WHEN others THEN

Line 3819: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;

3815: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3816: fnd_message.set_token('API_NAME',l_api_name);
3817: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
3818: fnd_msg_pub.add;
3819: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
3820: debug('Error:(O) '||l_error_rec.error_text);
3821: px_trx_error_rec := l_error_rec;
3822:
3823: END rma_receipt;

Line 3924: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;

3920:
3921: EXCEPTION
3922:
3923: WHEN fnd_api.g_exc_error THEN
3924: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
3925: x_return_status := fnd_api.g_ret_sts_error;
3926:
3927: WHEN others THEN
3928: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');