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'));
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,
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:
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:
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'));
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,
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:
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:
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'));
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,
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:
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: