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_PARTY_RELATIONSHIPS_PVT dependencies on CSI_INSTANCE_PARTIES_VLD_PVT

Line 1499: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

1495:
1496: -- Start API body
1497: --
1498: -- Check if all the required parameters are passed
1499: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
1500: ( p_party_rec.INSTANCE_ID ,
1501: ' p_party_rec.INSTANCE_ID ',
1502: l_api_name );
1503: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char

Line 1503: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char

1499: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
1500: ( p_party_rec.INSTANCE_ID ,
1501: ' p_party_rec.INSTANCE_ID ',
1502: l_api_name );
1503: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char
1504: ( p_party_rec.PARTY_SOURCE_TABLE ,
1505: ' p_party_rec.PARTY_SOURCE_TABLE ',
1506: l_api_name );
1507: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

Line 1507: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

1503: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char
1504: ( p_party_rec.PARTY_SOURCE_TABLE ,
1505: ' p_party_rec.PARTY_SOURCE_TABLE ',
1506: l_api_name );
1507: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
1508: ( p_party_rec.PARTY_ID ,
1509: ' p_party_rec.PARTY_ID ',
1510: l_api_name );
1511:

Line 1512: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char

1508: ( p_party_rec.PARTY_ID ,
1509: ' p_party_rec.PARTY_ID ',
1510: l_api_name );
1511:
1512: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char
1513: ( p_party_rec.RELATIONSHIP_TYPE_CODE,
1514: ' p_party_rec.RELATIONSHIP_TYPE_CODE',
1515: l_api_name );
1516:

Line 1517: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char

1513: ( p_party_rec.RELATIONSHIP_TYPE_CODE,
1514: ' p_party_rec.RELATIONSHIP_TYPE_CODE',
1515: l_api_name );
1516:
1517: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char
1518: ( p_party_rec.CONTACT_FLAG,
1519: ' p_party_rec.CONTACT_FLAG',
1520: l_api_name );
1521:

Line 1576: IF (CSI_Instance_parties_vld_pvt.Is_Party_Expired

1572: END IF;
1573: --
1574: IF l_record_found THEN
1575: /* -- Commented by sk for bug 2232880
1576: IF (CSI_Instance_parties_vld_pvt.Is_Party_Expired
1577: (p_party_rec)) THEN
1578: IF (p_party_rec.ACTIVE_END_DATE = FND_API.G_MISS_DATE) THEN
1579: p_party_rec.ACTIVE_END_DATE := NULL;
1580: END IF;

Line 1616: IF (CSI_Instance_parties_vld_pvt.Is_Party_Rel_Comb_Exists

1612: ELSE -- -- Added by sk for bug 2232880 l_record not found
1613: --END IF; -- commented by sk for bug 2232880
1614: -- Verify if the Party rel combination exists
1615: IF p_called_from_grp <> FND_API.G_TRUE THEN
1616: IF (CSI_Instance_parties_vld_pvt.Is_Party_Rel_Comb_Exists
1617: (p_party_rec.instance_id ,
1618: p_party_rec.party_source_table ,
1619: p_party_rec.party_id ,
1620: p_party_rec.relationship_type_code ,

Line 1635: p_party_rec.INSTANCE_PARTY_ID := CSI_Instance_parties_vld_pvt.gen_inst_party_id;

1631: -- If the instance_party_id passed is null then generate from sequence
1632: -- and check if the value exists . If exists then generate
1633: -- again from the sequence till we get a value that does not exist
1634: while l_process_flag loop
1635: p_party_rec.INSTANCE_PARTY_ID := CSI_Instance_parties_vld_pvt.gen_inst_party_id;
1636: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_PartyID_exists(p_party_rec.INSTANCE_PARTY_ID,
1637: FALSE )) THEN
1638: l_process_flag := FALSE;
1639: END IF;

Line 1636: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_PartyID_exists(p_party_rec.INSTANCE_PARTY_ID,

1632: -- and check if the value exists . If exists then generate
1633: -- again from the sequence till we get a value that does not exist
1634: while l_process_flag loop
1635: p_party_rec.INSTANCE_PARTY_ID := CSI_Instance_parties_vld_pvt.gen_inst_party_id;
1636: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_PartyID_exists(p_party_rec.INSTANCE_PARTY_ID,
1637: FALSE )) THEN
1638: l_process_flag := FALSE;
1639: END IF;
1640: end loop;

Line 1643: IF CSI_Instance_parties_vld_pvt.Is_Inst_PartyID_exists(p_party_rec.INSTANCE_PARTY_ID,

1639: END IF;
1640: end loop;
1641: ELSE
1642: -- Validate the instance_party_id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
1643: IF CSI_Instance_parties_vld_pvt.Is_Inst_PartyID_exists(p_party_rec.INSTANCE_PARTY_ID,
1644: TRUE ) THEN
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647: END IF;

Line 1651: IF NOT(CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid(p_party_rec.INSTANCE_ID)) THEN

1647: END IF;
1648:
1649: -- Verify if the instance_id exists in csi_item_instances
1650: IF p_called_from_grp <> FND_API.G_TRUE THEN
1651: IF NOT(CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid(p_party_rec.INSTANCE_ID)) THEN
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;
1654: END IF;
1655:

Line 1681: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Source_tab_Valid(p_party_rec.PARTY_SOURCE_TABLE)) THEN

1677: --
1678: IF l_exists_flag = 'N' THEN
1679: p_party_count_rec.party_source_count := p_party_count_rec.party_source_count + 1;
1680: p_party_source_tbl(p_party_count_rec.party_source_count).party_source_table := p_party_rec.PARTY_SOURCE_TABLE;
1681: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Source_tab_Valid(p_party_rec.PARTY_SOURCE_TABLE)) THEN
1682: p_party_source_tbl(p_party_count_rec.party_source_count).valid_flag := 'N';
1683: RAISE FND_API.G_EXC_ERROR;
1684: ELSE
1685: p_party_source_tbl(p_party_count_rec.party_source_count).valid_flag := 'Y';

Line 1719: IF NOT(CSI_Instance_parties_vld_pvt.Is_Party_Valid

1715: p_party_count_rec.party_id_count := p_party_count_rec.party_id_count + 1;
1716: p_party_id_tbl(p_party_count_rec.party_id_count).party_id := p_party_rec.PARTY_ID;
1717: p_party_id_tbl(p_party_count_rec.party_id_count).party_source_table := p_party_rec.PARTY_SOURCE_TABLE;
1718: p_party_id_tbl(p_party_count_rec.party_id_count).contact_flag := p_party_rec.CONTACT_FLAG;
1719: IF NOT(CSI_Instance_parties_vld_pvt.Is_Party_Valid
1720: (p_party_rec.PARTY_SOURCE_TABLE ,
1721: p_party_rec.PARTY_ID ,
1722: p_party_rec.CONTACT_FLAG)) THEN
1723: p_party_id_tbl(p_party_count_rec.party_id_count).valid_flag := 'N';

Line 1833: IF NOT(CSI_Instance_parties_vld_pvt.Is_Contact_Valid

1829: p_contact_tbl(p_party_count_rec.contact_id_count).contact_party_id := p_party_rec.PARTY_ID;
1830: p_contact_tbl(p_party_count_rec.contact_id_count).party_source_table := p_party_rec.PARTY_SOURCE_TABLE;
1831: p_contact_tbl(p_party_count_rec.contact_id_count).contact_ip_id := p_party_rec.CONTACT_IP_ID;
1832: /* code commented by sguthiva on 09-25-02 for bug 2377709
1833: IF NOT(CSI_Instance_parties_vld_pvt.Is_Contact_Valid
1834: (p_party_rec.PARTY_ID,
1835: p_party_rec.PARTY_SOURCE_TABLE,
1836: p_party_rec.CONTACT_IP_ID)) THEN
1837: p_contact_tbl(p_party_count_rec.contact_id_count).valid_flag := 'N';

Line 1872: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Rel_type_Valid

1868: IF l_exists_flag <> 'Y' THEN
1869: p_party_count_rec.rel_type_count := p_party_count_rec.rel_type_count + 1;
1870: p_party_rel_type_tbl(p_party_count_rec.rel_type_count).rel_type_code := p_party_rec.RELATIONSHIP_TYPE_CODE;
1871: p_party_rel_type_tbl(p_party_count_rec.rel_type_count).contact_flag := 'C';
1872: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Rel_type_Valid
1873: (p_party_rec.RELATIONSHIP_TYPE_CODE,
1874: 'C' )) THEN
1875: p_party_rel_type_tbl(p_party_count_rec.rel_type_count).valid_flag := 'N';
1876: RAISE FND_API.G_EXC_ERROR;

Line 1909: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Rel_type_Valid

1905: IF l_exists_flag <> 'Y' THEN
1906: p_party_count_rec.rel_type_count := p_party_count_rec.rel_type_count + 1;
1907: p_party_rel_type_tbl(p_party_count_rec.rel_type_count).rel_type_code := p_party_rec.RELATIONSHIP_TYPE_CODE;
1908: p_party_rel_type_tbl(p_party_count_rec.rel_type_count).contact_flag := 'P';
1909: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Rel_type_Valid
1910: (p_party_rec.RELATIONSHIP_TYPE_CODE,
1911: 'P' )) THEN
1912: p_party_rel_type_tbl(p_party_count_rec.rel_type_count).valid_flag := 'N';
1913: RAISE FND_API.G_EXC_ERROR;

Line 1929: IF NOT(CSI_Instance_parties_vld_pvt.Is_StartDate_Valid

1925: END IF;
1926:
1927: -- verify if the active_start_date is valid
1928: IF p_called_from_grp <> FND_API.G_TRUE THEN
1929: IF NOT(CSI_Instance_parties_vld_pvt.Is_StartDate_Valid
1930: (p_party_rec.ACTIVE_START_DATE,
1931: p_party_rec.ACTIVE_END_DATE ,
1932: p_party_rec.INSTANCE_ID )) THEN
1933: RAISE FND_API.G_EXC_ERROR;

Line 1941: IF NOT(CSI_Instance_parties_vld_pvt.Is_EndDate_Valid(p_party_rec.ACTIVE_START_DATE,

1937: -- Verify if the active_end_date is valid
1938: IF p_called_from_grp <> FND_API.G_TRUE THEN
1939: IF ((p_party_rec.ACTIVE_END_DATE is NOT NULL) AND
1940: ( p_party_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE)) THEN
1941: IF NOT(CSI_Instance_parties_vld_pvt.Is_EndDate_Valid(p_party_rec.ACTIVE_START_DATE,
1942: p_party_rec.ACTIVE_END_DATE ,
1943: p_party_rec.INSTANCE_ID,
1944: p_party_rec.INSTANCE_PARTY_ID,
1945: p_txn_rec.TRANSACTION_ID)) THEN

Line 1954: IF CSI_Instance_parties_vld_pvt.Is_Inst_Owner_exists

1950:
1951: -- Verify the instance owner exists already if exists then raise error
1952: IF p_called_from_grp <> FND_API.G_TRUE THEN
1953: IF p_party_rec.RELATIONSHIP_TYPE_CODE = 'OWNER' THEN
1954: IF CSI_Instance_parties_vld_pvt.Is_Inst_Owner_exists
1955: (p_instance_id => p_party_rec.INSTANCE_ID,
1956: p_instance_party_id => p_party_rec.instance_party_id ) THEN
1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;

Line 1981: IF CSI_Instance_parties_vld_pvt.Is_Primary_Contact_Pty

1977: -- given instance party relationship
1978: IF p_called_from_grp <> FND_API.G_TRUE THEN
1979: IF p_party_rec.PRIMARY_FLAG = 'Y' THEN
1980: IF p_party_rec.CONTACT_FLAG = 'Y' THEN
1981: IF CSI_Instance_parties_vld_pvt.Is_Primary_Contact_Pty
1982: (p_party_rec.INSTANCE_ID,
1983: p_party_rec.CONTACT_IP_ID,
1984: p_party_rec.RELATIONSHIP_TYPE_CODE,
1985: p_party_rec.ACTIVE_START_DATE,

Line 1997: IF CSI_Instance_parties_vld_pvt.Is_Primary_Pty

1993: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);
1994: FND_MSG_PUB.Add;
1995: RAISE FND_API.G_EXC_ERROR;
1996: ELSE
1997: IF CSI_Instance_parties_vld_pvt.Is_Primary_Pty
1998: (p_party_rec.INSTANCE_ID,
1999: p_party_rec.RELATIONSHIP_TYPE_CODE,
2000: p_party_rec.ACTIVE_START_DATE,
2001: p_party_rec.ACTIVE_END_DATE) THEN

Line 2124: l_inst_party_his_id := CSI_Instance_parties_vld_pvt.gen_inst_party_hist_id;

2120: RAISE FND_API.G_EXC_ERROR;
2121: END IF;
2122:
2123: -- Generate a unique instance_party_history_id from the sequence
2124: l_inst_party_his_id := CSI_Instance_parties_vld_pvt.gen_inst_party_hist_id;
2125:
2126: -- Call table handlers to insert into csi_i_parties_h table
2127: CSI_I_PARTIES_H_PKG.Insert_Row
2128: (

Line 2602: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

2598: END IF;
2599: -- Start API body
2600: --
2601: -- Check if all the required parameters are passed
2602: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
2603: ( p_party_rec.INSTANCE_PARTY_ID ,
2604: ' p_party_rec.INSTANCE_PARTY_ID ',
2605: l_api_name );
2606: --

Line 2617: IF NOT(CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid(p_party_rec.INSTANCE_ID)) THEN

2613: -- Check if the instance party id is valid
2614: -- End commentation by sk for bug 2232880
2615: -- Verify if the instance_id exists in csi_item_instances
2616: IF p_party_rec.INSTANCE_ID <> FND_API.G_MISS_NUM THEN
2617: IF NOT(CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid(p_party_rec.INSTANCE_ID)) THEN
2618: RAISE FND_API.G_EXC_ERROR;
2619: END IF;
2620: END IF;
2621: -- Verify the instance owner exists already if exists then raise error

Line 2623: IF CSI_Instance_parties_vld_pvt.Is_Inst_Owner_exists

2619: END IF;
2620: END IF;
2621: -- Verify the instance owner exists already if exists then raise error
2622: IF p_party_rec.RELATIONSHIP_TYPE_CODE = 'OWNER' THEN
2623: IF CSI_Instance_parties_vld_pvt.Is_Inst_Owner_exists
2624: (p_instance_id => p_party_rec.INSTANCE_ID,
2625: p_instance_party_id => p_party_rec.instance_party_id ) THEN
2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;

Line 2719: IF NOT(CSI_Instance_parties_vld_pvt.Is_EndDate_Valid

2715: RAISE FND_API.G_EXC_ERROR;
2716: ELSE
2717: -- Verify if the active_end_date is valid
2718: IF (g_expire_party_flag <> 'Y') THEN
2719: IF NOT(CSI_Instance_parties_vld_pvt.Is_EndDate_Valid
2720: (l_curr_party_rec.ACTIVE_START_DATE,
2721: p_party_rec.ACTIVE_END_DATE ,
2722: p_party_rec.INSTANCE_ID,
2723: p_party_rec.INSTANCE_PARTY_ID,

Line 2742: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Rel_type_Valid

2738: RAISE FND_API.G_EXC_ERROR;
2739: ELSE
2740: -- Verify the relationship_type_code is valid
2741: IF p_party_rec.contact_flag = 'Y' THEN
2742: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Rel_type_Valid
2743: (p_party_rec.RELATIONSHIP_TYPE_CODE,
2744: 'C' )) THEN
2745: RAISE FND_API.G_EXC_ERROR;
2746: END IF;

Line 2749: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Rel_type_Valid

2745: RAISE FND_API.G_EXC_ERROR;
2746: END IF;
2747: ELSE
2748: -- Verify the relationship_type_code is valid
2749: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Rel_type_Valid
2750: (p_party_rec.RELATIONSHIP_TYPE_CODE,
2751: 'P' )) THEN
2752: RAISE FND_API.G_EXC_ERROR;
2753: END IF;

Line 2817: IF CSI_Instance_parties_vld_pvt.Is_Primary_Contact_Pty

2813: THEN
2814: p_party_rec.ACTIVE_END_DATE := l_curr_party_rec.ACTIVE_END_DATE;
2815: END IF;
2816: -- SK END ADDITION
2817: IF CSI_Instance_parties_vld_pvt.Is_Primary_Contact_Pty
2818: (l_curr_party_rec.INSTANCE_ID,
2819: l_curr_party_rec.CONTACT_IP_ID,
2820: p_party_rec.RELATIONSHIP_TYPE_CODE,
2821: p_party_rec.ACTIVE_START_DATE,

Line 2861: IF CSI_Instance_parties_vld_pvt.Is_Primary_Pty

2857: THEN
2858: p_party_rec.ACTIVE_END_DATE := l_curr_party_rec.ACTIVE_END_DATE;
2859: END IF;
2860: -- SK END ADDITION
2861: IF CSI_Instance_parties_vld_pvt.Is_Primary_Pty
2862: (l_curr_party_rec.INSTANCE_ID,
2863: p_party_rec.RELATIONSHIP_TYPE_CODE,
2864: p_party_rec.ACTIVE_START_DATE,
2865: p_party_rec.ACTIVE_END_DATE) THEN

Line 2876: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Source_tab_Valid(p_party_rec.PARTY_SOURCE_TABLE)) THEN

2872: END IF;
2873: -- Call table handlers to insert into the csi_i_parties table
2874: -- Verify if the party_source_table exists in CSI_LOOKUPS
2875: IF (p_party_rec.PARTY_SOURCE_TABLE <> FND_API.G_MISS_CHAR) THEN
2876: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_Source_tab_Valid(p_party_rec.PARTY_SOURCE_TABLE)) THEN
2877: RAISE FND_API.G_EXC_ERROR;
2878: END IF;
2879: -- Verify if the party_id is valid based on the value of party_source_table
2880: IF (p_party_rec.PARTY_ID <> FND_API.G_MISS_NUM) THEN

Line 2881: IF NOT(CSI_Instance_parties_vld_pvt.Is_Party_Valid

2877: RAISE FND_API.G_EXC_ERROR;
2878: END IF;
2879: -- Verify if the party_id is valid based on the value of party_source_table
2880: IF (p_party_rec.PARTY_ID <> FND_API.G_MISS_NUM) THEN
2881: IF NOT(CSI_Instance_parties_vld_pvt.Is_Party_Valid
2882: (p_party_rec.PARTY_SOURCE_TABLE ,
2883: p_party_rec.PARTY_ID ,
2884: p_party_rec.CONTACT_FLAG )) THEN
2885: RAISE FND_API.G_EXC_ERROR;

Line 2890: IF NOT(CSI_Instance_parties_vld_pvt.Is_Party_Valid

2886: END IF;
2887: END IF;
2888: ELSE
2889: IF (p_party_rec.PARTY_ID <> FND_API.G_MISS_NUM) THEN
2890: IF NOT(CSI_Instance_parties_vld_pvt.Is_Party_Valid
2891: (l_curr_party_rec.PARTY_SOURCE_TABLE ,
2892: p_party_rec.PARTY_ID ,
2893: p_party_rec.CONTACT_FLAG )) THEN
2894: RAISE FND_API.G_EXC_ERROR;

Line 2918: CSI_Instance_parties_vld_pvt.Transfer_Party_Rules

2914: --AND (p_party_rec.party_id <> l_internal_party_id)) -- commented for bug 3294748
2915: THEN
2916: -- End of code comment for bug 2600000
2917: -- End commentation by sguthiva for bug 2307804
2918: CSI_Instance_parties_vld_pvt.Transfer_Party_Rules
2919: ( p_api_version => p_api_version
2920: ,p_commit => p_commit
2921: ,p_init_msg_list => p_init_msg_list
2922: ,p_validation_level => p_validation_level

Line 3027: IF (CSI_Instance_parties_vld_pvt.Is_Party_Rel_Comb_Exists

3023: WHEN OTHERS THEN
3024: NULL;
3025: END;
3026: ELSE
3027: IF (CSI_Instance_parties_vld_pvt.Is_Party_Rel_Comb_Exists
3028: (l_alt_pk_instance_id ,
3029: l_alt_pk_pty_source_tab ,
3030: l_alt_pk_party_id ,
3031: l_alt_pk_rel_type_code ,

Line 3162: l_inst_party_his_id := CSI_Instance_parties_vld_pvt.gen_inst_party_hist_id;

3158: FND_MSG_PUB.ADD;
3159: RAISE FND_API.G_EXC_ERROR;
3160: END IF;
3161: -- Generate a unique instance_party_history_id from the sequence
3162: l_inst_party_his_id := CSI_Instance_parties_vld_pvt.gen_inst_party_hist_id;
3163:
3164:
3165: select mod(l_object_version_number,l_full_dump_frequency)
3166: into l_mod_value

Line 4370: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

4366: END IF;
4367: -- Start API body
4368: --
4369: -- Check if all the required parameters are passed
4370: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
4371: ( p_instance_party_rec.instance_party_id ,
4372: ' p_instance_party_rec.instance_party_id ',
4373: l_api_name );
4374: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

Line 4374: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

4370: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
4371: ( p_instance_party_rec.instance_party_id ,
4372: ' p_instance_party_rec.instance_party_id ',
4373: l_api_name );
4374: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
4375: ( p_instance_party_rec.object_version_number ,
4376: ' p_instance_party_rec.object_version_number ',
4377: l_api_name );
4378:

Line 4380: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_partyID_Valid

4376: ' p_instance_party_rec.object_version_number ',
4377: l_api_name );
4378:
4379: -- Check if the instance party id is valid
4380: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_partyID_Valid
4381: (p_Instance_party_id => p_instance_party_rec.instance_party_id
4382: ,p_txn_type_id => p_txn_rec.transaction_type_id
4383: ,p_mode => 'E' -- Added for bug 3550541
4384: )

Line 4594: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

4590: END IF;
4591: -- Start API body
4592: --
4593: -- Check if all the required parameters are passed
4594: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
4595: ( p_party_account_rec.INSTANCE_PARTY_ID,
4596: ' p_party_account_rec.INSTANCE_PARTY_ID ',
4597: l_api_name );
4598:

Line 4599: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

4595: ( p_party_account_rec.INSTANCE_PARTY_ID,
4596: ' p_party_account_rec.INSTANCE_PARTY_ID ',
4597: l_api_name );
4598:
4599: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
4600: ( p_party_account_rec.PARTY_ACCOUNT_ID,
4601: ' p_party_account_rec.PARTY_ACCOUNT_ID ',
4602: l_api_name );
4603: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char

Line 4603: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char

4599: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
4600: ( p_party_account_rec.PARTY_ACCOUNT_ID,
4601: ' p_party_account_rec.PARTY_ACCOUNT_ID ',
4602: l_api_name );
4603: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char
4604: ( p_party_account_rec.RELATIONSHIP_TYPE_CODE,
4605: 'p_party_account_rec.RELATIONSHIP_TYPE_CODE',
4606: l_api_name );
4607:

Line 4734: IF CSI_Instance_parties_vld_pvt.Is_Account_Expired

4730: END;
4731: END IF;
4732: END IF; -- called from group check
4733: /* -- Commented by sk for fixing the bug 2232880
4734: IF CSI_Instance_parties_vld_pvt.Is_Account_Expired
4735: (p_party_account_rec) THEN
4736: IF (p_party_account_rec.ACTIVE_END_DATE = FND_API.G_MISS_DATE ) THEN
4737: p_party_account_rec.active_end_date := NULL;
4738: END IF;

Line 4779: IF CSI_Instance_parties_vld_pvt.Is_Pty_Acct_Comb_Exists

4775: -- END IF; -- commented by sk for fixing the bug 2232880
4776: ELSE -- Added by sk for fixing the bug 2232880
4777: -- Verify if the party account combination exists
4778: IF p_called_from_grp <> FND_API.G_TRUE THEN
4779: IF CSI_Instance_parties_vld_pvt.Is_Pty_Acct_Comb_Exists
4780: (p_party_account_rec.instance_party_id ,
4781: p_party_account_rec.party_account_id ,
4782: p_party_account_rec.relationship_type_code ) THEN
4783: RAISE FND_API.G_EXC_ERROR;

Line 4793: p_party_account_rec.IP_ACCOUNT_ID := CSI_Instance_parties_vld_pvt.gen_ip_account_id;

4789: -- If ip_account_id passed is null then generate from sequence
4790: -- and check if the value exists . If exists then generate again
4791: -- from the sequence till we get a value that does not exist
4792: while l_process_flag loop
4793: p_party_account_rec.IP_ACCOUNT_ID := CSI_Instance_parties_vld_pvt.gen_ip_account_id;
4794: IF NOT(CSI_Instance_parties_vld_pvt.Is_IP_account_Exists(p_party_account_rec.IP_ACCOUNT_ID,
4795: FALSE )) THEN
4796: l_process_flag := FALSE;
4797: END IF;

Line 4794: IF NOT(CSI_Instance_parties_vld_pvt.Is_IP_account_Exists(p_party_account_rec.IP_ACCOUNT_ID,

4790: -- and check if the value exists . If exists then generate again
4791: -- from the sequence till we get a value that does not exist
4792: while l_process_flag loop
4793: p_party_account_rec.IP_ACCOUNT_ID := CSI_Instance_parties_vld_pvt.gen_ip_account_id;
4794: IF NOT(CSI_Instance_parties_vld_pvt.Is_IP_account_Exists(p_party_account_rec.IP_ACCOUNT_ID,
4795: FALSE )) THEN
4796: l_process_flag := FALSE;
4797: END IF;
4798: end loop;

Line 4801: IF CSI_Instance_parties_vld_pvt.Is_IP_account_Exists(p_party_account_rec.IP_ACCOUNT_ID ,

4797: END IF;
4798: end loop;
4799: ELSE
4800: -- Validate the instance_party_id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
4801: IF CSI_Instance_parties_vld_pvt.Is_IP_account_Exists(p_party_account_rec.IP_ACCOUNT_ID ,
4802: TRUE ) THEN
4803: RAISE FND_API.G_EXC_ERROR;
4804: END IF;
4805: END IF;

Line 4832: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_partyID_Valid(

4828: --
4829: IF l_exists_flag <> 'Y' THEN
4830: p_account_count_rec.inst_party_count := p_account_count_rec.inst_party_count + 1;
4831: p_inst_party_tbl(p_account_count_rec.inst_party_count).instance_party_id := p_party_account_rec.INSTANCE_PARTY_ID;
4832: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_partyID_Valid(
4833: p_Instance_party_id => p_party_account_rec.INSTANCE_PARTY_ID
4834: ,p_txn_type_id => p_txn_rec.transaction_type_id
4835: ,p_mode => 'C' ) -- Added for bug 3550541
4836: )

Line 4851: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_accountID_Valid

4847: END IF;
4848: END IF; -- called from group check
4849: -- Verify Party Account ID is Valid
4850: IF p_called_from_grp <> FND_API.G_TRUE THEN
4851: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_accountID_Valid
4852: (p_party_account_rec.PARTY_ACCOUNT_ID,
4853: p_party_account_rec.INSTANCE_PARTY_ID,
4854: p_party_account_rec.RELATIONSHIP_TYPE_CODE,
4855: p_txn_rec.transaction_type_id, -- Added for bug 3550541

Line 4887: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_Rel_type_Valid

4883: IF l_exists_flag <> 'Y' THEN
4884: p_account_count_rec.rel_type_count := p_account_count_rec.rel_type_count + 1;
4885: p_acct_rel_type_tbl(p_account_count_rec.rel_type_count).rel_type_code :=
4886: p_party_account_rec.RELATIONSHIP_TYPE_CODE;
4887: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_Rel_type_Valid
4888: (p_party_account_rec.RELATIONSHIP_TYPE_CODE)) THEN
4889: p_acct_rel_type_tbl(p_account_count_rec.rel_type_count).valid_flag := 'N';
4890: RAISE FND_API.G_EXC_ERROR;
4891: ELSE

Line 4904: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_StartDate_Valid

4900: END IF;
4901:
4902: -- verify if the active_start_date is valid
4903: IF p_called_from_grp <> FND_API.G_TRUE THEN
4904: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_StartDate_Valid
4905: (p_party_account_rec.ACTIVE_START_DATE,
4906: p_party_account_rec.ACTIVE_END_DATE ,
4907: p_party_account_rec.INSTANCE_PARTY_ID )) THEN
4908: RAISE FND_API.G_EXC_ERROR;

Line 4914: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_EndDate_Valid

4910:
4911: -- Verify if the active_end_date is valid
4912: IF ((p_party_account_rec.ACTIVE_END_DATE is NOT NULL) AND
4913: (p_party_account_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE )) THEN
4914: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_EndDate_Valid
4915: (p_party_account_rec.ACTIVE_START_DATE,
4916: p_party_account_rec.ACTIVE_END_DATE ,
4917: p_party_account_rec.INSTANCE_PARTY_ID ,
4918: p_party_account_rec.IP_ACCOUNT_ID ,

Line 4955: IF NOT(CSI_Instance_parties_vld_pvt.Is_bill_to_add_valid

4951: p_account_count_rec.site_use_count := p_account_count_rec.site_use_count + 1;
4952: p_site_use_tbl(p_account_count_rec.site_use_count).site_use_id :=
4953: p_party_account_rec.bill_to_address;
4954: p_site_use_tbl(p_account_count_rec.site_use_count).site_use_code := 'BILL_TO';
4955: IF NOT(CSI_Instance_parties_vld_pvt.Is_bill_to_add_valid
4956: ( p_party_account_rec.bill_to_address)) THEN
4957: p_site_use_tbl(p_account_count_rec.site_use_count).valid_flag := 'N';
4958: RAISE FND_API.G_EXC_ERROR;
4959: ELSE

Line 4995: IF NOT(CSI_Instance_parties_vld_pvt.Is_ship_to_add_valid

4991: p_account_count_rec.site_use_count := p_account_count_rec.site_use_count + 1;
4992: p_site_use_tbl(p_account_count_rec.site_use_count).site_use_id :=
4993: p_party_account_rec.ship_to_address;
4994: p_site_use_tbl(p_account_count_rec.site_use_count).site_use_code := 'SHIP_TO';
4995: IF NOT(CSI_Instance_parties_vld_pvt.Is_ship_to_add_valid
4996: ( p_party_account_rec.ship_to_address)) THEN
4997: p_site_use_tbl(p_account_count_rec.site_use_count).valid_flag := 'N';
4998: RAISE FND_API.G_EXC_ERROR;
4999: ELSE

Line 5009: IF CSI_Instance_parties_vld_pvt.Acct_Rules_Check

5005: -- Following will not be done when called from Group API.
5006: -- Verify if it meets Account Rules
5007: IF p_called_from_grp <> FND_API.G_TRUE THEN
5008:
5009: IF CSI_Instance_parties_vld_pvt.Acct_Rules_Check
5010: (p_party_account_rec.instance_party_id ,
5011: p_party_account_rec.relationship_type_code ) THEN
5012: RAISE FND_API.G_EXC_ERROR;
5013: END IF;

Line 5016: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record

5012: RAISE FND_API.G_EXC_ERROR;
5013: END IF;
5014:
5015: -- Get the parent party record
5016: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record
5017: ( p_party_account_rec.instance_party_id,
5018: l_party_rec)) THEN
5019: RAISE FND_API.G_EXC_ERROR;
5020: END IF;

Line 5100: l_ip_account_history_id := CSI_Instance_parties_vld_pvt.gen_ip_account_hist_id;

5096: RAISE FND_API.G_EXC_ERROR;
5097: END IF;
5098:
5099: -- Generate a unique instance_party_history_id from the sequence
5100: l_ip_account_history_id := CSI_Instance_parties_vld_pvt.gen_ip_account_hist_id;
5101:
5102: CSI_IP_ACCOUNTS_H_PKG.Insert_Row
5103: (
5104: px_IP_ACCOUNT_HISTORY_ID => l_ip_account_history_id ,

Line 5468: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

5464:
5465: -- Start API body
5466: --
5467: -- Check if all the required parameters are passed
5468: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
5469: ( p_party_account_rec.ip_account_id ,
5470: ' p_party_account_rec.IP_ACCOUNT_ID ',
5471: l_api_name );
5472: --

Line 5511: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_partyID_Valid

5507: -- End addition by sguthiva for bug 2307804
5508:
5509: IF p_party_account_rec.INSTANCE_PARTY_ID <> FND_API.G_MISS_NUM THEN
5510: -- Check if the instance party id is valid
5511: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_partyID_Valid
5512: (p_Instance_party_id => p_party_account_rec.INSTANCE_PARTY_ID
5513: ,p_txn_type_id => p_txn_rec.transaction_type_id
5514: ,p_mode => 'U' -- Added for bug 3550541
5515: )

Line 5562: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_partyID_Valid

5558: -- End addition
5559: END IF;
5560: ELSE
5561: -- srramakr Updates not allowed for Expired instance. Bug # 2477417
5562: IF NOT(CSI_Instance_parties_vld_pvt.Is_Inst_partyID_Valid
5563: (p_Instance_party_id => l_curr_party_acct_rec.INSTANCE_PARTY_ID
5564: ,p_txn_type_id => p_txn_rec.transaction_type_id
5565: ,p_mode => 'U' -- Added for bug 3550541
5566: )

Line 5572: l_party_relation := CSI_Instance_parties_vld_pvt.Get_Party_relation

5568: THEN
5569: RAISE FND_API.G_EXC_ERROR;
5570: END IF;
5571: END IF;
5572: l_party_relation := CSI_Instance_parties_vld_pvt.Get_Party_relation
5573: (l_curr_party_acct_rec.Instance_party_id);
5574: --
5575: IF p_party_account_rec.active_start_date IS NULL THEN
5576: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

Line 5623: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_EndDate_Valid

5619:
5620: -- Verify if the active_end_date is valid
5621: IF p_party_account_rec.expire_flag = fnd_api.g_false THEN -- Added by sguthiva for bug 2307804
5622: -- IF (g_expire_account_flag <> 'Y') THEN -- Commented by sguthiva for bug 2307804
5623: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_EndDate_Valid
5624: (l_curr_party_acct_rec.ACTIVE_START_DATE,
5625: p_party_account_rec.ACTIVE_END_DATE ,
5626: p_party_account_rec.INSTANCE_PARTY_ID ,
5627: p_party_account_rec.IP_ACCOUNT_ID ,

Line 5665: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_Rel_type_Valid

5661: FND_MSG_PUB.ADD;
5662: RAISE FND_API.G_EXC_ERROR;
5663: ELSE
5664: -- Verify the relationship_type_code is valid
5665: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_Rel_type_Valid
5666: (p_party_account_rec.RELATIONSHIP_TYPE_CODE)) THEN
5667: RAISE FND_API.G_EXC_ERROR;
5668: END IF;
5669: END IF;

Line 5693: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_accountID_Valid

5689: (p_party_account_rec.ACTIVE_END_DATE IS NOT NULL AND
5690: p_party_account_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE AND
5691: p_party_account_rec.ACTIVE_END_DATE > SYSDATE)
5692: THEN
5693: IF NOT(CSI_Instance_parties_vld_pvt.Is_Pty_accountID_Valid
5694: (p_party_account_rec.PARTY_ACCOUNT_ID,
5695: l_instance_party_id, --l_curr_party_acct_rec.INSTANCE_PARTY_ID,
5696: p_party_account_rec.RELATIONSHIP_TYPE_CODE,
5697: p_txn_rec.transaction_type_id, -- Added for bug 3550541

Line 5714: IF NOT(CSI_Instance_parties_vld_pvt.Is_bill_to_add_valid

5710: END IF;
5711:
5712: -- Verify if bill to address is correct
5713: IF p_party_account_rec.bill_to_address <> FND_API.G_MISS_NUM THEN
5714: IF NOT(CSI_Instance_parties_vld_pvt.Is_bill_to_add_valid
5715: ( p_party_account_rec.bill_to_address)) THEN
5716: RAISE FND_API.G_EXC_ERROR;
5717: END IF;
5718: END IF;

Line 5723: IF NOT(CSI_Instance_parties_vld_pvt.Is_ship_to_add_valid

5719:
5720:
5721: -- Verify if ship to address is correct
5722: IF p_party_account_rec.ship_to_address <> FND_API.G_MISS_NUM THEN
5723: IF NOT(CSI_Instance_parties_vld_pvt.Is_ship_to_add_valid
5724: ( p_party_account_rec.ship_to_address)) THEN
5725: RAISE FND_API.G_EXC_ERROR;
5726: END IF;
5727: END IF;

Line 5795: IF CSI_Instance_parties_vld_pvt.Is_Pty_Acct_Comb_Exists

5791: l_temp_acct_date := p_party_account_rec.active_end_date;
5792: END;
5793:
5794: ELSE
5795: IF CSI_Instance_parties_vld_pvt.Is_Pty_Acct_Comb_Exists
5796: (l_alt_pk_inst_pty_id ,
5797: l_alt_pk_pty_acct_id ,
5798: l_alt_pk_rel_type_code ) THEN
5799: RAISE FND_API.G_EXC_ERROR;

Line 5809: IF CSI_Instance_parties_vld_pvt.Acct_Rules_Check

5805: IF ((l_alt_pk_inst_pty_id <> l_curr_party_acct_rec.instance_party_id)
5806: OR
5807: (l_alt_pk_rel_type_code <> l_curr_party_acct_rec.relationship_type_code))
5808: THEN
5809: IF CSI_Instance_parties_vld_pvt.Acct_Rules_Check
5810: (l_alt_pk_inst_pty_id ,
5811: l_alt_pk_rel_type_code ) THEN
5812: RAISE FND_API.G_EXC_ERROR;
5813: END IF;

Line 5817: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record

5813: END IF;
5814: END IF;
5815:
5816: -- Get party record for later use in contaracts
5817: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record
5818: (l_curr_party_acct_rec.instance_party_id,
5819: l_party_rec)) THEN
5820: RAISE FND_API.G_EXC_ERROR;
5821: END IF;

Line 5916: l_ip_account_history_id := CSI_Instance_parties_vld_pvt.gen_ip_account_hist_id;

5912:
5913:
5914:
5915: -- Generate a unique instance_party_history_id from the sequence
5916: l_ip_account_history_id := CSI_Instance_parties_vld_pvt.gen_ip_account_hist_id;
5917:
5918: -- Get the full_dump_frequency from csi_install_parameter
5919: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5920: csi_gen_utility_pvt.populate_install_param_rec;

Line 7229: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

7225: END IF;
7226: -- Start API body
7227: --
7228: -- Check if all the required parameters are passed
7229: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
7230: ( p_party_account_rec.ip_account_id,
7231: ' p_party_account_rec.ip_account_id ',
7232: l_api_name );
7233:

Line 7234: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

7230: ( p_party_account_rec.ip_account_id,
7231: ' p_party_account_rec.ip_account_id ',
7232: l_api_name );
7233:
7234: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
7235: ( p_party_account_rec.object_version_number,
7236: ' p_party_account_rec.object_version_number ',
7237: l_api_name );
7238:

Line 7241: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ip_account_Valid

7237: l_api_name );
7238:
7239:
7240: -- Check if the instance party id is valid
7241: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ip_account_Valid
7242: (p_party_account_rec.ip_account_id))THEN
7243: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
7244: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_party_account_rec.ip_account_id);
7245: FND_MSG_PUB.Add;