eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ACCT_MERGE_PKG dependencies on FND_API

Line 183: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

179: AND m.process_flag = 'N'
180: AND m.request_id = req_id
181: AND m.set_number = set_num;
182:
183: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
184: l_msg_count NUMBER;
185: l_msg_data VARCHAR2(2000);
186:
187: -- Variables for 'GET ITEM INSTANCE DETAILS' API call

Line 477: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num Then -- { 8

473: );
474: END IF; -- } 7
475:
476: -- build the transaction record, if this is the first time
477: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num Then -- { 8
478: --
479: -- Check if there is a transaction record created by any other csi routine
480: -- If so use that id otherwise initialize the txn_rec attributes
481: --

Line 559: p_commit => fnd_api.g_false,

555: write_to_cr_log( l_msg_string );
556:
557: csi_item_instance_pub.get_item_instance_details(
558: p_api_version => 1.0,
559: p_commit => fnd_api.g_false,
560: p_init_msg_list => fnd_api.g_true,
561: p_validation_level => fnd_api.g_valid_level_full,
562: p_instance_rec => l_g_instance_rec,
563: p_get_parties => fnd_api.g_true,

Line 560: p_init_msg_list => fnd_api.g_true,

556:
557: csi_item_instance_pub.get_item_instance_details(
558: p_api_version => 1.0,
559: p_commit => fnd_api.g_false,
560: p_init_msg_list => fnd_api.g_true,
561: p_validation_level => fnd_api.g_valid_level_full,
562: p_instance_rec => l_g_instance_rec,
563: p_get_parties => fnd_api.g_true,
564: p_party_header_tbl => l_g_ph_tbl,

Line 561: p_validation_level => fnd_api.g_valid_level_full,

557: csi_item_instance_pub.get_item_instance_details(
558: p_api_version => 1.0,
559: p_commit => fnd_api.g_false,
560: p_init_msg_list => fnd_api.g_true,
561: p_validation_level => fnd_api.g_valid_level_full,
562: p_instance_rec => l_g_instance_rec,
563: p_get_parties => fnd_api.g_true,
564: p_party_header_tbl => l_g_ph_tbl,
565: p_get_accounts => fnd_api.g_true,

Line 563: p_get_parties => fnd_api.g_true,

559: p_commit => fnd_api.g_false,
560: p_init_msg_list => fnd_api.g_true,
561: p_validation_level => fnd_api.g_valid_level_full,
562: p_instance_rec => l_g_instance_rec,
563: p_get_parties => fnd_api.g_true,
564: p_party_header_tbl => l_g_ph_tbl,
565: p_get_accounts => fnd_api.g_true,
566: p_account_header_tbl => l_g_pah_tbl,
567: p_get_org_assignments => fnd_api.g_false,

Line 565: p_get_accounts => fnd_api.g_true,

561: p_validation_level => fnd_api.g_valid_level_full,
562: p_instance_rec => l_g_instance_rec,
563: p_get_parties => fnd_api.g_true,
564: p_party_header_tbl => l_g_ph_tbl,
565: p_get_accounts => fnd_api.g_true,
566: p_account_header_tbl => l_g_pah_tbl,
567: p_get_org_assignments => fnd_api.g_false,
568: p_org_header_tbl => l_g_ouh_tbl,
569: p_get_pricing_attribs => fnd_api.g_false,

Line 567: p_get_org_assignments => fnd_api.g_false,

563: p_get_parties => fnd_api.g_true,
564: p_party_header_tbl => l_g_ph_tbl,
565: p_get_accounts => fnd_api.g_true,
566: p_account_header_tbl => l_g_pah_tbl,
567: p_get_org_assignments => fnd_api.g_false,
568: p_org_header_tbl => l_g_ouh_tbl,
569: p_get_pricing_attribs => fnd_api.g_false,
570: p_pricing_attrib_tbl => l_g_pa_tbl,
571: p_get_ext_attribs => fnd_api.g_false,

Line 569: p_get_pricing_attribs => fnd_api.g_false,

565: p_get_accounts => fnd_api.g_true,
566: p_account_header_tbl => l_g_pah_tbl,
567: p_get_org_assignments => fnd_api.g_false,
568: p_org_header_tbl => l_g_ouh_tbl,
569: p_get_pricing_attribs => fnd_api.g_false,
570: p_pricing_attrib_tbl => l_g_pa_tbl,
571: p_get_ext_attribs => fnd_api.g_false,
572: p_ext_attrib_tbl => l_g_eav_tbl,
573: p_ext_attrib_def_tbl => l_g_ea_tbl,

Line 571: p_get_ext_attribs => fnd_api.g_false,

567: p_get_org_assignments => fnd_api.g_false,
568: p_org_header_tbl => l_g_ouh_tbl,
569: p_get_pricing_attribs => fnd_api.g_false,
570: p_pricing_attrib_tbl => l_g_pa_tbl,
571: p_get_ext_attribs => fnd_api.g_false,
572: p_ext_attrib_tbl => l_g_eav_tbl,
573: p_ext_attrib_def_tbl => l_g_ea_tbl,
574: p_get_asset_assignments => fnd_api.g_false,
575: p_asset_header_tbl => l_g_iah_tbl,

Line 574: p_get_asset_assignments => fnd_api.g_false,

570: p_pricing_attrib_tbl => l_g_pa_tbl,
571: p_get_ext_attribs => fnd_api.g_false,
572: p_ext_attrib_tbl => l_g_eav_tbl,
573: p_ext_attrib_def_tbl => l_g_ea_tbl,
574: p_get_asset_assignments => fnd_api.g_false,
575: p_asset_header_tbl => l_g_iah_tbl,
576: p_time_stamp => l_g_time_stamp,
577: x_return_status => l_return_status,
578: x_msg_count => l_msg_count,

Line 587: fnd_msg_pub.get ( l_msg_ctr, FND_API.G_FALSE, l_msg_data, l_msg_dummy );

583:
584: IF ( l_return_status <> 'S' ) Then
585: write_to_cr_log( 'Msg Count : '||to_char(l_msg_count));
586: FOR l_msg_ctr in 1..l_msg_count LOOP
587: fnd_msg_pub.get ( l_msg_ctr, FND_API.G_FALSE, l_msg_data, l_msg_dummy );
588: write_to_cr_log( 'Msg : '|| to_char(l_msg_ctr) || ' ' || l_msg_data );
589: END LOOP;
590: END IF;
591:

Line 692: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;

688: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id;
689: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
690: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
691: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
692: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
693: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
694: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
695: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
696: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

Line 693: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;

689: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
690: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
691: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
692: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
693: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
694: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
695: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
696: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
697: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

Line 713: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;

709: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
710: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
711: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
712: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
713: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
714:
715: -- move the account record to update table
716: l_acct_idx := l_acct_idx + 1;
717: p_u_party_account_tbl(l_acct_idx).ip_account_id := l_g_pah_tbl(l_acct_rec_index).ip_account_id;

Line 740: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;

736: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(l_acct_rec_index).ship_to_address;
737: END IF;
738:
739: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(l_acct_rec_index).relationship_type_code;
740: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
741: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
742: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(l_acct_rec_index).context;
743: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(l_acct_rec_index).attribute1;
744: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(l_acct_rec_index).attribute2;

Line 741: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;

737: END IF;
738:
739: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(l_acct_rec_index).relationship_type_code;
740: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
741: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
742: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(l_acct_rec_index).context;
743: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(l_acct_rec_index).attribute1;
744: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(l_acct_rec_index).attribute2;
745: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(l_acct_rec_index).attribute3;

Line 759: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;

755: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(l_acct_rec_index).attribute13;
756: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(l_acct_rec_index).attribute14;
757: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(l_acct_rec_index).attribute15;
758: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(l_acct_rec_index).object_version_number;
759: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
760: ELSE -- } address_only { Otherwise
761: IF ( l_num_of_acct_records = 1 ) THEN -- { if one record for the party
762: -- IF ( l_acct_rec_index > 0 ) THEN -- if account index is known
763: IF ( l_acct_rec_index > 0 ) AND

Line 779: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;

775: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id; --Fix for Bug 4284460
776: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
777: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
778: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
779: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
780: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
781: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
782: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
783: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

Line 780: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;

776: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
777: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
778: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
779: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
780: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
781: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
782: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
783: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
784: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

Line 800: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;

796: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
797: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
798: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
799: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
800: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
801:
802: -- move the account record to update table
803: l_acct_idx := l_acct_idx + 1;
804: p_u_party_account_tbl(l_acct_idx).ip_account_id := l_g_pah_tbl(l_acct_rec_index).ip_account_id;

Line 827: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;

823: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(l_acct_rec_index).ship_to_address;
824: END IF;
825:
826: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(l_acct_rec_index).relationship_type_code;
827: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
828: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
829: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(l_acct_rec_index).context;
830: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(l_acct_rec_index).attribute1;
831: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(l_acct_rec_index).attribute2;

Line 828: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;

824: END IF;
825:
826: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(l_acct_rec_index).relationship_type_code;
827: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
828: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
829: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(l_acct_rec_index).context;
830: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(l_acct_rec_index).attribute1;
831: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(l_acct_rec_index).attribute2;
832: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(l_acct_rec_index).attribute3;

Line 846: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;

842: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(l_acct_rec_index).attribute13;
843: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(l_acct_rec_index).attribute14;
844: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(l_acct_rec_index).attribute15;
845: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(l_acct_rec_index).object_version_number;
846: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
847:
848: END IF; -- } if account index is known and account needs to be modified
849: ELSIF ( l_num_of_acct_records > 1 ) THEN -- } account records = 1 { account records for party > 1
850: IF l_owner_update = 'Y' THEN -- { l_owner_update is 'Y'

Line 873: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;

869: p_u_party_tbl(l_pty_idx).party_id := l_to_party_id;
870: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
871: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
872: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
873: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
874: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
875: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
876: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
877: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

Line 874: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;

870: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
871: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
872: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
873: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
874: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
875: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
876: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
877: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
878: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

Line 894: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;

890: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
891: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
892: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
893: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
894: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
895:
896: -- create new party record with l_g_ph_tbl party_id
897: l_pty_idx := l_pty_idx + 1;
898: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;

Line 898: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;

894: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
895:
896: -- create new party record with l_g_ph_tbl party_id
897: l_pty_idx := l_pty_idx + 1;
898: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;
899: p_u_party_tbl(l_pty_idx).instance_id := l_g_ph_tbl(J).instance_id;
900: p_u_party_tbl(l_pty_idx).party_source_table := l_g_ph_tbl(J).party_source_table;
901: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id;
902: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;

Line 905: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;

901: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id;
902: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;
903: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
904: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
905: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
906: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
907: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
908: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
909: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

Line 906: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;

902: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;
903: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
904: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
905: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
906: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
907: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
908: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
909: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
910: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

Line 926: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;

922: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
923: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
924: p_u_party_tbl(l_pty_idx).primary_flag := 'N';
925: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
926: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
927:
928: FOR K in 1..l_g_pah_tbl.count LOOP -- { K Loop
929: IF ( l_g_pah_tbl(K).instance_party_id = l_instance_party_id AND
930: l_g_pah_tbl(K).active_end_date IS NULL ) THEN -- { accounts for the same party

Line 942: p_u_party_account_tbl(l_acct_idx).instance_party_id := FND_API.G_MISS_NUM;

938: p_u_party_account_tbl(l_acct_idx).parent_tbl_index := l_pty_idx-1;
939: p_u_party_account_tbl(l_acct_idx).instance_party_id := l_g_pah_tbl(K).instance_party_id;
940: ELSE -- } if record needs update { if record needs no update
941: p_u_party_account_tbl(l_acct_idx).parent_tbl_index := l_pty_idx;
942: p_u_party_account_tbl(l_acct_idx).instance_party_id := FND_API.G_MISS_NUM;
943: END IF; -- } if the record needs no update
944:
945: IF l_g_pah_tbl(K).party_account_id = NUM_COL1_ORIG_LIST(I) THEN
946: p_u_party_account_tbl(l_acct_idx).party_account_id := NUM_COL1_NEW_LIST(I);

Line 964: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;

960: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(K).ship_to_address;
961: END IF;
962:
963: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
964: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
965: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
966: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
967: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
968: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;

Line 965: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;

961: END IF;
962:
963: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
964: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
965: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
966: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
967: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
968: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;
969: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(K).attribute3;

Line 983: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;

979: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(K).attribute13;
980: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(K).attribute14;
981: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(K).attribute15;
982: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(K).object_version_number;
983: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
984: END IF; -- } accounts for the same party
985: END LOOP; -- } K Loop
986:
987: ELSE -- } l_pty_with_diff_accts = 'Y' 1 { l_pty_with_diff_accts = 'N' 1

Line 998: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;

994: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id; --Fix for Bug 4284460
995: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
996: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
997: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
998: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
999: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1000: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1001: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1002: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

Line 999: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;

995: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
996: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
997: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
998: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
999: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1000: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1001: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1002: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
1003: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

Line 1019: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;

1015: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
1016: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
1017: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
1018: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
1019: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1020:
1021: FOR K in 1..l_g_pah_tbl.count LOOP -- { K Loop
1022: IF ( l_g_pah_tbl(K).instance_party_id = l_instance_party_id AND
1023: l_g_pah_tbl(K).active_end_date IS NULL AND

Line 1053: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;

1049: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(K).ship_to_address;
1050: END IF;
1051:
1052: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1053: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1054: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1055: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1056: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1057: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;

Line 1054: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;

1050: END IF;
1051:
1052: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1053: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1054: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1055: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1056: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1057: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;
1058: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(K).attribute3;

Line 1072: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;

1068: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(K).attribute13;
1069: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(K).attribute14;
1070: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(K).attribute15;
1071: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(K).object_version_number;
1072: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
1073: END IF; -- } accounts for the same party
1074: END LOOP; -- } K Loop
1075: END IF; -- } l_pty_with_diff_accts 1
1076: ELSE -- } l_owner_update = 'Y' { l_owner_update = 'N'

Line 1107: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;

1103: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id;
1104: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
1105: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1106: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1107: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1108: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1109: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1110: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1111: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

Line 1108: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;

1104: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
1105: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1106: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1107: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1108: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1109: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1110: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1111: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
1112: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

Line 1128: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;

1124: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
1125: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
1126: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
1127: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
1128: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1129:
1130: -- create new party record with l_to_party
1131: l_pty_idx := l_pty_idx + 1;
1132: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;

Line 1132: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;

1128: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1129:
1130: -- create new party record with l_to_party
1131: l_pty_idx := l_pty_idx + 1;
1132: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;
1133: p_u_party_tbl(l_pty_idx).instance_id := l_g_ph_tbl(J).instance_id;
1134: p_u_party_tbl(l_pty_idx).party_source_table := l_g_ph_tbl(J).party_source_table;
1135: p_u_party_tbl(l_pty_idx).party_id := l_to_party_id;
1136: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;

Line 1139: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;

1135: p_u_party_tbl(l_pty_idx).party_id := l_to_party_id;
1136: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;
1137: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1138: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1139: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1140: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1141: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1142: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1143: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

Line 1140: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;

1136: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;
1137: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1138: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1139: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1140: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1141: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1142: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1143: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
1144: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

Line 1160: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;

1156: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
1157: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
1158: p_u_party_tbl(l_pty_idx).primary_flag := 'N';
1159: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
1160: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1161:
1162: FOR K in 1..l_g_pah_tbl.count LOOP -- { K Loop
1163: IF ( l_g_pah_tbl(K).instance_party_id = l_instance_party_id AND
1164: l_g_pah_tbl(K).active_end_date IS NULL ) THEN -- { accounts for the same party

Line 1173: p_u_party_account_tbl(l_acct_idx).instance_party_id := FND_API.G_MISS_NUM;

1169: IF ( l_g_pah_tbl(K).party_account_id = NUM_COL1_ORIG_LIST(I) OR
1170: l_g_pah_tbl(K).bill_to_address = NUM_COL2_ORIG_LIST(I) OR
1171: l_g_pah_tbl(K).ship_to_address = NUM_COL3_ORIG_LIST(I) ) THEN -- { if the record needs update
1172: p_u_party_account_tbl(l_acct_idx).parent_tbl_index := l_pty_idx;
1173: p_u_party_account_tbl(l_acct_idx).instance_party_id := FND_API.G_MISS_NUM;
1174: ELSE -- } if record needs update { if record needs no update
1175: p_u_party_account_tbl(l_acct_idx).parent_tbl_index := l_pty_idx-1;
1176: p_u_party_account_tbl(l_acct_idx).instance_party_id := l_g_pah_tbl(K).instance_party_id;
1177: END IF; -- } if the record needs no update

Line 1198: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;

1194: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(K).ship_to_address;
1195: END IF;
1196:
1197: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1198: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1199: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1200: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1201: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1202: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;

Line 1199: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;

1195: END IF;
1196:
1197: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1198: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1199: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1200: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1201: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1202: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;
1203: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(K).attribute3;

Line 1217: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;

1213: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(K).attribute13;
1214: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(K).attribute14;
1215: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(K).attribute15;
1216: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(K).object_version_number;
1217: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
1218: END IF; -- } accounts for the same party
1219: END LOOP; -- } K Loop
1220:
1221: ELSE -- } l_pty_with_diff_accts = 'Y' { l_pty_with_diff_accts = 'N'

Line 1232: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;

1228: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id; --Fix for Bug 4284460
1229: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
1230: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1231: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1232: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1233: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1234: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1235: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1236: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

Line 1233: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;

1229: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
1230: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1231: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1232: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1233: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1234: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1235: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1236: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
1237: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

Line 1253: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;

1249: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
1250: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
1251: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
1252: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
1253: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1254:
1255: FOR K in 1..l_g_pah_tbl.count LOOP -- { K Loop
1256: IF ( l_g_pah_tbl(K).instance_party_id = l_instance_party_id AND
1257: l_g_pah_tbl(K).active_end_date IS NULL ) THEN -- { accounts for the same party

Line 1283: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;

1279: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(K).ship_to_address;
1280: END IF;
1281:
1282: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1283: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1284: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1285: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1286: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1287: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;

Line 1284: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;

1280: END IF;
1281:
1282: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1283: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1284: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1285: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1286: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1287: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;
1288: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(K).attribute3;

Line 1302: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;

1298: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(K).attribute13;
1299: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(K).attribute14;
1300: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(K).attribute15;
1301: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(K).object_version_number;
1302: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
1303: END IF; -- } accounts for the same party
1304: END LOOP; -- } K Loop
1305: END IF; -- } l_pty_with_diff_accts = 'N'
1306: END IF; -- } l_owner_update = 'N'

Line 1340: p_commit => fnd_api.g_false,

1336: -- Now update the instance with all new data
1337: error_str := '022';
1338: csi_item_instance_pub.update_item_instance(
1339: p_api_version => 1.0,
1340: p_commit => fnd_api.g_false,
1341: p_init_msg_list => fnd_api.g_true,
1342: p_validation_level => fnd_api.g_valid_level_full,
1343: p_instance_rec => p_u_instance_rec,
1344: p_ext_attrib_values_tbl => p_u_ext_attrib_values_tbl,

Line 1341: p_init_msg_list => fnd_api.g_true,

1337: error_str := '022';
1338: csi_item_instance_pub.update_item_instance(
1339: p_api_version => 1.0,
1340: p_commit => fnd_api.g_false,
1341: p_init_msg_list => fnd_api.g_true,
1342: p_validation_level => fnd_api.g_valid_level_full,
1343: p_instance_rec => p_u_instance_rec,
1344: p_ext_attrib_values_tbl => p_u_ext_attrib_values_tbl,
1345: p_party_tbl => p_u_party_tbl,

Line 1342: p_validation_level => fnd_api.g_valid_level_full,

1338: csi_item_instance_pub.update_item_instance(
1339: p_api_version => 1.0,
1340: p_commit => fnd_api.g_false,
1341: p_init_msg_list => fnd_api.g_true,
1342: p_validation_level => fnd_api.g_valid_level_full,
1343: p_instance_rec => p_u_instance_rec,
1344: p_ext_attrib_values_tbl => p_u_ext_attrib_values_tbl,
1345: p_party_tbl => p_u_party_tbl,
1346: p_account_tbl => p_u_party_account_tbl,

Line 1362: fnd_msg_pub.get ( l_msg_ctr, FND_API.G_FALSE, l_msg_data, l_msg_dummy );

1358: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','return_status'||l_return_status,FALSE);
1359: IF l_return_status <> 'S' Then
1360: write_to_cr_log( 'Msg Count : '||to_char(l_msg_count));
1361: FOR l_msg_ctr in 1..l_msg_count LOOP
1362: fnd_msg_pub.get ( l_msg_ctr, FND_API.G_FALSE, l_msg_data, l_msg_dummy );
1363: write_to_cr_log( 'Msg : '|| to_char(l_msg_ctr) || ' ' || l_msg_data );
1364: END LOOP;
1365: RAISE l_merge_excep;
1366: END IF;