APPS.POS_MERGE_SUPPLIER_PKG dependencies on POS_MERGE_SUPPLIER_PKG

Line 1: PACKAGE BODY POS_MERGE_SUPPLIER_PKG AS

1: PACKAGE BODY POS_MERGE_SUPPLIER_PKG AS
2: /* $Header: POSMRGSUPB.pls 120.1.12020000.3 2012/07/23 20:30:32 yaoli ship $ */
3:
4: TYPE bank_dtls_rec_type IS RECORD(
5: instrument_type iby_pmt_instr_uses_all.instrument_type%TYPE,

Line 36: 'Inside POS_MERGE_SUPPLIER_PKG.create_bus_attr ');

32: BEGIN
33: x_return_status := fnd_api.g_ret_sts_success;
34:
35: fnd_file.put_line(fnd_file.log,
36: 'Inside POS_MERGE_SUPPLIER_PKG.create_bus_attr ');
37: BEGIN
38: pos_supp_classification_pkg.add_bus_class_attr(p_party_id,
39: p_buss_class_rec.vendor_id,
40: p_buss_class_rec.lookup_code,

Line 82: 'Inside POS_MERGE_SUPPLIER_PKG.get_bus_attr_rec ' ||

78:
79: BEGIN
80: x_return_status := fnd_api.g_ret_sts_success;
81: fnd_file.put_line(fnd_file.log,
82: 'Inside POS_MERGE_SUPPLIER_PKG.get_bus_attr_rec ' ||
83: p_party_id);
84:
85: SELECT --classification_id,
86: --vendor_id,

Line 154: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge p_to_fk_id: ' ||

150: BEGIN
151: x_return_status := fnd_api.g_ret_sts_success;
152:
153: fnd_file.put_line(fnd_file.log,
154: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge p_to_fk_id: ' ||
155: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
156: ' p_from_id: ' || p_from_id);
157:
158: /* Set the status to MERGED */

Line 175: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge l_to_vendor_id: ' ||

171: FROM ap_suppliers
172: WHERE party_id = p_to_fk_id;
173:
174: fnd_file.put_line(fnd_file.log,
175: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge l_to_vendor_id: ' ||
176: l_to_vendor_id);
177:
178: DELETE FROM pos_supplier_mappings a
179: WHERE a.party_id = p_to_fk_id

Line 212: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge l_count: ' ||

208: /*AND attr_from.classification_id = p_from_fk_id
209: AND attr_to.classification_id = p_to_fk_id;*/
210:
211: fnd_file.put_line(fnd_file.log,
212: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge l_count: ' ||
213: l_count);
214:
215: IF (l_count = 0) THEN
216: BEGIN

Line 566: 'Inside POS_MERGE_SUPPLIER_PKG.prod_service_merge p_to_fk_id: ' ||

562: BEGIN
563: x_return_status := fnd_api.g_ret_sts_success;
564:
565: fnd_file.put_line(fnd_file.log,
566: 'Inside POS_MERGE_SUPPLIER_PKG.prod_service_merge p_to_fk_id: ' ||
567: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
568: ' p_from_id : ' || p_from_id);
569:
570: SELECT vendor_id

Line 681: 'Inside POS_MERGE_SUPPLIER_PKG.party_contact_merge p_to_fk_id: ' ||

677: BEGIN
678: x_return_status := fnd_api.g_ret_sts_success;
679:
680: fnd_file.put_line(fnd_file.log,
681: 'Inside POS_MERGE_SUPPLIER_PKG.party_contact_merge p_to_fk_id: ' ||
682: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
683: ' p_from_id : ' || p_from_id);
684:
685: l_party_id := p_to_fk_id;

Line 831: 'Inside POS_MERGE_SUPPLIER_PKG.bank_dtls_merge p_to_fk_id: ' ||

827: BEGIN
828: x_return_status := fnd_api.g_ret_sts_success;
829:
830: fnd_file.put_line(fnd_file.log,
831: 'Inside POS_MERGE_SUPPLIER_PKG.bank_dtls_merge p_to_fk_id: ' ||
832: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id);
833:
834: get_bank_dtls_rec(p_init_msg_list => 'T',
835: p_from_party => p_from_fk_id,

Line 3854: 'Inside POS_MERGE_SUPPLIER_PKG.supplier_uda_merge p_to_fk_id: ' ||

3850: RETURN;
3851: END IF;
3852:
3853: fnd_file.put_line(fnd_file.log,
3854: 'Inside POS_MERGE_SUPPLIER_PKG.supplier_uda_merge p_to_fk_id: ' ||
3855: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id);
3856:
3857: /* Update the status of all the records in the bath to
3858: PERFORM_UDA_MERGE*/

Line 4035: 'Inside POS_MERGE_SUPPLIER_PKG.supplier_site_uda_merge p_to_fk_id: ' ||

4031: BEGIN
4032: x_return_status := fnd_api.g_ret_sts_success;
4033:
4034: fnd_file.put_line(fnd_file.log,
4035: 'Inside POS_MERGE_SUPPLIER_PKG.supplier_site_uda_merge p_to_fk_id: ' ||
4036: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id ||
4037: ' p_from_id : ' || p_from_id);
4038:
4039: /* Update the status of all the records in the bath to

Line 4242: 'Inside POS_MERGE_SUPPLIER_PKG.party_site_uda_merge p_to_fk_id: ' ||

4238: RETURN;
4239: END IF;
4240:
4241: fnd_file.put_line(fnd_file.log,
4242: 'Inside POS_MERGE_SUPPLIER_PKG.party_site_uda_merge p_to_fk_id: ' ||
4243: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
4244: ' p_from_id: ' || p_from_id || ' p_batch_id: ' ||
4245: p_batch_id);
4246:

Line 4414: 'Inside POS_MERGE_SUPPLIER_PKG.enable_party_as_supplier p_to_fk_id: ' ||

4410: BEGIN
4411: x_return_status := fnd_api.g_ret_sts_success;
4412:
4413: fnd_file.put_line(fnd_file.log,
4414: 'Inside POS_MERGE_SUPPLIER_PKG.enable_party_as_supplier p_to_fk_id: ' ||
4415: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id);
4416:
4417: UPDATE ap_suppliers
4418: SET end_date_active = SYSDATE

Line 4479: END pos_merge_supplier_pkg;

4475: WHEN OTHERS THEN
4476: x_return_status := fnd_api.g_ret_sts_unexp_error;
4477: END enable_party_as_supplier;
4478:
4479: END pos_merge_supplier_pkg;