DBA Data[Home] [Help]

APPS.CSI_T_TXN_RLTNSHPS_GRP dependencies on STANDARD

Line 39: -- Standard Start of API savepoint

35: l_obj_tld_id NUMBER ;
36:
37: BEGIN
38:
39: -- Standard Start of API savepoint
40: SAVEPOINT create_txn_ii_rltns_dtls;
41:
42: csi_t_gen_utility_pvt.add('API Being Executed : Create Txn Relationships');
43: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

50:
51: -- Initialize API return status to success
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: -- Standard call to check for call compatibility.
55: IF NOT
56:
57: FND_API.Compatible_API_Call (
58: p_current_version_number => l_api_version,

Line 113: -- Standard check of p_commit.

109:
110: END IF;
111:
112:
113: -- Standard check of p_commit.
114: IF FND_API.To_Boolean( p_commit ) THEN
115: COMMIT WORK;
116: END IF;
117:

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

121: dbms_session.set_sql_trace(false);
122: END IF;
123: ****/
124:
125: -- Standard call to get message count and if count is get message info.
126: FND_MSG_PUB.Count_And_Get(
127: p_count => x_msg_count,
128: p_data => x_msg_data);
129:

Line 198: -- Standard Start of API savepoint

194: l_msg_data VARCHAR2(512);
195:
196: BEGIN
197:
198: -- Standard Start of API savepoint
199: SAVEPOINT update_txn_ii_rltns_dtls;
200:
201: csi_t_gen_utility_pvt.add('API Being Executed : Update Txn Relationships');
202: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

209:
210: -- Initialize API return status to success
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: -- Standard call to check for call compatibility.
214: IF NOT
215:
216: FND_API.Compatible_API_Call (
217: p_current_version_number => l_api_version,

Line 256: -- Standard check of p_commit.

252: IF l_return_status <> fnd_api.g_ret_sts_success THEN
253: RAISE fnd_api.g_exc_error;
254: END IF;
255:
256: -- Standard check of p_commit.
257: IF FND_API.To_Boolean( p_commit ) THEN
258: COMMIT WORK;
259: END IF;
260:

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

263: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
264: dbms_session.set_sql_trace(false);
265: END IF;
266: ****/
267: -- Standard call to get message count and if count is get message info.
268: FND_MSG_PUB.Count_And_Get(
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271:

Line 339: -- Standard Start of API savepoint

335: l_msg_data VARCHAR2(2000);
336:
337: BEGIN
338:
339: -- Standard Start of API savepoint
340: SAVEPOINT Delete_Inst_Reltship_Dtls;
341:
342: csi_t_gen_utility_pvt.add('API Being Executed : Delete Txn Relationships');
343: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

350:
351: -- Initialize API return status to success
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT
356:
357: FND_API.Compatible_API_Call (
358: p_current_version_number => l_api_version,

Line 397: -- Standard check of p_commit.

393: IF l_return_status <> fnd_api.g_ret_sts_success THEN
394: RAISE fnd_api.g_exc_error;
395: END IF;
396:
397: -- Standard check of p_commit.
398: IF FND_API.To_Boolean( p_commit ) THEN
399: COMMIT WORK;
400: END IF;
401:

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

405: dbms_session.set_sql_trace(false);
406: END IF;
407: ****/
408:
409: -- Standard call to get message count and if count is get message info.
410: FND_MSG_PUB.Count_And_Get(
411: p_count => x_msg_count,
412: p_data => x_msg_data);
413: