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 CSI_T_GEN_UTILITY_PVT

Line 37: csi_t_gen_utility_pvt.add('Begin : '||l_api_name);

33: l_obj_tld_id NUMBER ;
34:
35: BEGIN
36:
37: csi_t_gen_utility_pvt.add('Begin : '||l_api_name);
38: -- Standard Start of API savepoint
39: SAVEPOINT create_txn_ii_rltns_dtls;
40:
41:

Line 65: csi_t_gen_utility_pvt.dump_api_info(

61: END IF;
62:
63: -- Check the profile option debug_level for debug message reporting
64:
65: csi_t_gen_utility_pvt.dump_api_info(
66: p_pkg_name => g_pkg_name,
67: p_api_name => l_api_name);
68:
69: csi_t_gen_utility_pvt.add(

Line 69: csi_t_gen_utility_pvt.add(

65: csi_t_gen_utility_pvt.dump_api_info(
66: p_pkg_name => g_pkg_name,
67: p_api_name => l_api_name);
68:
69: csi_t_gen_utility_pvt.add(
70: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
71:
72: -- Added for CZ Integration (Begin)
73:

Line 169: IF csi_t_gen_utility_pvt.g_debug_level > 1 THEN

165: END IF ;
166: END IF ; --object_id is null
167: -- Added for CZ Integration (End)
168:
169: IF csi_t_gen_utility_pvt.g_debug_level > 1 THEN
170:
171: csi_t_gen_utility_pvt.dump_ii_rltns_rec(
172: p_ii_rltns_rec => p_txn_ii_rltns_rec);
173:

Line 171: csi_t_gen_utility_pvt.dump_ii_rltns_rec(

167: -- Added for CZ Integration (End)
168:
169: IF csi_t_gen_utility_pvt.g_debug_level > 1 THEN
170:
171: csi_t_gen_utility_pvt.dump_ii_rltns_rec(
172: p_ii_rltns_rec => p_txn_ii_rltns_rec);
173:
174: END IF;
175:

Line 236: csi_t_gen_utility_pvt.add('Validate subject_id.');

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(
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

Line 258: csi_t_gen_utility_pvt.add('Validate object_id.');

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(
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

Line 276: csi_t_gen_utility_pvt.add('Validate relationship_type code.');

272: END IF;
273: -- END IF;
274: END IF;
275:
276: csi_t_gen_utility_pvt.add('Validate relationship_type code.');
277:
278: -- validate relationship_type_code csi_ii_relation_types table
279: csi_t_vldn_routines_pvt.validate_ii_rltns_type_code(
280: p_rltns_type_code => p_txn_ii_rltns_rec.relationship_type_code,

Line 294: csi_t_gen_utility_pvt.add('Validate instance reference.');

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,
298: p_level_inst_ref_id => p_txn_ii_rltns_rec.csi_inst_relationship_id,

Line 302: csi_t_gen_utility_pvt.add('Error in here.');

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;
306:

Line 328: csi_t_gen_utility_pvt.dump_line_detail_rec

324:
325: -- validate position_reference
326:
327: /* Added M-M changes Validate the relationship record */
328: csi_t_gen_utility_pvt.dump_line_detail_rec
329: ( p_line_detail_rec => l_txn_line_dtl_rec1
330: );
331:
332: csi_t_gen_utility_pvt.dump_line_detail_rec

Line 332: csi_t_gen_utility_pvt.dump_line_detail_rec

328: csi_t_gen_utility_pvt.dump_line_detail_rec
329: ( p_line_detail_rec => l_txn_line_dtl_rec1
330: );
331:
332: csi_t_gen_utility_pvt.dump_line_detail_rec
333: ( p_line_detail_rec => l_txn_line_dtl_rec2
334: );
335:
336: csi_t_vldn_routines_pvt.validate_txn_rltnshp (

Line 355: csi_t_gen_utility_pvt.dump_api_info(

351: end if;
352:
353: begin
354:
355: csi_t_gen_utility_pvt.dump_api_info(
356: p_api_name => 'insert_row',
357: p_pkg_name => 'csi_t_ii_relationships_pkg');
358:
359: csi_t_ii_relationships_pkg.insert_row(

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 424: csi_t_gen_utility_pvt.set_debug_off;

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.
428: FND_MSG_PUB.Count_And_Get(

Line 530: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

526:
527: END IF;
528:
529: --debug messages
530: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
531:
532: csi_t_gen_utility_pvt.dump_api_info(
533: p_pkg_name => g_pkg_name,
534: p_api_name => l_api_name);

Line 532: csi_t_gen_utility_pvt.dump_api_info(

528:
529: --debug messages
530: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
531:
532: csi_t_gen_utility_pvt.dump_api_info(
533: p_pkg_name => g_pkg_name,
534: p_api_name => l_api_name);
535:
536: csi_t_gen_utility_pvt.add(

Line 536: csi_t_gen_utility_pvt.add(

532: csi_t_gen_utility_pvt.dump_api_info(
533: p_pkg_name => g_pkg_name,
534: p_api_name => l_api_name);
535:
536: csi_t_gen_utility_pvt.add(
537: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
538:
539: -- Main API code
540: IF p_txn_ii_rltns_tbl.count > 0 THEN

Line 545: csi_t_gen_utility_pvt.dump_ii_rltns_rec(

541: FOR l_ind IN p_txn_ii_rltns_tbl.FIRST .. p_txn_ii_rltns_tbl.LAST
542: LOOP
543:
544: IF l_debug_level > 1 THEN
545: csi_t_gen_utility_pvt.dump_ii_rltns_rec(
546: p_ii_rltns_rec => p_txn_ii_rltns_tbl(l_ind));
547: END IF;
548:
549: l_iir_rec.txn_relationship_id :=

Line 705: csi_t_gen_utility_pvt.add('Validate subject_id.');

701: l_txn_line_dtl_rec2 := l_txn_line_dtl_g_miss; --object TLD record
702: END IF;
703: END IF;
704:
705: csi_t_gen_utility_pvt.add('Validate subject_id.');
706:
707: IF l_iir_rec.subject_type = 'T' THEN
708: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
709: p_txn_line_detail_id => l_iir_rec.subject_id,

Line 723: csi_t_gen_utility_pvt.add('Validate object_id.');

719:
720: END IF;
721: END IF;
722:
723: csi_t_gen_utility_pvt.add('Validate object_id.');
724:
725: IF l_iir_rec.object_type = 'T' THEN
726: -- validate object_id
727: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

Line 907: csi_t_gen_utility_pvt.dump_api_info(

903:
904:
905: begin
906:
907: csi_t_gen_utility_pvt.dump_api_info(
908: p_api_name => 'update_row',
909: p_pkg_name => 'csi_t_ii_relationships_pkg');
910:
911: csi_t_ii_relationships_pkg.update_row(

Line 1070: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

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;
1071:
1072: csi_t_gen_utility_pvt.dump_api_info(
1073: p_pkg_name => g_pkg_name,
1074: p_api_name => l_api_name);

Line 1072: csi_t_gen_utility_pvt.dump_api_info(

1068: END IF;
1069:
1070: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
1071:
1072: csi_t_gen_utility_pvt.dump_api_info(
1073: p_pkg_name => g_pkg_name,
1074: p_api_name => l_api_name);
1075:
1076: csi_t_gen_utility_pvt.add(

Line 1076: csi_t_gen_utility_pvt.add(

1072: csi_t_gen_utility_pvt.dump_api_info(
1073: p_pkg_name => g_pkg_name,
1074: p_api_name => l_api_name);
1075:
1076: csi_t_gen_utility_pvt.add(
1077: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
1078:
1079: -- Main API code
1080:

Line 1107: csi_t_gen_utility_pvt.dump_api_info(

1103: RAISE fnd_api.g_exc_error;
1104:
1105: END IF;
1106:
1107: csi_t_gen_utility_pvt.dump_api_info(
1108: p_api_name => 'delete_row',
1109: p_pkg_name => 'csi_t_ii_relationships_pkg');
1110:
1111: csi_t_ii_relationships_pkg.delete_row(