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 209: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

205: AND ( YT.ACTIVE_END_DATE IS NULL OR YT.ACTIVE_END_DATE > SYSDATE )
206: AND CIP.INSTANCE_ID = CII.INSTANCE_ID
207: AND ( CII.ACTIVE_END_DATE IS NULL OR CII.ACTIVE_END_DATE > SYSDATE );
208:
209: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
210: l_msg_count NUMBER;
211: l_msg_data VARCHAR2(2000);
212:
213: -- Variables for 'GET ITEM INSTANCE DETAILS' API call

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

507: END IF; -- } 7
508:
509: csi_t_gen_utility_pvt.add('build the transaction record, if this is the first time');
510: -- build the transaction record, if this is the first time
511: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num Then -- { 8
512: --
513: -- Check if there is a transaction record created by any other csi routine
514: -- If so use that id otherwise initialize the txn_rec attributes
515: --

Line 589: p_commit => fnd_api.g_false,

585: write_to_cr_log( l_msg_string );
586:
587: csi_item_instance_pub.get_item_instance_details(
588: p_api_version => 1.0,
589: p_commit => fnd_api.g_false,
590: p_init_msg_list => fnd_api.g_true,
591: p_validation_level => fnd_api.g_valid_level_full,
592: p_instance_rec => l_g_instance_rec,
593: p_get_parties => fnd_api.g_true,

Line 590: p_init_msg_list => fnd_api.g_true,

586:
587: csi_item_instance_pub.get_item_instance_details(
588: p_api_version => 1.0,
589: p_commit => fnd_api.g_false,
590: p_init_msg_list => fnd_api.g_true,
591: p_validation_level => fnd_api.g_valid_level_full,
592: p_instance_rec => l_g_instance_rec,
593: p_get_parties => fnd_api.g_true,
594: p_party_header_tbl => l_g_ph_tbl,

Line 591: p_validation_level => fnd_api.g_valid_level_full,

587: csi_item_instance_pub.get_item_instance_details(
588: p_api_version => 1.0,
589: p_commit => fnd_api.g_false,
590: p_init_msg_list => fnd_api.g_true,
591: p_validation_level => fnd_api.g_valid_level_full,
592: p_instance_rec => l_g_instance_rec,
593: p_get_parties => fnd_api.g_true,
594: p_party_header_tbl => l_g_ph_tbl,
595: p_get_accounts => fnd_api.g_true,

Line 593: p_get_parties => fnd_api.g_true,

589: p_commit => fnd_api.g_false,
590: p_init_msg_list => fnd_api.g_true,
591: p_validation_level => fnd_api.g_valid_level_full,
592: p_instance_rec => l_g_instance_rec,
593: p_get_parties => fnd_api.g_true,
594: p_party_header_tbl => l_g_ph_tbl,
595: p_get_accounts => fnd_api.g_true,
596: p_account_header_tbl => l_g_pah_tbl,
597: p_get_org_assignments => fnd_api.g_false,

Line 595: p_get_accounts => fnd_api.g_true,

591: p_validation_level => fnd_api.g_valid_level_full,
592: p_instance_rec => l_g_instance_rec,
593: p_get_parties => fnd_api.g_true,
594: p_party_header_tbl => l_g_ph_tbl,
595: p_get_accounts => fnd_api.g_true,
596: p_account_header_tbl => l_g_pah_tbl,
597: p_get_org_assignments => fnd_api.g_false,
598: p_org_header_tbl => l_g_ouh_tbl,
599: p_get_pricing_attribs => fnd_api.g_false,

Line 597: p_get_org_assignments => fnd_api.g_false,

593: p_get_parties => fnd_api.g_true,
594: p_party_header_tbl => l_g_ph_tbl,
595: p_get_accounts => fnd_api.g_true,
596: p_account_header_tbl => l_g_pah_tbl,
597: p_get_org_assignments => fnd_api.g_false,
598: p_org_header_tbl => l_g_ouh_tbl,
599: p_get_pricing_attribs => fnd_api.g_false,
600: p_pricing_attrib_tbl => l_g_pa_tbl,
601: p_get_ext_attribs => fnd_api.g_false,

Line 599: p_get_pricing_attribs => fnd_api.g_false,

595: p_get_accounts => fnd_api.g_true,
596: p_account_header_tbl => l_g_pah_tbl,
597: p_get_org_assignments => fnd_api.g_false,
598: p_org_header_tbl => l_g_ouh_tbl,
599: p_get_pricing_attribs => fnd_api.g_false,
600: p_pricing_attrib_tbl => l_g_pa_tbl,
601: p_get_ext_attribs => fnd_api.g_false,
602: p_ext_attrib_tbl => l_g_eav_tbl,
603: p_ext_attrib_def_tbl => l_g_ea_tbl,

Line 601: p_get_ext_attribs => fnd_api.g_false,

597: p_get_org_assignments => fnd_api.g_false,
598: p_org_header_tbl => l_g_ouh_tbl,
599: p_get_pricing_attribs => fnd_api.g_false,
600: p_pricing_attrib_tbl => l_g_pa_tbl,
601: p_get_ext_attribs => fnd_api.g_false,
602: p_ext_attrib_tbl => l_g_eav_tbl,
603: p_ext_attrib_def_tbl => l_g_ea_tbl,
604: p_get_asset_assignments => fnd_api.g_false,
605: p_asset_header_tbl => l_g_iah_tbl,

Line 604: p_get_asset_assignments => fnd_api.g_false,

600: p_pricing_attrib_tbl => l_g_pa_tbl,
601: p_get_ext_attribs => fnd_api.g_false,
602: p_ext_attrib_tbl => l_g_eav_tbl,
603: p_ext_attrib_def_tbl => l_g_ea_tbl,
604: p_get_asset_assignments => fnd_api.g_false,
605: p_asset_header_tbl => l_g_iah_tbl,
606: p_time_stamp => l_g_time_stamp,
607: x_return_status => l_return_status,
608: x_msg_count => l_msg_count,

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

613:
614: IF ( l_return_status <> 'S' ) Then
615: write_to_cr_log( 'Msg Count : '||to_char(l_msg_count));
616: FOR l_msg_ctr in 1..l_msg_count LOOP
617: fnd_msg_pub.get ( l_msg_ctr, FND_API.G_FALSE, l_msg_data, l_msg_dummy );
618: write_to_cr_log( 'Msg : '|| to_char(l_msg_ctr) || ' ' || l_msg_data );
619: END LOOP;
620: END IF;
621:

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

721: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id;
722: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
723: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
724: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
725: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
726: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
727: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
728: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
729: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

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

722: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
723: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
724: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
725: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
726: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
727: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
728: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
729: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
730: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

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

742: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
743: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
744: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
745: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
746: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
747:
748: -- move the account record to update table
749: l_acct_idx := l_acct_idx + 1;
750: p_u_party_account_tbl(l_acct_idx).ip_account_id := l_g_pah_tbl(l_acct_rec_index).ip_account_id;

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

769: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(l_acct_rec_index).ship_to_address;
770: END IF;
771:
772: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(l_acct_rec_index).relationship_type_code;
773: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
774: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
775: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(l_acct_rec_index).context;
776: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(l_acct_rec_index).attribute1;
777: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(l_acct_rec_index).attribute2;

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

770: END IF;
771:
772: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(l_acct_rec_index).relationship_type_code;
773: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
774: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
775: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(l_acct_rec_index).context;
776: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(l_acct_rec_index).attribute1;
777: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(l_acct_rec_index).attribute2;
778: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(l_acct_rec_index).attribute3;

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

788: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(l_acct_rec_index).attribute13;
789: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(l_acct_rec_index).attribute14;
790: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(l_acct_rec_index).attribute15;
791: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(l_acct_rec_index).object_version_number;
792: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
793: ELSE -- } address_only { Otherwise
794: IF ( l_num_of_acct_records = 1 ) THEN -- { if one record for the party
795: -- IF ( l_acct_rec_index > 0 ) THEN -- if account index is known
796: IF ( l_acct_rec_index > 0 ) AND

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

808: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id; --Fix for Bug 4284460
809: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
810: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
811: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
812: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
813: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
814: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
815: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
816: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

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

809: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
810: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
811: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
812: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
813: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
814: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
815: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
816: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
817: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

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

829: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
830: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
831: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
832: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
833: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
834:
835: -- move the account record to update table
836: l_acct_idx := l_acct_idx + 1;
837: p_u_party_account_tbl(l_acct_idx).ip_account_id := l_g_pah_tbl(l_acct_rec_index).ip_account_id;

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

856: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(l_acct_rec_index).ship_to_address;
857: END IF;
858:
859: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(l_acct_rec_index).relationship_type_code;
860: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
861: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
862: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(l_acct_rec_index).context;
863: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(l_acct_rec_index).attribute1;
864: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(l_acct_rec_index).attribute2;

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

857: END IF;
858:
859: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(l_acct_rec_index).relationship_type_code;
860: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
861: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
862: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(l_acct_rec_index).context;
863: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(l_acct_rec_index).attribute1;
864: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(l_acct_rec_index).attribute2;
865: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(l_acct_rec_index).attribute3;

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

875: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(l_acct_rec_index).attribute13;
876: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(l_acct_rec_index).attribute14;
877: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(l_acct_rec_index).attribute15;
878: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(l_acct_rec_index).object_version_number;
879: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
880:
881: END IF; -- } if account index is known and account needs to be modified
882: ELSIF ( l_num_of_acct_records > 1 ) THEN -- } account records = 1 { account records for party > 1
883: IF l_owner_update = 'Y' THEN -- { l_owner_update is 'Y'

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

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

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

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

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

923: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
924: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
925: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
926: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
927: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
928:
929: -- create new party record with l_g_ph_tbl party_id
930: l_pty_idx := l_pty_idx + 1;
931: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;

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

927: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
928:
929: -- create new party record with l_g_ph_tbl party_id
930: l_pty_idx := l_pty_idx + 1;
931: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;
932: p_u_party_tbl(l_pty_idx).instance_id := l_g_ph_tbl(J).instance_id;
933: p_u_party_tbl(l_pty_idx).party_source_table := l_g_ph_tbl(J).party_source_table;
934: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id;
935: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;

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

934: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id;
935: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;
936: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
937: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
938: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
939: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
940: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
941: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
942: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

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

935: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;
936: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
937: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
938: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
939: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
940: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
941: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
942: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
943: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

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

955: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
956: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
957: p_u_party_tbl(l_pty_idx).primary_flag := 'N';
958: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
959: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
960:
961: FOR K in 1..l_g_pah_tbl.count LOOP -- { K Loop
962: IF ( l_g_pah_tbl(K).instance_party_id = l_instance_party_id AND
963: l_g_pah_tbl(K).active_end_date IS NULL ) THEN -- { accounts for the same party

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

971: p_u_party_account_tbl(l_acct_idx).parent_tbl_index := l_pty_idx-1;
972: p_u_party_account_tbl(l_acct_idx).instance_party_id := l_g_pah_tbl(K).instance_party_id;
973: ELSE -- } if record needs update { if record needs no update
974: p_u_party_account_tbl(l_acct_idx).parent_tbl_index := l_pty_idx;
975: p_u_party_account_tbl(l_acct_idx).instance_party_id := FND_API.G_MISS_NUM;
976: END IF; -- } if the record needs no update
977:
978: IF l_g_pah_tbl(K).party_account_id = NUM_COL1_ORIG_LIST(I) THEN
979: p_u_party_account_tbl(l_acct_idx).party_account_id := NUM_COL1_NEW_LIST(I);

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

993: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(K).ship_to_address;
994: END IF;
995:
996: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
997: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
998: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
999: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1000: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1001: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;

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

994: END IF;
995:
996: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
997: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
998: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
999: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1000: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1001: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;
1002: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(K).attribute3;

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

1012: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(K).attribute13;
1013: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(K).attribute14;
1014: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(K).attribute15;
1015: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(K).object_version_number;
1016: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
1017: END IF; -- } accounts for the same party
1018: END LOOP; -- } K Loop
1019:
1020: ELSE -- } l_pty_with_diff_accts = 'Y' 1 { l_pty_with_diff_accts = 'N' 1

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

1027: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id; --Fix for Bug 4284460
1028: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
1029: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1030: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1031: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1032: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1033: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1034: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1035: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

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

1028: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
1029: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1030: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1031: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1032: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1033: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1034: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1035: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
1036: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

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

1048: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
1049: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
1050: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
1051: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
1052: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1053:
1054: FOR K in 1..l_g_pah_tbl.count LOOP -- { K Loop
1055: IF ( l_g_pah_tbl(K).instance_party_id = l_instance_party_id AND
1056: l_g_pah_tbl(K).active_end_date IS NULL AND

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

1082: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(K).ship_to_address;
1083: END IF;
1084:
1085: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1086: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1087: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1088: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1089: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1090: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;

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

1083: END IF;
1084:
1085: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1086: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1087: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1088: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1089: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1090: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;
1091: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(K).attribute3;

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

1101: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(K).attribute13;
1102: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(K).attribute14;
1103: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(K).attribute15;
1104: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(K).object_version_number;
1105: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
1106: END IF; -- } accounts for the same party
1107: END LOOP; -- } K Loop
1108: END IF; -- } l_pty_with_diff_accts 1
1109: ELSE -- } l_owner_update = 'Y' { l_owner_update = 'N'

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

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

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

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

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

1157: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
1158: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
1159: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
1160: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
1161: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1162:
1163: -- create new party record with l_to_party
1164: l_pty_idx := l_pty_idx + 1;
1165: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;

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

1161: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1162:
1163: -- create new party record with l_to_party
1164: l_pty_idx := l_pty_idx + 1;
1165: p_u_party_tbl(l_pty_idx).instance_party_id := FND_API.G_MISS_NUM;
1166: p_u_party_tbl(l_pty_idx).instance_id := l_g_ph_tbl(J).instance_id;
1167: p_u_party_tbl(l_pty_idx).party_source_table := l_g_ph_tbl(J).party_source_table;
1168: p_u_party_tbl(l_pty_idx).party_id := l_to_party_id;
1169: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;

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

1168: p_u_party_tbl(l_pty_idx).party_id := l_to_party_id;
1169: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;
1170: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1171: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1172: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1173: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1174: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1175: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1176: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

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

1169: p_u_party_tbl(l_pty_idx).relationship_type_code := l_prof_reltype_code;
1170: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1171: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1172: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1173: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1174: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1175: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1176: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
1177: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

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

1189: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
1190: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
1191: p_u_party_tbl(l_pty_idx).primary_flag := 'N';
1192: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
1193: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1194:
1195: FOR K in 1..l_g_pah_tbl.count LOOP -- { K Loop
1196: IF ( l_g_pah_tbl(K).instance_party_id = l_instance_party_id AND
1197: l_g_pah_tbl(K).active_end_date IS NULL ) THEN -- { accounts for the same party

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

1202: IF ( l_g_pah_tbl(K).party_account_id = NUM_COL1_ORIG_LIST(I) OR
1203: l_g_pah_tbl(K).bill_to_address = NUM_COL2_ORIG_LIST(I) OR
1204: l_g_pah_tbl(K).ship_to_address = NUM_COL3_ORIG_LIST(I) ) THEN -- { if the record needs update
1205: p_u_party_account_tbl(l_acct_idx).parent_tbl_index := l_pty_idx;
1206: p_u_party_account_tbl(l_acct_idx).instance_party_id := FND_API.G_MISS_NUM;
1207: ELSE -- } if record needs update { if record needs no update
1208: p_u_party_account_tbl(l_acct_idx).parent_tbl_index := l_pty_idx-1;
1209: p_u_party_account_tbl(l_acct_idx).instance_party_id := l_g_pah_tbl(K).instance_party_id;
1210: END IF; -- } if the record needs no update

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

1227: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(K).ship_to_address;
1228: END IF;
1229:
1230: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1231: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1232: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1233: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1234: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1235: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;

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

1228: END IF;
1229:
1230: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1231: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1232: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1233: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1234: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1235: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;
1236: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(K).attribute3;

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

1246: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(K).attribute13;
1247: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(K).attribute14;
1248: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(K).attribute15;
1249: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(K).object_version_number;
1250: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
1251: END IF; -- } accounts for the same party
1252: END LOOP; -- } K Loop
1253:
1254: ELSE -- } l_pty_with_diff_accts = 'Y' { l_pty_with_diff_accts = 'N'

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

1261: p_u_party_tbl(l_pty_idx).party_id := l_g_ph_tbl(J).party_id; --Fix for Bug 4284460
1262: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
1263: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1264: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1265: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1266: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1267: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1268: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1269: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;

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

1262: p_u_party_tbl(l_pty_idx).relationship_type_code := l_g_ph_tbl(J).relationship_type_code;
1263: p_u_party_tbl(l_pty_idx).contact_flag := l_g_ph_tbl(J).contact_flag;
1264: p_u_party_tbl(l_pty_idx).contact_ip_id := l_g_ph_tbl(J).contact_ip_id;
1265: p_u_party_tbl(l_pty_idx).active_start_date := FND_API.G_MISS_DATE;
1266: p_u_party_tbl(l_pty_idx).active_end_date := FND_API.G_MISS_DATE;
1267: p_u_party_tbl(l_pty_idx).context := l_g_ph_tbl(J).context;
1268: p_u_party_tbl(l_pty_idx).attribute1 := l_g_ph_tbl(J).attribute1;
1269: p_u_party_tbl(l_pty_idx).attribute2 := l_g_ph_tbl(J).attribute2;
1270: p_u_party_tbl(l_pty_idx).attribute3 := l_g_ph_tbl(J).attribute3;

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

1282: p_u_party_tbl(l_pty_idx).attribute15 := l_g_ph_tbl(J).attribute15;
1283: p_u_party_tbl(l_pty_idx).object_version_number := l_g_ph_tbl(J).object_version_number;
1284: p_u_party_tbl(l_pty_idx).primary_flag := l_g_ph_tbl(J).primary_flag;
1285: p_u_party_tbl(l_pty_idx).preferred_flag := l_g_ph_tbl(J).preferred_flag;
1286: p_u_party_tbl(l_pty_idx).call_contracts := FND_API.G_FALSE;
1287:
1288: FOR K in 1..l_g_pah_tbl.count LOOP -- { K Loop
1289: IF ( l_g_pah_tbl(K).instance_party_id = l_instance_party_id AND
1290: l_g_pah_tbl(K).active_end_date IS NULL ) THEN -- { accounts for the same party

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

1312: p_u_party_account_tbl(l_acct_idx).ship_to_address := l_g_pah_tbl(K).ship_to_address;
1313: END IF;
1314:
1315: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1316: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1317: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1318: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1319: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1320: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;

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

1313: END IF;
1314:
1315: p_u_party_account_tbl(l_acct_idx).relationship_type_code := l_g_pah_tbl(K).relationship_type_code;
1316: p_u_party_account_tbl(l_acct_idx).active_start_date := FND_API.G_MISS_DATE;
1317: p_u_party_account_tbl(l_acct_idx).active_end_date := FND_API.G_MISS_DATE;
1318: p_u_party_account_tbl(l_acct_idx).context := l_g_pah_tbl(K).context;
1319: p_u_party_account_tbl(l_acct_idx).attribute1 := l_g_pah_tbl(K).attribute1;
1320: p_u_party_account_tbl(l_acct_idx).attribute2 := l_g_pah_tbl(K).attribute2;
1321: p_u_party_account_tbl(l_acct_idx).attribute3 := l_g_pah_tbl(K).attribute3;

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

1331: p_u_party_account_tbl(l_acct_idx).attribute13 := l_g_pah_tbl(K).attribute13;
1332: p_u_party_account_tbl(l_acct_idx).attribute14 := l_g_pah_tbl(K).attribute14;
1333: p_u_party_account_tbl(l_acct_idx).attribute15 := l_g_pah_tbl(K).attribute15;
1334: p_u_party_account_tbl(l_acct_idx).object_version_number := l_g_pah_tbl(K).object_version_number;
1335: p_u_party_account_tbl(l_acct_idx).call_contracts := FND_API.G_FALSE;
1336: END IF; -- } accounts for the same party
1337: END LOOP; -- } K Loop
1338: END IF; -- } l_pty_with_diff_accts = 'N'
1339: END IF; -- } l_owner_update = 'N'

Line 1371: p_commit => fnd_api.g_false,

1367: error_str := '022';
1368: csi_t_gen_utility_pvt.add('Calling csi_item_instance_pub.update_item_instance');
1369: csi_item_instance_pub.update_item_instance(
1370: p_api_version => 1.0,
1371: p_commit => fnd_api.g_false,
1372: p_init_msg_list => fnd_api.g_true,
1373: p_validation_level => fnd_api.g_valid_level_full,
1374: p_instance_rec => p_u_instance_rec,
1375: p_ext_attrib_values_tbl => p_u_ext_attrib_values_tbl,

Line 1372: p_init_msg_list => fnd_api.g_true,

1368: csi_t_gen_utility_pvt.add('Calling csi_item_instance_pub.update_item_instance');
1369: csi_item_instance_pub.update_item_instance(
1370: p_api_version => 1.0,
1371: p_commit => fnd_api.g_false,
1372: p_init_msg_list => fnd_api.g_true,
1373: p_validation_level => fnd_api.g_valid_level_full,
1374: p_instance_rec => p_u_instance_rec,
1375: p_ext_attrib_values_tbl => p_u_ext_attrib_values_tbl,
1376: p_party_tbl => p_u_party_tbl,

Line 1373: p_validation_level => fnd_api.g_valid_level_full,

1369: csi_item_instance_pub.update_item_instance(
1370: p_api_version => 1.0,
1371: p_commit => fnd_api.g_false,
1372: p_init_msg_list => fnd_api.g_true,
1373: p_validation_level => fnd_api.g_valid_level_full,
1374: p_instance_rec => p_u_instance_rec,
1375: p_ext_attrib_values_tbl => p_u_ext_attrib_values_tbl,
1376: p_party_tbl => p_u_party_tbl,
1377: p_account_tbl => p_u_party_account_tbl,

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

1389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','return_status'||l_return_status,FALSE);
1390: IF l_return_status <> 'S' Then
1391: write_to_cr_log( 'Msg Count : '||to_char(l_msg_count));
1392: FOR l_msg_ctr in 1..l_msg_count LOOP
1393: fnd_msg_pub.get ( l_msg_ctr, FND_API.G_FALSE, l_msg_data, l_msg_dummy );
1394: write_to_cr_log( 'Msg : '|| to_char(l_msg_ctr) || ' ' || l_msg_data );
1395: END LOOP;
1396: RAISE l_merge_excep;
1397: END IF;