eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_T_TXN_RLTNSHPS_GRP dependencies on FND_API

Line 12: p_commit IN VARCHAR2 := fnd_api.g_false,

8: g_login_id NUMBER := FND_GLOBAL.Login_Id;
9:
10: PROCEDURE create_txn_ii_rltns_dtls(
11: p_api_version IN NUMBER,
12: p_commit IN VARCHAR2 := fnd_api.g_false,
13: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
14: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: x_return_status OUT NOCOPY VARCHAR2,

Line 13: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

9:
10: PROCEDURE create_txn_ii_rltns_dtls(
11: p_api_version IN NUMBER,
12: p_commit IN VARCHAR2 := fnd_api.g_false,
13: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
14: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,

Line 14: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

10: PROCEDURE create_txn_ii_rltns_dtls(
11: p_api_version IN NUMBER,
12: p_commit IN VARCHAR2 := fnd_api.g_false,
13: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
14: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2)

Line 25: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;

21: l_api_name CONSTANT VARCHAR2(30) := 'create_txn_ii_rltns_dtls';
22: l_api_version CONSTANT NUMBER := 1.0;
23: l_debug_level NUMBER;
24:
25: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
26: l_msg_count NUMBER;
27: l_msg_data VARCHAR2(512);
28:
29: l_count NUMBER;

Line 47: IF FND_API.To_Boolean( p_init_msg_list ) THEN

43: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
44:
45:
46: -- Initialize message list if p_init_msg_list is set to TRUE.
47: IF FND_API.To_Boolean( p_init_msg_list ) THEN
48: FND_MSG_PUB.Initialize;
49: END IF;
50:
51: -- Initialize API return status to success

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48: FND_MSG_PUB.Initialize;
49: END IF;
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:

Line 57: FND_API.Compatible_API_Call (

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,
59: p_caller_version_number => p_api_version,
60: p_api_name => l_api_name,
61: p_pkg_name => g_pkg_name) THEN

Line 63: RAISE FND_API.G_Exc_Unexpected_Error;

59: p_caller_version_number => p_api_version,
60: p_api_name => l_api_name,
61: p_pkg_name => g_pkg_name) THEN
62:
63: RAISE FND_API.G_Exc_Unexpected_Error;
64:
65: END IF;
66:
67: /**** Commented for Bug 3304439

Line 78: -- fnd_api.g_exc_error exception

74: -- main code starts here
75: --
76: -- This procedure check if the installed base is active, If not active
77: -- populates the error message in the message queue and raises the
78: -- fnd_api.g_exc_error exception
79: --
80:
81: csi_utility_grp.check_ib_active;
82:

Line 102: IF l_return_status <> fnd_api.g_ret_sts_success THEN

98: x_return_status => l_return_status,
99: x_msg_count => l_msg_count,
100: x_msg_data => l_msg_data);
101:
102: IF l_return_status <> fnd_api.g_ret_sts_success THEN
103: raise fnd_api.g_exc_error;
104: END IF;
105:
106: px_txn_ii_rltns_tbl(l_ind) := l_txn_ii_rltns_rec;

Line 103: raise fnd_api.g_exc_error;

99: x_msg_count => l_msg_count,
100: x_msg_data => l_msg_data);
101:
102: IF l_return_status <> fnd_api.g_ret_sts_success THEN
103: raise fnd_api.g_exc_error;
104: END IF;
105:
106: px_txn_ii_rltns_tbl(l_ind) := l_txn_ii_rltns_rec;
107:

Line 114: IF FND_API.To_Boolean( p_commit ) THEN

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:
118: /**** Commented for Bug 3304439

Line 136: WHEN FND_API.G_EXC_ERROR THEN

132:
133: csi_t_gen_utility_pvt.set_debug_off;
134:
135: EXCEPTION
136: WHEN FND_API.G_EXC_ERROR THEN
137:
138: ROLLBACK TO create_txn_ii_rltns_dtls;
139: x_return_status := FND_API.G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get (

Line 139: x_return_status := FND_API.G_RET_STS_ERROR ;

135: EXCEPTION
136: WHEN FND_API.G_EXC_ERROR THEN
137:
138: ROLLBACK TO create_txn_ii_rltns_dtls;
139: x_return_status := FND_API.G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get (
141: p_count => x_msg_count,
142: p_data => x_msg_data);
143:

Line 144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

140: FND_MSG_PUB.Count_And_Get (
141: p_count => x_msg_count,
142: p_data => x_msg_data);
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145:
146: ROLLBACK TO create_txn_ii_rltns_dtls;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148:

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145:
146: ROLLBACK TO create_txn_ii_rltns_dtls;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148:
149: FND_MSG_PUB.Count_And_Get(
150: p_count => x_msg_count,
151: p_data => x_msg_data);

Line 156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

152:
153: WHEN OTHERS THEN
154:
155: ROLLBACK TO create_txn_ii_rltns_dtls;
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157:
158: IF FND_MSG_PUB.Check_Msg_Level(
159: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
160:

Line 178: ,p_commit IN VARCHAR2 := fnd_api.g_false

174: /*
175: */
176: PROCEDURE update_txn_ii_rltns_dtls (
177: p_api_version IN NUMBER
178: ,p_commit IN VARCHAR2 := fnd_api.g_false
179: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
180: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
181: ,p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl
182: ,x_return_status OUT NOCOPY VARCHAR2

Line 179: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

175: */
176: PROCEDURE update_txn_ii_rltns_dtls (
177: p_api_version IN NUMBER
178: ,p_commit IN VARCHAR2 := fnd_api.g_false
179: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
180: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
181: ,p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl
182: ,x_return_status OUT NOCOPY VARCHAR2
183: ,x_msg_count OUT NOCOPY NUMBER

Line 180: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

176: PROCEDURE update_txn_ii_rltns_dtls (
177: p_api_version IN NUMBER
178: ,p_commit IN VARCHAR2 := fnd_api.g_false
179: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
180: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
181: ,p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl
182: ,x_return_status OUT NOCOPY VARCHAR2
183: ,x_msg_count OUT NOCOPY NUMBER
184: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 192: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;

188: l_api_name CONSTANT VARCHAR2(30) := 'update_txn_ii_rltns_dtls';
189: l_api_version CONSTANT NUMBER := 1.0;
190: l_debug_level NUMBER;
191:
192: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
193: l_msg_count NUMBER;
194: l_msg_data VARCHAR2(512);
195:
196: BEGIN

Line 206: IF FND_API.to_Boolean( p_init_msg_list ) THEN

202: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
203:
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list ) THEN
207: FND_MSG_PUB.initialize;
208: END IF;
209:
210: -- Initialize API return status to success

Line 211: x_return_status := FND_API.G_RET_STS_SUCCESS;

207: FND_MSG_PUB.initialize;
208: END IF;
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:

Line 216: FND_API.Compatible_API_Call (

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,
218: p_caller_version_number => p_api_version,
219: p_api_name => l_api_name,
220: p_pkg_name => G_PKG_NAME) THEN

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: p_caller_version_number => p_api_version,
219: p_api_name => l_api_name,
220: p_pkg_name => G_PKG_NAME) THEN
221:
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223:
224: END IF;
225:
226: /**** Commented for Bug 3304439

Line 237: -- fnd_api.g_exc_error exception

233: -- Main API code
234: --
235: -- This procedure check if the installed base is active, If not active
236: -- populates the error message in the message queue and raises the
237: -- fnd_api.g_exc_error exception
238: --
239:
240: csi_utility_grp.check_ib_active;
241:

Line 252: IF l_return_status <> fnd_api.g_ret_sts_success THEN

248: x_return_status => l_return_status,
249: x_msg_count => l_msg_count,
250: x_msg_data => l_msg_data);
251:
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.

Line 253: RAISE fnd_api.g_exc_error;

249: x_msg_count => l_msg_count,
250: x_msg_data => l_msg_data);
251:
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

Line 257: IF FND_API.To_Boolean( p_commit ) 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:
261: /**** Commented for Bug 3304439

Line 278: WHEN FND_API.G_EXC_ERROR THEN

274:
275: csi_t_gen_utility_pvt.set_debug_off;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279:
280: ROLLBACK TO update_txn_ii_rltns_dtls;
281: x_return_status := FND_API.G_RET_STS_ERROR ;
282: FND_MSG_PUB.Count_And_Get (

Line 281: x_return_status := FND_API.G_RET_STS_ERROR ;

277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279:
280: ROLLBACK TO update_txn_ii_rltns_dtls;
281: x_return_status := FND_API.G_RET_STS_ERROR ;
282: FND_MSG_PUB.Count_And_Get (
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:

Line 286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

282: FND_MSG_PUB.Count_And_Get (
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287:
288: ROLLBACK TO update_txn_ii_rltns_dtls;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
290:

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287:
288: ROLLBACK TO update_txn_ii_rltns_dtls;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
290:
291: FND_MSG_PUB.Count_And_Get(
292: p_count => x_msg_count,
293: p_data => x_msg_data);

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

294:
295: WHEN OTHERS THEN
296:
297: ROLLBACK TO update_txn_ii_rltns_dtls;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299:
300: IF FND_MSG_PUB.Check_Msg_Level(
301: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
302:

Line 319: ,p_commit IN VARCHAR2 := fnd_api.g_false

315: /*
316: */
317: PROCEDURE delete_txn_ii_rltns_dtls(
318: p_api_version IN NUMBER
319: ,p_commit IN VARCHAR2 := fnd_api.g_false
320: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
321: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
322: ,p_txn_ii_rltns_ids_tbl IN csi_t_datastructures_grp.txn_ii_rltns_ids_tbl
323: ,x_return_status OUT NOCOPY VARCHAR2

Line 320: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

316: */
317: PROCEDURE delete_txn_ii_rltns_dtls(
318: p_api_version IN NUMBER
319: ,p_commit IN VARCHAR2 := fnd_api.g_false
320: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
321: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
322: ,p_txn_ii_rltns_ids_tbl IN csi_t_datastructures_grp.txn_ii_rltns_ids_tbl
323: ,x_return_status OUT NOCOPY VARCHAR2
324: ,x_msg_count OUT NOCOPY NUMBER

Line 321: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

317: PROCEDURE delete_txn_ii_rltns_dtls(
318: p_api_version IN NUMBER
319: ,p_commit IN VARCHAR2 := fnd_api.g_false
320: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
321: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
322: ,p_txn_ii_rltns_ids_tbl IN csi_t_datastructures_grp.txn_ii_rltns_ids_tbl
323: ,x_return_status OUT NOCOPY VARCHAR2
324: ,x_msg_count OUT NOCOPY NUMBER
325: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 347: IF FND_API.to_Boolean( p_init_msg_list ) THEN

343: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
344:
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350:
351: -- Initialize API return status to success

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS;

348: FND_MSG_PUB.initialize;
349: END IF;
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:

Line 357: FND_API.Compatible_API_Call (

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,
359: p_caller_version_number => p_api_version,
360: p_api_name => l_api_name,
361: p_pkg_name => G_PKG_NAME) THEN

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: p_caller_version_number => p_api_version,
360: p_api_name => l_api_name,
361: p_pkg_name => G_PKG_NAME) THEN
362:
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364:
365: END IF;
366:
367: /**** Commented for Bug 3304439

Line 378: -- fnd_api.g_exc_error exception

374: -- Main API code
375: --
376: -- This procedure check if the installed base is active, If not active
377: -- populates the error message in the message queue and raises the
378: -- fnd_api.g_exc_error exception
379: --
380:
381: csi_utility_grp.check_ib_active;
382:

Line 393: IF l_return_status <> fnd_api.g_ret_sts_success THEN

389: x_return_status => l_return_status,
390: x_msg_count => l_msg_count,
391: x_msg_data => l_msg_data);
392:
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.

Line 394: RAISE fnd_api.g_exc_error;

390: x_msg_count => l_msg_count,
391: x_msg_data => l_msg_data);
392:
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

Line 398: IF FND_API.To_Boolean( p_commit ) 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:
402: /**** Commented for Bug 3304439

Line 420: WHEN FND_API.G_EXC_ERROR THEN

416:
417: csi_t_gen_utility_pvt.set_debug_off;
418:
419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN
421:
422: ROLLBACK TO Delete_Inst_Reltship_Dtls;
423: x_return_status := FND_API.G_RET_STS_ERROR ;
424: FND_MSG_PUB.Count_And_Get (

Line 423: x_return_status := FND_API.G_RET_STS_ERROR ;

419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN
421:
422: ROLLBACK TO Delete_Inst_Reltship_Dtls;
423: x_return_status := FND_API.G_RET_STS_ERROR ;
424: FND_MSG_PUB.Count_And_Get (
425: p_count => x_msg_count,
426: p_data => x_msg_data);
427:

Line 428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

424: FND_MSG_PUB.Count_And_Get (
425: p_count => x_msg_count,
426: p_data => x_msg_data);
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429:
430: ROLLBACK TO Delete_Inst_Reltship_Dtls;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432:

Line 431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429:
430: ROLLBACK TO Delete_Inst_Reltship_Dtls;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432:
433: FND_MSG_PUB.Count_And_Get(
434: p_count => x_msg_count,
435: p_data => x_msg_data);

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

436:
437: WHEN OTHERS THEN
438:
439: ROLLBACK TO Delete_Inst_Reltship_Dtls;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441:
442: IF FND_MSG_PUB.Check_Msg_Level(
443: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
444: