[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
826: l_old_parent_owner_pty_acct_id NUMBER;
827: l_old_child_owner_pty_acct_id NUMBER;
828: -- End of code addition for fixing bug 6368172, section 1 of 5
829: BEGIN
830: -- Standard Start of API savepoint
831: SAVEPOINT update_inst_party_rel_pub ;
832:
833: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
834:
833: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
834:
835: csi_utility_grp.check_ib_active;
836:
837: -- Standard call to check for call compatibility.
838: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
839: p_api_version ,
840: l_api_name ,
841: g_pkg_name )
1873: -- code written by sk on 12/06/01 for fixing TRF bug 2133944
1874: -- End of API body
1875:
1876:
1877: -- Standard check of p_commit.
1878: IF FND_API.To_Boolean( p_commit ) THEN
1879: COMMIT WORK;
1880: END IF;
1881:
1886: END IF;
1887: -- End disable trace
1888: ****/
1889:
1890: -- Standard call to get message count and if count is get message info.
1891: FND_MSG_PUB.Count_And_Get
1892: (p_count => x_msg_count ,
1893: p_data => x_msg_data );
1894: EXCEPTION
1945: l_line_count NUMBER;
1946: l_flag VARCHAR2(1) :='N';
1947:
1948: BEGIN
1949: -- Standard Start of API savepoint
1950: SAVEPOINT expire_inst_party_rel_pub;
1951:
1952: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
1953:
1952: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
1953:
1954: csi_utility_grp.check_ib_active;
1955:
1956: -- Standard call to check for call compatibility.
1957: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1958: p_api_version ,
1959: l_api_name ,
1960: g_pkg_name )
2030: END IF;
2031: --
2032: -- End of API body
2033:
2034: -- Standard check of p_commit.
2035: IF FND_API.To_Boolean( p_commit ) THEN
2036: COMMIT WORK;
2037: END IF;
2038:
2043: END IF;
2044: -- End disable trace
2045: ****/
2046:
2047: -- Standard call to get message count and if count is get message info.
2048: FND_MSG_PUB.Count_And_Get
2049: (p_count => x_msg_count ,
2050: p_data => x_msg_data );
2051: EXCEPTION
2119: ' object_version_number, bill_to_address, ship_to_address from csi_ip_accounts ';
2120:
2121:
2122: BEGIN
2123: -- Standard Start of API savepoint
2124: -- SAVEPOINT get_inst_party_acct_pub;
2125:
2126: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2127:
2127:
2128: csi_utility_grp.check_ib_active;
2129:
2130:
2131: -- Standard call to check for call compatibility.
2132: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2133: p_api_version ,
2134: l_api_name ,
2135: g_pkg_name )
2241:
2242: --
2243: -- End of API body
2244:
2245: -- Standard check of p_commit.
2246: /*
2247: IF FND_API.To_Boolean( p_commit ) THEN
2248: COMMIT WORK;
2249: END IF;
2256: END IF;
2257: -- End disable trace
2258: ****/
2259:
2260: -- Standard call to get message count and if count is get message info.
2261: FND_MSG_PUB.Count_And_Get
2262: (p_count => x_msg_count ,
2263: p_data => x_msg_data );
2264: EXCEPTION
2324: --
2325: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2326:
2327: BEGIN
2328: -- Standard Start of API savepoint
2329: SAVEPOINT create_inst_party_acct_pub;
2330:
2331: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2332:
2332:
2333: csi_utility_grp.check_ib_active;
2334:
2335:
2336: -- Standard call to check for call compatibility.
2337: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2338: p_api_version ,
2339: l_api_name ,
2340: g_pkg_name )
2418: END IF;
2419: --
2420: -- End of API body
2421:
2422: -- Standard check of p_commit.
2423: IF FND_API.To_Boolean( p_commit ) THEN
2424: COMMIT WORK;
2425: END IF;
2426:
2431: END IF;
2432: -- End disable trace
2433: ****/
2434:
2435: -- Standard call to get message count and if count is get message info.
2436: FND_MSG_PUB.Count_And_Get
2437: (p_count => x_msg_count ,
2438: p_data => x_msg_data );
2439: EXCEPTION
2511: l_object_id NUMBER;
2512: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2513: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2514: BEGIN
2515: -- Standard Start of API savepoint
2516: SAVEPOINT update_inst_party_acct_pub;
2517:
2518: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2519:
2519:
2520: csi_utility_grp.check_ib_active;
2521:
2522:
2523: -- Standard call to check for call compatibility.
2524: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2525: p_api_version ,
2526: l_api_name ,
2527: g_pkg_name )
2758: -- End of fix for bug 2151750
2759: --
2760: -- End of API body
2761:
2762: -- Standard check of p_commit.
2763: IF FND_API.To_Boolean( p_commit ) THEN
2764: COMMIT WORK;
2765: END IF;
2766:
2771: END IF;
2772: -- End disable trace
2773: ****/
2774:
2775: -- Standard call to get message count and if count is get message info.
2776: FND_MSG_PUB.Count_And_Get
2777: (p_count => x_msg_count ,
2778: p_data => x_msg_data );
2779: EXCEPTION
2832: l_ip_account_id NUMBER ;
2833: l_flag VARCHAR2(1) :='N';
2834:
2835: BEGIN
2836: -- Standard Start of API savepoint
2837: SAVEPOINT expire_inst_party_acct_pub;
2838:
2839: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2840:
2840:
2841: csi_utility_grp.check_ib_active;
2842:
2843:
2844: -- Standard call to check for call compatibility.
2845: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2846: p_api_version ,
2847: l_api_name ,
2848: g_pkg_name )
2919: END IF;
2920: --
2921: -- End of API body
2922:
2923: -- Standard check of p_commit.
2924: IF FND_API.To_Boolean( p_commit ) THEN
2925: COMMIT WORK;
2926: END IF;
2927:
2932: END IF;
2933: -- End disable trace
2934: ****/
2935:
2936: -- Standard call to get message count and if count is get message info.
2937: FND_MSG_PUB.Count_And_Get
2938: (p_count => x_msg_count ,
2939: p_data => x_msg_data );
2940: EXCEPTION