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 2564: -- Standard Start of API savepoint

2560: l_pty_end_date DATE;
2561:
2562: l_inst_just_expired VARCHAR2(1) := FND_API.G_FALSE; --Added for bug 7517240
2563: BEGIN
2564: -- Standard Start of API savepoint
2565: -- SAVEPOINT update_inst_party_rel_pvt ;
2566:
2567: -- Standard call to check for call compatibility.
2568: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

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

Line 4256: -- Standard check of p_commit.

4252: END IF;
4253: END LOOP;
4254: END IF;
4255: -- End of API body
4256: -- Standard check of p_commit.
4257: IF FND_API.To_Boolean( p_commit ) THEN
4258: COMMIT WORK;
4259: END IF;
4260: -- Standard call to get message count and if count is get message info.

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

4256: -- Standard check of p_commit.
4257: IF FND_API.To_Boolean( p_commit ) THEN
4258: COMMIT WORK;
4259: END IF;
4260: -- Standard call to get message count and if count is get message info.
4261: FND_MSG_PUB.Count_And_Get
4262: (p_count => x_msg_count ,
4263: p_data => x_msg_data );
4264: EXCEPTION

Line 4366: -- Standard Start of API savepoint

4362: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
4363: FOR UPDATE OF OBJECT_VERSION_NUMBER;
4364:
4365: BEGIN
4366: -- Standard Start of API savepoint
4367: -- SAVEPOINT expire_inst_party_rel_pvt;
4368:
4369: -- Standard call to check for call compatibility.
4370: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

4365: BEGIN
4366: -- Standard Start of API savepoint
4367: -- SAVEPOINT expire_inst_party_rel_pvt;
4368:
4369: -- Standard call to check for call compatibility.
4370: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4371: p_api_version ,
4372: l_api_name ,
4373: g_pkg_name )

Line 4505: -- Standard check of p_commit.

4501: END IF;
4502: --
4503: -- End of API body
4504:
4505: -- Standard check of p_commit.
4506: IF FND_API.To_Boolean( p_commit ) THEN
4507: COMMIT WORK;
4508: END IF;
4509: -- Standard call to get message count and if count is get message info.

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

4505: -- Standard check of p_commit.
4506: IF FND_API.To_Boolean( p_commit ) THEN
4507: COMMIT WORK;
4508: END IF;
4509: -- Standard call to get message count and if count is get message info.
4510: FND_MSG_PUB.Count_And_Get
4511: (p_count => x_msg_count ,
4512: p_data => x_msg_data );
4513: EXCEPTION

Line 4592: -- Standard Start of API savepoint

4588: WHERE instance_id = p_ins_id;
4589: l_instance_csr instance_csr%ROWTYPE;
4590: l_last_vld_org NUMBER; -- Added by sguthiva for bug 2307804
4591: BEGIN
4592: -- Standard Start of API savepoint
4593: SAVEPOINT create_inst_party_acct_pvt;
4594:
4595: -- Standard call to check for call compatibility.
4596: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

4591: BEGIN
4592: -- Standard Start of API savepoint
4593: SAVEPOINT create_inst_party_acct_pvt;
4594:
4595: -- Standard call to check for call compatibility.
4596: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4597: p_api_version ,
4598: l_api_name ,
4599: g_pkg_name )

Line 5268: -- Standard check of p_commit.

5264: END IF; -- Added by sk for bug 2110790
5265: -- End addition by sguthiva for bug 2307804
5266: --
5267: -- End of API body
5268: -- Standard check of p_commit.
5269:
5270: IF FND_API.To_Boolean( p_commit ) THEN
5271: COMMIT WORK;
5272: END IF;

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

5271: COMMIT WORK;
5272: END IF;
5273:
5274:
5275: -- Standard call to get message count and if count is get message info.
5276: FND_MSG_PUB.Count_And_Get
5277: (p_count => x_msg_count ,
5278: p_data => x_msg_data );
5279: EXCEPTION

Line 5466: -- Standard Start of API savepoint

5462: l_found_for_update VARCHAR2(1):='N';
5463: l_dummy VARCHAR2(1);
5464: l_instance_party_id NUMBER;
5465: BEGIN
5466: -- Standard Start of API savepoint
5467: -- SAVEPOINT update_inst_party_acct_pvt;
5468:
5469:
5470: -- Standard call to check for call compatibility.

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

5466: -- Standard Start of API savepoint
5467: -- SAVEPOINT update_inst_party_acct_pvt;
5468:
5469:
5470: -- Standard call to check for call compatibility.
5471: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5472: p_api_version ,
5473: l_api_name ,
5474: g_pkg_name )

Line 7130: -- Standard check of p_commit.

7126: END IF;
7127: -- End addition by sguthiva for bug 2307804
7128: --
7129: -- End of API body
7130: -- Standard check of p_commit.
7131: IF FND_API.To_Boolean( p_commit ) THEN
7132: COMMIT WORK;
7133: END IF;
7134: -- Standard call to get message count and if count is get message info.

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

7130: -- Standard check of p_commit.
7131: IF FND_API.To_Boolean( p_commit ) THEN
7132: COMMIT WORK;
7133: END IF;
7134: -- Standard call to get message count and if count is get message info.
7135: FND_MSG_PUB.Count_And_Get
7136: (p_count => x_msg_count ,
7137: p_data => x_msg_data );
7138: EXCEPTION

Line 7236: -- Standard Start of API savepoint

7232:
7233: l_curr_party_acct_rec get_curr_party_acct_rec%ROWTYPE;
7234:
7235: BEGIN
7236: -- Standard Start of API savepoint
7237: SAVEPOINT expire_inst_party_acct_pvt;
7238:
7239: -- Standard call to check for call compatibility.
7240: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

7235: BEGIN
7236: -- Standard Start of API savepoint
7237: SAVEPOINT expire_inst_party_acct_pvt;
7238:
7239: -- Standard call to check for call compatibility.
7240: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7241: p_api_version ,
7242: l_api_name ,
7243: g_pkg_name )

Line 7383: -- Standard check of p_commit.

7379: --
7380: -- Commented the tablehandler call since Update API got invoked
7381: --
7382: -- End of API body
7383: -- Standard check of p_commit.
7384: IF FND_API.To_Boolean( p_commit ) THEN
7385: COMMIT WORK;
7386: END IF;
7387: -- Standard call to get message count and if count is get message info.

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

7383: -- Standard check of p_commit.
7384: IF FND_API.To_Boolean( p_commit ) THEN
7385: COMMIT WORK;
7386: END IF;
7387: -- Standard call to get message count and if count is get message info.
7388: FND_MSG_PUB.Count_And_Get
7389: (p_count => x_msg_count ,
7390: p_data => x_msg_data );
7391: EXCEPTION

Line 7446: -- Standard Start of API savepoint

7442: l_csi_debug_level NUMBER;
7443:
7444:
7445: BEGIN
7446: -- Standard Start of API savepoint
7447: -- SAVEPOINT get_contact_details_pvt;
7448:
7449: -- Standard call to check for call compatibility.
7450: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

7445: BEGIN
7446: -- Standard Start of API savepoint
7447: -- SAVEPOINT get_contact_details_pvt;
7448:
7449: -- Standard call to check for call compatibility.
7450: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7451: p_api_version ,
7452: l_api_name ,
7453: g_pkg_name )

Line 7803: -- Standard check of p_commit.

7799: x_contact_details.contact_party_id := p_contact_party_id;
7800: --
7801: -- End of API body
7802:
7803: -- Standard check of p_commit.
7804: /*
7805: IF FND_API.To_Boolean( p_commit ) THEN
7806: COMMIT WORK;
7807: END IF;

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

7806: COMMIT WORK;
7807: END IF;
7808: */
7809:
7810: -- Standard call to get message count and if count is get message info.
7811: FND_MSG_PUB.Count_And_Get
7812: (p_count => x_msg_count ,
7813: p_data => x_msg_data );
7814: EXCEPTION

Line 7950: -- Standard Start of API savepoint

7946: l_party_query_rec csi_datastructures_pub.party_query_rec;
7947: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7948: -- End addition for bug 2781480
7949: BEGIN
7950: -- Standard Start of API savepoint
7951: -- SAVEPOINT get_inst_party_rel_hist;
7952:
7953:
7954: -- Standard call to check for call compatibility.

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

7950: -- Standard Start of API savepoint
7951: -- SAVEPOINT get_inst_party_rel_hist;
7952:
7953:
7954: -- Standard call to check for call compatibility.
7955: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7956: p_api_version ,
7957: l_api_name ,
7958: g_pkg_name )

Line 8532: -- Standard check of p_commit.

8528: END LOOP;
8529:
8530: -- End of API body
8531:
8532: -- Standard check of p_commit.
8533: /*
8534: IF FND_API.To_Boolean( p_commit ) THEN
8535: COMMIT WORK;
8536: END IF;

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

8543: END IF;
8544: -- End disable trace
8545: ****/
8546:
8547: -- Standard call to get message count and if count is get message info.
8548: FND_MSG_PUB.Count_And_Get
8549: (p_count => x_msg_count ,
8550: p_data => x_msg_data );
8551: EXCEPTION

Line 8671: -- Standard Start of API savepoint

8667: AND cah.ip_account_id = ca.ip_account_id
8668: AND ca.instance_party_id = cip.instance_party_id; -- Added by sguthiva on 9-APR for bug 2304649
8669:
8670: BEGIN
8671: -- Standard Start of API savepoint
8672: -- SAVEPOINT get_inst_party_account_hist;
8673:
8674:
8675: -- Standard call to check for call compatibility.

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

8671: -- Standard Start of API savepoint
8672: -- SAVEPOINT get_inst_party_account_hist;
8673:
8674:
8675: -- Standard call to check for call compatibility.
8676: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
8677: p_api_version ,
8678: l_api_name ,
8679: g_pkg_name )

Line 9093: -- Standard check of p_commit.

9089: END LOOP;
9090:
9091: -- End of API body
9092:
9093: -- Standard check of p_commit.
9094: /*
9095: IF FND_API.To_Boolean( p_commit ) THEN
9096: COMMIT WORK;
9097: END IF;

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

9104: END IF;
9105: -- End disable trace
9106: ****/
9107:
9108: -- Standard call to get message count and if count is get message info.
9109: FND_MSG_PUB.Count_And_Get
9110: (p_count => x_msg_count ,
9111: p_data => x_msg_data );
9112: EXCEPTION