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_OUS_GRP dependencies on FND_API

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

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

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

10:
11: PROCEDURE create_txn_org_assgn_dtls(
12: p_api_version IN NUMBER,
13: p_commit IN VARCHAR2 := fnd_api.g_false,
14: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
15: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
16: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,

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

11: PROCEDURE create_txn_org_assgn_dtls(
12: p_api_version IN NUMBER,
13: p_commit IN VARCHAR2 := fnd_api.g_false,
14: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
15: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
16: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2)

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

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

Line 43: IF FND_API.To_Boolean( p_init_msg_list ) THEN

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

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: FND_MSG_PUB.Initialize;
45: END IF;
46:
47: -- Initialize API return status to success
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: -- Standard call to check for call compatibility.
51: IF NOT
52:

Line 53: FND_API.Compatible_API_Call (

49:
50: -- Standard call to check for call compatibility.
51: IF NOT
52:
53: FND_API.Compatible_API_Call (
54: p_current_version_number => l_api_version,
55: p_caller_version_number => p_api_version,
56: p_api_name => l_api_name,
57: p_pkg_name => g_pkg_name) THEN

Line 59: RAISE FND_API.G_Exc_Unexpected_Error;

55: p_caller_version_number => p_api_version,
56: p_api_name => l_api_name,
57: p_pkg_name => g_pkg_name) THEN
58:
59: RAISE FND_API.G_Exc_Unexpected_Error;
60:
61: END IF;
62:
63: /**** Commented for Bug 3304439

Line 74: -- fnd_api.g_exc_error exception

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

Line 98: IF l_return_status <> fnd_api.g_ret_sts_success THEN

94: x_return_status => l_return_status,
95: x_msg_count => l_msg_count,
96: x_msg_data => l_msg_data);
97:
98: IF l_return_status <> fnd_api.g_ret_sts_success THEN
99: raise fnd_api.g_exc_error;
100: END IF;
101:
102: END LOOP;

Line 99: raise fnd_api.g_exc_error;

95: x_msg_count => l_msg_count,
96: x_msg_data => l_msg_data);
97:
98: IF l_return_status <> fnd_api.g_ret_sts_success THEN
99: raise fnd_api.g_exc_error;
100: END IF;
101:
102: END LOOP;
103:

Line 106: IF FND_API.To_Boolean( p_commit ) THEN

102: END LOOP;
103:
104: END IF;
105: -- Standard check of p_commit.
106: IF FND_API.To_Boolean( p_commit ) THEN
107: COMMIT WORK;
108: END IF;
109:
110: /**** Commented for Bug 3304439

Line 128: WHEN FND_API.G_EXC_ERROR THEN

124:
125: csi_t_gen_utility_pvt.set_debug_off;
126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129:
130: ROLLBACK TO create_txn_org_assgn_dtls;
131: x_return_status := FND_API.G_RET_STS_ERROR ;
132: FND_MSG_PUB.Count_And_Get (

Line 131: x_return_status := FND_API.G_RET_STS_ERROR ;

127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129:
130: ROLLBACK TO create_txn_org_assgn_dtls;
131: x_return_status := FND_API.G_RET_STS_ERROR ;
132: FND_MSG_PUB.Count_And_Get (
133: p_count => x_msg_count,
134: p_data => x_msg_data);
135:

Line 136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

132: FND_MSG_PUB.Count_And_Get (
133: p_count => x_msg_count,
134: p_data => x_msg_data);
135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137:
138: ROLLBACK TO create_txn_org_assgn_dtls;
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
140:

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

144:
145: WHEN OTHERS THEN
146:
147: ROLLBACK TO create_txn_org_assgn_dtls;
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
149:
150: IF FND_MSG_PUB.Check_Msg_Level(
151: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
152:

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

166: */
167: PROCEDURE update_txn_org_assgn_dtls
168: (
169: p_api_version IN NUMBER
170: ,p_commit IN VARCHAR2 := fnd_api.g_false
171: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
172: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
173: ,p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl
174: ,x_return_status OUT NOCOPY VARCHAR2

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

167: PROCEDURE update_txn_org_assgn_dtls
168: (
169: p_api_version IN NUMBER
170: ,p_commit IN VARCHAR2 := fnd_api.g_false
171: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
172: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
173: ,p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl
174: ,x_return_status OUT NOCOPY VARCHAR2
175: ,x_msg_count OUT NOCOPY NUMBER

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

168: (
169: p_api_version IN NUMBER
170: ,p_commit IN VARCHAR2 := fnd_api.g_false
171: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
172: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
173: ,p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl
174: ,x_return_status OUT NOCOPY VARCHAR2
175: ,x_msg_count OUT NOCOPY NUMBER
176: ,x_msg_data OUT NOCOPY VARCHAR2

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

180: l_api_name CONSTANT VARCHAR2(30) := 'Update_Txn_Org_Assgn_Dtls';
181: l_api_version CONSTANT NUMBER := 1.0;
182: l_debug_level NUMBER;
183:
184: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
185: l_msg_count NUMBER;
186: l_msg_data VARCHAR2(512);
187:
188: BEGIN

Line 198: IF FND_API.to_Boolean( p_init_msg_list ) THEN

194: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
195:
196:
197: -- Initialize message list if p_init_msg_list is set to TRUE.
198: IF FND_API.to_Boolean( p_init_msg_list ) THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: -- Initialize API return status to success

Line 203: x_return_status := FND_API.G_RET_STS_SUCCESS;

199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: -- Initialize API return status to success
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: -- Standard call to check for call compatibility.
206: IF NOT
207:

Line 208: FND_API.Compatible_API_Call (

204:
205: -- Standard call to check for call compatibility.
206: IF NOT
207:
208: FND_API.Compatible_API_Call (
209: p_current_version_number => l_api_version,
210: p_caller_version_number => p_api_version,
211: p_api_name => l_api_name,
212: p_pkg_name => G_PKG_NAME) THEN

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: p_caller_version_number => p_api_version,
211: p_api_name => l_api_name,
212: p_pkg_name => G_PKG_NAME) THEN
213:
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215:
216: END IF;
217:
218: /**** Commented for Bug 3304439

Line 229: -- fnd_api.g_exc_error exception

225: -- Main API code
226: --
227: -- This procedure check if the installed base is active, If not active
228: -- populates the error message in the message queue and raises the
229: -- fnd_api.g_exc_error exception
230: --
231:
232: csi_utility_grp.check_ib_active;
233:

Line 244: IF l_return_status <> fnd_api.g_ret_sts_success THEN

240: x_return_status => l_return_status,
241: x_msg_count => l_msg_count,
242: x_msg_data => l_msg_data);
243:
244: IF l_return_status <> fnd_api.g_ret_sts_success THEN
245: RAISE fnd_api.g_exc_error;
246: END IF;
247:
248: -- Standard check of p_commit.

Line 245: RAISE fnd_api.g_exc_error;

241: x_msg_count => l_msg_count,
242: x_msg_data => l_msg_data);
243:
244: IF l_return_status <> fnd_api.g_ret_sts_success THEN
245: RAISE fnd_api.g_exc_error;
246: END IF;
247:
248: -- Standard check of p_commit.
249: IF FND_API.To_Boolean( p_commit ) THEN

Line 249: IF FND_API.To_Boolean( p_commit ) THEN

245: RAISE fnd_api.g_exc_error;
246: END IF;
247:
248: -- Standard check of p_commit.
249: IF FND_API.To_Boolean( p_commit ) THEN
250: COMMIT WORK;
251: END IF;
252:
253: /**** Commented for Bug 3304439

Line 271: WHEN FND_API.G_EXC_ERROR THEN

267:
268: csi_t_gen_utility_pvt.set_debug_off;
269:
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272:
273: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: FND_MSG_PUB.Count_And_Get (

Line 274: x_return_status := FND_API.G_RET_STS_ERROR ;

270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272:
273: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: FND_MSG_PUB.Count_And_Get (
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: FND_MSG_PUB.Count_And_Get (
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280:
281: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283:

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280:
281: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283:
284: FND_MSG_PUB.Count_And_Get(
285: p_count => x_msg_count,
286: p_data => x_msg_data);

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

287:
288: WHEN OTHERS THEN
289:
290: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
292:
293: IF FND_MSG_PUB.Check_Msg_Level(
294: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
295:

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

308:
309: PROCEDURE delete_txn_org_assgn_dtls
310: (
311: p_api_version IN NUMBER
312: ,p_commit IN VARCHAR2 := fnd_api.g_false
313: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
314: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
315: ,p_txn_org_assgn_ids_tbl IN csi_t_datastructures_grp.txn_org_assgn_ids_tbl
316: ,x_return_status OUT NOCOPY VARCHAR2

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

309: PROCEDURE delete_txn_org_assgn_dtls
310: (
311: p_api_version IN NUMBER
312: ,p_commit IN VARCHAR2 := fnd_api.g_false
313: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
314: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
315: ,p_txn_org_assgn_ids_tbl IN csi_t_datastructures_grp.txn_org_assgn_ids_tbl
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER

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

310: (
311: p_api_version IN NUMBER
312: ,p_commit IN VARCHAR2 := fnd_api.g_false
313: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
314: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
315: ,p_txn_org_assgn_ids_tbl IN csi_t_datastructures_grp.txn_org_assgn_ids_tbl
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2

Line 340: IF FND_API.to_Boolean( p_init_msg_list ) THEN

336: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
337:
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE.
340: IF FND_API.to_Boolean( p_init_msg_list ) THEN
341: FND_MSG_PUB.initialize;
342: END IF;
343:
344: -- Initialize API return status to success

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: FND_MSG_PUB.initialize;
342: END IF;
343:
344: -- Initialize API return status to success
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: -- Standard call to check for call compatibility.
348: IF NOT
349:

Line 350: FND_API.Compatible_API_Call (

346:
347: -- Standard call to check for call compatibility.
348: IF NOT
349:
350: FND_API.Compatible_API_Call (
351: p_current_version_number => l_api_version,
352: p_caller_version_number => p_api_version,
353: p_api_name => l_api_name,
354: p_pkg_name => G_PKG_NAME) THEN

Line 356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

352: p_caller_version_number => p_api_version,
353: p_api_name => l_api_name,
354: p_pkg_name => G_PKG_NAME) THEN
355:
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357:
358: END IF;
359:
360: /**** Commented for Bug 3304439

Line 371: -- fnd_api.g_exc_error exception

367: -- Main API code
368: --
369: -- This procedure check if the installed base is active, If not active
370: -- populates the error message in the message queue and raises the
371: -- fnd_api.g_exc_error exception
372: --
373:
374: csi_utility_grp.check_ib_active;
375:

Line 386: IF l_return_status <> fnd_api.g_ret_sts_success THEN

382: x_return_status => l_return_status,
383: x_msg_count => l_msg_count,
384: x_msg_data => l_msg_data);
385:
386: IF l_return_status <> fnd_api.g_ret_sts_success THEN
387: RAISE fnd_api.g_exc_error;
388: END IF;
389:
390: -- Standard check of p_commit.

Line 387: RAISE fnd_api.g_exc_error;

383: x_msg_count => l_msg_count,
384: x_msg_data => l_msg_data);
385:
386: IF l_return_status <> fnd_api.g_ret_sts_success THEN
387: RAISE fnd_api.g_exc_error;
388: END IF;
389:
390: -- Standard check of p_commit.
391: IF FND_API.To_Boolean( p_commit ) THEN

Line 391: IF FND_API.To_Boolean( p_commit ) THEN

387: RAISE fnd_api.g_exc_error;
388: END IF;
389:
390: -- Standard check of p_commit.
391: IF FND_API.To_Boolean( p_commit ) THEN
392: COMMIT WORK;
393: END IF;
394:
395: /**** Commented for Bug 3304439

Line 413: WHEN FND_API.G_EXC_ERROR THEN

409:
410: csi_t_gen_utility_pvt.set_debug_off;
411:
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414:
415: ROLLBACK TO delete_txn_org_assgn_dtls;
416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get (

Line 416: x_return_status := FND_API.G_RET_STS_ERROR ;

412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414:
415: ROLLBACK TO delete_txn_org_assgn_dtls;
416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get (
418: p_count => x_msg_count,
419: p_data => x_msg_data);
420:

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

417: FND_MSG_PUB.Count_And_Get (
418: p_count => x_msg_count,
419: p_data => x_msg_data);
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: ROLLBACK TO delete_txn_org_assgn_dtls;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
425:

Line 424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: ROLLBACK TO delete_txn_org_assgn_dtls;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
425:
426: FND_MSG_PUB.Count_And_Get(
427: p_count => x_msg_count,
428: p_data => x_msg_data);

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

429:
430: WHEN OTHERS THEN
431:
432: ROLLBACK TO delete_txn_org_assgn_dtls;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
434:
435: IF FND_MSG_PUB.Check_Msg_Level(
436: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
437: