[Home] [Help]
47: ' FROM CSI_I_PARTIES ';
48: l_pty_name VARCHAR2(360);
49:
50: BEGIN
51: -- Standard Start of API savepoint
52: -- SAVEPOINT get_inst_party_rel_pub;
53:
54: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
55:
54: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
55:
56: csi_utility_grp.check_ib_active;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
60: p_api_version ,
61: l_api_name ,
62: g_pkg_name )
303: --end of the new code for resolve_id_columns 08/24/01
304: --
305: -- End of API body
306:
307: -- Standard check of p_commit.
308: /*
309: IF FND_API.To_Boolean( p_commit ) THEN
310: COMMIT WORK;
311: END IF;
318: END IF;
319: -- End disable trace
320: ****/
321:
322: -- Standard call to get message count and if count is get message info.
323: FND_MSG_PUB.Count_And_Get
324: (p_count => x_msg_count ,
325: p_data => x_msg_data );
326: EXCEPTION
392: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
393: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
394: l_account_found VARCHAR2(1) :=NULL;
395: BEGIN
396: -- Standard Start of API savepoint
397: SAVEPOINT create_inst_party_rel_pub;
398:
399: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
400:
399: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
400:
401: csi_utility_grp.check_ib_active;
402:
403: -- Standard call to check for call compatibility.
404: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
405: p_api_version ,
406: l_api_name ,
407: g_pkg_name )
649:
650:
651: --
652: -- End of API body
653: -- Standard check of p_commit.
654:
655: IF FND_API.To_Boolean( p_commit ) THEN
656: COMMIT WORK;
657: END IF;
663: END IF;
664: -- End disable trace
665: ****/
666:
667: -- Standard call to get message count and if count is get message info.
668: FND_MSG_PUB.Count_And_Get
669: (p_count => x_msg_count ,
670: p_data => x_msg_data );
671: EXCEPTION
831: l_old_parent_owner_pty_acct_id NUMBER;
832: l_old_child_owner_pty_acct_id NUMBER;
833: -- End of code addition for fixing bug 6368172, section 1 of 5
834: BEGIN
835: -- Standard Start of API savepoint
836: SAVEPOINT update_inst_party_rel_pub ;
837:
838: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
839:
838: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
839:
840: csi_utility_grp.check_ib_active;
841:
842: -- Standard call to check for call compatibility.
843: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
844: p_api_version ,
845: l_api_name ,
846: g_pkg_name )
1922: -- code written by sk on 12/06/01 for fixing TRF bug 2133944
1923: -- End of API body
1924:
1925:
1926: -- Standard check of p_commit.
1927: IF FND_API.To_Boolean( p_commit ) THEN
1928: COMMIT WORK;
1929: END IF;
1930:
1935: END IF;
1936: -- End disable trace
1937: ****/
1938:
1939: -- Standard call to get message count and if count is get message info.
1940: FND_MSG_PUB.Count_And_Get
1941: (p_count => x_msg_count ,
1942: p_data => x_msg_data );
1943: EXCEPTION
1994: l_line_count NUMBER;
1995: l_flag VARCHAR2(1) :='N';
1996:
1997: BEGIN
1998: -- Standard Start of API savepoint
1999: SAVEPOINT expire_inst_party_rel_pub;
2000:
2001: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2002:
2001: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2002:
2003: csi_utility_grp.check_ib_active;
2004:
2005: -- Standard call to check for call compatibility.
2006: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2007: p_api_version ,
2008: l_api_name ,
2009: g_pkg_name )
2079: END IF;
2080: --
2081: -- End of API body
2082:
2083: -- Standard check of p_commit.
2084: IF FND_API.To_Boolean( p_commit ) THEN
2085: COMMIT WORK;
2086: END IF;
2087:
2092: END IF;
2093: -- End disable trace
2094: ****/
2095:
2096: -- Standard call to get message count and if count is get message info.
2097: FND_MSG_PUB.Count_And_Get
2098: (p_count => x_msg_count ,
2099: p_data => x_msg_data );
2100: EXCEPTION
2168: ' object_version_number, bill_to_address, ship_to_address from csi_ip_accounts ';
2169:
2170:
2171: BEGIN
2172: -- Standard Start of API savepoint
2173: -- SAVEPOINT get_inst_party_acct_pub;
2174:
2175: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2176:
2176:
2177: csi_utility_grp.check_ib_active;
2178:
2179:
2180: -- Standard call to check for call compatibility.
2181: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2182: p_api_version ,
2183: l_api_name ,
2184: g_pkg_name )
2290:
2291: --
2292: -- End of API body
2293:
2294: -- Standard check of p_commit.
2295: /*
2296: IF FND_API.To_Boolean( p_commit ) THEN
2297: COMMIT WORK;
2298: END IF;
2305: END IF;
2306: -- End disable trace
2307: ****/
2308:
2309: -- Standard call to get message count and if count is get message info.
2310: FND_MSG_PUB.Count_And_Get
2311: (p_count => x_msg_count ,
2312: p_data => x_msg_data );
2313: EXCEPTION
2373: --
2374: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2375:
2376: BEGIN
2377: -- Standard Start of API savepoint
2378: SAVEPOINT create_inst_party_acct_pub;
2379:
2380: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2381:
2381:
2382: csi_utility_grp.check_ib_active;
2383:
2384:
2385: -- Standard call to check for call compatibility.
2386: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2387: p_api_version ,
2388: l_api_name ,
2389: g_pkg_name )
2467: END IF;
2468: --
2469: -- End of API body
2470:
2471: -- Standard check of p_commit.
2472: IF FND_API.To_Boolean( p_commit ) THEN
2473: COMMIT WORK;
2474: END IF;
2475:
2480: END IF;
2481: -- End disable trace
2482: ****/
2483:
2484: -- Standard call to get message count and if count is get message info.
2485: FND_MSG_PUB.Count_And_Get
2486: (p_count => x_msg_count ,
2487: p_data => x_msg_data );
2488: EXCEPTION
2560: l_object_id NUMBER;
2561: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2562: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2563: BEGIN
2564: -- Standard Start of API savepoint
2565: SAVEPOINT update_inst_party_acct_pub;
2566:
2567: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2568:
2568:
2569: csi_utility_grp.check_ib_active;
2570:
2571:
2572: -- Standard call to check for call compatibility.
2573: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2574: p_api_version ,
2575: l_api_name ,
2576: g_pkg_name )
2807: -- End of fix for bug 2151750
2808: --
2809: -- End of API body
2810:
2811: -- Standard check of p_commit.
2812: IF FND_API.To_Boolean( p_commit ) THEN
2813: COMMIT WORK;
2814: END IF;
2815:
2820: END IF;
2821: -- End disable trace
2822: ****/
2823:
2824: -- Standard call to get message count and if count is get message info.
2825: FND_MSG_PUB.Count_And_Get
2826: (p_count => x_msg_count ,
2827: p_data => x_msg_data );
2828: EXCEPTION
2881: l_ip_account_id NUMBER ;
2882: l_flag VARCHAR2(1) :='N';
2883:
2884: BEGIN
2885: -- Standard Start of API savepoint
2886: SAVEPOINT expire_inst_party_acct_pub;
2887:
2888: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2889:
2889:
2890: csi_utility_grp.check_ib_active;
2891:
2892:
2893: -- Standard call to check for call compatibility.
2894: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2895: p_api_version ,
2896: l_api_name ,
2897: g_pkg_name )
2968: END IF;
2969: --
2970: -- End of API body
2971:
2972: -- Standard check of p_commit.
2973: IF FND_API.To_Boolean( p_commit ) THEN
2974: COMMIT WORK;
2975: END IF;
2976:
2981: END IF;
2982: -- End disable trace
2983: ****/
2984:
2985: -- Standard call to get message count and if count is get message info.
2986: FND_MSG_PUB.Count_And_Get
2987: (p_count => x_msg_count ,
2988: p_data => x_msg_data );
2989: EXCEPTION