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 638: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

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

Line 895: csi_t_gen_utility_pvt.dump_instance_query_rec(

891: x_party_query_rec := l_party_query_rec;
892:
893: debug('Instance query criteria for the customer product.');
894:
895: csi_t_gen_utility_pvt.dump_instance_query_rec(
896: p_instance_query_rec => x_instance_query_rec);
897:
898: debug('party query criteria :');
899: debug(' party_id :'||l_party_query_rec.party_id);

Line 951: csi_t_gen_utility_pvt.dump_api_info(

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

Line 2652: csi_t_gen_utility_pvt.build_file_name(

2648: fnd_msg_pub.initialize;
2649:
2650: x_return_status := fnd_api.g_ret_sts_success;
2651:
2652: csi_t_gen_utility_pvt.build_file_name(
2653: p_file_segment1 => 'csirmarc',
2654: p_file_segment2 => p_mtl_txn_id);
2655:
2656: api_log('rma_receipt');

Line 2966: csi_t_gen_utility_pvt.dump_api_info(

2962:
2963: l_txn_rec.split_reason_code := 'PARTIAL_RETURN';
2964: l_txn_rec.transaction_action_code := 'MULT_ITEM_SRL_CONTROL'; -- temporarily setting a unique identifier
2965:
2966: csi_t_gen_utility_pvt.dump_api_info(
2967: p_pkg_name => 'csi_item_instance_pvt',
2968: p_api_name => 'split_item_instance');
2969:
2970: csi_t_gen_utility_pvt.dump_csi_instance_rec(

Line 2970: csi_t_gen_utility_pvt.dump_csi_instance_rec(

2966: csi_t_gen_utility_pvt.dump_api_info(
2967: p_pkg_name => 'csi_item_instance_pvt',
2968: p_api_name => 'split_item_instance');
2969:
2970: csi_t_gen_utility_pvt.dump_csi_instance_rec(
2971: p_csi_instance_rec => l_split_nsrc_inst_rec);
2972:
2973: csi_item_instance_pvt.split_item_instance (
2974: p_api_version => 1.0,

Line 3043: csi_t_gen_utility_pvt.dump_api_info(

3039: l_u_instance_rec.last_txn_line_detail_id := l_upd_inst_tbl(n).last_txn_line_detail_id;
3040: l_u_instance_rec.object_version_number := l_upd_inst_tbl(n).object_version_number;
3041: l_txn_rec.transaction_action_code := 'MULT_ITEM_SRL_CONTROL'; -- temporarily setting a unique identifier
3042:
3043: csi_t_gen_utility_pvt.dump_api_info(
3044: p_pkg_name => 'csi_item_instance_pub',
3045: p_api_name => 'update_item_instance');
3046:
3047: csi_t_gen_utility_pvt.dump_csi_instance_rec(

Line 3047: csi_t_gen_utility_pvt.dump_csi_instance_rec(

3043: csi_t_gen_utility_pvt.dump_api_info(
3044: p_pkg_name => 'csi_item_instance_pub',
3045: p_api_name => 'update_item_instance');
3046:
3047: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3048: p_csi_instance_rec => l_u_instance_rec);
3049:
3050: csi_item_instance_pub.update_item_instance(
3051: p_api_version => 1.0,

Line 3306: csi_t_gen_utility_pvt.dump_api_info(

3302: l_upd_pty_accts_tbl(1).relationship_type_code := 'OWNER';
3303: l_upd_pty_accts_tbl(1).call_contracts := fnd_api.g_false;
3304:
3305: /* Commented the call as part of fix for Bug 2733128. Added call to Update_Item_Instance instead
3306: csi_t_gen_utility_pvt.dump_api_info(
3307: p_pkg_name => 'csi_party_relationships_pub',
3308: p_api_name => 'update_inst_party_relationship');
3309:
3310: csi_party_relationships_pub.update_inst_party_relationship (

Line 3323: csi_t_gen_utility_pvt.dump_api_info(

3319: x_msg_count => l_msg_count,
3320: x_msg_data => l_msg_data);
3321: */
3322:
3323: csi_t_gen_utility_pvt.dump_api_info(
3324: p_pkg_name => 'csi_item_instance_pub',
3325: p_api_name => 'update_item_instance');
3326:
3327: csi_item_instance_pub.update_item_instance(

Line 3433: csi_t_gen_utility_pvt.dump_csi_instance_rec(

3429: l_crt_pty_accts_tbl(1).party_account_id := l_src_order_rec.customer_account_id;
3430: l_crt_pty_accts_tbl(1).relationship_type_code := 'OWNER';
3431: l_crt_pty_accts_tbl(1).call_contracts := fnd_api.g_false;
3432:
3433: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3434: p_csi_instance_rec => l_crt_instance_rec);
3435:
3436: csi_t_gen_utility_pvt.dump_api_info(
3437: p_pkg_name => 'csi_item_instance_pub',

Line 3436: csi_t_gen_utility_pvt.dump_api_info(

3432:
3433: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3434: p_csi_instance_rec => l_crt_instance_rec);
3435:
3436: csi_t_gen_utility_pvt.dump_api_info(
3437: p_pkg_name => 'csi_item_instance_pub',
3438: p_api_name => 'create_item_instance');
3439:
3440: csi_item_instance_pub.create_item_instance(

Line 3537: csi_t_gen_utility_pvt.dump_api_info(

3533: l_split_src_inst_rec.active_start_date := l_instances_tbl(i_ind).mtl_txn_creation_date;
3534:
3535: l_txn_rec.split_reason_code := 'PARTIAL_RETURN';
3536:
3537: csi_t_gen_utility_pvt.dump_api_info(
3538: p_pkg_name => 'csi_item_instance_pvt',
3539: p_api_name => 'split_item_instance');
3540:
3541: csi_item_instance_pvt.split_item_instance (

Line 3579: csi_t_gen_utility_pvt.dump_api_info(

3575: l_exp_instance_rec.call_contracts := fnd_api.g_false;
3576: l_exp_instance_rec.active_end_date := sysdate;
3577: l_exp_instance_rec.last_oe_rma_line_id := l_txn_rec.source_line_ref_id;
3578:
3579: csi_t_gen_utility_pvt.dump_api_info(
3580: p_pkg_name => 'csi_item_instance_pub',
3581: p_api_name => 'update_item_instance');
3582:
3583: csi_t_gen_utility_pvt.dump_csi_instance_rec(

Line 3583: csi_t_gen_utility_pvt.dump_csi_instance_rec(

3579: csi_t_gen_utility_pvt.dump_api_info(
3580: p_pkg_name => 'csi_item_instance_pub',
3581: p_api_name => 'update_item_instance');
3582:
3583: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3584: p_csi_instance_rec => l_exp_instance_rec);
3585:
3586: csi_item_instance_pub.update_item_instance(
3587: p_api_version => 1.0,

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

3764:
3765: rollback to rma_receipt;
3766:
3767: x_return_status := fnd_api.g_ret_sts_error;
3768: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
3769: debug('Error:(E) '||l_error_rec.error_text);
3770: px_trx_error_rec := l_error_rec;
3771:
3772: WHEN others THEN

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

3776: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3777: fnd_message.set_token('API_NAME',l_api_name);
3778: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
3779: fnd_msg_pub.add;
3780: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
3781: debug('Error:(O) '||l_error_rec.error_text);
3782: px_trx_error_rec := l_error_rec;
3783:
3784: END rma_receipt;

Line 3885: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;

3881:
3882: EXCEPTION
3883:
3884: WHEN fnd_api.g_exc_error THEN
3885: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
3886: x_return_status := fnd_api.g_ret_sts_error;
3887:
3888: WHEN others THEN
3889: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');