DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on STANDARD

Line 1455: -- Standard Start of API savepoint

1451: l_valid_flag VARCHAR2(1);
1452: l_exists VARCHAR2(1);
1453:
1454: BEGIN
1455: -- Standard Start of API savepoint
1456: SAVEPOINT create_inst_party_rel_pvt;
1457:
1458: -- Standard call to check for call compatibility.
1459: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 1458: -- Standard call to check for call compatibility.

1454: BEGIN
1455: -- Standard Start of API savepoint
1456: SAVEPOINT create_inst_party_rel_pvt;
1457:
1458: -- Standard call to check for call compatibility.
1459: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1460: p_api_version ,
1461: l_api_name ,
1462: g_pkg_name )

Line 2197: -- Standard check of p_commit.

2193:
2194: --
2195: -- End of API body
2196:
2197: -- Standard check of p_commit.
2198: IF FND_API.To_Boolean( p_commit ) THEN
2199: COMMIT WORK;
2200: END IF;
2201:

Line 2203: -- Standard call to get message count and if count is get message info.

2199: COMMIT WORK;
2200: END IF;
2201:
2202:
2203: -- Standard call to get message count and if count is get message info.
2204: FND_MSG_PUB.Count_And_Get
2205: (p_count => x_msg_count ,
2206: p_data => x_msg_data );
2207: EXCEPTION

Line 2561: -- Standard Start of API savepoint

2557: l_party_hist_rec csi_datastructures_pub.party_history_rec;
2558: l_ins_pty_found NUMBER;
2559: l_pty_end_date DATE;
2560: BEGIN
2561: -- Standard Start of API savepoint
2562: -- SAVEPOINT update_inst_party_rel_pvt ;
2563:
2564: -- Standard call to check for call compatibility.
2565: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 2564: -- Standard call to check for call compatibility.

2560: BEGIN
2561: -- Standard Start of API savepoint
2562: -- SAVEPOINT update_inst_party_rel_pvt ;
2563:
2564: -- Standard call to check for call compatibility.
2565: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2566: p_api_version ,
2567: l_api_name ,
2568: g_pkg_name )

Line 4217: -- Standard check of p_commit.

4213: END IF;
4214: END LOOP;
4215: END IF;
4216: -- End of API body
4217: -- Standard check of p_commit.
4218: IF FND_API.To_Boolean( p_commit ) THEN
4219: COMMIT WORK;
4220: END IF;
4221: -- Standard call to get message count and if count is get message info.

Line 4221: -- Standard call to get message count and if count is get message info.

4217: -- Standard check of p_commit.
4218: IF FND_API.To_Boolean( p_commit ) THEN
4219: COMMIT WORK;
4220: END IF;
4221: -- Standard call to get message count and if count is get message info.
4222: FND_MSG_PUB.Count_And_Get
4223: (p_count => x_msg_count ,
4224: p_data => x_msg_data );
4225: EXCEPTION

Line 4327: -- Standard Start of API savepoint

4323: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
4324: FOR UPDATE OF OBJECT_VERSION_NUMBER;
4325:
4326: BEGIN
4327: -- Standard Start of API savepoint
4328: -- SAVEPOINT expire_inst_party_rel_pvt;
4329:
4330: -- Standard call to check for call compatibility.
4331: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 4330: -- Standard call to check for call compatibility.

4326: BEGIN
4327: -- Standard Start of API savepoint
4328: -- SAVEPOINT expire_inst_party_rel_pvt;
4329:
4330: -- Standard call to check for call compatibility.
4331: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4332: p_api_version ,
4333: l_api_name ,
4334: g_pkg_name )

Line 4466: -- Standard check of p_commit.

4462: END IF;
4463: --
4464: -- End of API body
4465:
4466: -- Standard check of p_commit.
4467: IF FND_API.To_Boolean( p_commit ) THEN
4468: COMMIT WORK;
4469: END IF;
4470: -- Standard call to get message count and if count is get message info.

Line 4470: -- Standard call to get message count and if count is get message info.

4466: -- Standard check of p_commit.
4467: IF FND_API.To_Boolean( p_commit ) THEN
4468: COMMIT WORK;
4469: END IF;
4470: -- Standard call to get message count and if count is get message info.
4471: FND_MSG_PUB.Count_And_Get
4472: (p_count => x_msg_count ,
4473: p_data => x_msg_data );
4474: EXCEPTION

Line 4553: -- Standard Start of API savepoint

4549: WHERE instance_id = p_ins_id;
4550: l_instance_csr instance_csr%ROWTYPE;
4551: l_last_vld_org NUMBER; -- Added by sguthiva for bug 2307804
4552: BEGIN
4553: -- Standard Start of API savepoint
4554: SAVEPOINT create_inst_party_acct_pvt;
4555:
4556: -- Standard call to check for call compatibility.
4557: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 4556: -- Standard call to check for call compatibility.

4552: BEGIN
4553: -- Standard Start of API savepoint
4554: SAVEPOINT create_inst_party_acct_pvt;
4555:
4556: -- Standard call to check for call compatibility.
4557: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4558: p_api_version ,
4559: l_api_name ,
4560: g_pkg_name )

Line 5227: -- Standard check of p_commit.

5223: END IF; -- Added by sk for bug 2110790
5224: -- End addition by sguthiva for bug 2307804
5225: --
5226: -- End of API body
5227: -- Standard check of p_commit.
5228:
5229: IF FND_API.To_Boolean( p_commit ) THEN
5230: COMMIT WORK;
5231: END IF;

Line 5234: -- Standard call to get message count and if count is get message info.

5230: COMMIT WORK;
5231: END IF;
5232:
5233:
5234: -- Standard call to get message count and if count is get message info.
5235: FND_MSG_PUB.Count_And_Get
5236: (p_count => x_msg_count ,
5237: p_data => x_msg_data );
5238: EXCEPTION

Line 5425: -- Standard Start of API savepoint

5421: l_found_for_update VARCHAR2(1):='N';
5422: l_dummy VARCHAR2(1);
5423: l_instance_party_id NUMBER;
5424: BEGIN
5425: -- Standard Start of API savepoint
5426: -- SAVEPOINT update_inst_party_acct_pvt;
5427:
5428:
5429: -- Standard call to check for call compatibility.

Line 5429: -- Standard call to check for call compatibility.

5425: -- Standard Start of API savepoint
5426: -- SAVEPOINT update_inst_party_acct_pvt;
5427:
5428:
5429: -- Standard call to check for call compatibility.
5430: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5431: p_api_version ,
5432: l_api_name ,
5433: g_pkg_name )

Line 7080: -- Standard check of p_commit.

7076: END IF;
7077: -- End addition by sguthiva for bug 2307804
7078: --
7079: -- End of API body
7080: -- Standard check of p_commit.
7081: IF FND_API.To_Boolean( p_commit ) THEN
7082: COMMIT WORK;
7083: END IF;
7084: -- Standard call to get message count and if count is get message info.

Line 7084: -- Standard call to get message count and if count is get message info.

7080: -- Standard check of p_commit.
7081: IF FND_API.To_Boolean( p_commit ) THEN
7082: COMMIT WORK;
7083: END IF;
7084: -- Standard call to get message count and if count is get message info.
7085: FND_MSG_PUB.Count_And_Get
7086: (p_count => x_msg_count ,
7087: p_data => x_msg_data );
7088: EXCEPTION

Line 7186: -- Standard Start of API savepoint

7182:
7183: l_curr_party_acct_rec get_curr_party_acct_rec%ROWTYPE;
7184:
7185: BEGIN
7186: -- Standard Start of API savepoint
7187: SAVEPOINT expire_inst_party_acct_pvt;
7188:
7189: -- Standard call to check for call compatibility.
7190: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 7189: -- Standard call to check for call compatibility.

7185: BEGIN
7186: -- Standard Start of API savepoint
7187: SAVEPOINT expire_inst_party_acct_pvt;
7188:
7189: -- Standard call to check for call compatibility.
7190: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7191: p_api_version ,
7192: l_api_name ,
7193: g_pkg_name )

Line 7333: -- Standard check of p_commit.

7329: --
7330: -- Commented the tablehandler call since Update API got invoked
7331: --
7332: -- End of API body
7333: -- Standard check of p_commit.
7334: IF FND_API.To_Boolean( p_commit ) THEN
7335: COMMIT WORK;
7336: END IF;
7337: -- Standard call to get message count and if count is get message info.

Line 7337: -- Standard call to get message count and if count is get message info.

7333: -- Standard check of p_commit.
7334: IF FND_API.To_Boolean( p_commit ) THEN
7335: COMMIT WORK;
7336: END IF;
7337: -- Standard call to get message count and if count is get message info.
7338: FND_MSG_PUB.Count_And_Get
7339: (p_count => x_msg_count ,
7340: p_data => x_msg_data );
7341: EXCEPTION

Line 7396: -- Standard Start of API savepoint

7392: l_csi_debug_level NUMBER;
7393:
7394:
7395: BEGIN
7396: -- Standard Start of API savepoint
7397: -- SAVEPOINT get_contact_details_pvt;
7398:
7399: -- Standard call to check for call compatibility.
7400: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 7399: -- Standard call to check for call compatibility.

7395: BEGIN
7396: -- Standard Start of API savepoint
7397: -- SAVEPOINT get_contact_details_pvt;
7398:
7399: -- Standard call to check for call compatibility.
7400: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7401: p_api_version ,
7402: l_api_name ,
7403: g_pkg_name )

Line 7753: -- Standard check of p_commit.

7749: x_contact_details.contact_party_id := p_contact_party_id;
7750: --
7751: -- End of API body
7752:
7753: -- Standard check of p_commit.
7754: /*
7755: IF FND_API.To_Boolean( p_commit ) THEN
7756: COMMIT WORK;
7757: END IF;

Line 7760: -- Standard call to get message count and if count is get message info.

7756: COMMIT WORK;
7757: END IF;
7758: */
7759:
7760: -- Standard call to get message count and if count is get message info.
7761: FND_MSG_PUB.Count_And_Get
7762: (p_count => x_msg_count ,
7763: p_data => x_msg_data );
7764: EXCEPTION

Line 7900: -- Standard Start of API savepoint

7896: l_party_query_rec csi_datastructures_pub.party_query_rec;
7897: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7898: -- End addition for bug 2781480
7899: BEGIN
7900: -- Standard Start of API savepoint
7901: -- SAVEPOINT get_inst_party_rel_hist;
7902:
7903:
7904: -- Standard call to check for call compatibility.

Line 7904: -- Standard call to check for call compatibility.

7900: -- Standard Start of API savepoint
7901: -- SAVEPOINT get_inst_party_rel_hist;
7902:
7903:
7904: -- Standard call to check for call compatibility.
7905: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7906: p_api_version ,
7907: l_api_name ,
7908: g_pkg_name )

Line 8482: -- Standard check of p_commit.

8478: END LOOP;
8479:
8480: -- End of API body
8481:
8482: -- Standard check of p_commit.
8483: /*
8484: IF FND_API.To_Boolean( p_commit ) THEN
8485: COMMIT WORK;
8486: END IF;

Line 8497: -- Standard call to get message count and if count is get message info.

8493: END IF;
8494: -- End disable trace
8495: ****/
8496:
8497: -- Standard call to get message count and if count is get message info.
8498: FND_MSG_PUB.Count_And_Get
8499: (p_count => x_msg_count ,
8500: p_data => x_msg_data );
8501: EXCEPTION

Line 8621: -- Standard Start of API savepoint

8617: AND cah.ip_account_id = ca.ip_account_id
8618: AND ca.instance_party_id = cip.instance_party_id; -- Added by sguthiva on 9-APR for bug 2304649
8619:
8620: BEGIN
8621: -- Standard Start of API savepoint
8622: -- SAVEPOINT get_inst_party_account_hist;
8623:
8624:
8625: -- Standard call to check for call compatibility.

Line 8625: -- Standard call to check for call compatibility.

8621: -- Standard Start of API savepoint
8622: -- SAVEPOINT get_inst_party_account_hist;
8623:
8624:
8625: -- Standard call to check for call compatibility.
8626: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
8627: p_api_version ,
8628: l_api_name ,
8629: g_pkg_name )

Line 9043: -- Standard check of p_commit.

9039: END LOOP;
9040:
9041: -- End of API body
9042:
9043: -- Standard check of p_commit.
9044: /*
9045: IF FND_API.To_Boolean( p_commit ) THEN
9046: COMMIT WORK;
9047: END IF;

Line 9058: -- Standard call to get message count and if count is get message info.

9054: END IF;
9055: -- End disable trace
9056: ****/
9057:
9058: -- Standard call to get message count and if count is get message info.
9059: FND_MSG_PUB.Count_And_Get
9060: (p_count => x_msg_count ,
9061: p_data => x_msg_data );
9062: EXCEPTION