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

APPS.CSI_T_TXN_RLTNSHPS_PVT dependencies on FND_API

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

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

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

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

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

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

Line 43: IF FND_API.to_Boolean( p_init_msg_list ) THEN

39: SAVEPOINT create_txn_ii_rltns_dtls;
40:
41:
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.to_Boolean( p_init_msg_list ) THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46:
47: -- Initialize API return status to success

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 53: FND_API.Compatible_API_Call (

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

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: p_caller_version_number => p_api_version,
56: p_api_name => l_api_name,
57: p_pkg_name => G_PKG_NAME) THEN
58:
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60:
61: END IF;
62:
63: -- Check the profile option debug_level for debug message reporting

Line 74: IF ( NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num)

70: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
71:
72: -- Added for CZ Integration (Begin)
73:
74: IF ( NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num)
75: <> fnd_api.g_miss_num
76: OR NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num)
77: <> fnd_api.g_miss_num )
78: AND p_txn_ii_rltns_rec.api_caller_identity <> 'CONFIG'

Line 75: <> fnd_api.g_miss_num

71:
72: -- Added for CZ Integration (Begin)
73:
74: IF ( NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num)
75: <> fnd_api.g_miss_num
76: OR NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num)
77: <> fnd_api.g_miss_num )
78: AND p_txn_ii_rltns_rec.api_caller_identity <> 'CONFIG'
79: THEN

Line 76: OR NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num)

72: -- Added for CZ Integration (Begin)
73:
74: IF ( NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num)
75: <> fnd_api.g_miss_num
76: OR NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num)
77: <> fnd_api.g_miss_num )
78: AND p_txn_ii_rltns_rec.api_caller_identity <> 'CONFIG'
79: THEN
80: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');

Line 77: <> fnd_api.g_miss_num )

73:
74: IF ( NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num)
75: <> fnd_api.g_miss_num
76: OR NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num)
77: <> fnd_api.g_miss_num )
78: AND p_txn_ii_rltns_rec.api_caller_identity <> 'CONFIG'
79: THEN
80: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
81: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_rec.api_caller_identity) ;

Line 83: RAISE FND_API.g_exc_error;

79: THEN
80: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
81: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_rec.api_caller_identity) ;
82: FND_MSG_PUB.add;
83: RAISE FND_API.g_exc_error;
84: END IF ;
85:
86: IF (NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
87: AND NVL(p_txn_ii_rltns_rec.subject_id , fnd_api.g_miss_num)

Line 86: IF (NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num

82: FND_MSG_PUB.add;
83: RAISE FND_API.g_exc_error;
84: END IF ;
85:
86: IF (NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
87: AND NVL(p_txn_ii_rltns_rec.subject_id , fnd_api.g_miss_num)
88: = fnd_api.g_miss_num)
89: THEN
90: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.

Line 87: AND NVL(p_txn_ii_rltns_rec.subject_id , fnd_api.g_miss_num)

83: RAISE FND_API.g_exc_error;
84: END IF ;
85:
86: IF (NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
87: AND NVL(p_txn_ii_rltns_rec.subject_id , fnd_api.g_miss_num)
88: = fnd_api.g_miss_num)
89: THEN
90: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.
91:

Line 88: = fnd_api.g_miss_num)

84: END IF ;
85:
86: IF (NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
87: AND NVL(p_txn_ii_rltns_rec.subject_id , fnd_api.g_miss_num)
88: = fnd_api.g_miss_num)
89: THEN
90: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.
91:
92: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

Line 100: IF x_return_status <> fnd_api.g_ret_sts_success

96: x_instance_id => l_sub_instance_id ,
97: x_txn_line_detail_id => l_sub_tld_id ,
98: x_return_status => x_return_status );
99:
100: IF x_return_status <> fnd_api.g_ret_sts_success
101: THEN
102: RAISE fnd_api.g_exc_error ;
103: END IF ;
104: IF l_sub_instance_id IS NULL

Line 102: RAISE fnd_api.g_exc_error ;

98: x_return_status => x_return_status );
99:
100: IF x_return_status <> fnd_api.g_ret_sts_success
101: THEN
102: RAISE fnd_api.g_exc_error ;
103: END IF ;
104: IF l_sub_instance_id IS NULL
105: AND l_sub_tld_id IS NULL
106: THEN

Line 107: RAISE fnd_api.g_exc_error ;

103: END IF ;
104: IF l_sub_instance_id IS NULL
105: AND l_sub_tld_id IS NULL
106: THEN
107: RAISE fnd_api.g_exc_error ;
108: END IF ;
109:
110: IF l_sub_instance_id IS NOT NULL
111: THEN

Line 134: IF (NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num

130:
131: END IF ; --subject_id is null
132:
133:
134: IF (NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
135: AND NVL(p_txn_ii_rltns_rec.object_id , fnd_api.g_miss_num)
136: = fnd_api.g_miss_num)
137: THEN
138: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

Line 135: AND NVL(p_txn_ii_rltns_rec.object_id , fnd_api.g_miss_num)

131: END IF ; --subject_id is null
132:
133:
134: IF (NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
135: AND NVL(p_txn_ii_rltns_rec.object_id , fnd_api.g_miss_num)
136: = fnd_api.g_miss_num)
137: THEN
138: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
139: p_config_inst_hdr_id => p_txn_ii_rltns_rec.obj_config_inst_hdr_id,

Line 136: = fnd_api.g_miss_num)

132:
133:
134: IF (NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
135: AND NVL(p_txn_ii_rltns_rec.object_id , fnd_api.g_miss_num)
136: = fnd_api.g_miss_num)
137: THEN
138: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
139: p_config_inst_hdr_id => p_txn_ii_rltns_rec.obj_config_inst_hdr_id,
140: p_config_inst_rev_num => p_txn_ii_rltns_rec.obj_config_inst_rev_num,

Line 146: IF x_return_status <> fnd_api.g_ret_sts_success

142: x_instance_id => l_obj_instance_id ,
143: x_txn_line_detail_id => l_obj_tld_id ,
144: x_return_status => x_return_status );
145:
146: IF x_return_status <> fnd_api.g_ret_sts_success
147: THEN
148: RAISE fnd_api.g_exc_error ;
149: END IF ;
150:

Line 148: RAISE fnd_api.g_exc_error ;

144: x_return_status => x_return_status );
145:
146: IF x_return_status <> fnd_api.g_ret_sts_success
147: THEN
148: RAISE fnd_api.g_exc_error ;
149: END IF ;
150:
151: IF l_obj_instance_id IS NOT NULL
152: THEN

Line 164: RAISE fnd_api.g_exc_error ;

160:
161: IF l_obj_instance_id IS NULL
162: AND l_obj_tld_id IS NULL
163: THEN
164: RAISE fnd_api.g_exc_error ;
165: END IF ;
166: END IF ; --object_id is null
167: -- Added for CZ Integration (End)
168:

Line 209: RAISE fnd_api.g_exc_error;

205: IF p_txn_ii_rltns_rec.subject_type not in ('T', 'I') THEN
206: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
207: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.subject_type);
208: FND_MSG_PUB.add;
209: RAISE fnd_api.g_exc_error;
210: ELSIF p_txn_ii_rltns_rec.object_type not in ('T', 'I') THEN
211: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
212: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.object_type);
213: FND_MSG_PUB.add;

Line 214: RAISE fnd_api.g_exc_error;

210: ELSIF p_txn_ii_rltns_rec.object_type not in ('T', 'I') THEN
211: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
212: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.object_type);
213: FND_MSG_PUB.add;
214: RAISE fnd_api.g_exc_error;
215: ELSIF (p_txn_ii_rltns_rec.subject_type = 'I'
216: AND p_txn_ii_rltns_rec.object_type = 'I' ) THEN
217: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
218: FND_MESSAGE.set_token('TXN_DTL_ID',p_txn_ii_rltns_rec.object_id);

Line 220: x_return_status := fnd_api.g_ret_sts_error;

216: AND p_txn_ii_rltns_rec.object_type = 'I' ) THEN
217: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
218: FND_MESSAGE.set_token('TXN_DTL_ID',p_txn_ii_rltns_rec.object_id);
219: FND_MSG_PUB.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: RAISE fnd_api.g_exc_error;
222: ELSIF NOT(p_txn_ii_rltns_rec.subject_type = 'T'
223: AND p_txn_ii_rltns_rec.object_type = 'T' ) THEN
224: IF p_txn_ii_rltns_rec.subject_type = 'T' THEN

Line 221: RAISE fnd_api.g_exc_error;

217: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
218: FND_MESSAGE.set_token('TXN_DTL_ID',p_txn_ii_rltns_rec.object_id);
219: FND_MSG_PUB.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: RAISE fnd_api.g_exc_error;
222: ELSIF NOT(p_txn_ii_rltns_rec.subject_type = 'T'
223: AND p_txn_ii_rltns_rec.object_type = 'T' ) THEN
224: IF p_txn_ii_rltns_rec.subject_type = 'T' THEN
225: l_txn_line_dtl_rec1 := l_txn_line_dtl_g_miss;-- subject TLD record

Line 233: /* IF nvl(p_txn_ii_rltns_rec.subject_index_flag,fnd_api.g_miss_char)

229: END IF;
230:
231:
232: IF p_txn_ii_rltns_rec.subject_type = 'T' THEN
233: /* IF nvl(p_txn_ii_rltns_rec.subject_index_flag,fnd_api.g_miss_char)
234: = fnd_api.g_miss_char THEN -- Added the IF for M-M . checking the index flags so that records passed by the txn details grp API are not validated again.
235: */
236: csi_t_gen_utility_pvt.add('Validate subject_id.');
237:

Line 234: = fnd_api.g_miss_char THEN -- Added the IF for M-M . checking the index flags so that records passed by the txn details grp API are not validated again.

230:
231:
232: IF p_txn_ii_rltns_rec.subject_type = 'T' THEN
233: /* IF nvl(p_txn_ii_rltns_rec.subject_index_flag,fnd_api.g_miss_char)
234: = fnd_api.g_miss_char THEN -- Added the IF for M-M . checking the index flags so that records passed by the txn details grp API are not validated again.
235: */
236: csi_t_gen_utility_pvt.add('Validate subject_id.');
237:
238: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

Line 243: IF l_return_status <> fnd_api.g_ret_sts_success THEN

239: p_txn_line_detail_id => p_txn_ii_rltns_rec.subject_id,
240: x_txn_line_detail_rec =>l_txn_line_dtl_rec2, -- calling the overloaded routine. M-M change
241: x_return_status => l_return_status);
242:
243: IF l_return_status <> fnd_api.g_ret_sts_success THEN
244:
245: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
246: FND_MESSAGE.set_token('SUBJECT_ID',p_txn_ii_rltns_rec.subject_id);
247: FND_MSG_PUB.add;

Line 248: RAISE fnd_api.g_exc_error;

244:
245: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
246: FND_MESSAGE.set_token('SUBJECT_ID',p_txn_ii_rltns_rec.subject_id);
247: FND_MSG_PUB.add;
248: RAISE fnd_api.g_exc_error;
249:
250: END IF;
251: -- END IF;
252: END IF;

Line 255: /* IF nvl(p_txn_ii_rltns_rec.object_index_flag,fnd_api.g_miss_char)

251: -- END IF;
252: END IF;
253:
254: IF p_txn_ii_rltns_rec.object_type = 'T' THEN
255: /* IF nvl(p_txn_ii_rltns_rec.object_index_flag,fnd_api.g_miss_char)
256: = fnd_api.g_miss_char THEN -- Added for M-M . checking the index flags so that records passed by the txn details grp API are not validated again.
257: */
258: csi_t_gen_utility_pvt.add('Validate object_id.');
259:

Line 256: = fnd_api.g_miss_char THEN -- Added for M-M . checking the index flags so that records passed by the txn details grp API are not validated again.

252: END IF;
253:
254: IF p_txn_ii_rltns_rec.object_type = 'T' THEN
255: /* IF nvl(p_txn_ii_rltns_rec.object_index_flag,fnd_api.g_miss_char)
256: = fnd_api.g_miss_char THEN -- Added for M-M . checking the index flags so that records passed by the txn details grp API are not validated again.
257: */
258: csi_t_gen_utility_pvt.add('Validate object_id.');
259:
260: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

Line 265: IF l_return_status <> fnd_api.g_ret_sts_success THEN

261: p_txn_line_detail_id => p_txn_ii_rltns_rec.object_id,
262: x_txn_line_detail_rec =>l_txn_line_dtl_rec1, -- calling the overloaded routine. M-M change
263: x_return_status => l_return_status);
264:
265: IF l_return_status <> fnd_api.g_ret_sts_success THEN
266:
267: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
268: FND_MESSAGE.set_token('OBJECT_ID',p_txn_ii_rltns_rec.object_id);
269: FND_MSG_PUB.add;

Line 270: RAISE fnd_api.g_exc_error;

266:
267: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
268: FND_MESSAGE.set_token('OBJECT_ID',p_txn_ii_rltns_rec.object_id);
269: FND_MSG_PUB.add;
270: RAISE fnd_api.g_exc_error;
271:
272: END IF;
273: -- END IF;
274: END IF;

Line 283: IF l_return_status = fnd_api.g_ret_sts_error THEN

279: csi_t_vldn_routines_pvt.validate_ii_rltns_type_code(
280: p_rltns_type_code => p_txn_ii_rltns_rec.relationship_type_code,
281: x_return_status => l_return_status);
282:
283: IF l_return_status = fnd_api.g_ret_sts_error THEN
284: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
285: FND_MESSAGE.set_token('RLTNS_CODE',
286: p_txn_ii_rltns_rec.relationship_type_code);
287: FND_MSG_PUB.add;

Line 288: RAISE fnd_api.g_exc_error;

284: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
285: FND_MESSAGE.set_token('RLTNS_CODE',
286: p_txn_ii_rltns_rec.relationship_type_code);
287: FND_MSG_PUB.add;
288: RAISE fnd_api.g_exc_error;
289: END IF;
290:
291: -- validate instance reference
292:

Line 293: IF nvl(p_txn_ii_rltns_rec.csi_inst_relationship_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

289: END IF;
290:
291: -- validate instance reference
292:
293: IF nvl(p_txn_ii_rltns_rec.csi_inst_relationship_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
294: csi_t_gen_utility_pvt.add('Validate instance reference.');
295: csi_t_vldn_routines_pvt.validate_instance_reference(
296: p_level => 'II_RLTNS',
297: p_level_dtl_id => p_txn_ii_rltns_rec.object_id,

Line 301: IF l_return_status <> fnd_api.g_ret_sts_success THEN

297: p_level_dtl_id => p_txn_ii_rltns_rec.object_id,
298: p_level_inst_ref_id => p_txn_ii_rltns_rec.csi_inst_relationship_id,
299: x_return_status => l_return_status);
300:
301: IF l_return_status <> fnd_api.g_ret_sts_success THEN
302: csi_t_gen_utility_pvt.add('Error in here.');
303: RAISE fnd_api.g_exc_error;
304: END IF;
305: END IF;

Line 303: RAISE fnd_api.g_exc_error;

299: x_return_status => l_return_status);
300:
301: IF l_return_status <> fnd_api.g_ret_sts_success THEN
302: csi_t_gen_utility_pvt.add('Error in here.');
303: RAISE fnd_api.g_exc_error;
304: END IF;
305: END IF;
306:
307: -- Validate transfer_components

Line 308: IF p_txn_ii_rltns_rec.transfer_components_flag <> fnd_api.g_miss_char THEN

304: END IF;
305: END IF;
306:
307: -- Validate transfer_components
308: IF p_txn_ii_rltns_rec.transfer_components_flag <> fnd_api.g_miss_char THEN
309: IF p_txn_ii_rltns_rec.relationship_type_code
310: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
311: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
312: FND_MESSAGE.set_token('PARAM','transfer_components_flag');

Line 317: p_txn_ii_rltns_rec.transfer_components_flag := fnd_api.g_miss_char;

313: FND_MESSAGE.set_token('VALUE',p_txn_ii_rltns_rec.transfer_components_flag);
314: FND_MESSAGE.set_token('REASON','This attribute is applicable to
315: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
316: FND_MSG_PUB.add;
317: p_txn_ii_rltns_rec.transfer_components_flag := fnd_api.g_miss_char;
318: END IF;
319: END IF;
320:
321: -- validate mandatory_flag

Line 342: IF l_return_status <> fnd_api.g_ret_sts_success THEN

338: p_txn_line_detail_rec2 => l_txn_line_dtl_rec2,
339: p_iir_rec => p_txn_ii_rltns_rec,
340: x_return_status => l_return_status);
341:
342: IF l_return_status <> fnd_api.g_ret_sts_success THEN
343: RAISE fnd_api.g_exc_error;
344: END IF;
345:
346: -- call table handler

Line 343: RAISE fnd_api.g_exc_error;

339: p_iir_rec => p_txn_ii_rltns_rec,
340: x_return_status => l_return_status);
341:
342: IF l_return_status <> fnd_api.g_ret_sts_success THEN
343: RAISE fnd_api.g_exc_error;
344: END IF;
345:
346: -- call table handler
347:

Line 348: if nvl(p_txn_ii_rltns_rec.txn_relationship_id,fnd_api.g_miss_num) <>

344: END IF;
345:
346: -- call table handler
347:
348: if nvl(p_txn_ii_rltns_rec.txn_relationship_id,fnd_api.g_miss_num) <>
349: fnd_api.g_miss_num then
350: l_txn_relationship_id := p_txn_ii_rltns_rec.txn_relationship_id;
351: end if;
352:

Line 349: fnd_api.g_miss_num then

345:
346: -- call table handler
347:
348: if nvl(p_txn_ii_rltns_rec.txn_relationship_id,fnd_api.g_miss_num) <>
349: fnd_api.g_miss_num then
350: l_txn_relationship_id := p_txn_ii_rltns_rec.txn_relationship_id;
351: end if;
352:
353: begin

Line 413: raise fnd_api.g_exc_error;

409: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
410: fnd_message.set_token('MESSAGE',
411: 'csi_t_ii_relationships_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
412: fnd_msg_pub.add;
413: raise fnd_api.g_exc_error;
414: end;
415:
416: p_txn_ii_rltns_rec.txn_relationship_id := l_txn_relationship_id;
417:

Line 419: IF FND_API.To_Boolean( p_commit ) THEN

415:
416: p_txn_ii_rltns_rec.txn_relationship_id := l_txn_relationship_id;
417:
418: -- Standard check of p_commit.
419: IF FND_API.To_Boolean( p_commit ) THEN
420: COMMIT WORK;
421: END IF;
422:
423: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN

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

419: IF FND_API.To_Boolean( p_commit ) THEN
420: COMMIT WORK;
421: END IF;
422:
423: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
424: csi_t_gen_utility_pvt.set_debug_off;
425: END IF;
426:
427: -- Standard call to get message count and if count is get message info.

Line 433: WHEN FND_API.G_EXC_ERROR THEN

429: p_count => x_msg_count,
430: p_data => x_msg_data);
431:
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434:
435: ROLLBACK TO create_txn_ii_rltns_dtls;
436:
437: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 437: x_return_status := FND_API.G_RET_STS_ERROR ;

433: WHEN FND_API.G_EXC_ERROR THEN
434:
435: ROLLBACK TO create_txn_ii_rltns_dtls;
436:
437: x_return_status := FND_API.G_RET_STS_ERROR ;
438: FND_MSG_PUB.Count_And_Get (
439: p_count => x_msg_count,
440: p_data => x_msg_data);
441:

Line 442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

438: FND_MSG_PUB.Count_And_Get (
439: p_count => x_msg_count,
440: p_data => x_msg_data);
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443:
444: ROLLBACK TO create_txn_ii_rltns_dtls;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446:

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443:
444: ROLLBACK TO create_txn_ii_rltns_dtls;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446:
447: FND_MSG_PUB.Count_And_Get(
448: p_count => x_msg_count,
449: p_data => x_msg_data);

Line 454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

450:
451: WHEN OTHERS THEN
452:
453: ROLLBACK TO create_txn_ii_rltns_dtls;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455:
456: IF FND_MSG_PUB.Check_Msg_Level(
457: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
458:

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

469: END create_txn_ii_rltns_dtls;
470:
471: PROCEDURE update_txn_ii_rltns_dtls (
472: p_api_version IN NUMBER,
473: p_commit IN VARCHAR2 := fnd_api.g_false,
474: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
475: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
476: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
477: x_return_status OUT NOCOPY VARCHAR2,

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

470:
471: PROCEDURE update_txn_ii_rltns_dtls (
472: p_api_version IN NUMBER,
473: p_commit IN VARCHAR2 := fnd_api.g_false,
474: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
475: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
476: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
477: x_return_status OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,

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

471: PROCEDURE update_txn_ii_rltns_dtls (
472: p_api_version IN NUMBER,
473: p_commit IN VARCHAR2 := fnd_api.g_false,
474: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
475: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
476: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
477: x_return_status OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,
479: x_msg_data OUT NOCOPY VARCHAR2)

Line 509: IF FND_API.to_Boolean( p_init_msg_list ) THEN

505: -- Standard Start of API savepoint
506: SAVEPOINT update_txn_ii_rltns_dtls;
507:
508: -- Initialize message list if p_init_msg_list is set to TRUE.
509: IF FND_API.to_Boolean( p_init_msg_list ) THEN
510: FND_MSG_PUB.initialize;
511: END IF;
512:
513: -- Initialize API return status to success

Line 514: x_return_status := FND_API.G_RET_STS_SUCCESS;

510: FND_MSG_PUB.initialize;
511: END IF;
512:
513: -- Initialize API return status to success
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515:
516: -- Standard call to check for call compatibility.
517: IF NOT
518:

Line 519: FND_API.Compatible_API_Call (

515:
516: -- Standard call to check for call compatibility.
517: IF NOT
518:
519: FND_API.Compatible_API_Call (
520: p_current_version_number => l_api_version,
521: p_caller_version_number => p_api_version,
522: p_api_name => l_api_name,
523: p_pkg_name => G_PKG_NAME) THEN

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

521: p_caller_version_number => p_api_version,
522: p_api_name => l_api_name,
523: p_pkg_name => G_PKG_NAME) THEN
524:
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526:
527: END IF;
528:
529: --debug messages

Line 561: IF l_return_status <> fnd_api.g_ret_sts_success THEN

557: csi_t_vldn_routines_pvt.validate_txn_relationship_id(
558: p_txn_relationship_id => l_iir_rec.txn_relationship_id,
559: x_return_status => l_return_status);
560:
561: IF l_return_status <> fnd_api.g_ret_sts_success THEN
562:
563: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
564: FND_MESSAGE.set_token('RLTNS_ID',l_iir_rec.txn_relationship_id);
565: FND_MSG_PUB.add;

Line 566: RAISE fnd_api.g_exc_error;

562:
563: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
564: FND_MESSAGE.set_token('RLTNS_ID',l_iir_rec.txn_relationship_id);
565: FND_MSG_PUB.add;
566: RAISE fnd_api.g_exc_error;
567:
568: END IF;
569:
570: FOR l_iir_cur_rec in iir_cur(l_iir_rec.txn_relationship_id)

Line 582: IF ( NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num)

578:
579:
580: -- Added for CZ Integration (Begin)
581:
582: IF ( NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num)
583: <> fnd_api.g_miss_num
584: OR NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num)
585: <> fnd_api.g_miss_num )
586: AND p_txn_ii_rltns_tbl(l_ind).api_caller_identity <> 'CONFIG'

Line 583: <> fnd_api.g_miss_num

579:
580: -- Added for CZ Integration (Begin)
581:
582: IF ( NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num)
583: <> fnd_api.g_miss_num
584: OR NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num)
585: <> fnd_api.g_miss_num )
586: AND p_txn_ii_rltns_tbl(l_ind).api_caller_identity <> 'CONFIG'
587: THEN

Line 584: OR NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num)

580: -- Added for CZ Integration (Begin)
581:
582: IF ( NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num)
583: <> fnd_api.g_miss_num
584: OR NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num)
585: <> fnd_api.g_miss_num )
586: AND p_txn_ii_rltns_tbl(l_ind).api_caller_identity <> 'CONFIG'
587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');

Line 585: <> fnd_api.g_miss_num )

581:
582: IF ( NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num)
583: <> fnd_api.g_miss_num
584: OR NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num)
585: <> fnd_api.g_miss_num )
586: AND p_txn_ii_rltns_tbl(l_ind).api_caller_identity <> 'CONFIG'
587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
589: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_tbl(l_ind).api_caller_identity) ;

Line 591: RAISE FND_API.g_exc_error;

587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
589: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_tbl(l_ind).api_caller_identity) ;
590: FND_MSG_PUB.add;
591: RAISE FND_API.g_exc_error;
592: END IF ;
593:
594: IF (NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
595: AND NVL(p_txn_ii_rltns_tbl(l_ind).subject_id , fnd_api.g_miss_num)

Line 594: IF (NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num

590: FND_MSG_PUB.add;
591: RAISE FND_API.g_exc_error;
592: END IF ;
593:
594: IF (NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
595: AND NVL(p_txn_ii_rltns_tbl(l_ind).subject_id , fnd_api.g_miss_num)
596: = fnd_api.g_miss_num)
597: THEN
598: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.

Line 595: AND NVL(p_txn_ii_rltns_tbl(l_ind).subject_id , fnd_api.g_miss_num)

591: RAISE FND_API.g_exc_error;
592: END IF ;
593:
594: IF (NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
595: AND NVL(p_txn_ii_rltns_tbl(l_ind).subject_id , fnd_api.g_miss_num)
596: = fnd_api.g_miss_num)
597: THEN
598: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.
599:

Line 596: = fnd_api.g_miss_num)

592: END IF ;
593:
594: IF (NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
595: AND NVL(p_txn_ii_rltns_tbl(l_ind).subject_id , fnd_api.g_miss_num)
596: = fnd_api.g_miss_num)
597: THEN
598: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.
599:
600: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

Line 608: IF x_return_status <> fnd_api.g_ret_sts_success

604: x_instance_id => l_sub_instance_id ,
605: x_txn_line_detail_id => l_sub_tld_id ,
606: x_return_status => x_return_status );
607:
608: IF x_return_status <> fnd_api.g_ret_sts_success
609: THEN
610: RAISE fnd_api.g_exc_error ;
611: END IF ;
612: IF l_sub_instance_id IS NULL

Line 610: RAISE fnd_api.g_exc_error ;

606: x_return_status => x_return_status );
607:
608: IF x_return_status <> fnd_api.g_ret_sts_success
609: THEN
610: RAISE fnd_api.g_exc_error ;
611: END IF ;
612: IF l_sub_instance_id IS NULL
613: AND l_sub_tld_id IS NULL
614: THEN

Line 615: RAISE fnd_api.g_exc_error ;

611: END IF ;
612: IF l_sub_instance_id IS NULL
613: AND l_sub_tld_id IS NULL
614: THEN
615: RAISE fnd_api.g_exc_error ;
616: END IF ;
617:
618: IF l_sub_instance_id IS NOT NULL
619: THEN

Line 642: IF (NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num

638:
639: END IF ; --subject_id is null
640:
641:
642: IF (NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
643: AND NVL(p_txn_ii_rltns_tbl(l_ind).object_id , fnd_api.g_miss_num)
644: = fnd_api.g_miss_num)
645: THEN
646: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

Line 643: AND NVL(p_txn_ii_rltns_tbl(l_ind).object_id , fnd_api.g_miss_num)

639: END IF ; --subject_id is null
640:
641:
642: IF (NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
643: AND NVL(p_txn_ii_rltns_tbl(l_ind).object_id , fnd_api.g_miss_num)
644: = fnd_api.g_miss_num)
645: THEN
646: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
647: p_config_inst_hdr_id => p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id,

Line 644: = fnd_api.g_miss_num)

640:
641:
642: IF (NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
643: AND NVL(p_txn_ii_rltns_tbl(l_ind).object_id , fnd_api.g_miss_num)
644: = fnd_api.g_miss_num)
645: THEN
646: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
647: p_config_inst_hdr_id => p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id,
648: p_config_inst_rev_num => p_txn_ii_rltns_tbl(l_ind).obj_config_inst_rev_num,

Line 654: IF x_return_status <> fnd_api.g_ret_sts_success

650: x_instance_id => l_obj_instance_id ,
651: x_txn_line_detail_id => l_obj_tld_id ,
652: x_return_status => x_return_status );
653:
654: IF x_return_status <> fnd_api.g_ret_sts_success
655: THEN
656: RAISE fnd_api.g_exc_error ;
657: END IF ;
658:

Line 656: RAISE fnd_api.g_exc_error ;

652: x_return_status => x_return_status );
653:
654: IF x_return_status <> fnd_api.g_ret_sts_success
655: THEN
656: RAISE fnd_api.g_exc_error ;
657: END IF ;
658:
659: IF l_obj_instance_id IS NOT NULL
660: THEN

Line 672: RAISE fnd_api.g_exc_error ;

668:
669: IF l_obj_instance_id IS NULL
670: AND l_obj_tld_id IS NULL
671: THEN
672: RAISE fnd_api.g_exc_error ;
673: END IF ;
674: END IF ; --object_id is null
675: -- Added for CZ Integration (End)
676:

Line 683: RAISE fnd_api.g_exc_error;

679: IF l_iir_rec.subject_type not in ('T', 'I') THEN
680: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
681: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.subject_type);
682: FND_MSG_PUB.add;
683: RAISE fnd_api.g_exc_error;
684: ELSIF l_iir_rec.object_type not in ('T', 'I') THEN
685: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
686: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.object_type);
687: FND_MSG_PUB.add;

Line 688: RAISE fnd_api.g_exc_error;

684: ELSIF l_iir_rec.object_type not in ('T', 'I') THEN
685: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
686: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.object_type);
687: FND_MSG_PUB.add;
688: RAISE fnd_api.g_exc_error;
689: ELSIF (l_iir_rec.subject_type = 'I'
690: AND l_iir_rec.object_type = 'I' ) THEN
691: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
692: FND_MESSAGE.set_token('TXN_DTL_ID',l_iir_rec.object_id);

Line 694: x_return_status := fnd_api.g_ret_sts_error;

690: AND l_iir_rec.object_type = 'I' ) THEN
691: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
692: FND_MESSAGE.set_token('TXN_DTL_ID',l_iir_rec.object_id);
693: FND_MSG_PUB.add;
694: x_return_status := fnd_api.g_ret_sts_error;
695: RAISE fnd_api.g_exc_error;
696: ELSIF NOT(l_iir_rec.subject_type = 'T'
697: AND l_iir_rec.object_type = 'T' ) THEN
698: IF l_iir_rec.subject_type = 'T' THEN

Line 695: RAISE fnd_api.g_exc_error;

691: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
692: FND_MESSAGE.set_token('TXN_DTL_ID',l_iir_rec.object_id);
693: FND_MSG_PUB.add;
694: x_return_status := fnd_api.g_ret_sts_error;
695: RAISE fnd_api.g_exc_error;
696: ELSIF NOT(l_iir_rec.subject_type = 'T'
697: AND l_iir_rec.object_type = 'T' ) THEN
698: IF l_iir_rec.subject_type = 'T' THEN
699: l_txn_line_dtl_rec1 := l_txn_line_dtl_g_miss;-- subject TLD record

Line 713: IF l_return_status <> fnd_api.g_ret_sts_success THEN

709: p_txn_line_detail_id => l_iir_rec.subject_id,
710: x_txn_line_detail_rec =>l_txn_line_dtl_rec2, -- calling the overloaded routine. M-M change
711: x_return_status => l_return_status);
712:
713: IF l_return_status <> fnd_api.g_ret_sts_success THEN
714:
715: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
716: FND_MESSAGE.set_token('SUBJECT_ID',l_iir_rec.subject_id);
717: FND_MSG_PUB.add;

Line 718: RAISE fnd_api.g_exc_error;

714:
715: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
716: FND_MESSAGE.set_token('SUBJECT_ID',l_iir_rec.subject_id);
717: FND_MSG_PUB.add;
718: RAISE fnd_api.g_exc_error;
719:
720: END IF;
721: END IF;
722:

Line 732: IF l_return_status <> fnd_api.g_ret_sts_success THEN

728: p_txn_line_detail_id => l_iir_rec.object_id,
729: x_txn_line_detail_rec =>l_txn_line_dtl_rec1, -- calling the overloaded routine. M-M change
730: x_return_status => l_return_status);
731:
732: IF l_return_status <> fnd_api.g_ret_sts_success THEN
733:
734: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
735: FND_MESSAGE.set_token('OBJECT_ID',l_iir_rec.object_id);
736: FND_MSG_PUB.add;

Line 737: RAISE fnd_api.g_exc_error;

733:
734: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
735: FND_MESSAGE.set_token('OBJECT_ID',l_iir_rec.object_id);
736: FND_MSG_PUB.add;
737: RAISE fnd_api.g_exc_error;
738:
739: END IF;
740: END IF;
741:

Line 757: RAISE FND_API.g_exc_error;

753: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
754: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
755: FND_MESSAGE.set_token('STATUS',l_processing_status);
756: FND_MSG_PUB.add;
757: RAISE FND_API.g_exc_error;
758:
759: ELSIF l_iir_rec.object_type = 'T' THEN
760: SELECT tl.processing_status
761: INTO l_processing_status

Line 773: RAISE FND_API.g_exc_error;

769: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
770: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
771: FND_MESSAGE.set_token('STATUS',l_processing_status);
772: FND_MSG_PUB.add;
773: RAISE FND_API.g_exc_error;
774: END IF;
775: END IF;
776: ELSIF l_iir_rec.object_type = 'T' THEN
777: SELECT tl.processing_status

Line 790: RAISE FND_API.g_exc_error;

786: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
787: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
788: FND_MESSAGE.set_token('STATUS',l_processing_status);
789: FND_MSG_PUB.add;
790: RAISE FND_API.g_exc_error;
791: END IF;
792:
793: END IF;
794: Exception when others then

Line 799: raise fnd_api.g_exc_error;

795: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
796: fnd_message.set_token('MESSAGE',
797: 'Unhandled exception in Update Txn reltns'||substr(sqlerrm,1,200));
798: fnd_msg_pub.add;
799: raise fnd_api.g_exc_error;
800: END;
801:
802: l_iir_rec.relationship_type_code :=
803: p_txn_ii_rltns_tbl(l_ind).relationship_type_code;

Line 805: IF l_iir_rec.relationship_type_code <> fnd_api.g_miss_char THEN

801:
802: l_iir_rec.relationship_type_code :=
803: p_txn_ii_rltns_tbl(l_ind).relationship_type_code;
804:
805: IF l_iir_rec.relationship_type_code <> fnd_api.g_miss_char THEN
806:
807: csi_t_vldn_routines_pvt.validate_ii_rltns_type_code(
808: p_rltns_type_code => l_iir_rec.relationship_type_code,
809: x_return_status => l_return_status);

Line 811: IF l_return_status <> fnd_api.g_ret_sts_success THEN

807: csi_t_vldn_routines_pvt.validate_ii_rltns_type_code(
808: p_rltns_type_code => l_iir_rec.relationship_type_code,
809: x_return_status => l_return_status);
810:
811: IF l_return_status <> fnd_api.g_ret_sts_success THEN
812:
813: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
814: FND_MESSAGE.set_token('RLTNS_CODE',l_iir_rec.relationship_type_code);
815: FND_MSG_PUB.add;

Line 816: RAISE fnd_api.g_exc_error;

812:
813: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
814: FND_MESSAGE.set_token('RLTNS_CODE',l_iir_rec.relationship_type_code);
815: FND_MSG_PUB.add;
816: RAISE fnd_api.g_exc_error;
817:
818: END IF;
819:
820: END IF;

Line 827: IF l_iir_rec.transfer_components_flag <> fnd_api.g_miss_char THEN

823:
824: l_iir_rec.transfer_components_flag :=
825: p_txn_ii_rltns_tbl(l_ind).transfer_components_flag;
826:
827: IF l_iir_rec.transfer_components_flag <> fnd_api.g_miss_char THEN
828: IF l_iir_rec.relationship_type_code
829: NOT IN ('REPLACED-BY', 'REPLACEMENT-FOR','UPGRADED-FROM') THEN
830: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
831: FND_MESSAGE.set_token('PARAM','transfer_components_flag');

Line 836: l_iir_rec.transfer_components_flag := fnd_api.g_miss_char;

832: FND_MESSAGE.set_token('VALUE',l_iir_rec.transfer_components_flag);
833: FND_MESSAGE.set_token('REASON','This attribute is applicable to
834: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
835: FND_MSG_PUB.add;
836: l_iir_rec.transfer_components_flag := fnd_api.g_miss_char;
837: END IF;
838: END IF;
839:
840: l_iir_rec.csi_inst_relationship_id :=

Line 844: IF l_iir_rec.csi_inst_relationship_id <> fnd_api.g_miss_num

840: l_iir_rec.csi_inst_relationship_id :=
841: p_txn_ii_rltns_tbl(l_ind).csi_inst_relationship_id;
842:
843: -- ##validate instance relationship_id
844: IF l_iir_rec.csi_inst_relationship_id <> fnd_api.g_miss_num
845: AND
846: l_iir_rec.csi_inst_relationship_id is not null
847: THEN
848: null;

Line 860: IF l_return_status <> fnd_api.g_ret_sts_success THEN

856: p_txn_line_detail_rec2 => l_txn_line_dtl_rec2,
857: p_iir_rec => l_iir_rec,
858: x_return_status => l_return_status);
859:
860: IF l_return_status <> fnd_api.g_ret_sts_success THEN
861: RAISE fnd_api.g_exc_error;
862: END IF;
863:
864:

Line 861: RAISE fnd_api.g_exc_error;

857: p_iir_rec => l_iir_rec,
858: x_return_status => l_return_status);
859:
860: IF l_return_status <> fnd_api.g_ret_sts_success THEN
861: RAISE fnd_api.g_exc_error;
862: END IF;
863:
864:
865: l_iir_rec.position_reference := p_txn_ii_rltns_tbl(l_ind).position_reference;

Line 964: raise fnd_api.g_exc_error;

960: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
961: fnd_message.set_token('MESSAGE',
962: 'csi_t_ii_relationships_pkg.update_row Failed. '||substr(sqlerrm,1,200));
963: fnd_msg_pub.add;
964: raise fnd_api.g_exc_error;
965: end;
966:
967: END LOOP;
968: END LOOP;

Line 972: IF FND_API.To_Boolean( p_commit ) THEN

968: END LOOP;
969: END IF;
970:
971: -- Standard check of p_commit.
972: IF FND_API.To_Boolean( p_commit ) THEN
973: COMMIT WORK;
974: END IF;
975:
976: -- Standard call to get message count and if count is get message info.

Line 982: WHEN FND_API.G_EXC_ERROR THEN

978: p_count => x_msg_count,
979: p_data => x_msg_data);
980:
981: EXCEPTION
982: WHEN FND_API.G_EXC_ERROR THEN
983:
984: ROLLBACK TO update_txn_ii_rltns_dtls;
985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get (

Line 985: x_return_status := FND_API.G_RET_STS_ERROR ;

981: EXCEPTION
982: WHEN FND_API.G_EXC_ERROR THEN
983:
984: ROLLBACK TO update_txn_ii_rltns_dtls;
985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get (
987: p_count => x_msg_count,
988: p_data => x_msg_data);
989:

Line 990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

986: FND_MSG_PUB.Count_And_Get (
987: p_count => x_msg_count,
988: p_data => x_msg_data);
989:
990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
991:
992: ROLLBACK TO update_txn_ii_rltns_dtls;
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994:

Line 993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

989:
990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
991:
992: ROLLBACK TO update_txn_ii_rltns_dtls;
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994:
995: FND_MSG_PUB.Count_And_Get(
996: p_count => x_msg_count,
997: p_data => x_msg_data);

Line 1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

998:
999: WHEN OTHERS THEN
1000:
1001: ROLLBACK TO update_txn_ii_rltns_dtls;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1003:
1004: IF FND_MSG_PUB.Check_Msg_Level(
1005: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1006:

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

1017: END update_txn_ii_rltns_dtls;
1018:
1019: PROCEDURE delete_txn_ii_rltns_dtls(
1020: p_api_version IN NUMBER
1021: ,p_commit IN VARCHAR2 := fnd_api.g_false
1022: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1023: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1024: ,p_txn_ii_rltns_ids_tbl IN csi_t_datastructures_grp.txn_ii_rltns_ids_tbl
1025: ,x_return_status OUT NOCOPY VARCHAR2

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

1018:
1019: PROCEDURE delete_txn_ii_rltns_dtls(
1020: p_api_version IN NUMBER
1021: ,p_commit IN VARCHAR2 := fnd_api.g_false
1022: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1023: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1024: ,p_txn_ii_rltns_ids_tbl IN csi_t_datastructures_grp.txn_ii_rltns_ids_tbl
1025: ,x_return_status OUT NOCOPY VARCHAR2
1026: ,x_msg_count OUT NOCOPY NUMBER

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

1019: PROCEDURE delete_txn_ii_rltns_dtls(
1020: p_api_version IN NUMBER
1021: ,p_commit IN VARCHAR2 := fnd_api.g_false
1022: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1023: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1024: ,p_txn_ii_rltns_ids_tbl IN csi_t_datastructures_grp.txn_ii_rltns_ids_tbl
1025: ,x_return_status OUT NOCOPY VARCHAR2
1026: ,x_msg_count OUT NOCOPY NUMBER
1027: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 1050: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1046: -- Standard Start of API savepoint
1047: SAVEPOINT delete_txn_ii_rltns_dtls;
1048:
1049: -- Initialize message list if p_init_msg_list is set to TRUE.
1050: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1051: FND_MSG_PUB.initialize;
1052: END IF;
1053:
1054: -- Initialize API return status to success

Line 1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

1051: FND_MSG_PUB.initialize;
1052: END IF;
1053:
1054: -- Initialize API return status to success
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: -- Standard call to check for call compatibility.
1058: IF NOT
1059:

Line 1060: FND_API.Compatible_API_Call (

1056:
1057: -- Standard call to check for call compatibility.
1058: IF NOT
1059:
1060: FND_API.Compatible_API_Call (
1061: p_current_version_number => l_api_version,
1062: p_caller_version_number => p_api_version,
1063: p_api_name => l_api_name,
1064: p_pkg_name => G_PKG_NAME) THEN

Line 1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1062: p_caller_version_number => p_api_version,
1063: p_api_name => l_api_name,
1064: p_pkg_name => G_PKG_NAME) THEN
1065:
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067:
1068: END IF;
1069:
1070: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

Line 1092: IF NVL(l_rltns_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

1088: END IF;
1089:
1090: l_rltns_id := p_txn_ii_rltns_ids_tbl(l_ind).txn_relationship_id;
1091:
1092: IF NVL(l_rltns_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1093:
1094: csi_t_vldn_routines_pvt.validate_txn_relationship_id(
1095: p_txn_relationship_id => l_rltns_id,
1096: x_return_status => l_return_status);

Line 1098: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1094: csi_t_vldn_routines_pvt.validate_txn_relationship_id(
1095: p_txn_relationship_id => l_rltns_id,
1096: x_return_status => l_return_status);
1097:
1098: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1099:
1100: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
1101: FND_MESSAGE.set_token('RLTNS_ID',l_rltns_id);
1102: FND_MSG_PUB.add;

Line 1103: RAISE fnd_api.g_exc_error;

1099:
1100: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
1101: FND_MESSAGE.set_token('RLTNS_ID',l_rltns_id);
1102: FND_MSG_PUB.add;
1103: RAISE fnd_api.g_exc_error;
1104:
1105: END IF;
1106:
1107: csi_t_gen_utility_pvt.dump_api_info(

Line 1126: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1122:
1123: -- #validate transaction_line_id
1124:
1125:
1126: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1127:
1128: null;
1129: -- #populate error message
1130:

Line 1147: IF FND_API.To_Boolean( p_commit ) THEN

1143: END LOOP;
1144: END IF;
1145:
1146: -- Standard check of p_commit.
1147: IF FND_API.To_Boolean( p_commit ) THEN
1148: COMMIT WORK;
1149: END IF;
1150:
1151: -- Standard call to get message count and if count is get message info.

Line 1157: WHEN FND_API.G_EXC_ERROR THEN

1153: p_count => x_msg_count,
1154: p_data => x_msg_data);
1155:
1156: EXCEPTION
1157: WHEN FND_API.G_EXC_ERROR THEN
1158:
1159: ROLLBACK TO delete_txn_ii_rltns_dtls;
1160: x_return_status := FND_API.G_RET_STS_ERROR ;
1161: FND_MSG_PUB.Count_And_Get (

Line 1160: x_return_status := FND_API.G_RET_STS_ERROR ;

1156: EXCEPTION
1157: WHEN FND_API.G_EXC_ERROR THEN
1158:
1159: ROLLBACK TO delete_txn_ii_rltns_dtls;
1160: x_return_status := FND_API.G_RET_STS_ERROR ;
1161: FND_MSG_PUB.Count_And_Get (
1162: p_count => x_msg_count,
1163: p_data => x_msg_data);
1164:

Line 1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1161: FND_MSG_PUB.Count_And_Get (
1162: p_count => x_msg_count,
1163: p_data => x_msg_data);
1164:
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166:
1167: ROLLBACK TO delete_txn_ii_rltns_dtls;
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1169:

Line 1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1164:
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166:
1167: ROLLBACK TO delete_txn_ii_rltns_dtls;
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1169:
1170: FND_MSG_PUB.Count_And_Get(
1171: p_count => x_msg_count,
1172: p_data => x_msg_data);

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1173:
1174: WHEN OTHERS THEN
1175:
1176: ROLLBACK TO delete_txn_ii_rltns_dtls;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178:
1179: IF FND_MSG_PUB.Check_Msg_Level(
1180: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1181: