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

Line 48: WHEN FND_API.G_EXC_ERROR THEN

44: csi_t_gen_utility_pvt.set_debug_off;
45: return l_found;
46:
47: EXCEPTION
48: WHEN FND_API.G_EXC_ERROR THEN
49:
50: csi_t_gen_utility_pvt.set_debug_off;
51: RETURN false;
52:

Line 53: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

49:
50: csi_t_gen_utility_pvt.set_debug_off;
51: RETURN false;
52:
53: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
54:
55: csi_t_gen_utility_pvt.set_debug_off;
56: RETURN false;
57:

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

67: This procedure gets the transaction details for the given transaction lines.
68: */
69: PROCEDURE get_transaction_details(
70: p_api_version IN NUMBER
71: ,p_commit IN VARCHAR2 := fnd_api.g_false
72: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
73: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
74: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec

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

68: */
69: PROCEDURE get_transaction_details(
70: p_api_version IN NUMBER
71: ,p_commit IN VARCHAR2 := fnd_api.g_false
72: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
73: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
74: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl

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

69: PROCEDURE get_transaction_details(
70: p_api_version IN NUMBER
71: ,p_commit IN VARCHAR2 := fnd_api.g_false
72: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
73: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
74: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false

Line 77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false

73: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
74: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false

Line 79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false

75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false

Line 81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false

77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false

Line 83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false

79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false

Line 85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false

81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false

Line 87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false

83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
90: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
91: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false

Line 89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false

85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
90: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
91: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
92: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
93: ,x_return_status OUT NOCOPY VARCHAR2

Line 91: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false

87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
90: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
91: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
92: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
93: ,x_return_status OUT NOCOPY VARCHAR2
94: ,x_msg_count OUT NOCOPY NUMBER
95: ,x_msg_data OUT NOCOPY VARCHAR2)

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

98: l_api_name CONSTANT VARCHAR2(30) := 'get_transaction_dtls';
99: l_api_version CONSTANT NUMBER := 1.0;
100: l_debug_level NUMBER;
101:
102: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
103: l_msg_count NUMBER;
104: l_msg_data VARCHAR2(512);
105:
106: ---Added (Start) for m-to-m enhancements

Line 129: AND a.transaction_line_id = DECODE(c_line_id,fnd_api.g_miss_num, a.transaction_line_id,NULL, a.transaction_line_id, c_line_id);

125: SELECT a.transaction_line_id,
126: a.source_transaction_id
127: FROM csi_t_transaction_lines a
128: WHERE a.source_txn_header_id = c_header_id
129: AND a.transaction_line_id = DECODE(c_line_id,fnd_api.g_miss_num, a.transaction_line_id,NULL, a.transaction_line_id, c_line_id);
130:
131: ---Added (End) for m-to-m enhancements
132:
133: BEGIN

Line 142: IF FND_API.to_Boolean( p_init_msg_list ) THEN

138: csi_t_gen_utility_pvt.add('API Being Executed : Get Transaction Details');
139: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list ) THEN
143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Initialize API return status to success

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: -- Standard call to check for call compatibility.
150: IF NOT
151:

Line 152: FND_API.Compatible_API_Call (

148:
149: -- Standard call to check for call compatibility.
150: IF NOT
151:
152: FND_API.Compatible_API_Call (
153: p_current_version_number => l_api_version,
154: p_caller_version_number => p_api_version,
155: p_api_name => l_api_name,
156: p_pkg_name => G_PKG_NAME) THEN

Line 158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

154: p_caller_version_number => p_api_version,
155: p_api_name => l_api_name,
156: p_pkg_name => G_PKG_NAME) THEN
157:
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159:
160: END IF;
161:
162: /**** Commented for Bug 3304439

Line 173: -- fnd_api.g_exc_error exception

169: -- Main API code
170: --
171: -- This procedure check if the installed base is active, If not active
172: -- populates the error message in the message queue and raises the
173: -- fnd_api.g_exc_error exception
174:
175: csi_utility_grp.check_ib_active;
176:
177: -- Added for CZ Integration (Begin)

Line 179: IF NVL(l_txn_line_query_rec.config_session_hdr_id , fnd_api.g_miss_num)

175: csi_utility_grp.check_ib_active;
176:
177: -- Added for CZ Integration (Begin)
178: l_txn_line_query_rec := p_txn_line_query_rec ;
179: IF NVL(l_txn_line_query_rec.config_session_hdr_id , fnd_api.g_miss_num)
180: <> fnd_api.g_miss_num
181: THEN
182: csi_t_gen_utility_pvt.add ('getting txn line id for session keys');
183: ---Get the line id associated with the given Config attribs.

Line 180: <> fnd_api.g_miss_num

176:
177: -- Added for CZ Integration (Begin)
178: l_txn_line_query_rec := p_txn_line_query_rec ;
179: IF NVL(l_txn_line_query_rec.config_session_hdr_id , fnd_api.g_miss_num)
180: <> fnd_api.g_miss_num
181: THEN
182: csi_t_gen_utility_pvt.add ('getting txn line id for session keys');
183: ---Get the line id associated with the given Config attribs.
184: csi_t_vldn_routines_pvt.get_cz_txn_line_id(

Line 191: IF x_return_status <> fnd_api.g_ret_sts_success

187: p_config_session_item_id => p_txn_line_query_rec.config_session_item_id ,
188: x_txn_line_id => l_txn_line_query_rec.transaction_line_id,
189: x_return_status => x_return_status);
190:
191: IF x_return_status <> fnd_api.g_ret_sts_success
192: THEN
193: RAISE FND_API.g_exc_error;
194: END IF ;
195:

Line 193: RAISE FND_API.g_exc_error;

189: x_return_status => x_return_status);
190:
191: IF x_return_status <> fnd_api.g_ret_sts_success
192: THEN
193: RAISE FND_API.g_exc_error;
194: END IF ;
195:
196: END IF ;
197: -- Added for CZ Integration (End)

Line 202: AND l_txn_line_query_rec.source_txn_header_id <> fnd_api.g_miss_num

198:
199: ---Added (Start) for m-to-m enhancements
200: l_loop_cnt := 0;
201: IF l_txn_line_query_rec.source_txn_header_id IS NOT NULL
202: AND l_txn_line_query_rec.source_txn_header_id <> fnd_api.g_miss_num
203: THEN
204: --IF l_txn_line_query_rec.source_transaction_type_id = 51
205: --THEN
206: FOR txn_line_rec IN txn_line_cur (l_txn_line_query_rec.source_txn_header_id, l_txn_line_query_rec.transaction_line_id)

Line 214: OR l_txn_line_query_rec.transaction_line_id=fnd_api.g_miss_num

210:
211: l_loop_cnt := l_loop_cnt+1 ;
212:
213: IF l_txn_line_query_rec.transaction_line_id IS NULL
214: OR l_txn_line_query_rec.transaction_line_id=fnd_api.g_miss_num
215: THEN
216: l_txn_line_query_rec.transaction_line_id := txn_line_rec.transaction_line_id ;
217: END IF ;
218:

Line 247: IF l_return_status <> fnd_api.g_ret_sts_success THEN

243: x_return_status => l_return_status,
244: x_msg_count => l_msg_count,
245: x_msg_data => l_msg_data);
246:
247: IF l_return_status <> fnd_api.g_ret_sts_success THEN
248: RAISE fnd_api.g_exc_error;
249: END IF;
250:
251: IF x_tmp_line_detail_tbl.COUNT > 0

Line 248: RAISE fnd_api.g_exc_error;

244: x_msg_count => l_msg_count,
245: x_msg_data => l_msg_data);
246:
247: IF l_return_status <> fnd_api.g_ret_sts_success THEN
248: RAISE fnd_api.g_exc_error;
249: END IF;
250:
251: IF x_tmp_line_detail_tbl.COUNT > 0
252: THEN

Line 369: IF FND_API.To_Boolean( p_commit ) THEN

365:
366: END LOOP ; ---txn_line_cur
367:
368: -- Standard check of p_commit.
369: IF FND_API.To_Boolean( p_commit ) THEN
370: COMMIT WORK;
371: END IF;
372:
373: /**** Commented for Bug 3304439

Line 418: IF l_return_status <> fnd_api.g_ret_sts_success THEN

414: x_return_status => l_return_status,
415: x_msg_count => l_msg_count,
416: x_msg_data => l_msg_data);
417:
418: IF l_return_status <> fnd_api.g_ret_sts_success THEN
419: RAISE fnd_api.g_exc_error;
420: END IF;
421:
422: -- Standard check of p_commit.

Line 419: RAISE fnd_api.g_exc_error;

415: x_msg_count => l_msg_count,
416: x_msg_data => l_msg_data);
417:
418: IF l_return_status <> fnd_api.g_ret_sts_success THEN
419: RAISE fnd_api.g_exc_error;
420: END IF;
421:
422: -- Standard check of p_commit.
423: IF FND_API.To_Boolean( p_commit ) THEN

Line 423: IF FND_API.To_Boolean( p_commit ) THEN

419: RAISE fnd_api.g_exc_error;
420: END IF;
421:
422: -- Standard check of p_commit.
423: IF FND_API.To_Boolean( p_commit ) THEN
424: COMMIT WORK;
425: END IF;
426:
427: /**** Commented for Bug 3304439

Line 444: WHEN FND_API.G_EXC_ERROR THEN

440: csi_t_gen_utility_pvt.add('API Executed : Get Transaction Details');
441: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
442:
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445:
446: ROLLBACK TO Get_Transaction_Dtls;
447: x_return_status := FND_API.G_RET_STS_ERROR ;
448: FND_MSG_PUB.Count_And_Get (

Line 447: x_return_status := FND_API.G_RET_STS_ERROR ;

443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445:
446: ROLLBACK TO Get_Transaction_Dtls;
447: x_return_status := FND_API.G_RET_STS_ERROR ;
448: FND_MSG_PUB.Count_And_Get (
449: p_count => x_msg_count,
450: p_data => x_msg_data);
451:

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

448: FND_MSG_PUB.Count_And_Get (
449: p_count => x_msg_count,
450: p_data => x_msg_data);
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453:
454: ROLLBACK TO Get_Transaction_Dtls;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456:

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453:
454: ROLLBACK TO Get_Transaction_Dtls;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456:
457: FND_MSG_PUB.Count_And_Get(
458: p_count => x_msg_count,
459: p_data => x_msg_data);

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

460:
461: WHEN OTHERS THEN
462:
463: ROLLBACK TO Get_Transaction_Dtls;
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
465:
466: IF FND_MSG_PUB.Check_Msg_Level(
467: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
468:

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

484: */
485: PROCEDURE create_transaction_dtls
486: (
487: p_api_version IN NUMBER
488: ,p_commit IN VARCHAR2 := fnd_api.g_false
489: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
490: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
491: ,px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl

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

485: PROCEDURE create_transaction_dtls
486: (
487: p_api_version IN NUMBER
488: ,p_commit IN VARCHAR2 := fnd_api.g_false
489: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
490: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
491: ,px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl

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

486: (
487: p_api_version IN NUMBER
488: ,p_commit IN VARCHAR2 := fnd_api.g_false
489: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
490: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
491: ,px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl

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

505: l_api_name CONSTANT VARCHAR2(30) := 'create_transaction_dtls';
506: l_api_version CONSTANT NUMBER := 1.0;
507: l_debug_level NUMBER;
508:
509: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
510: l_msg_count NUMBER;
511: l_msg_data VARCHAR2(512);
512:
513: l_count NUMBER;

Line 528: IF FND_API.To_Boolean( p_init_msg_list ) THEN

524: csi_t_gen_utility_pvt.add('API Being Executed : Create Transaction Details');
525: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.To_Boolean( p_init_msg_list ) THEN
529: FND_MSG_PUB.Initialize;
530: END IF;
531:
532: -- Initialize API return status to success

Line 533: x_return_status := FND_API.G_RET_STS_SUCCESS;

529: FND_MSG_PUB.Initialize;
530: END IF;
531:
532: -- Initialize API return status to success
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534:
535: -- Standard call to check for call compatibility.
536: IF NOT
537:

Line 538: FND_API.Compatible_API_Call (

534:
535: -- Standard call to check for call compatibility.
536: IF NOT
537:
538: FND_API.Compatible_API_Call (
539: p_current_version_number => l_api_version,
540: p_caller_version_number => p_api_version,
541: p_api_name => l_api_name,
542: p_pkg_name => g_pkg_name) THEN

Line 544: RAISE FND_API.G_Exc_Unexpected_Error;

540: p_caller_version_number => p_api_version,
541: p_api_name => l_api_name,
542: p_pkg_name => g_pkg_name) THEN
543:
544: RAISE FND_API.G_Exc_Unexpected_Error;
545:
546: END IF;
547:
548: /**** Commented for Bug 3304439

Line 559: -- fnd_api.g_exc_error exception

555: -- main code starts here
556: --
557: -- This procedure check if the installed base is active, If not active
558: -- populates the error message in the message queue and raises the
559: -- fnd_api.g_exc_error exception
560: --
561:
562: csi_utility_grp.check_ib_active;
563:

Line 565: IF NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)

561:
562: csi_utility_grp.check_ib_active;
563:
564: -- Added for CZ Integration (Begin)
565: IF NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)
566: <> fnd_api.g_miss_num
567: AND px_txn_line_rec.api_caller_identity <> 'CONFIG'
568: THEN
569: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');

Line 566: <> fnd_api.g_miss_num

562: csi_utility_grp.check_ib_active;
563:
564: -- Added for CZ Integration (Begin)
565: IF NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)
566: <> fnd_api.g_miss_num
567: AND px_txn_line_rec.api_caller_identity <> 'CONFIG'
568: THEN
569: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
570: FND_MESSAGE.set_token('API_CALLER',px_txn_line_rec.api_caller_identity) ;

Line 572: RAISE FND_API.g_exc_error;

568: THEN
569: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
570: FND_MESSAGE.set_token('API_CALLER',px_txn_line_rec.api_caller_identity) ;
571: FND_MSG_PUB.add;
572: RAISE FND_API.g_exc_error;
573: END IF ;
574:
575: IF NVL(px_txn_line_rec.source_transaction_type_id , -1) = 401
576: AND NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)

Line 576: AND NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)

572: RAISE FND_API.g_exc_error;
573: END IF ;
574:
575: IF NVL(px_txn_line_rec.source_transaction_type_id , -1) = 401
576: AND NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)
577: = fnd_api.g_miss_num
578: THEN
579: FND_MESSAGE.set_name('CSI','CSI_TXN_CZ_KEYS_NOT_GIVEN');
580: FND_MSG_PUB.add;

Line 577: = fnd_api.g_miss_num

573: END IF ;
574:
575: IF NVL(px_txn_line_rec.source_transaction_type_id , -1) = 401
576: AND NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)
577: = fnd_api.g_miss_num
578: THEN
579: FND_MESSAGE.set_name('CSI','CSI_TXN_CZ_KEYS_NOT_GIVEN');
580: FND_MSG_PUB.add;
581: RAISE FND_API.g_exc_error;

Line 581: RAISE FND_API.g_exc_error;

577: = fnd_api.g_miss_num
578: THEN
579: FND_MESSAGE.set_name('CSI','CSI_TXN_CZ_KEYS_NOT_GIVEN');
580: FND_MSG_PUB.add;
581: RAISE FND_API.g_exc_error;
582: END IF ;
583:
584: IF NVL(px_txn_line_rec.source_transaction_type_id , -1) <> 401
585: AND NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)

Line 585: AND NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)

581: RAISE FND_API.g_exc_error;
582: END IF ;
583:
584: IF NVL(px_txn_line_rec.source_transaction_type_id , -1) <> 401
585: AND NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)
586: <> fnd_api.g_miss_num
587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_SOURCE');
589: FND_MSG_PUB.add;

Line 586: <> fnd_api.g_miss_num

582: END IF ;
583:
584: IF NVL(px_txn_line_rec.source_transaction_type_id , -1) <> 401
585: AND NVL(px_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)
586: <> fnd_api.g_miss_num
587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_SOURCE');
589: FND_MSG_PUB.add;
590: RAISE FND_API.g_exc_error;

Line 590: RAISE FND_API.g_exc_error;

586: <> fnd_api.g_miss_num
587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_SOURCE');
589: FND_MSG_PUB.add;
590: RAISE FND_API.g_exc_error;
591: END IF ;
592: -- Added for CZ Integration (End)
593:
594:

Line 608: p_commit => fnd_api.g_false,

604: END IF;
605:
606: csi_t_txn_details_pvt.create_transaction_dtls(
607: p_api_version => p_api_version,
608: p_commit => fnd_api.g_false,
609: p_init_msg_list => p_init_msg_list,
610: p_validation_level => p_validation_level,
611: px_txn_line_rec => px_txn_line_rec,
612: px_txn_line_detail_tbl => px_txn_line_detail_tbl,

Line 623: IF l_return_status <> fnd_api.g_ret_sts_success THEN

619: x_return_status => l_return_status,
620: x_msg_count => l_msg_count,
621: x_msg_data => l_msg_data);
622:
623: IF l_return_status <> fnd_api.g_ret_sts_success THEN
624: RAISE fnd_api.g_exc_error;
625: END IF;
626:
627: -- Standard check of p_commit.

Line 624: RAISE fnd_api.g_exc_error;

620: x_msg_count => l_msg_count,
621: x_msg_data => l_msg_data);
622:
623: IF l_return_status <> fnd_api.g_ret_sts_success THEN
624: RAISE fnd_api.g_exc_error;
625: END IF;
626:
627: -- Standard check of p_commit.
628: IF FND_API.To_Boolean( p_commit ) THEN

Line 628: IF FND_API.To_Boolean( p_commit ) THEN

624: RAISE fnd_api.g_exc_error;
625: END IF;
626:
627: -- Standard check of p_commit.
628: IF FND_API.To_Boolean( p_commit ) THEN
629: COMMIT WORK;
630: END IF;
631:
632: /**** Commented for Bug 3304439

Line 650: WHEN FND_API.G_EXC_ERROR THEN

646:
647: csi_t_gen_utility_pvt.set_debug_off;
648:
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651:
652: ROLLBACK TO create_transaction_dtls;
653: x_return_status := FND_API.G_RET_STS_ERROR ;
654: FND_MSG_PUB.Count_And_Get (

Line 653: x_return_status := FND_API.G_RET_STS_ERROR ;

649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651:
652: ROLLBACK TO create_transaction_dtls;
653: x_return_status := FND_API.G_RET_STS_ERROR ;
654: FND_MSG_PUB.Count_And_Get (
655: p_count => x_msg_count,
656: p_data => x_msg_data);
657:

Line 661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

657:
658: csi_t_gen_utility_pvt.dump_error_stack;
659: csi_t_gen_utility_pvt.set_debug_off;
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662:
663: ROLLBACK TO create_transaction_dtls;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
665:

Line 664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662:
663: ROLLBACK TO create_transaction_dtls;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
665:
666: FND_MSG_PUB.Count_And_Get(
667: p_count => x_msg_count,
668: p_data => x_msg_data);

Line 676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

672:
673: WHEN OTHERS THEN
674:
675: ROLLBACK TO create_transaction_dtls;
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
677:
678: IF FND_MSG_PUB.Check_Msg_Level(
679: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
680:

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

697: This procedure is used to update the transaction line details.
698: */
699: PROCEDURE update_txn_line_dtls(
700: p_api_version IN NUMBER
701: ,p_commit IN VARCHAR2 := fnd_api.g_false
702: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
703: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
704: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl

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

698: */
699: PROCEDURE update_txn_line_dtls(
700: p_api_version IN NUMBER
701: ,p_commit IN VARCHAR2 := fnd_api.g_false
702: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
703: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
704: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl

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

699: PROCEDURE update_txn_line_dtls(
700: p_api_version IN NUMBER
701: ,p_commit IN VARCHAR2 := fnd_api.g_false
702: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
703: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
704: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
707: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl

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

718: l_api_name CONSTANT VARCHAR2(30) := 'update_txn_line_dtls';
719: l_api_version CONSTANT NUMBER := 1.0;
720: l_debug_level NUMBER;
721:
722: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
723: l_msg_count NUMBER;
724: l_msg_data VARCHAR2(512);
725:
726: BEGIN

Line 735: IF FND_API.to_Boolean( p_init_msg_list ) THEN

731: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');
732: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean( p_init_msg_list ) THEN
736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Initialize API return status to success

Line 740: x_return_status := FND_API.G_RET_STS_SUCCESS;

736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Initialize API return status to success
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742: -- Standard call to check for call compatibility.
743: IF NOT
744:

Line 745: FND_API.Compatible_API_Call (

741:
742: -- Standard call to check for call compatibility.
743: IF NOT
744:
745: FND_API.Compatible_API_Call (
746: p_current_version_number => l_api_version,
747: p_caller_version_number => p_api_version,
748: p_api_name => l_api_name,
749: p_pkg_name => G_PKG_NAME) THEN

Line 751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

747: p_caller_version_number => p_api_version,
748: p_api_name => l_api_name,
749: p_pkg_name => G_PKG_NAME) THEN
750:
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752:
753: END IF;
754:
755: /**** Commented for Bug 3304439

Line 766: -- fnd_api.g_exc_error exception

762: -- Main API code
763: --
764: -- This procedure check if the installed base is active, If not active
765: -- populates the error message in the message queue and raises the
766: -- fnd_api.g_exc_error exception
767: --
768:
769: csi_utility_grp.check_ib_active;
770:

Line 772: IF NVL(p_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)

768:
769: csi_utility_grp.check_ib_active;
770:
771: -- Added for CZ Integration (Begin)
772: IF NVL(p_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)
773: <> fnd_api.g_miss_num
774: AND p_txn_line_rec.api_caller_identity <> 'CONFIG'
775: THEN
776: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');

Line 773: <> fnd_api.g_miss_num

769: csi_utility_grp.check_ib_active;
770:
771: -- Added for CZ Integration (Begin)
772: IF NVL(p_txn_line_rec.config_session_hdr_id , fnd_api.g_miss_num)
773: <> fnd_api.g_miss_num
774: AND p_txn_line_rec.api_caller_identity <> 'CONFIG'
775: THEN
776: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
777: FND_MESSAGE.set_token('API_CALLER',p_txn_line_rec.api_caller_identity);

Line 779: RAISE FND_API.g_exc_error;

775: THEN
776: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
777: FND_MESSAGE.set_token('API_CALLER',p_txn_line_rec.api_caller_identity);
778: FND_MSG_PUB.add;
779: RAISE FND_API.g_exc_error;
780: END IF ;
781: -- Added for CZ Integration (End)
782:
783: csi_t_txn_line_dtls_pvt.update_txn_line_dtls(

Line 785: p_commit => fnd_api.g_false,

781: -- Added for CZ Integration (End)
782:
783: csi_t_txn_line_dtls_pvt.update_txn_line_dtls(
784: p_api_version => p_api_version,
785: p_commit => fnd_api.g_false,
786: p_init_msg_list => p_init_msg_list,
787: p_validation_level => p_validation_level,
788: p_txn_line_rec => p_txn_line_rec,
789: p_txn_line_detail_tbl => p_txn_line_detail_tbl,

Line 799: IF l_return_status <> fnd_api.g_ret_sts_success THEN

795: x_return_status => l_return_status,
796: x_msg_count => l_msg_count,
797: x_msg_data => l_msg_data);
798:
799: IF l_return_status <> fnd_api.g_ret_sts_success THEN
800: RAISE fnd_api.g_exc_error;
801: END IF;
802:
803: -- Standard check of p_commit.

Line 800: RAISE fnd_api.g_exc_error;

796: x_msg_count => l_msg_count,
797: x_msg_data => l_msg_data);
798:
799: IF l_return_status <> fnd_api.g_ret_sts_success THEN
800: RAISE fnd_api.g_exc_error;
801: END IF;
802:
803: -- Standard check of p_commit.
804: IF FND_API.To_Boolean( p_commit ) THEN

Line 804: IF FND_API.To_Boolean( p_commit ) THEN

800: RAISE fnd_api.g_exc_error;
801: END IF;
802:
803: -- Standard check of p_commit.
804: IF FND_API.To_Boolean( p_commit ) THEN
805: COMMIT WORK;
806: END IF;
807:
808: /**** Commented for Bug 3304439

Line 828: WHEN FND_API.G_EXC_ERROR THEN

824:
825: csi_t_gen_utility_pvt.set_debug_off;
826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829:
830: ROLLBACK TO Update_Txn_Line_Dtls;
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832: FND_MSG_PUB.Count_And_Get (

Line 831: x_return_status := FND_API.G_RET_STS_ERROR ;

827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829:
830: ROLLBACK TO Update_Txn_Line_Dtls;
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832: FND_MSG_PUB.Count_And_Get (
833: p_count => x_msg_count,
834: p_data => x_msg_data);
835:

Line 839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

835:
836: csi_t_gen_utility_pvt.dump_error_stack;
837: csi_t_gen_utility_pvt.set_debug_off;
838:
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840:
841: ROLLBACK TO Update_Txn_Line_Dtls;
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
843:

Line 842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

838:
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840:
841: ROLLBACK TO Update_Txn_Line_Dtls;
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
843:
844: FND_MSG_PUB.Count_And_Get(
845: p_count => x_msg_count,
846: p_data => x_msg_data);

Line 854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

850:
851: WHEN OTHERS THEN
852:
853: ROLLBACK TO Update_Txn_Line_Dtls;
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
855:
856: IF FND_MSG_PUB.Check_Msg_Level(
857: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
858:

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

875: */
876: PROCEDURE delete_transaction_dtls
877: (
878: p_api_version IN NUMBER
879: ,p_commit IN VARCHAR2 := fnd_api.g_false
880: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
881: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
882: ,p_transaction_line_id IN NUMBER
883: ,p_api_caller_identity IN VARCHAR2

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

876: PROCEDURE delete_transaction_dtls
877: (
878: p_api_version IN NUMBER
879: ,p_commit IN VARCHAR2 := fnd_api.g_false
880: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
881: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
882: ,p_transaction_line_id IN NUMBER
883: ,p_api_caller_identity IN VARCHAR2
884: ,x_return_status OUT NOCOPY VARCHAR2

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

877: (
878: p_api_version IN NUMBER
879: ,p_commit IN VARCHAR2 := fnd_api.g_false
880: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
881: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
882: ,p_transaction_line_id IN NUMBER
883: ,p_api_caller_identity IN VARCHAR2
884: ,x_return_status OUT NOCOPY VARCHAR2
885: ,x_msg_count OUT NOCOPY NUMBER

Line 916: IF FND_API.to_Boolean( p_init_msg_list ) THEN

912: csi_t_gen_utility_pvt.add('API Being Executed : Delete Transaction Details');
913: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
914:
915: -- Initialize message list if p_init_msg_list is set to TRUE.
916: IF FND_API.to_Boolean( p_init_msg_list ) THEN
917: FND_MSG_PUB.initialize;
918: END IF;
919:
920: -- Initialize API return status to success

Line 921: x_return_status := FND_API.G_RET_STS_SUCCESS;

917: FND_MSG_PUB.initialize;
918: END IF;
919:
920: -- Initialize API return status to success
921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922:
923: -- Standard call to check for call compatibility.
924: IF NOT
925:

Line 926: FND_API.Compatible_API_Call (

922:
923: -- Standard call to check for call compatibility.
924: IF NOT
925:
926: FND_API.Compatible_API_Call (
927: p_current_version_number => l_api_version,
928: p_caller_version_number => p_api_version,
929: p_api_name => l_api_name,
930: p_pkg_name => G_PKG_NAME) THEN

Line 932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

928: p_caller_version_number => p_api_version,
929: p_api_name => l_api_name,
930: p_pkg_name => G_PKG_NAME) THEN
931:
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933:
934: END IF;
935:
936: /**** Commented for Bug 3304439

Line 947: -- fnd_api.g_exc_error exception

943: -- Main API code
944: --
945: -- This procedure check if the installed base is active, If not active
946: -- populates the error message in the message queue and raises the
947: -- fnd_api.g_exc_error exception
948: --
949: csi_utility_grp.check_ib_active;
950: IF p_api_caller_identity <> 'CONFIG'
951: THEN

Line 961: RAISE FND_API.g_exc_error;

957: THEN
958: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
959: FND_MESSAGE.set_token('API_CALLER',p_api_caller_identity);
960: FND_MSG_PUB.add;
961: RAISE FND_API.g_exc_error;
962: END IF ;
963: END IF ;
964:
965: -- Needed to pass some parameter to identify that this is being called from the PURGE program

Line 983: IF l_return_status <> fnd_api.g_ret_sts_success THEN

979: x_return_status => l_return_status,
980: x_msg_count => l_msg_count,
981: x_msg_data => l_msg_data);
982:
983: IF l_return_status <> fnd_api.g_ret_sts_success THEN
984: RAISE fnd_api.g_exc_error;
985: END IF;
986:
987: -- Standard check of p_commit.

Line 984: RAISE fnd_api.g_exc_error;

980: x_msg_count => l_msg_count,
981: x_msg_data => l_msg_data);
982:
983: IF l_return_status <> fnd_api.g_ret_sts_success THEN
984: RAISE fnd_api.g_exc_error;
985: END IF;
986:
987: -- Standard check of p_commit.
988: IF FND_API.To_Boolean( p_commit ) THEN

Line 988: IF FND_API.To_Boolean( p_commit ) THEN

984: RAISE fnd_api.g_exc_error;
985: END IF;
986:
987: -- Standard check of p_commit.
988: IF FND_API.To_Boolean( p_commit ) THEN
989: COMMIT WORK;
990: END IF;
991:
992: /**** Commented for Bug 3304439

Line 1012: WHEN FND_API.G_EXC_ERROR THEN

1008:
1009: csi_t_gen_utility_pvt.set_debug_off;
1010:
1011: EXCEPTION
1012: WHEN FND_API.G_EXC_ERROR THEN
1013:
1014: ROLLBACK TO Delete_Transaction_Dtls;
1015: x_return_status := FND_API.G_RET_STS_ERROR ;
1016: FND_MSG_PUB.Count_And_Get (

Line 1015: x_return_status := FND_API.G_RET_STS_ERROR ;

1011: EXCEPTION
1012: WHEN FND_API.G_EXC_ERROR THEN
1013:
1014: ROLLBACK TO Delete_Transaction_Dtls;
1015: x_return_status := FND_API.G_RET_STS_ERROR ;
1016: FND_MSG_PUB.Count_And_Get (
1017: p_count => x_msg_count,
1018: p_data => x_msg_data);
1019:

Line 1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1018: p_data => x_msg_data);
1019:
1020: csi_t_gen_utility_pvt.set_debug_off;
1021:
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023:
1024: ROLLBACK TO Delete_Transaction_Dtls;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026:

Line 1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1021:
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023:
1024: ROLLBACK TO Delete_Transaction_Dtls;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026:
1027: FND_MSG_PUB.Count_And_Get(
1028: p_count => x_msg_count,
1029: p_data => x_msg_data);

Line 1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1032:
1033: WHEN OTHERS THEN
1034:
1035: ROLLBACK TO Delete_Transaction_Dtls;
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037:
1038: IF FND_MSG_PUB.Check_Msg_Level(
1039: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1040:

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

1054:
1055:
1056: PROCEDURE copy_transaction_dtls(
1057: p_api_version IN NUMBER,
1058: p_commit IN VARCHAR2 := fnd_api.g_false,
1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1060: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1061: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

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

1055:
1056: PROCEDURE copy_transaction_dtls(
1057: p_api_version IN NUMBER,
1058: p_commit IN VARCHAR2 := fnd_api.g_false,
1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1060: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1061: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,

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

1056: PROCEDURE copy_transaction_dtls(
1057: p_api_version IN NUMBER,
1058: p_commit IN VARCHAR2 := fnd_api.g_false,
1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1060: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1061: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,

Line 1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,

1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1060: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1061: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
1066: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
1067: p_copy_ext_attribs_flag IN varchar2 := fnd_api.g_true,

Line 1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,

1060: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1061: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
1066: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
1067: p_copy_ext_attribs_flag IN varchar2 := fnd_api.g_true,
1068: p_copy_txn_systems_flag IN varchar2 := fnd_api.g_true,

Line 1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,

1061: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
1066: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
1067: p_copy_ext_attribs_flag IN varchar2 := fnd_api.g_true,
1068: p_copy_txn_systems_flag IN varchar2 := fnd_api.g_true,
1069: x_return_status OUT NOCOPY VARCHAR2,

Line 1066: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,

1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
1066: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
1067: p_copy_ext_attribs_flag IN varchar2 := fnd_api.g_true,
1068: p_copy_txn_systems_flag IN varchar2 := fnd_api.g_true,
1069: x_return_status OUT NOCOPY VARCHAR2,
1070: x_msg_count OUT NOCOPY NUMBER,

Line 1067: p_copy_ext_attribs_flag IN varchar2 := fnd_api.g_true,

1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
1066: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
1067: p_copy_ext_attribs_flag IN varchar2 := fnd_api.g_true,
1068: p_copy_txn_systems_flag IN varchar2 := fnd_api.g_true,
1069: x_return_status OUT NOCOPY VARCHAR2,
1070: x_msg_count OUT NOCOPY NUMBER,
1071: x_msg_data OUT NOCOPY VARCHAR2)

Line 1068: p_copy_txn_systems_flag IN varchar2 := fnd_api.g_true,

1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
1066: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
1067: p_copy_ext_attribs_flag IN varchar2 := fnd_api.g_true,
1068: p_copy_txn_systems_flag IN varchar2 := fnd_api.g_true,
1069: x_return_status OUT NOCOPY VARCHAR2,
1070: x_msg_count OUT NOCOPY NUMBER,
1071: x_msg_data OUT NOCOPY VARCHAR2)
1072: IS

Line 1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1087: csi_t_gen_utility_pvt.add('API Being Executed : Copy Transaction Details');
1088: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1089:
1090: -- Initialize message list if p_init_msg_list is set to TRUE.
1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1092: FND_MSG_PUB.initialize;
1093: END IF;
1094:
1095: -- Initialize API return status to success

Line 1096: x_return_status := FND_API.G_RET_STS_SUCCESS;

1092: FND_MSG_PUB.initialize;
1093: END IF;
1094:
1095: -- Initialize API return status to success
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: -- Standard call to check for call compatibility.
1099: IF NOT
1100:

Line 1101: FND_API.Compatible_API_Call (

1097:
1098: -- Standard call to check for call compatibility.
1099: IF NOT
1100:
1101: FND_API.Compatible_API_Call (
1102: p_current_version_number => l_api_version,
1103: p_caller_version_number => p_api_version,
1104: p_api_name => l_api_name,
1105: p_pkg_name => G_PKG_NAME) THEN

Line 1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1103: p_caller_version_number => p_api_version,
1104: p_api_name => l_api_name,
1105: p_pkg_name => G_PKG_NAME) THEN
1106:
1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1108:
1109: END IF;
1110:
1111: /**** Commented for Bug 3304439

Line 1122: -- fnd_api.g_exc_error exception

1118: -- Main API code
1119: --
1120: -- This procedure check if the installed base is active, If not active
1121: -- populates the error message in the message queue and raises the
1122: -- fnd_api.g_exc_error exception
1123: --
1124:
1125: csi_utility_grp.check_ib_active;
1126:

Line 1144: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1140: x_return_status => l_return_status,
1141: x_msg_count => l_msg_count,
1142: x_msg_data => l_msg_data);
1143:
1144: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1145: RAISE fnd_api.g_exc_error;
1146: END IF;
1147:
1148: -- Standard check of p_commit.

Line 1145: RAISE fnd_api.g_exc_error;

1141: x_msg_count => l_msg_count,
1142: x_msg_data => l_msg_data);
1143:
1144: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1145: RAISE fnd_api.g_exc_error;
1146: END IF;
1147:
1148: -- Standard check of p_commit.
1149: IF FND_API.To_Boolean( p_commit ) THEN

Line 1149: IF FND_API.To_Boolean( p_commit ) THEN

1145: RAISE fnd_api.g_exc_error;
1146: END IF;
1147:
1148: -- Standard check of p_commit.
1149: IF FND_API.To_Boolean( p_commit ) THEN
1150: COMMIT WORK;
1151: END IF;
1152:
1153: /**** Commented for Bug 3304439

Line 1172: WHEN FND_API.G_EXC_ERROR THEN

1168:
1169: csi_t_gen_utility_pvt.set_debug_off;
1170:
1171: EXCEPTION
1172: WHEN FND_API.G_EXC_ERROR THEN
1173:
1174: ROLLBACK TO copy_Transaction_Dtls;
1175: x_return_status := FND_API.G_RET_STS_ERROR ;
1176: FND_MSG_PUB.Count_And_Get (

Line 1175: x_return_status := FND_API.G_RET_STS_ERROR ;

1171: EXCEPTION
1172: WHEN FND_API.G_EXC_ERROR THEN
1173:
1174: ROLLBACK TO copy_Transaction_Dtls;
1175: x_return_status := FND_API.G_RET_STS_ERROR ;
1176: FND_MSG_PUB.Count_And_Get (
1177: p_count => x_msg_count,
1178: p_data => x_msg_data);
1179:

Line 1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1178: p_data => x_msg_data);
1179:
1180: csi_t_gen_utility_pvt.set_debug_off;
1181:
1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1183:
1184: ROLLBACK TO copy_Transaction_Dtls;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1186:

Line 1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1181:
1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1183:
1184: ROLLBACK TO copy_Transaction_Dtls;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1186:
1187: FND_MSG_PUB.Count_And_Get(
1188: p_count => x_msg_count,
1189: p_data => x_msg_data);

Line 1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1192:
1193: WHEN OTHERS THEN
1194:
1195: ROLLBACK TO copy_Transaction_Dtls;
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1197:
1198: IF FND_MSG_PUB.Check_Msg_Level(
1199: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1200:

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

1217: This API is for managing the transaction details entities incl. the line details.
1218: */
1219: PROCEDURE update_transaction_dtls(
1220: p_api_version IN NUMBER
1221: ,p_commit IN VARCHAR2 := fnd_api.g_false
1222: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1223: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1224: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl

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

1218: */
1219: PROCEDURE update_transaction_dtls(
1220: p_api_version IN NUMBER
1221: ,p_commit IN VARCHAR2 := fnd_api.g_false
1222: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1223: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1224: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl

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

1219: PROCEDURE update_transaction_dtls(
1220: p_api_version IN NUMBER
1221: ,p_commit IN VARCHAR2 := fnd_api.g_false
1222: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1223: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1224: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
1227: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl

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

1237: l_api_name CONSTANT VARCHAR2(30) := 'update_transaction_dtls';
1238: l_api_version CONSTANT NUMBER := 1.0;
1239: l_debug_level NUMBER;
1240:
1241: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
1242: l_msg_count NUMBER;
1243: l_msg_data VARCHAR2(512);
1244:
1245: BEGIN

Line 1254: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1250: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');
1251: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1252:
1253: -- Initialize message list if p_init_msg_list is set to TRUE.
1254: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1255: FND_MSG_PUB.initialize;
1256: END IF;
1257:
1258: -- Initialize API return status to success

Line 1259: x_return_status := FND_API.G_RET_STS_SUCCESS;

1255: FND_MSG_PUB.initialize;
1256: END IF;
1257:
1258: -- Initialize API return status to success
1259: x_return_status := FND_API.G_RET_STS_SUCCESS;
1260:
1261: -- Standard call to check for call compatibility.
1262: IF NOT
1263:

Line 1264: FND_API.Compatible_API_Call (

1260:
1261: -- Standard call to check for call compatibility.
1262: IF NOT
1263:
1264: FND_API.Compatible_API_Call (
1265: p_current_version_number => l_api_version,
1266: p_caller_version_number => p_api_version,
1267: p_api_name => l_api_name,
1268: p_pkg_name => G_PKG_NAME) THEN

Line 1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1266: p_caller_version_number => p_api_version,
1267: p_api_name => l_api_name,
1268: p_pkg_name => G_PKG_NAME) THEN
1269:
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271:
1272: END IF;
1273:
1274: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

Line 1289: -- fnd_api.g_exc_error exception

1285: -- Main API code
1286: --
1287: -- This procedure check if the installed base is active, If not active
1288: -- populates the error message in the message queue and raises the
1289: -- fnd_api.g_exc_error exception
1290: --
1291:
1292: csi_utility_grp.check_ib_active;
1293:

Line 1303: p_commit => fnd_api.g_false,

1299:
1300: -- Calling the Private ...
1301: csi_t_txn_details_pvt.update_transaction_dtls(
1302: p_api_version => p_api_version,
1303: p_commit => fnd_api.g_false,
1304: p_init_msg_list => p_init_msg_list,
1305: p_validation_level => p_validation_level,
1306: p_txn_line_rec => p_txn_line_rec,
1307: px_txn_line_detail_tbl => px_txn_line_detail_tbl,

Line 1317: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1313: x_return_status => l_return_status,
1314: x_msg_count => l_msg_count,
1315: x_msg_data => l_msg_data);
1316:
1317: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1318: RAISE fnd_api.g_exc_error;
1319: END IF;
1320:
1321: -- Standard check of p_commit.

Line 1318: RAISE fnd_api.g_exc_error;

1314: x_msg_count => l_msg_count,
1315: x_msg_data => l_msg_data);
1316:
1317: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1318: RAISE fnd_api.g_exc_error;
1319: END IF;
1320:
1321: -- Standard check of p_commit.
1322: IF FND_API.To_Boolean( p_commit ) THEN

Line 1322: IF FND_API.To_Boolean( p_commit ) THEN

1318: RAISE fnd_api.g_exc_error;
1319: END IF;
1320:
1321: -- Standard check of p_commit.
1322: IF FND_API.To_Boolean( p_commit ) THEN
1323: COMMIT WORK;
1324: END IF;
1325:
1326: -- Standard call to get message count and if count is get message info.

Line 1339: WHEN FND_API.G_EXC_ERROR THEN

1335:
1336: csi_t_gen_utility_pvt.set_debug_off;
1337:
1338: EXCEPTION
1339: WHEN FND_API.G_EXC_ERROR THEN
1340:
1341: ROLLBACK TO update_transaction_dtls;
1342: x_return_status := FND_API.G_RET_STS_ERROR ;
1343: FND_MSG_PUB.Count_And_Get (

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR ;

1338: EXCEPTION
1339: WHEN FND_API.G_EXC_ERROR THEN
1340:
1341: ROLLBACK TO update_transaction_dtls;
1342: x_return_status := FND_API.G_RET_STS_ERROR ;
1343: FND_MSG_PUB.Count_And_Get (
1344: p_count => x_msg_count,
1345: p_data => x_msg_data);
1346:

Line 1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1346:
1347: csi_t_gen_utility_pvt.dump_error_stack;
1348: csi_t_gen_utility_pvt.set_debug_off;
1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351:
1352: ROLLBACK TO update_transaction_dtls;
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354:

Line 1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351:
1352: ROLLBACK TO update_transaction_dtls;
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354:
1355: FND_MSG_PUB.Count_And_Get(
1356: p_count => x_msg_count,
1357: p_data => x_msg_data);

Line 1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1361:
1362: WHEN OTHERS THEN
1363:
1364: ROLLBACK TO update_transaction_dtls;
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1366:
1367: IF FND_MSG_PUB.Check_Msg_Level(
1368: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1369:

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

1383: END update_transaction_dtls;
1384:
1385: PROCEDURE split_transaction_details(
1386: p_api_version IN NUMBER,
1387: p_commit IN VARCHAR2 := fnd_api.g_false,
1388: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1389: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1390: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

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

1384:
1385: PROCEDURE split_transaction_details(
1386: p_api_version IN NUMBER,
1387: p_commit IN VARCHAR2 := fnd_api.g_false,
1388: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1389: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1390: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

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

1385: PROCEDURE split_transaction_details(
1386: p_api_version IN NUMBER,
1387: p_commit IN VARCHAR2 := fnd_api.g_false,
1388: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1389: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1390: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 1413: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1409: csi_t_gen_utility_pvt.add('API Being Executed : Split Transaction Details');
1410: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1411:
1412: -- Initialize message list if p_init_msg_list is set to TRUE.
1413: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1414: FND_MSG_PUB.initialize;
1415: END IF;
1416:
1417: -- Initialize API return status to success

Line 1418: x_return_status := FND_API.G_RET_STS_SUCCESS;

1414: FND_MSG_PUB.initialize;
1415: END IF;
1416:
1417: -- Initialize API return status to success
1418: x_return_status := FND_API.G_RET_STS_SUCCESS;
1419:
1420: -- Standard call to check for call compatibility.
1421: IF NOT
1422: FND_API.Compatible_API_Call (

Line 1422: FND_API.Compatible_API_Call (

1418: x_return_status := FND_API.G_RET_STS_SUCCESS;
1419:
1420: -- Standard call to check for call compatibility.
1421: IF NOT
1422: FND_API.Compatible_API_Call (
1423: p_current_version_number => l_api_version,
1424: p_caller_version_number => p_api_version,
1425: p_api_name => l_api_name,
1426: p_pkg_name => G_PKG_NAME) THEN

Line 1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1424: p_caller_version_number => p_api_version,
1425: p_api_name => l_api_name,
1426: p_pkg_name => G_PKG_NAME) THEN
1427:
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429:
1430: END IF;
1431:
1432: -- Check for the profile option and enable trace

Line 1441: -- fnd_api.g_exc_error exception

1437: -- Main API code
1438: --
1439: -- This procedure check if the installed base is active, If not active
1440: -- populates the error message in the message queue and raises the
1441: -- fnd_api.g_exc_error exception
1442: --
1443:
1444: csi_utility_grp.check_ib_active;
1445:

Line 1464: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1460: x_return_status => x_return_status,
1461: x_msg_count => x_msg_count,
1462: x_msg_data => x_msg_data
1463: );
1464: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467:
1468: IF FND_API.To_Boolean( p_commit ) THEN

Line 1465: RAISE fnd_api.g_exc_error;

1461: x_msg_count => x_msg_count,
1462: x_msg_data => x_msg_data
1463: );
1464: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467:
1468: IF FND_API.To_Boolean( p_commit ) THEN
1469: COMMIT WORK;

Line 1468: IF FND_API.To_Boolean( p_commit ) THEN

1464: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467:
1468: IF FND_API.To_Boolean( p_commit ) THEN
1469: COMMIT WORK;
1470: END IF;
1471:
1472: -- Check for the profile option and disable the trace

Line 1488: WHEN FND_API.G_EXC_ERROR THEN

1484:
1485: csi_t_gen_utility_pvt.set_debug_off;
1486:
1487: EXCEPTION
1488: WHEN FND_API.G_EXC_ERROR THEN
1489:
1490: ROLLBACK TO split_transaction_details;
1491: x_return_status := FND_API.G_RET_STS_ERROR ;
1492: FND_MSG_PUB.Count_And_Get (

Line 1491: x_return_status := FND_API.G_RET_STS_ERROR ;

1487: EXCEPTION
1488: WHEN FND_API.G_EXC_ERROR THEN
1489:
1490: ROLLBACK TO split_transaction_details;
1491: x_return_status := FND_API.G_RET_STS_ERROR ;
1492: FND_MSG_PUB.Count_And_Get (
1493: p_count => x_msg_count,
1494: p_data => x_msg_data);
1495:

Line 1498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1494: p_data => x_msg_data);
1495:
1496: csi_t_gen_utility_pvt.set_debug_off;
1497:
1498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1499:
1500: ROLLBACK TO split_transaction_details;
1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1502:

Line 1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1497:
1498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1499:
1500: ROLLBACK TO split_transaction_details;
1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1502:
1503: FND_MSG_PUB.Count_And_Get (
1504: p_count => x_msg_count,
1505: p_data => x_msg_data);

Line 1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1508:
1509: WHEN OTHERS THEN
1510:
1511: ROLLBACK TO split_transaction_details;
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513:
1514: FND_MSG_PUB.Count_And_Get (
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);