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

Line 28: p_commit IN varchar2 := fnd_api.g_false,

24: END api_log;
25:
26: PROCEDURE create_txn_party_dtls(
27: p_api_version IN number,
28: p_commit IN varchar2 := fnd_api.g_false,
29: p_init_msg_list IN varchar2 := fnd_api.g_false,
30: p_validation_level IN number := fnd_api.g_valid_level_full,
31: p_txn_party_dtl_index IN number,
32: p_txn_party_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_rec,

Line 29: p_init_msg_list IN varchar2 := fnd_api.g_false,

25:
26: PROCEDURE create_txn_party_dtls(
27: p_api_version IN number,
28: p_commit IN varchar2 := fnd_api.g_false,
29: p_init_msg_list IN varchar2 := fnd_api.g_false,
30: p_validation_level IN number := fnd_api.g_valid_level_full,
31: p_txn_party_dtl_index IN number,
32: p_txn_party_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_rec,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 30: p_validation_level IN number := fnd_api.g_valid_level_full,

26: PROCEDURE create_txn_party_dtls(
27: p_api_version IN number,
28: p_commit IN varchar2 := fnd_api.g_false,
29: p_init_msg_list IN varchar2 := fnd_api.g_false,
30: p_validation_level IN number := fnd_api.g_valid_level_full,
31: p_txn_party_dtl_index IN number,
32: p_txn_party_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_rec,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: x_return_status OUT NOCOPY varchar2,

Line 59: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

55: -- Standard Start of API savepoint
56: savepoint create_txn_party_dtls;
57:
58: -- Initialize message list if p_init_msg_list is set to TRUE.
59: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: -- Initialize API return status to success

Line 64: x_return_status := fnd_api.G_RET_STS_SUCCESS;

60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: -- Initialize API return status to success
64: x_return_status := fnd_api.G_RET_STS_SUCCESS;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT
68:

Line 69: fnd_api.Compatible_API_Call (

65:
66: -- Standard call to check for call compatibility.
67: IF NOT
68:
69: fnd_api.Compatible_API_Call (
70: p_current_version_number => l_api_version,
71: p_caller_version_number => p_api_version,
72: p_api_name => l_api_name,
73: p_pkg_name => G_PKG_NAME) THEN

Line 75: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

71: p_caller_version_number => p_api_version,
72: p_api_name => l_api_name,
73: p_pkg_name => G_PKG_NAME) THEN
74:
75: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
76:
77: END IF;
78:
79: -- debug messages

Line 107: IF l_return_status <> fnd_api.g_ret_sts_success THEN

103: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
104: p_txn_line_detail_id => p_txn_party_detail_rec.txn_line_detail_id,
105: x_return_status => l_return_status);
106:
107: IF l_return_status <> fnd_api.g_ret_sts_success THEN
108:
109: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
110: FND_MESSAGE.set_token('LINE_DTL_ID',
111: p_txn_party_detail_rec.txn_line_detail_id);

Line 113: RAISE fnd_api.g_exc_error;

109: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
110: FND_MESSAGE.set_token('LINE_DTL_ID',
111: p_txn_party_detail_rec.txn_line_detail_id);
112: FND_MSG_PUB.add;
113: RAISE fnd_api.g_exc_error;
114:
115: END IF;
116:
117:

Line 118: IF NVL(p_txn_party_detail_rec.instance_party_id , fnd_api.g_miss_num) =

114:
115: END IF;
116:
117:
118: IF NVL(p_txn_party_detail_rec.instance_party_id , fnd_api.g_miss_num) =
119: fnd_api.g_miss_num
120: THEN
121:
122: csi_t_vldn_routines_pvt.check_reqd_param(

Line 119: fnd_api.g_miss_num

115: END IF;
116:
117:
118: IF NVL(p_txn_party_detail_rec.instance_party_id , fnd_api.g_miss_num) =
119: fnd_api.g_miss_num
120: THEN
121:
122: csi_t_vldn_routines_pvt.check_reqd_param(
123: p_value => p_txn_party_detail_rec.party_source_table,

Line 142: IF NVL(p_txn_party_detail_rec.party_source_table, fnd_api.g_miss_char) <>

138: p_api_name => l_api_name);
139:
140:
141: -- validate party_source_table from cs_lookups
142: IF NVL(p_txn_party_detail_rec.party_source_table, fnd_api.g_miss_char) <>
143: fnd_api.g_miss_char
144: THEN
145:
146: IF NOT

Line 143: fnd_api.g_miss_char

139:
140:
141: -- validate party_source_table from cs_lookups
142: IF NVL(p_txn_party_detail_rec.party_source_table, fnd_api.g_miss_char) <>
143: fnd_api.g_miss_char
144: THEN
145:
146: IF NOT
147: csi_instance_parties_vld_pvt.is_pty_source_tab_valid(

Line 151: RAISE fnd_api.g_exc_error;

147: csi_instance_parties_vld_pvt.is_pty_source_tab_valid(
148: p_party_source_table => p_txn_party_detail_rec.party_source_table)
149: THEN
150: csi_t_gen_utility_pvt.add('Validate party source table failed.');
151: RAISE fnd_api.g_exc_error;
152: END IF;
153:
154: END IF;
155:

Line 158: IF NVL(p_txn_party_detail_rec.party_source_id, fnd_api.g_miss_num) <>

154: END IF;
155:
156:
157: -- validate party_source_id for party_source_table
158: IF NVL(p_txn_party_detail_rec.party_source_id, fnd_api.g_miss_num) <>
159: fnd_api.g_miss_num
160: THEN
161:
162: IF NOT

Line 159: fnd_api.g_miss_num

155:
156:
157: -- validate party_source_id for party_source_table
158: IF NVL(p_txn_party_detail_rec.party_source_id, fnd_api.g_miss_num) <>
159: fnd_api.g_miss_num
160: THEN
161:
162: IF NOT
163: csi_instance_parties_vld_pvt.is_party_valid(

Line 169: RAISE fnd_api.g_exc_error;

165: p_party_id => p_txn_party_detail_rec.party_source_id,
166: p_contact_flag => p_txn_party_detail_rec.contact_flag)
167: THEN
168: csi_t_gen_utility_pvt.add('Validate party source id failed.');
169: RAISE fnd_api.g_exc_error;
170: END IF;
171:
172: END IF;
173:

Line 181: IF nvl(p_txn_party_detail_rec.contact_flag,fnd_api.g_miss_char) <> fnd_api.g_miss_char

177: p_param_name => 'p_txn_party_detail_rec.contact_flag',
178: p_api_name => l_api_name);
179:
180: -- contact_flag should be Y or N
181: IF nvl(p_txn_party_detail_rec.contact_flag,fnd_api.g_miss_char) <> fnd_api.g_miss_char
182: THEN
183: csi_t_vldn_routines_pvt.validate_contact_flag(
184: p_contact_flag => p_txn_party_detail_rec.contact_flag,
185: x_return_status => l_return_status);

Line 187: IF l_return_status <> fnd_api.g_ret_sts_success THEN

183: csi_t_vldn_routines_pvt.validate_contact_flag(
184: p_contact_flag => p_txn_party_detail_rec.contact_flag,
185: x_return_status => l_return_status);
186:
187: IF l_return_status <> fnd_api.g_ret_sts_success THEN
188:
189: FND_MESSAGE.set_name('CSI','CSI_TXN_CONTACT_FLAG_INVALID');
190: FND_MESSAGE.set_token ('CONTACT_FLAG', p_txn_party_detail_rec.contact_flag);
191:

Line 193: RAISE fnd_api.g_exc_error;

189: FND_MESSAGE.set_name('CSI','CSI_TXN_CONTACT_FLAG_INVALID');
190: FND_MESSAGE.set_token ('CONTACT_FLAG', p_txn_party_detail_rec.contact_flag);
191:
192: FND_MSG_PUB.add;
193: RAISE fnd_api.g_exc_error;
194:
195: END IF;
196: END IF;
197:

Line 199: IF NVL(p_txn_party_detail_rec.relationship_type_code, fnd_api.g_miss_char) <>

195: END IF;
196: END IF;
197:
198: -- validate relationship_type_code from cs_lookups
199: IF NVL(p_txn_party_detail_rec.relationship_type_code, fnd_api.g_miss_char) <>
200: fnd_api.g_miss_char
201: THEN
202:
203: IF p_txn_party_detail_rec.contact_flag = 'Y' THEN

Line 200: fnd_api.g_miss_char

196: END IF;
197:
198: -- validate relationship_type_code from cs_lookups
199: IF NVL(p_txn_party_detail_rec.relationship_type_code, fnd_api.g_miss_char) <>
200: fnd_api.g_miss_char
201: THEN
202:
203: IF p_txn_party_detail_rec.contact_flag = 'Y' THEN
204: l_contact_flag := 'C';

Line 215: RAISE fnd_api.g_exc_error;

211: p_party_rel_type_code => p_txn_party_detail_rec.relationship_type_code,
212: p_contact_flag => l_contact_flag)
213: THEN
214: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');
215: RAISE fnd_api.g_exc_error;
216: END IF;
217:
218: END IF;
219:

Line 222: IF NVL(p_txn_party_detail_rec.instance_party_id, fnd_api.g_miss_num) <>

218: END IF;
219:
220:
221: -- validate instance_party_id from csi_i_parties
222: IF NVL(p_txn_party_detail_rec.instance_party_id, fnd_api.g_miss_num) <>
223: fnd_api.g_miss_num
224: THEN
225:
226: csi_t_vldn_routines_pvt.validate_instance_reference(

Line 223: fnd_api.g_miss_num

219:
220:
221: -- validate instance_party_id from csi_i_parties
222: IF NVL(p_txn_party_detail_rec.instance_party_id, fnd_api.g_miss_num) <>
223: fnd_api.g_miss_num
224: THEN
225:
226: csi_t_vldn_routines_pvt.validate_instance_reference(
227: p_level => 'PARTY',

Line 232: IF l_return_status <> fnd_api.g_ret_sts_error THEN

228: p_level_dtl_id => p_txn_party_detail_rec.txn_line_detail_id,
229: p_level_inst_ref_id => p_txn_party_detail_rec.instance_party_id,
230: x_return_status => l_return_status);
231:
232: IF l_return_status <> fnd_api.g_ret_sts_error THEN
233: csi_t_gen_utility_pvt.add('Validate instance reference failed.');
234: RAISE fnd_api.g_exc_error;
235: END IF;
236:

Line 234: RAISE fnd_api.g_exc_error;

230: x_return_status => l_return_status);
231:
232: IF l_return_status <> fnd_api.g_ret_sts_error THEN
233: csi_t_gen_utility_pvt.add('Validate instance reference failed.');
234: RAISE fnd_api.g_exc_error;
235: END IF;
236:
237: END IF;
238:

Line 250: IF l_return_status <> fnd_api.g_ret_sts_success THEN

246: p_txn_line_detail_id => p_txn_party_detail_rec.txn_line_detail_id,
247: p_instance_party_id => p_txn_party_detail_rec.instance_party_id,
248: x_return_status => l_return_status);
249:
250: IF l_return_status <> fnd_api.g_ret_sts_success THEN
251:
252: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_ERROR');
253: FND_MESSAGE.set_token('PTY_SRC_NAME',
254: p_txn_party_detail_rec.party_source_table);

Line 258: RAISE fnd_api.g_exc_error;

254: p_txn_party_detail_rec.party_source_table);
255: FND_MESSAGE.set_token('PTY_SRC_ID',
256: p_txn_party_detail_rec.party_source_id);
257: FND_MSG_PUB.add;
258: RAISE fnd_api.g_exc_error;
259:
260: END IF;
261:
262: END IF;

Line 264: SELECT decode(nvl(p_txn_party_detail_rec.preserve_detail_flag,fnd_api.g_miss_char),

260: END IF;
261:
262: END IF;
263:
264: SELECT decode(nvl(p_txn_party_detail_rec.preserve_detail_flag,fnd_api.g_miss_char),
265: fnd_api.g_miss_char, 'Y', p_txn_party_detail_rec.preserve_detail_flag)
266: INTO l_preserve_detail_flag
267: FROM sys.dual;
268:

Line 265: fnd_api.g_miss_char, 'Y', p_txn_party_detail_rec.preserve_detail_flag)

261:
262: END IF;
263:
264: SELECT decode(nvl(p_txn_party_detail_rec.preserve_detail_flag,fnd_api.g_miss_char),
265: fnd_api.g_miss_char, 'Y', p_txn_party_detail_rec.preserve_detail_flag)
266: INTO l_preserve_detail_flag
267: FROM sys.dual;
268:
269: -- call table handler to create row in the table

Line 270: IF nvl(p_txn_party_detail_rec.txn_party_detail_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num

266: INTO l_preserve_detail_flag
267: FROM sys.dual;
268:
269: -- call table handler to create row in the table
270: IF nvl(p_txn_party_detail_rec.txn_party_detail_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
271: THEN
272: l_txn_party_detail_id := p_txn_party_detail_rec.txn_party_detail_id;
273: END IF;
274:

Line 326: raise fnd_api.g_exc_error;

322: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
323: fnd_message.set_token('MESSAGE',
324: 'csi_t_party_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
325: fnd_msg_pub.add;
326: raise fnd_api.g_exc_error;
327: end;
328:
329: p_txn_party_detail_rec.txn_party_detail_id := l_txn_party_detail_id;
330:

Line 354: IF l_return_status <> fnd_api.g_ret_sts_success THEN

350: x_return_status => l_return_status,
351: x_msg_count => l_msg_count,
352: x_msg_data => l_msg_data);
353:
354: IF l_return_status <> fnd_api.g_ret_sts_success THEN
355: csi_t_gen_utility_pvt.add('Create txn party accounts failed.');
356: RAISE fnd_api.g_exc_error;
357: END IF;
358:

Line 356: RAISE fnd_api.g_exc_error;

352: x_msg_data => l_msg_data);
353:
354: IF l_return_status <> fnd_api.g_ret_sts_success THEN
355: csi_t_gen_utility_pvt.add('Create txn party accounts failed.');
356: RAISE fnd_api.g_exc_error;
357: END IF;
358:
359: px_txn_pty_acct_detail_tbl(l_index).txn_party_detail_id :=
360: l_pty_acct_rec.txn_party_detail_id;

Line 370: IF fnd_api.To_Boolean( p_commit ) THEN

366: END LOOP;
367:
368: END IF;
369: -- Standard check of p_commit.
370: IF fnd_api.To_Boolean( p_commit ) THEN
371: COMMIT WORK;
372: END IF;
373:
374: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN

Line 374: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN

370: IF fnd_api.To_Boolean( p_commit ) THEN
371: COMMIT WORK;
372: END IF;
373:
374: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
375: csi_t_gen_utility_pvt.set_debug_off;
376: END IF;
377:
378: -- Standard call to get message count and if count is get message info.

Line 384: WHEN fnd_api.G_EXC_ERROR THEN

380: p_count => x_msg_count,
381: p_data => x_msg_data);
382:
383: EXCEPTION
384: WHEN fnd_api.G_EXC_ERROR THEN
385:
386: ROLLBACK TO create_txn_party_dtls;
387: x_return_status := fnd_api.G_RET_STS_ERROR ;
388: FND_MSG_PUB.Count_And_Get (

Line 387: x_return_status := fnd_api.G_RET_STS_ERROR ;

383: EXCEPTION
384: WHEN fnd_api.G_EXC_ERROR THEN
385:
386: ROLLBACK TO create_txn_party_dtls;
387: x_return_status := fnd_api.G_RET_STS_ERROR ;
388: FND_MSG_PUB.Count_And_Get (
389: p_count => x_msg_count,
390: p_data => x_msg_data);
391:

Line 392: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

388: FND_MSG_PUB.Count_And_Get (
389: p_count => x_msg_count,
390: p_data => x_msg_data);
391:
392: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
393:
394: ROLLBACK TO create_txn_party_dtls;
395: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
396:

Line 395: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

391:
392: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
393:
394: ROLLBACK TO create_txn_party_dtls;
395: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
396:
397: FND_MSG_PUB.Count_And_Get(
398: p_count => x_msg_count,
399: p_data => x_msg_data);

Line 404: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

400:
401: WHEN OTHERS THEN
402:
403: ROLLBACK TO create_txn_party_dtls;
404: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
405:
406: IF FND_MSG_PUB.Check_Msg_Level(
407: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408:

Line 424: p_commit IN varchar2 := fnd_api.g_false,

420:
421:
422: PROCEDURE create_txn_pty_acct_dtls(
423: p_api_version IN number,
424: p_commit IN varchar2 := fnd_api.g_false,
425: p_init_msg_list IN varchar2 := fnd_api.g_false,
426: p_validation_level IN number := fnd_api.g_valid_level_full,
427: p_txn_pty_acct_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_rec,
428: x_return_status OUT NOCOPY varchar2,

Line 425: p_init_msg_list IN varchar2 := fnd_api.g_false,

421:
422: PROCEDURE create_txn_pty_acct_dtls(
423: p_api_version IN number,
424: p_commit IN varchar2 := fnd_api.g_false,
425: p_init_msg_list IN varchar2 := fnd_api.g_false,
426: p_validation_level IN number := fnd_api.g_valid_level_full,
427: p_txn_pty_acct_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_rec,
428: x_return_status OUT NOCOPY varchar2,
429: x_msg_count OUT NOCOPY number,

Line 426: p_validation_level IN number := fnd_api.g_valid_level_full,

422: PROCEDURE create_txn_pty_acct_dtls(
423: p_api_version IN number,
424: p_commit IN varchar2 := fnd_api.g_false,
425: p_init_msg_list IN varchar2 := fnd_api.g_false,
426: p_validation_level IN number := fnd_api.g_valid_level_full,
427: p_txn_pty_acct_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_rec,
428: x_return_status OUT NOCOPY varchar2,
429: x_msg_count OUT NOCOPY number,
430: x_msg_data OUT NOCOPY varchar2)

Line 449: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

445: -- Standard Start of API savepoint
446: SAVEPOINT create_txn_pty_acct_dtls;
447:
448: -- Initialize message list if p_init_msg_list is set to TRUE.
449: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
450: FND_MSG_PUB.initialize;
451: END IF;
452:
453: -- Initialize API return status to success

Line 454: x_return_status := fnd_api.G_RET_STS_SUCCESS;

450: FND_MSG_PUB.initialize;
451: END IF;
452:
453: -- Initialize API return status to success
454: x_return_status := fnd_api.G_RET_STS_SUCCESS;
455:
456: -- Standard call to check for call compatibility.
457: IF NOT
458:

Line 459: fnd_api.compatible_api_call (

455:
456: -- Standard call to check for call compatibility.
457: IF NOT
458:
459: fnd_api.compatible_api_call (
460: p_current_version_number => l_api_version,
461: p_caller_version_number => p_api_version,
462: p_api_name => l_api_name,
463: p_pkg_name => g_pkg_name) THEN

Line 465: RAISE fnd_api.g_exc_unexpected_error;

461: p_caller_version_number => p_api_version,
462: p_api_name => l_api_name,
463: p_pkg_name => g_pkg_name) THEN
464:
465: RAISE fnd_api.g_exc_unexpected_error;
466:
467: END IF;
468:
469: -- Check the profile option debug_level for debug message reporting

Line 501: IF l_return_status <> fnd_api.g_ret_sts_success THEN

497: csi_t_vldn_routines_pvt.validate_account_id(
498: p_account_id => p_txn_pty_acct_detail_rec.account_id,
499: x_return_status => l_return_status);
500:
501: IF l_return_status <> fnd_api.g_ret_sts_success THEN
502:
503: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');
504: FND_MESSAGE.set_token('ACCT_ID',p_txn_pty_acct_detail_rec.account_id);
505: FND_MSG_PUB.add;

Line 506: RAISE fnd_api.g_exc_error;

502:
503: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');
504: FND_MESSAGE.set_token('ACCT_ID',p_txn_pty_acct_detail_rec.account_id);
505: FND_MSG_PUB.add;
506: RAISE fnd_api.g_exc_error;
507:
508: END IF;
509:
510: -- validate relationship_type_code from cs_lookups table

Line 516: RAISE fnd_api.g_exc_error;

512: csi_instance_parties_vld_pvt.is_pty_rel_type_valid(
513: p_party_rel_type_code => p_txn_pty_acct_detail_rec.relationship_type_code,
514: p_contact_flag => 'A')
515: THEN
516: RAISE fnd_api.g_exc_error;
517: END IF;
518:
519:
520: --##

Line 522: IF NVL(p_txn_pty_acct_detail_rec.ip_account_id, fnd_api.g_miss_num) <>

518:
519:
520: --##
521: -- validate ip_acount_id from the csi_instance_party_account_table
522: IF NVL(p_txn_pty_acct_detail_rec.ip_account_id, fnd_api.g_miss_num) <>
523: fnd_api.g_miss_num
524: THEN
525:
526: csi_t_vldn_routines_pvt.validate_ip_account_id(

Line 523: fnd_api.g_miss_num

519:
520: --##
521: -- validate ip_acount_id from the csi_instance_party_account_table
522: IF NVL(p_txn_pty_acct_detail_rec.ip_account_id, fnd_api.g_miss_num) <>
523: fnd_api.g_miss_num
524: THEN
525:
526: csi_t_vldn_routines_pvt.validate_ip_account_id(
527: p_ip_account_id => p_txn_pty_acct_detail_rec.ip_account_id,

Line 530: IF x_return_status <> fnd_api.g_ret_sts_success THEN

526: csi_t_vldn_routines_pvt.validate_ip_account_id(
527: p_ip_account_id => p_txn_pty_acct_detail_rec.ip_account_id,
528: x_return_status => l_return_status);
529:
530: IF x_return_status <> fnd_api.g_ret_sts_success THEN
531:
532: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
533: FND_MESSAGE.set_token('IP_ACCOUNT_ID',p_txn_pty_acct_detail_rec.ip_account_id);
534: FND_MSG_PUB.add;

Line 535: RAISE fnd_api.g_exc_error;

531:
532: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
533: FND_MESSAGE.set_token('IP_ACCOUNT_ID',p_txn_pty_acct_detail_rec.ip_account_id);
534: FND_MSG_PUB.add;
535: RAISE fnd_api.g_exc_error;
536:
537: END IF;
538:
539: END IF;

Line 546: IF l_return_status <> fnd_api.g_ret_sts_success THEN

542: csi_t_vldn_routines_pvt.get_party_detail_rec(
543: p_party_detail_id => p_txn_pty_acct_detail_rec.txn_party_detail_id,
544: x_party_detail_rec => l_pty_dtl_rec,
545: x_return_status => l_return_status);
546: IF l_return_status <> fnd_api.g_ret_sts_success THEN
547: -- raise error
548: RAISE fnd_api.g_exc_error;
549: END IF;
550:

Line 548: RAISE fnd_api.g_exc_error;

544: x_party_detail_rec => l_pty_dtl_rec,
545: x_return_status => l_return_status);
546: IF l_return_status <> fnd_api.g_ret_sts_success THEN
547: -- raise error
548: RAISE fnd_api.g_exc_error;
549: END IF;
550:
551: csi_t_vldn_routines_pvt.validate_party_account_id(
552: p_party_id => l_pty_dtl_rec.party_source_id,

Line 556: IF l_return_status <> fnd_api.g_ret_sts_success THEN

552: p_party_id => l_pty_dtl_rec.party_source_id,
553: p_party_account_id => p_txn_pty_acct_detail_rec.account_id,
554: x_return_status => l_return_status);
555:
556: IF l_return_status <> fnd_api.g_ret_sts_success THEN
557:
558: FND_MESSAGE.set_name('CSI','CSI_TXN_PTY_ACCT_INVALID');
559: FND_MESSAGE.set_token('PTY_ID',l_pty_dtl_rec.party_source_id);
560: FND_MESSAGE.set_token('PTY_ACC_ID',p_txn_pty_acct_detail_rec.account_id);

Line 562: RAISE fnd_api.g_exc_error;

558: FND_MESSAGE.set_name('CSI','CSI_TXN_PTY_ACCT_INVALID');
559: FND_MESSAGE.set_token('PTY_ID',l_pty_dtl_rec.party_source_id);
560: FND_MESSAGE.set_token('PTY_ACC_ID',p_txn_pty_acct_detail_rec.account_id);
561: FND_MSG_PUB.add;
562: RAISE fnd_api.g_exc_error;
563:
564: END IF;
565:
566: -- validate bill_to and ship_to address

Line 567: IF p_txn_pty_acct_detail_rec.bill_to_address_id <> fnd_api.g_miss_num THEN

563:
564: END IF;
565:
566: -- validate bill_to and ship_to address
567: IF p_txn_pty_acct_detail_rec.bill_to_address_id <> fnd_api.g_miss_num THEN
568:
569: csi_t_vldn_routines_pvt.validate_site_use_id(
570: p_account_id => p_txn_pty_acct_detail_rec.account_id,
571: p_site_use_id => p_txn_pty_acct_detail_rec.bill_to_address_id,

Line 575: IF l_return_status <> fnd_api.g_ret_sts_success THEN

571: p_site_use_id => p_txn_pty_acct_detail_rec.bill_to_address_id,
572: p_site_use_code => 'BILL_TO',
573: x_return_status => l_return_status);
574:
575: IF l_return_status <> fnd_api.g_ret_sts_success THEN
576: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
577: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
578: bill_to_address_id);
579: FND_MESSAGE.set_token('SITE_USE_CODE','BILL_TO');

Line 581: RAISE fnd_api.g_exc_error;

577: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
578: bill_to_address_id);
579: FND_MESSAGE.set_token('SITE_USE_CODE','BILL_TO');
580: FND_MSG_PUB.add;
581: RAISE fnd_api.g_exc_error;
582: END IF;
583:
584: END IF;
585:

Line 586: IF p_txn_pty_acct_detail_rec.ship_to_address_id <> fnd_api.g_miss_num THEN

582: END IF;
583:
584: END IF;
585:
586: IF p_txn_pty_acct_detail_rec.ship_to_address_id <> fnd_api.g_miss_num THEN
587:
588: csi_t_vldn_routines_pvt.validate_site_use_id(
589: p_account_id => p_txn_pty_acct_detail_rec.account_id,
590: p_site_use_id => p_txn_pty_acct_detail_rec.ship_to_address_id,

Line 594: IF l_return_status <> fnd_api.g_ret_sts_success THEN

590: p_site_use_id => p_txn_pty_acct_detail_rec.ship_to_address_id,
591: p_site_use_code => 'SHIP_TO',
592: x_return_status => l_return_status);
593:
594: IF l_return_status <> fnd_api.g_ret_sts_success THEN
595: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
596: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
597: ship_to_address_id);
598: FND_MESSAGE.set_token('SITE_USE_CODE','SHIP_TO');

Line 600: RAISE fnd_api.g_exc_error;

596: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
597: ship_to_address_id);
598: FND_MESSAGE.set_token('SITE_USE_CODE','SHIP_TO');
599: FND_MSG_PUB.add;
600: RAISE fnd_api.g_exc_error;
601: END IF;
602:
603: END IF;
604:

Line 605: SELECT decode(nvl(p_txn_pty_acct_detail_rec.preserve_detail_flag,fnd_api.g_miss_char),

601: END IF;
602:
603: END IF;
604:
605: SELECT decode(nvl(p_txn_pty_acct_detail_rec.preserve_detail_flag,fnd_api.g_miss_char),
606: fnd_api.g_miss_char, 'Y', p_txn_pty_acct_detail_rec.preserve_detail_flag)
607: INTO l_preserve_detail_flag
608: FROM sys.dual;
609:

Line 606: fnd_api.g_miss_char, 'Y', p_txn_pty_acct_detail_rec.preserve_detail_flag)

602:
603: END IF;
604:
605: SELECT decode(nvl(p_txn_pty_acct_detail_rec.preserve_detail_flag,fnd_api.g_miss_char),
606: fnd_api.g_miss_char, 'Y', p_txn_pty_acct_detail_rec.preserve_detail_flag)
607: INTO l_preserve_detail_flag
608: FROM sys.dual;
609:
610: -- call the table handler to insert row in to the database table

Line 611: IF nvl(p_txn_pty_acct_detail_rec.txn_account_detail_id, fnd_api.g_miss_num) <>

607: INTO l_preserve_detail_flag
608: FROM sys.dual;
609:
610: -- call the table handler to insert row in to the database table
611: IF nvl(p_txn_pty_acct_detail_rec.txn_account_detail_id, fnd_api.g_miss_num) <>
612: fnd_api.g_miss_num THEN
613: l_txn_account_detail_id := p_txn_pty_acct_detail_rec.txn_account_detail_id;
614: END IF;
615:

Line 612: fnd_api.g_miss_num THEN

608: FROM sys.dual;
609:
610: -- call the table handler to insert row in to the database table
611: IF nvl(p_txn_pty_acct_detail_rec.txn_account_detail_id, fnd_api.g_miss_num) <>
612: fnd_api.g_miss_num THEN
613: l_txn_account_detail_id := p_txn_pty_acct_detail_rec.txn_account_detail_id;
614: END IF;
615:
616: begin

Line 661: raise fnd_api.g_exc_error;

657: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
658: fnd_message.set_token('MESSAGE',
659: 'csi_t_party_accounts_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
660: fnd_msg_pub.add;
661: raise fnd_api.g_exc_error;
662: end;
663:
664: p_txn_pty_acct_detail_rec.txn_account_detail_id := l_txn_account_detail_id;
665:

Line 667: IF fnd_api.To_Boolean( p_commit ) THEN

663:
664: p_txn_pty_acct_detail_rec.txn_account_detail_id := l_txn_account_detail_id;
665:
666: -- Standard check of p_commit.
667: IF fnd_api.To_Boolean( p_commit ) THEN
668: COMMIT WORK;
669: END IF;
670:
671: csi_t_gen_utility_pvt.set_debug_off;

Line 679: WHEN fnd_api.G_EXC_ERROR THEN

675: p_count => x_msg_count,
676: p_data => x_msg_data);
677:
678: EXCEPTION
679: WHEN fnd_api.G_EXC_ERROR THEN
680:
681: ROLLBACK TO Create_Txn_Pty_Acct_Dtls;
682: x_return_status := fnd_api.G_RET_STS_ERROR ;
683: FND_MSG_PUB.Count_And_Get (

Line 682: x_return_status := fnd_api.G_RET_STS_ERROR ;

678: EXCEPTION
679: WHEN fnd_api.G_EXC_ERROR THEN
680:
681: ROLLBACK TO Create_Txn_Pty_Acct_Dtls;
682: x_return_status := fnd_api.G_RET_STS_ERROR ;
683: FND_MSG_PUB.Count_And_Get (
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686: csi_t_gen_utility_pvt.set_debug_off;

Line 688: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

684: p_count => x_msg_count,
685: p_data => x_msg_data);
686: csi_t_gen_utility_pvt.set_debug_off;
687:
688: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
689:
690: ROLLBACK TO Create_Txn_Pty_Acct_Dtls;
691: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
692:

Line 691: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

687:
688: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
689:
690: ROLLBACK TO Create_Txn_Pty_Acct_Dtls;
691: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
692:
693: FND_MSG_PUB.Count_And_Get(
694: p_count => x_msg_count,
695: p_data => x_msg_data);

Line 701: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

697:
698: WHEN OTHERS THEN
699:
700: ROLLBACK TO Create_Txn_Pty_Acct_Dtls;
701: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
702:
703: IF FND_MSG_PUB.Check_Msg_Level(
704: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
705:

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

717: END create_txn_pty_acct_dtls;
718:
719: PROCEDURE update_txn_party_dtls(
720: p_api_version IN NUMBER,
721: p_commit IN VARCHAR2 := fnd_api.g_false,
722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
723: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
724: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
725: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

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

718:
719: PROCEDURE update_txn_party_dtls(
720: p_api_version IN NUMBER,
721: p_commit IN VARCHAR2 := fnd_api.g_false,
722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
723: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
724: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
725: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
726: x_return_status OUT NOCOPY VARCHAR2,

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

719: PROCEDURE update_txn_party_dtls(
720: p_api_version IN NUMBER,
721: p_commit IN VARCHAR2 := fnd_api.g_false,
722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
723: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
724: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
725: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,

Line 737: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

733: l_debug_level NUMBER;
734:
735: l_pty_rec csi_t_party_details%ROWTYPE;
736: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;
737: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
738: l_msg_count number;
739: l_msg_data varchar2(512);
740: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
741: l_del_pa_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;

Line 771: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

767: -- Standard Start of API savepoint
768: SAVEPOINT update_txn_party_dtls;
769:
770: -- Initialize message list if p_init_msg_list is set to TRUE.
771: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
772: FND_MSG_PUB.initialize;
773: END IF;
774:
775: -- Initialize API return status to success

Line 776: x_return_status := fnd_api.G_RET_STS_SUCCESS;

772: FND_MSG_PUB.initialize;
773: END IF;
774:
775: -- Initialize API return status to success
776: x_return_status := fnd_api.G_RET_STS_SUCCESS;
777:
778: -- Standard call to check for call compatibility.
779: IF NOT
780:

Line 781: fnd_api.Compatible_API_Call (

777:
778: -- Standard call to check for call compatibility.
779: IF NOT
780:
781: fnd_api.Compatible_API_Call (
782: p_current_version_number => l_api_version,
783: p_caller_version_number => p_api_version,
784: p_api_name => l_api_name,
785: p_pkg_name => G_PKG_NAME) THEN

Line 787: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

783: p_caller_version_number => p_api_version,
784: p_api_name => l_api_name,
785: p_pkg_name => G_PKG_NAME) THEN
786:
787: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
788:
789: END IF;
790:
791: -- debug messages

Line 826: IF l_return_status <> fnd_api.g_ret_sts_success THEN

822: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(
823: p_txn_party_detail_id => l_pty_rec.txn_party_detail_id,
824: x_return_status => l_return_status);
825:
826: IF l_return_status <> fnd_api.g_ret_sts_success THEN
827:
828: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
829: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_rec.txn_party_detail_id);
830: FND_MSG_PUB.add;

Line 831: RAISE fnd_api.g_exc_error;

827:
828: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
829: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_rec.txn_party_detail_id);
830: FND_MSG_PUB.add;
831: RAISE fnd_api.g_exc_error;
832:
833: END IF;
834:
835: FOR l_pty_cur_rec IN pty_cur (l_pty_rec.txn_party_detail_id)

Line 854: RAISE fnd_api.g_exc_error;

850: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
851: FND_MESSAGE.set_token('LVL_ID', l_pty_rec.txn_line_detail_id);
852: FND_MESSAGE.set_token('STATUS',l_processing_status);
853: FND_MSG_PUB.add;
854: RAISE fnd_api.g_exc_error;
855:
856: END IF;
857:
858: l_pty_rec.party_source_table :=

Line 861: IF l_pty_rec.party_source_table <> fnd_api.g_miss_char

857:
858: l_pty_rec.party_source_table :=
859: p_txn_party_detail_tbl(l_ind).party_source_table;
860:
861: IF l_pty_rec.party_source_table <> fnd_api.g_miss_char
862: THEN
863:
864: -- validate party_source_table
865: csi_t_vldn_routines_pvt.check_reqd_param(

Line 875: RAISE fnd_api.g_exc_error;

871: csi_instance_parties_vld_pvt.is_pty_source_tab_valid(
872: p_party_source_table => l_pty_rec.party_source_table)
873: THEN
874: csi_t_gen_utility_pvt.add('Validate party source table failed.');
875: RAISE fnd_api.g_exc_error;
876: END IF;
877:
878: END IF;
879:

Line 887: IF l_pty_rec.party_source_id <> fnd_api.g_miss_num THEN

883: l_pty_rec.contact_flag :=
884: p_txn_party_detail_tbl(l_ind).contact_flag;
885:
886:
887: IF l_pty_rec.party_source_id <> fnd_api.g_miss_num THEN
888:
889: csi_t_vldn_routines_pvt.check_reqd_param(
890: p_value => l_pty_rec.party_source_id,
891: p_param_name => 'l_pty_rec.party_source_id',

Line 902: RAISE fnd_api.g_exc_error;

898: p_party_id => l_pty_rec.party_source_id,
899: p_contact_flag => l_pty_rec.contact_flag)
900: THEN
901: csi_t_gen_utility_pvt.add('Validate party source table failed.');
902: RAISE fnd_api.g_exc_error;
903: END IF;
904: END IF;
905:
906: l_pty_rec.instance_party_id :=

Line 909: IF NVL(l_pty_rec.instance_party_id , fnd_api.g_miss_num) <>

905:
906: l_pty_rec.instance_party_id :=
907: p_txn_party_detail_tbl(l_ind).instance_party_id;
908:
909: IF NVL(l_pty_rec.instance_party_id , fnd_api.g_miss_num) <>
910: fnd_api.g_miss_num
911: THEN
912:
913: --check if the instance_party_id is a valid dtl of

Line 910: fnd_api.g_miss_num

906: l_pty_rec.instance_party_id :=
907: p_txn_party_detail_tbl(l_ind).instance_party_id;
908:
909: IF NVL(l_pty_rec.instance_party_id , fnd_api.g_miss_num) <>
910: fnd_api.g_miss_num
911: THEN
912:
913: --check if the instance_party_id is a valid dtl of
914: --referenced instance id (from the txn_line_details)

Line 922: IF l_return_status <> fnd_api.g_ret_sts_success THEN

918: p_level_dtl_id => l_pty_rec.txn_line_detail_id,
919: p_level_inst_ref_id => l_pty_rec.instance_party_id,
920: x_return_status => l_return_status);
921:
922: IF l_return_status <> fnd_api.g_ret_sts_success THEN
923: csi_t_gen_utility_pvt.add('Validate instance party id failed.');
924: RAISE fnd_api.g_exc_error;
925: END IF;
926:

Line 924: RAISE fnd_api.g_exc_error;

920: x_return_status => l_return_status);
921:
922: IF l_return_status <> fnd_api.g_ret_sts_success THEN
923: csi_t_gen_utility_pvt.add('Validate instance party id failed.');
924: RAISE fnd_api.g_exc_error;
925: END IF;
926:
927: END IF;
928:

Line 932: IF l_pty_rec.relationship_type_code <> fnd_api.g_miss_char THEN

928:
929: l_pty_rec.relationship_type_code :=
930: p_txn_party_detail_tbl(l_ind).relationship_type_code;
931:
932: IF l_pty_rec.relationship_type_code <> fnd_api.g_miss_char THEN
933:
934: csi_t_vldn_routines_pvt.check_reqd_param(
935: p_value => l_pty_rec.relationship_type_code,
936: p_param_name => 'l_pty_rec.relationship_type_code',

Line 952: RAISE fnd_api.g_exc_error;

948: p_party_rel_type_code => l_pty_rec.relationship_type_code,
949: p_contact_flag => l_contact_flag)
950: THEN
951: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');
952: RAISE fnd_api.g_exc_error;
953: END IF;
954:
955: END IF;
956:

Line 1053: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1049: p_party_account_id => l_pa_cur_rec.account_id,
1050: x_return_status => l_return_status);
1051:
1052: /* if not valid then mark the record for deletion */
1053: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1054:
1055: l_del_pa_ind := l_del_pa_ind + 1;
1056:
1057: l_del_pa_ids_tbl(l_del_pa_ind).txn_party_detail_id :=

Line 1091: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1087: x_return_status => l_return_status,
1088: x_msg_count => l_msg_count,
1089: x_msg_data => l_msg_data);
1090:
1091: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1092: RAISE fnd_api.g_exc_error;
1093: END IF;
1094:
1095: END IF;

Line 1092: RAISE fnd_api.g_exc_error;

1088: x_msg_count => l_msg_count,
1089: x_msg_data => l_msg_data);
1090:
1091: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1092: RAISE fnd_api.g_exc_error;
1093: END IF;
1094:
1095: END IF;
1096:

Line 1171: raise fnd_api.g_exc_error;

1167: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1168: fnd_message.set_token('MESSAGE',
1169: 'csi_t_party_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));
1170: fnd_msg_pub.add;
1171: raise fnd_api.g_exc_error;
1172: end;
1173:
1174: END LOOP;
1175:

Line 1184: IF nvl(px_txn_pty_acct_detail_tbl(l_pa_ind).txn_account_detail_id,fnd_api.g_miss_num) <>

1180: FOR l_pa_ind IN px_txn_pty_acct_detail_tbl.FIRST..
1181: px_txn_pty_acct_detail_tbl.LAST
1182: LOOP
1183: -- Self-Bug, part of Mass update. Handle create Account within a party update...
1184: IF nvl(px_txn_pty_acct_detail_tbl(l_pa_ind).txn_account_detail_id,fnd_api.g_miss_num) <>
1185: fnd_api.g_miss_num THEN -- it is a update account
1186:
1187: -- Build the acct tbl to call it at the end...
1188:

Line 1185: fnd_api.g_miss_num THEN -- it is a update account

1181: px_txn_pty_acct_detail_tbl.LAST
1182: LOOP
1183: -- Self-Bug, part of Mass update. Handle create Account within a party update...
1184: IF nvl(px_txn_pty_acct_detail_tbl(l_pa_ind).txn_account_detail_id,fnd_api.g_miss_num) <>
1185: fnd_api.g_miss_num THEN -- it is a update account
1186:
1187: -- Build the acct tbl to call it at the end...
1188:
1189: l_u_pty_acct_tbl(l_u_acct_ind).txn_account_detail_id :=

Line 1375: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1371: x_return_status => l_return_status,
1372: x_msg_count => l_msg_count,
1373: x_msg_data => l_msg_data);
1374:
1375: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1376: RAISE fnd_api.g_exc_error;
1377: END IF;
1378:
1379: END IF;

Line 1376: RAISE fnd_api.g_exc_error;

1372: x_msg_count => l_msg_count,
1373: x_msg_data => l_msg_data);
1374:
1375: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1376: RAISE fnd_api.g_exc_error;
1377: END IF;
1378:
1379: END IF;
1380:

Line 1395: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1391: x_return_status => l_return_status,
1392: x_msg_count => l_msg_count,
1393: x_msg_data => l_msg_data);
1394:
1395: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1396: RAISE fnd_api.g_exc_error;
1397: END IF;
1398:
1399: END IF;

Line 1396: RAISE fnd_api.g_exc_error;

1392: x_msg_count => l_msg_count,
1393: x_msg_data => l_msg_data);
1394:
1395: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1396: RAISE fnd_api.g_exc_error;
1397: END IF;
1398:
1399: END IF;
1400: END IF;

Line 1407: IF fnd_api.To_Boolean( p_commit ) THEN

1403:
1404: END IF;
1405:
1406: -- Standard check of p_commit.
1407: IF fnd_api.To_Boolean( p_commit ) THEN
1408: COMMIT WORK;
1409: END IF;
1410:
1411: -- Standard call to get message count and if count is get message info.

Line 1417: WHEN fnd_api.G_EXC_ERROR THEN

1413: p_count => x_msg_count,
1414: p_data => x_msg_data);
1415:
1416: EXCEPTION
1417: WHEN fnd_api.G_EXC_ERROR THEN
1418:
1419: ROLLBACK TO update_txn_party_dtls;
1420: x_return_status := fnd_api.G_RET_STS_ERROR ;
1421: FND_MSG_PUB.Count_And_Get (

Line 1420: x_return_status := fnd_api.G_RET_STS_ERROR ;

1416: EXCEPTION
1417: WHEN fnd_api.G_EXC_ERROR THEN
1418:
1419: ROLLBACK TO update_txn_party_dtls;
1420: x_return_status := fnd_api.G_RET_STS_ERROR ;
1421: FND_MSG_PUB.Count_And_Get (
1422: p_count => x_msg_count,
1423: p_data => x_msg_data);
1424:

Line 1425: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

1421: FND_MSG_PUB.Count_And_Get (
1422: p_count => x_msg_count,
1423: p_data => x_msg_data);
1424:
1425: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1426:
1427: ROLLBACK TO update_txn_party_dtls;
1428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1429:

Line 1428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1424:
1425: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1426:
1427: ROLLBACK TO update_txn_party_dtls;
1428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1429:
1430: FND_MSG_PUB.Count_And_Get(
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);

Line 1437: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1433:
1434: WHEN OTHERS THEN
1435:
1436: ROLLBACK TO update_txn_party_dtls;
1437: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1438:
1439: IF FND_MSG_PUB.Check_Msg_Level(
1440: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1441:

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

1454: /*
1455: */
1456: PROCEDURE update_txn_pty_acct_dtls (
1457: p_api_version IN NUMBER
1458: ,p_commit IN VARCHAR2 := fnd_api.g_false
1459: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1460: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1461: ,p_txn_pty_acct_detail_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1462: ,x_return_status OUT NOCOPY VARCHAR2

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

1455: */
1456: PROCEDURE update_txn_pty_acct_dtls (
1457: p_api_version IN NUMBER
1458: ,p_commit IN VARCHAR2 := fnd_api.g_false
1459: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1460: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1461: ,p_txn_pty_acct_detail_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1462: ,x_return_status OUT NOCOPY VARCHAR2
1463: ,x_msg_count OUT NOCOPY NUMBER

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

1456: PROCEDURE update_txn_pty_acct_dtls (
1457: p_api_version IN NUMBER
1458: ,p_commit IN VARCHAR2 := fnd_api.g_false
1459: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1460: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1461: ,p_txn_pty_acct_detail_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1462: ,x_return_status OUT NOCOPY VARCHAR2
1463: ,x_msg_count OUT NOCOPY NUMBER
1464: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 1486: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

1482: -- Standard Start of API savepoint
1483: SAVEPOINT update_txn_pty_acct_dtls;
1484:
1485: -- Initialize message list if p_init_msg_list is set to TRUE.
1486: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
1487: FND_MSG_PUB.initialize;
1488: END IF;
1489:
1490: -- Initialize API return status to success

Line 1491: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1487: FND_MSG_PUB.initialize;
1488: END IF;
1489:
1490: -- Initialize API return status to success
1491: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1492:
1493: -- Standard call to check for call compatibility.
1494: IF NOT
1495:

Line 1496: fnd_api.Compatible_API_Call (

1492:
1493: -- Standard call to check for call compatibility.
1494: IF NOT
1495:
1496: fnd_api.Compatible_API_Call (
1497: p_current_version_number => l_api_version,
1498: p_caller_version_number => p_api_version,
1499: p_api_name => l_api_name,
1500: p_pkg_name => G_PKG_NAME) THEN

Line 1502: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

1498: p_caller_version_number => p_api_version,
1499: p_api_name => l_api_name,
1500: p_pkg_name => G_PKG_NAME) THEN
1501:
1502: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1503:
1504: END IF;
1505:
1506: -- debug messages

Line 1541: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1537: csi_t_vldn_routines_pvt.validate_txn_acct_detail_id(
1538: p_txn_acct_detail_id => l_pa_rec.txn_account_detail_id,
1539: x_return_status => l_return_status);
1540:
1541: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1542:
1543: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');
1544: FND_MESSAGE.set_token('PTY_DTL_ID',l_pa_rec.txn_account_detail_id);
1545: FND_MSG_PUB.add;

Line 1546: RAISE fnd_api.g_exc_error;

1542:
1543: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');
1544: FND_MESSAGE.set_token('PTY_DTL_ID',l_pa_rec.txn_account_detail_id);
1545: FND_MSG_PUB.add;
1546: RAISE fnd_api.g_exc_error;
1547:
1548: END IF;
1549:
1550: FOR l_pa_cur_rec in pa_cur (l_pa_rec.txn_account_detail_id)

Line 1567: RAISE fnd_api.g_exc_error;

1563: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
1564: FND_MESSAGE.set_token('LVL_ID', l_pa_rec.txn_account_detail_id);
1565: FND_MESSAGE.set_token('STATUS',l_processing_status);
1566: FND_MSG_PUB.add;
1567: RAISE fnd_api.g_exc_error;
1568:
1569: END IF;
1570:
1571: l_pa_rec.ip_account_id :=

Line 1574: IF nvl(l_pa_rec.ip_account_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

1570:
1571: l_pa_rec.ip_account_id :=
1572: p_txn_pty_acct_detail_tbl(l_ind).ip_account_id;
1573:
1574: IF nvl(l_pa_rec.ip_account_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
1575: THEN
1576:
1577: --validate ip_account_id
1578: IF NOT csi_instance_parties_vld_pvt.is_ip_account_valid(

Line 1580: RAISE fnd_api.g_exc_error;

1576:
1577: --validate ip_account_id
1578: IF NOT csi_instance_parties_vld_pvt.is_ip_account_valid(
1579: p_ip_account_id => l_pa_rec.ip_account_id) THEN
1580: RAISE fnd_api.g_exc_error;
1581: csi_t_gen_utility_pvt.add('Validate ip account id failed.');
1582: END IF;
1583:
1584: END IF;

Line 1589: IF l_pa_rec.account_id <> fnd_api.g_miss_num THEN

1585:
1586: l_pa_rec.account_id :=
1587: p_txn_pty_acct_detail_tbl(l_ind).account_id;
1588:
1589: IF l_pa_rec.account_id <> fnd_api.g_miss_num THEN
1590:
1591: -- validate account_id from hz_cust_accounts table
1592: csi_t_vldn_routines_pvt.validate_account_id(
1593: p_account_id => l_pa_rec.account_id,

Line 1596: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1592: csi_t_vldn_routines_pvt.validate_account_id(
1593: p_account_id => l_pa_rec.account_id,
1594: x_return_status => l_return_status);
1595:
1596: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1597:
1598: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');
1599: FND_MESSAGE.set_token('ACCT_ID',l_pa_rec.account_id);
1600: FND_MSG_PUB.add;

Line 1601: RAISE fnd_api.g_exc_error;

1597:
1598: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');
1599: FND_MESSAGE.set_token('ACCT_ID',l_pa_rec.account_id);
1600: FND_MSG_PUB.add;
1601: RAISE fnd_api.g_exc_error;
1602:
1603: END IF;
1604:
1605: END IF;

Line 1610: IF l_pa_rec.relationship_type_code <> fnd_api.g_miss_char THEN

1606:
1607: l_pa_rec.relationship_type_code :=
1608: p_txn_pty_acct_detail_tbl(l_ind).relationship_type_code;
1609:
1610: IF l_pa_rec.relationship_type_code <> fnd_api.g_miss_char THEN
1611: -- validate relationship_type_code
1612: IF NOT
1613: csi_instance_parties_vld_pvt.is_pty_rel_type_valid(
1614: p_party_rel_type_code => l_pa_rec.relationship_type_code,

Line 1618: RAISE fnd_api.g_exc_error;

1614: p_party_rel_type_code => l_pa_rec.relationship_type_code,
1615: p_contact_flag => 'A')
1616: THEN
1617: csi_t_gen_utility_pvt.add('Validate party relationship type code failed.');
1618: RAISE fnd_api.g_exc_error;
1619: END IF;
1620:
1621: END IF;
1622:

Line 1701: raise fnd_api.g_exc_error;

1697: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1698: fnd_message.set_token('MESSAGE',
1699: 'csi_t_party_accounts_pkg.update_row Failed. '||substr(sqlerrm,1,200));
1700: fnd_msg_pub.add;
1701: raise fnd_api.g_exc_error;
1702: end;
1703:
1704: END LOOP;
1705:

Line 1711: IF fnd_api.To_Boolean( p_commit ) THEN

1707:
1708: END IF;
1709:
1710: -- Standard check of p_commit.
1711: IF fnd_api.To_Boolean( p_commit ) THEN
1712: COMMIT WORK;
1713: END IF;
1714:
1715: -- Standard call to get message count and if count is get message info.

Line 1721: WHEN fnd_api.G_EXC_ERROR THEN

1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:
1720: EXCEPTION
1721: WHEN fnd_api.G_EXC_ERROR THEN
1722:
1723: ROLLBACK TO update_txn_pty_acct_dtls;
1724: x_return_status := fnd_api.G_RET_STS_ERROR ;
1725: FND_MSG_PUB.Count_And_Get (

Line 1724: x_return_status := fnd_api.G_RET_STS_ERROR ;

1720: EXCEPTION
1721: WHEN fnd_api.G_EXC_ERROR THEN
1722:
1723: ROLLBACK TO update_txn_pty_acct_dtls;
1724: x_return_status := fnd_api.G_RET_STS_ERROR ;
1725: FND_MSG_PUB.Count_And_Get (
1726: p_count => x_msg_count,
1727: p_data => x_msg_data);
1728:

Line 1729: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

1725: FND_MSG_PUB.Count_And_Get (
1726: p_count => x_msg_count,
1727: p_data => x_msg_data);
1728:
1729: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1730:
1731: ROLLBACK TO update_txn_pty_acct_dtls;
1732: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1733:

Line 1732: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1728:
1729: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1730:
1731: ROLLBACK TO update_txn_pty_acct_dtls;
1732: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1733:
1734: FND_MSG_PUB.Count_And_Get(
1735: p_count => x_msg_count,
1736: p_data => x_msg_data);

Line 1742: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

1738: WHEN OTHERS THEN
1739:
1740:
1741: ROLLBACK TO update_txn_pty_acct_dtls;
1742: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
1743:
1744: IF FND_MSG_PUB.Check_Msg_Level(
1745: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1746:

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

1756: END update_txn_pty_acct_dtls;
1757:
1758: PROCEDURE delete_txn_party_dtls(
1759: p_api_version IN NUMBER
1760: ,p_commit IN VARCHAR2 := fnd_api.g_false
1761: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1762: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1763: ,p_txn_party_ids_tbl IN csi_t_datastructures_grp.txn_party_ids_tbl
1764: ,x_txn_pty_acct_ids_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_ids_tbl

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

1757:
1758: PROCEDURE delete_txn_party_dtls(
1759: p_api_version IN NUMBER
1760: ,p_commit IN VARCHAR2 := fnd_api.g_false
1761: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1762: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1763: ,p_txn_party_ids_tbl IN csi_t_datastructures_grp.txn_party_ids_tbl
1764: ,x_txn_pty_acct_ids_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_ids_tbl
1765: ,x_return_status OUT NOCOPY VARCHAR2

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

1758: PROCEDURE delete_txn_party_dtls(
1759: p_api_version IN NUMBER
1760: ,p_commit IN VARCHAR2 := fnd_api.g_false
1761: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1762: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1763: ,p_txn_party_ids_tbl IN csi_t_datastructures_grp.txn_party_ids_tbl
1764: ,x_txn_pty_acct_ids_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_ids_tbl
1765: ,x_return_status OUT NOCOPY VARCHAR2
1766: ,x_msg_count OUT NOCOPY NUMBER

Line 1804: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

1800: -- Standard Start of API savepoint
1801: SAVEPOINT delete_txn_party_dtls;
1802:
1803: -- Initialize message list if p_init_msg_list is set to TRUE.
1804: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
1805: FND_MSG_PUB.initialize;
1806: END IF;
1807:
1808: -- Initialize API return status to success

Line 1809: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1805: FND_MSG_PUB.initialize;
1806: END IF;
1807:
1808: -- Initialize API return status to success
1809: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1810:
1811: -- Standard call to check for call compatibility.
1812: IF NOT
1813:

Line 1814: fnd_api.Compatible_API_Call (

1810:
1811: -- Standard call to check for call compatibility.
1812: IF NOT
1813:
1814: fnd_api.Compatible_API_Call (
1815: p_current_version_number => l_api_version,
1816: p_caller_version_number => p_api_version,
1817: p_api_name => l_api_name,
1818: p_pkg_name => G_PKG_NAME) THEN

Line 1820: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

1816: p_caller_version_number => p_api_version,
1817: p_api_name => l_api_name,
1818: p_pkg_name => G_PKG_NAME) THEN
1819:
1820: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1821:
1822: END IF;
1823:
1824: l_pty_acc_ind := 0;

Line 1844: IF nvl(l_pty_dtl_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

1840: LOOP
1841:
1842: l_pty_dtl_id := p_txn_party_ids_tbl(l_ind).txn_party_detail_id;
1843:
1844: IF nvl(l_pty_dtl_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1845:
1846: -- validate the transaction party detail ID
1847: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(
1848: p_txn_party_detail_id => l_pty_dtl_id,

Line 1851: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1847: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(
1848: p_txn_party_detail_id => l_pty_dtl_id,
1849: x_return_status => l_return_status);
1850:
1851: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1852:
1853: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
1854: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);
1855: FND_MSG_PUB.add;

Line 1856: RAISE fnd_api.g_exc_error;

1852:
1853: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
1854: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);
1855: FND_MSG_PUB.add;
1856: RAISE fnd_api.g_exc_error;
1857:
1858: END IF;
1859:
1860: -- populate the party account table

Line 1883: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1879: x_return_status => l_return_status,
1880: x_msg_count => l_msg_count,
1881: x_msg_data => l_msg_data);
1882:
1883: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1884: RAISE fnd_api.g_exc_error;
1885: END IF;
1886:
1887: -- If the party deleted has contacts, delete them too

Line 1884: RAISE fnd_api.g_exc_error;

1880: x_msg_count => l_msg_count,
1881: x_msg_data => l_msg_data);
1882:
1883: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1884: RAISE fnd_api.g_exc_error;
1885: END IF;
1886:
1887: -- If the party deleted has contacts, delete them too
1888: FOR cont_pty_rec in cont_pty_cur(l_pty_dtl_id)

Line 1922: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1918: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
1919: p_txn_line_detail_id => l_line_dtl_id,
1920: x_return_status => l_return_status);
1921:
1922: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1923:
1924: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
1925: FND_MESSAGE.set_token('LINE_DTL_ID',l_line_dtl_id);
1926: FND_MSG_PUB.add;

Line 1927: RAISE fnd_api.g_exc_error;

1923:
1924: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
1925: FND_MESSAGE.set_token('LINE_DTL_ID',l_line_dtl_id);
1926: FND_MSG_PUB.add;
1927: RAISE fnd_api.g_exc_error;
1928:
1929: END IF;
1930:
1931: FOR pty_rec in pty_cur (l_line_dtl_id)

Line 1958: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1954: x_return_status => l_return_status,
1955: x_msg_count => l_msg_count,
1956: x_msg_data => l_msg_data);
1957:
1958: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1959: RAISE fnd_api.g_exc_error;
1960: END IF;
1961: -- If the party deleted has contacts, delete them too
1962: FOR cont_pty_rec in cont_pty_cur(l_pty_dtl_id)

Line 1959: RAISE fnd_api.g_exc_error;

1955: x_msg_count => l_msg_count,
1956: x_msg_data => l_msg_data);
1957:
1958: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1959: RAISE fnd_api.g_exc_error;
1960: END IF;
1961: -- If the party deleted has contacts, delete them too
1962: FOR cont_pty_rec in cont_pty_cur(l_pty_dtl_id)
1963: LOOP

Line 1988: IF fnd_api.To_Boolean( p_commit ) THEN

1984: END LOOP;
1985: END IF;
1986:
1987: -- Standard check of p_commit.
1988: IF fnd_api.To_Boolean( p_commit ) THEN
1989: COMMIT WORK;
1990: END IF;
1991:
1992: -- Standard call to get message count and if count is get message info.

Line 1998: WHEN fnd_api.G_EXC_ERROR THEN

1994: p_count => x_msg_count,
1995: p_data => x_msg_data);
1996:
1997: EXCEPTION
1998: WHEN fnd_api.G_EXC_ERROR THEN
1999:
2000: ROLLBACK TO delete_txn_party_dtls;
2001: x_return_status := fnd_api.G_RET_STS_ERROR ;
2002: FND_MSG_PUB.Count_And_Get (

Line 2001: x_return_status := fnd_api.G_RET_STS_ERROR ;

1997: EXCEPTION
1998: WHEN fnd_api.G_EXC_ERROR THEN
1999:
2000: ROLLBACK TO delete_txn_party_dtls;
2001: x_return_status := fnd_api.G_RET_STS_ERROR ;
2002: FND_MSG_PUB.Count_And_Get (
2003: p_count => x_msg_count,
2004: p_data => x_msg_data);
2005:

Line 2006: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

2002: FND_MSG_PUB.Count_And_Get (
2003: p_count => x_msg_count,
2004: p_data => x_msg_data);
2005:
2006: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2007:
2008: ROLLBACK TO delete_txn_party_dtls;
2009: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2010:

Line 2009: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2005:
2006: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2007:
2008: ROLLBACK TO delete_txn_party_dtls;
2009: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2010:
2011: FND_MSG_PUB.Count_And_Get(
2012: p_count => x_msg_count,
2013: p_data => x_msg_data);

Line 2018: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2014:
2015: WHEN OTHERS THEN
2016:
2017: ROLLBACK TO delete_txn_party_dtls;
2018: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2019:
2020: IF FND_MSG_PUB.Check_Msg_Level(
2021: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2022:

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

2034:
2035: /* deletes the party accounts based on the ids passed */
2036: PROCEDURE delete_txn_pty_acct_dtls(
2037: p_api_version IN NUMBER
2038: ,p_commit IN VARCHAR2 := fnd_api.g_false
2039: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2040: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2041: ,p_txn_pty_acct_ids_tbl IN csi_t_datastructures_grp.txn_pty_acct_ids_tbl
2042: ,x_return_status OUT NOCOPY VARCHAR2

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

2035: /* deletes the party accounts based on the ids passed */
2036: PROCEDURE delete_txn_pty_acct_dtls(
2037: p_api_version IN NUMBER
2038: ,p_commit IN VARCHAR2 := fnd_api.g_false
2039: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2040: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2041: ,p_txn_pty_acct_ids_tbl IN csi_t_datastructures_grp.txn_pty_acct_ids_tbl
2042: ,x_return_status OUT NOCOPY VARCHAR2
2043: ,x_msg_count OUT NOCOPY NUMBER

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

2036: PROCEDURE delete_txn_pty_acct_dtls(
2037: p_api_version IN NUMBER
2038: ,p_commit IN VARCHAR2 := fnd_api.g_false
2039: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2040: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2041: ,p_txn_pty_acct_ids_tbl IN csi_t_datastructures_grp.txn_pty_acct_ids_tbl
2042: ,x_return_status OUT NOCOPY VARCHAR2
2043: ,x_msg_count OUT NOCOPY NUMBER
2044: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 2066: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

2062: -- Standard Start of API savepoint
2063: SAVEPOINT delete_txn_pty_acct_dtls;
2064:
2065: -- Initialize message list if p_init_msg_list is set to TRUE.
2066: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
2067: FND_MSG_PUB.initialize;
2068: END IF;
2069:
2070: -- Initialize API return status to success

Line 2071: x_return_status := fnd_api.G_RET_STS_SUCCESS;

2067: FND_MSG_PUB.initialize;
2068: END IF;
2069:
2070: -- Initialize API return status to success
2071: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2072:
2073: -- Standard call to check for call compatibility.
2074: IF NOT
2075:

Line 2076: fnd_api.Compatible_API_Call (

2072:
2073: -- Standard call to check for call compatibility.
2074: IF NOT
2075:
2076: fnd_api.Compatible_API_Call (
2077: p_current_version_number => l_api_version,
2078: p_caller_version_number => p_api_version,
2079: p_api_name => l_api_name,
2080: p_pkg_name => G_PKG_NAME) THEN

Line 2082: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

2078: p_caller_version_number => p_api_version,
2079: p_api_name => l_api_name,
2080: p_pkg_name => G_PKG_NAME) THEN
2081:
2082: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
2083:
2084: END IF;
2085:
2086: -- debug messages

Line 2104: IF nvl(l_acct_dtl_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

2100: LOOP
2101:
2102: l_acct_dtl_id := p_txn_pty_acct_ids_tbl(l_ind).txn_account_detail_id;
2103:
2104: IF nvl(l_acct_dtl_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
2105: THEN
2106:
2107: csi_t_vldn_routines_pvt.validate_txn_acct_detail_id(
2108: p_txn_acct_detail_id => l_acct_dtl_id,

Line 2111: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2107: csi_t_vldn_routines_pvt.validate_txn_acct_detail_id(
2108: p_txn_acct_detail_id => l_acct_dtl_id,
2109: x_return_status => l_return_status);
2110:
2111: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2112:
2113: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');
2114: FND_MESSAGE.set_token('PTY_ACCT_ID',l_acct_dtl_id);
2115: FND_MSG_PUB.add;

Line 2116: RAISE fnd_api.g_exc_error;

2112:
2113: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');
2114: FND_MESSAGE.set_token('PTY_ACCT_ID',l_acct_dtl_id);
2115: FND_MSG_PUB.add;
2116: RAISE fnd_api.g_exc_error;
2117:
2118: END IF;
2119:
2120: csi_t_gen_utility_pvt.dump_api_info(

Line 2136: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2132: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(
2133: p_txn_party_detail_id => l_pty_dtl_id,
2134: x_return_status => l_return_status);
2135:
2136: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2137:
2138: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
2139: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);
2140: FND_MSG_PUB.add;

Line 2141: RAISE fnd_api.g_exc_error;

2137:
2138: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
2139: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);
2140: FND_MSG_PUB.add;
2141: RAISE fnd_api.g_exc_error;
2142:
2143: END IF;
2144:
2145: FOR pty_acc_rec in pty_acc_cur (l_pty_dtl_id)

Line 2163: IF fnd_api.To_Boolean( p_commit ) THEN

2159: END LOOP;
2160: END IF;
2161:
2162: -- Standard check of p_commit.
2163: IF fnd_api.To_Boolean( p_commit ) THEN
2164: COMMIT WORK;
2165: END IF;
2166:
2167: -- Standard call to get message count and if count is get message info.

Line 2173: WHEN fnd_api.G_EXC_ERROR THEN

2169: p_count => x_msg_count,
2170: p_data => x_msg_data);
2171:
2172: EXCEPTION
2173: WHEN fnd_api.G_EXC_ERROR THEN
2174:
2175: ROLLBACK TO delete_txn_pty_acct_dtls;
2176: x_return_status := fnd_api.G_RET_STS_ERROR ;
2177: FND_MSG_PUB.Count_And_Get (

Line 2176: x_return_status := fnd_api.G_RET_STS_ERROR ;

2172: EXCEPTION
2173: WHEN fnd_api.G_EXC_ERROR THEN
2174:
2175: ROLLBACK TO delete_txn_pty_acct_dtls;
2176: x_return_status := fnd_api.G_RET_STS_ERROR ;
2177: FND_MSG_PUB.Count_And_Get (
2178: p_count => x_msg_count,
2179: p_data => x_msg_data);
2180:

Line 2181: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

2177: FND_MSG_PUB.Count_And_Get (
2178: p_count => x_msg_count,
2179: p_data => x_msg_data);
2180:
2181: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2182:
2183: ROLLBACK TO delete_txn_pty_acct_dtls;
2184: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2185:

Line 2184: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2180:
2181: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2182:
2183: ROLLBACK TO delete_txn_pty_acct_dtls;
2184: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2185:
2186: FND_MSG_PUB.Count_And_Get(
2187: p_count => x_msg_count,
2188: p_data => x_msg_data);

Line 2193: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

2189:
2190: WHEN OTHERS THEN
2191:
2192: ROLLBACK TO delete_txn_pty_acct_dtls;
2193: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
2194:
2195: IF FND_MSG_PUB.Check_Msg_Level(
2196: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2197:

Line 2224: x_return_status := fnd_api.g_ret_sts_success;

2220: l_ind binary_integer;
2221:
2222: BEGIN
2223:
2224: x_return_status := fnd_api.g_ret_sts_success;
2225:
2226: api_log('get_pty_acct_dtls');
2227:
2228: l_select_stmt :=

Line 2388: x_return_status := fnd_api.g_ret_sts_success;

2384: l_ind binary_integer;
2385:
2386: BEGIN
2387:
2388: x_return_status := fnd_api.g_ret_sts_success;
2389:
2390: api_log('get_party_dtls');
2391:
2392: l_select_stmt :=

Line 2484: WHEN fnd_api.g_exc_error THEN

2480:
2481: dbms_sql.close_cursor(l_pty_cur_id);
2482:
2483: EXCEPTION
2484: WHEN fnd_api.g_exc_error THEN
2485: x_return_status := fnd_api.g_ret_sts_error;
2486: IF dbms_sql.is_open(l_pty_cur_id) THEN
2487: dbms_sql.close_cursor(l_pty_cur_id);
2488: END IF;

Line 2485: x_return_status := fnd_api.g_ret_sts_error;

2481: dbms_sql.close_cursor(l_pty_cur_id);
2482:
2483: EXCEPTION
2484: WHEN fnd_api.g_exc_error THEN
2485: x_return_status := fnd_api.g_ret_sts_error;
2486: IF dbms_sql.is_open(l_pty_cur_id) THEN
2487: dbms_sql.close_cursor(l_pty_cur_id);
2488: END IF;
2489: WHEN others THEN

Line 2490: x_return_status := fnd_api.g_ret_sts_unexp_error;

2486: IF dbms_sql.is_open(l_pty_cur_id) THEN
2487: dbms_sql.close_cursor(l_pty_cur_id);
2488: END IF;
2489: WHEN others THEN
2490: x_return_status := fnd_api.g_ret_sts_unexp_error;
2491:
2492: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2493: fnd_message.set_token('MESSAGE',substr(sqlerrm, 1, 255));
2494: fnd_msg_pub.add;

Line 2508: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

2504: x_return_status OUT NOCOPY varchar2)
2505: IS
2506: l_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2507: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2508: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2509: l_p_ind binary_integer := 0;
2510: BEGIN
2511: x_return_status := fnd_api.g_ret_sts_success;
2512: IF p_line_detail_tbl.count > 0 THEN

Line 2511: x_return_status := fnd_api.g_ret_sts_success;

2507: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2508: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2509: l_p_ind binary_integer := 0;
2510: BEGIN
2511: x_return_status := fnd_api.g_ret_sts_success;
2512: IF p_line_detail_tbl.count > 0 THEN
2513:
2514: FOR l_ind in p_line_detail_tbl.FIRST .. p_line_detail_tbl.LAST
2515: LOOP

Line 2535: WHEN fnd_api.g_exc_error THEN

2531: END LOOP;
2532: END IF;
2533: x_party_detail_tbl := l_party_detail_tbl;
2534: EXCEPTION
2535: WHEN fnd_api.g_exc_error THEN
2536: x_return_status := fnd_api.g_ret_sts_error;
2537: END get_all_party_dtls;
2538:
2539: PROCEDURE get_all_pty_acct_dtls(

Line 2536: x_return_status := fnd_api.g_ret_sts_error;

2532: END IF;
2533: x_party_detail_tbl := l_party_detail_tbl;
2534: EXCEPTION
2535: WHEN fnd_api.g_exc_error THEN
2536: x_return_status := fnd_api.g_ret_sts_error;
2537: END get_all_party_dtls;
2538:
2539: PROCEDURE get_all_pty_acct_dtls(
2540: p_party_detail_tbl in csi_t_datastructures_grp.txn_party_detail_tbl,

Line 2547: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

2543: IS
2544: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2545: l_tmp_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2546: l_pa_ind binary_integer := 0;
2547: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2548:
2549: BEGIN
2550:
2551: x_return_status := fnd_api.g_ret_sts_success;

Line 2551: x_return_status := fnd_api.g_ret_sts_success;

2547: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2548:
2549: BEGIN
2550:
2551: x_return_status := fnd_api.g_ret_sts_success;
2552: IF p_party_detail_tbl.count > 0 THEN
2553: FOR l_ind IN p_party_detail_tbl.FIRST .. p_party_detail_tbl.LAST
2554: LOOP
2555:

Line 2577: WHEN fnd_api.g_exc_error THEN

2573: END IF;
2574: x_pty_acct_detail_tbl := l_pa_tbl;
2575:
2576: EXCEPTION
2577: WHEN fnd_api.g_exc_error THEN
2578: x_return_status := fnd_api.g_ret_sts_error;
2579: END get_all_pty_acct_dtls;
2580:
2581: END csi_t_txn_parties_pvt;

Line 2578: x_return_status := fnd_api.g_ret_sts_error;

2574: x_pty_acct_detail_tbl := l_pa_tbl;
2575:
2576: EXCEPTION
2577: WHEN fnd_api.g_exc_error THEN
2578: x_return_status := fnd_api.g_ret_sts_error;
2579: END get_all_pty_acct_dtls;
2580:
2581: END csi_t_txn_parties_pvt;