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_II_RELATIONSHIPS_PUB dependencies on CSI_GEN_UTILITY_PVT

Line 71: CSI_gen_utility_pvt.put_line( 'get_relationships');

67:
68: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
69: -- IF debug_level = 1 THEN dump the PROCEDURE name
70: IF (l_debug_level > 0) THEN
71: CSI_gen_utility_pvt.put_line( 'get_relationships');
72: END IF;
73:
74: -- IF the debug level = 2 THEN dump all the parameters values.
75: IF (l_debug_level > 1) THEN

Line 76: CSI_gen_utility_pvt.put_line(

72: END IF;
73:
74: -- IF the debug level = 2 THEN dump all the parameters values.
75: IF (l_debug_level > 1) THEN
76: CSI_gen_utility_pvt.put_line(
77: p_api_version ||'-'||
78: p_commit ||'-'||
79: p_init_msg_list ||'-'||
80: p_validation_level ||'-'||

Line 85: csi_gen_utility_pvt.dump_rel_query_rec(p_relationship_query_rec);

81: p_depth ||'_'||
82: p_time_stamp );
83:
84: -- dump the relationship query records
85: csi_gen_utility_pvt.dump_rel_query_rec(p_relationship_query_rec);
86: END IF;
87:
88: /***** srramakr commented for bug # 3304439
89: -- check for the profile option AND enable trace

Line 90: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

86: END IF;
87:
88: /***** srramakr commented for bug # 3304439
89: -- check for the profile option AND enable trace
90: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
91: -- END enable trace
92: ****/
93:
94: --

Line 235: CSI_gen_utility_pvt.put_line( 'create_relationship');

231:
232: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
233: -- IF debug_level = 1 THEN dump the PROCEDURE name
234: IF (l_debug_level > 0) THEN
235: CSI_gen_utility_pvt.put_line( 'create_relationship');
236: END IF;
237:
238: -- IF the debug level = 2 THEN dump all the parameters values.
239: IF (l_debug_level > 1) THEN

Line 242: CSI_gen_utility_pvt.put_line(

238: -- IF the debug level = 2 THEN dump all the parameters values.
239: IF (l_debug_level > 1) THEN
240:
241:
242: CSI_gen_utility_pvt.put_line(
243: p_api_version ||'-'||
244: p_commit ||'-'||
245: p_init_msg_list ||'-'||
246: p_validation_level );

Line 249: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);

245: p_init_msg_list ||'-'||
246: p_validation_level );
247:
248: -- dump the relationship query records
249: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
250: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
251:
252: END IF;
253:

Line 250: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

246: p_validation_level );
247:
248: -- dump the relationship query records
249: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
250: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
251:
252: END IF;
253:
254: /***** srramakr commented for bug # 3304439

Line 256: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

252: END IF;
253:
254: /***** srramakr commented for bug # 3304439
255: -- check for the profile option AND enable trace
256: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
257: -- END enable trace
258: ****/
259:
260:

Line 312: csi_gen_utility_pvt.put_line( ' Error from Update_relationship PVT..');

308: WHILE l_msg_count > 0 LOOP
309: x_msg_data := FND_MSG_PUB.GET
310: ( l_msg_index,
311: FND_API.G_FALSE );
312: csi_gen_utility_pvt.put_line( ' Error from Update_relationship PVT..');
313: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
314: l_msg_index := l_msg_index + 1;
315: l_msg_count := l_msg_count - 1;
316: END LOOP;

Line 313: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

309: x_msg_data := FND_MSG_PUB.GET
310: ( l_msg_index,
311: FND_API.G_FALSE );
312: csi_gen_utility_pvt.put_line( ' Error from Update_relationship PVT..');
313: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
314: l_msg_index := l_msg_index + 1;
315: l_msg_count := l_msg_count - 1;
316: END LOOP;
317: RAISE FND_API.G_EXC_ERROR;

Line 342: csi_gen_utility_pvt.put_line( ' Error from Create_relationship PVT..');

338: WHILE l_msg_count > 0 LOOP
339: x_msg_data := FND_MSG_PUB.GET
340: ( l_msg_index,
341: FND_API.G_FALSE );
342: csi_gen_utility_pvt.put_line( ' Error from Create_relationship PVT..');
343: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
344: l_msg_index := l_msg_index + 1;
345: l_msg_count := l_msg_count - 1;
346: END LOOP;

Line 343: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

339: x_msg_data := FND_MSG_PUB.GET
340: ( l_msg_index,
341: FND_API.G_FALSE );
342: csi_gen_utility_pvt.put_line( ' Error from Create_relationship PVT..');
343: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
344: l_msg_index := l_msg_index + 1;
345: l_msg_count := l_msg_count - 1;
346: END LOOP;
347: RAISE FND_API.G_EXC_ERROR;

Line 375: csi_gen_utility_pvt.put_line(' Calling CSI_BUSINESS_EVENT_PVT.CREATE_INSTANCE_EVENT');

371: l_internal_party_id := null;
372: END;
373:
374: IF l_internal_party_id <> l_owner_party_id THEN
375: csi_gen_utility_pvt.put_line(' Calling CSI_BUSINESS_EVENT_PVT.CREATE_INSTANCE_EVENT');
376: -- Check if relationships is already been built then allow update
377: BEGIN
378: SELECT 'Y'
379: INTO l_relationship_exists

Line 393: csi_gen_utility_pvt.put_line('In relationships, therefore raise the create instance event');

389: l_relationship_exists := 'Y';
390: END;
391:
392: IF l_relationship_exists = 'Y' THEN
393: csi_gen_utility_pvt.put_line('In relationships, therefore raise the create instance event');
394: csi_gen_utility_pvt.put_line('The Subject Id '||p_relationship_tbl(l_count).subject_id);
395: csi_gen_utility_pvt.put_line('The Object Id '||p_relationship_tbl(l_count).object_id);
396: csi_gen_utility_pvt.put_line('The relationship_type_code '||p_relationship_tbl(l_count).relationship_type_code);
397:

Line 394: csi_gen_utility_pvt.put_line('The Subject Id '||p_relationship_tbl(l_count).subject_id);

390: END;
391:
392: IF l_relationship_exists = 'Y' THEN
393: csi_gen_utility_pvt.put_line('In relationships, therefore raise the create instance event');
394: csi_gen_utility_pvt.put_line('The Subject Id '||p_relationship_tbl(l_count).subject_id);
395: csi_gen_utility_pvt.put_line('The Object Id '||p_relationship_tbl(l_count).object_id);
396: csi_gen_utility_pvt.put_line('The relationship_type_code '||p_relationship_tbl(l_count).relationship_type_code);
397:
398: l_root_asset_id :=csi_ii_relationships_pvt.Get_Root_Parent(p_relationship_tbl(l_count).subject_id,

Line 395: csi_gen_utility_pvt.put_line('The Object Id '||p_relationship_tbl(l_count).object_id);

391:
392: IF l_relationship_exists = 'Y' THEN
393: csi_gen_utility_pvt.put_line('In relationships, therefore raise the create instance event');
394: csi_gen_utility_pvt.put_line('The Subject Id '||p_relationship_tbl(l_count).subject_id);
395: csi_gen_utility_pvt.put_line('The Object Id '||p_relationship_tbl(l_count).object_id);
396: csi_gen_utility_pvt.put_line('The relationship_type_code '||p_relationship_tbl(l_count).relationship_type_code);
397:
398: l_root_asset_id :=csi_ii_relationships_pvt.Get_Root_Parent(p_relationship_tbl(l_count).subject_id,
399: p_relationship_tbl(l_count).relationship_type_code,

Line 396: csi_gen_utility_pvt.put_line('The relationship_type_code '||p_relationship_tbl(l_count).relationship_type_code);

392: IF l_relationship_exists = 'Y' THEN
393: csi_gen_utility_pvt.put_line('In relationships, therefore raise the create instance event');
394: csi_gen_utility_pvt.put_line('The Subject Id '||p_relationship_tbl(l_count).subject_id);
395: csi_gen_utility_pvt.put_line('The Object Id '||p_relationship_tbl(l_count).object_id);
396: csi_gen_utility_pvt.put_line('The relationship_type_code '||p_relationship_tbl(l_count).relationship_type_code);
397:
398: l_root_asset_id :=csi_ii_relationships_pvt.Get_Root_Parent(p_relationship_tbl(l_count).subject_id,
399: p_relationship_tbl(l_count).relationship_type_code,
400: p_relationship_tbl(l_count).object_id);

Line 422: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.CREATE_INSTANCE_EVENT');

418: WHILE l_msg_count > 0 LOOP
419: x_msg_data := FND_MSG_PUB.GET
420: (l_msg_index,
421: FND_API.G_FALSE );
422: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.CREATE_INSTANCE_EVENT');
423: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
424: l_msg_index := l_msg_index + 1;
425: l_msg_count := l_msg_count - 1;
426: END LOOP;

Line 423: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

419: x_msg_data := FND_MSG_PUB.GET
420: (l_msg_index,
421: FND_API.G_FALSE );
422: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.CREATE_INSTANCE_EVENT');
423: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
424: l_msg_index := l_msg_index + 1;
425: l_msg_count := l_msg_count - 1;
426: END LOOP;
427: RAISE FND_API.G_EXC_ERROR;

Line 453: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');

449: WHILE l_msg_count > 0 LOOP
450: x_msg_data := FND_MSG_PUB.GET
451: ( l_msg_index,
452: FND_API.G_FALSE );
453: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');
454: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
455: l_msg_index := l_msg_index + 1;
456: l_msg_count := l_msg_count - 1;
457: END LOOP;

Line 454: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

450: x_msg_data := FND_MSG_PUB.GET
451: ( l_msg_index,
452: FND_API.G_FALSE );
453: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');
454: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
455: l_msg_index := l_msg_index + 1;
456: l_msg_count := l_msg_count - 1;
457: END LOOP;
458: RAISE FND_API.G_EXC_ERROR;

Line 578: CSI_gen_utility_pvt.put_line( 'update_relationship');

574:
575: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
576: -- IF debug_level = 1 THEN dump the PROCEDURE name
577: IF (l_debug_level > 0) THEN
578: CSI_gen_utility_pvt.put_line( 'update_relationship');
579: END IF;
580:
581: -- IF the debug level = 2 THEN dump all the parameters values.
582: IF (l_debug_level > 1) THEN

Line 585: CSI_gen_utility_pvt.put_line(

581: -- IF the debug level = 2 THEN dump all the parameters values.
582: IF (l_debug_level > 1) THEN
583:
584:
585: CSI_gen_utility_pvt.put_line(
586: p_api_version ||'-'||
587: p_commit ||'-'||
588: p_init_msg_list ||'-'||
589: p_validation_level );

Line 592: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);

588: p_init_msg_list ||'-'||
589: p_validation_level );
590:
591: -- dump the relationship query records
592: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
593: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
594:
595: END IF;
596:

Line 593: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

589: p_validation_level );
590:
591: -- dump the relationship query records
592: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
593: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
594:
595: END IF;
596:
597: /***** srramakr commented for bug # 3304439

Line 599: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

595: END IF;
596:
597: /***** srramakr commented for bug # 3304439
598: -- check for the profile option AND enable trace
599: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
600: -- END enable trace
601: ****/
602:
603: -- Added for replacement bug

Line 638: csi_gen_utility_pvt.put_line('Value of relationship_id is : '||l_rel_tbl(1).relationship_id);

634: THEN
635:
636: l_rel_tbl.delete;
637: l_rel_tbl(1):=l_relationship_tbl(l_count);
638: csi_gen_utility_pvt.put_line('Value of relationship_id is : '||l_rel_tbl(1).relationship_id);
639: csi_gen_utility_pvt.put_line('Value of replace_flag is :'||l_replace_flag);
640: csi_ii_relationships_pvt.update_relationship(
641: p_api_version => p_api_version,
642: p_commit => fnd_api.g_false,

Line 639: csi_gen_utility_pvt.put_line('Value of replace_flag is :'||l_replace_flag);

635:
636: l_rel_tbl.delete;
637: l_rel_tbl(1):=l_relationship_tbl(l_count);
638: csi_gen_utility_pvt.put_line('Value of relationship_id is : '||l_rel_tbl(1).relationship_id);
639: csi_gen_utility_pvt.put_line('Value of replace_flag is :'||l_replace_flag);
640: csi_ii_relationships_pvt.update_relationship(
641: p_api_version => p_api_version,
642: p_commit => fnd_api.g_false,
643: p_init_msg_list => p_init_msg_list,

Line 664: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.update_relationship..');

660: WHILE l_msg_count > 0 LOOP
661: x_msg_data := FND_MSG_PUB.GET
662: ( l_msg_index,
663: FND_API.G_FALSE );
664: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.update_relationship..');
665: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
666: l_msg_index := l_msg_index + 1;
667: l_msg_count := l_msg_count - 1;
668: END LOOP;

Line 665: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

661: x_msg_data := FND_MSG_PUB.GET
662: ( l_msg_index,
663: FND_API.G_FALSE );
664: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.update_relationship..');
665: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
666: l_msg_index := l_msg_index + 1;
667: l_msg_count := l_msg_count - 1;
668: END LOOP;
669: RAISE FND_API.G_EXC_ERROR;

Line 704: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.create_relationship..');

700: LOOP
701: x_msg_data := FND_MSG_PUB.GET
702: ( l_msg_index,
703: FND_API.G_FALSE );
704: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.create_relationship..');
705: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
706: l_msg_index := l_msg_index + 1;
707: l_msg_count := l_msg_count - 1;
708: END LOOP;

Line 705: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

701: x_msg_data := FND_MSG_PUB.GET
702: ( l_msg_index,
703: FND_API.G_FALSE );
704: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.create_relationship..');
705: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
706: l_msg_index := l_msg_index + 1;
707: l_msg_count := l_msg_count - 1;
708: END LOOP;
709: RAISE FND_API.G_EXC_ERROR;

Line 745: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');

741: WHILE l_msg_count > 0 LOOP
742: x_msg_data := FND_MSG_PUB.GET
743: ( l_msg_index,
744: FND_API.G_FALSE );
745: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');
746: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
747: l_msg_index := l_msg_index + 1;
748: l_msg_count := l_msg_count - 1;
749: END LOOP;

Line 746: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

742: x_msg_data := FND_MSG_PUB.GET
743: ( l_msg_index,
744: FND_API.G_FALSE );
745: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');
746: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
747: l_msg_index := l_msg_index + 1;
748: l_msg_count := l_msg_count - 1;
749: END LOOP;
750: RAISE FND_API.G_EXC_ERROR;

Line 852: CSI_gen_utility_pvt.put_line( 'expire_relationship');

848:
849: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
850: -- IF debug_level = 1 THEN dump the PROCEDURE name
851: IF (l_debug_level > 0) THEN
852: CSI_gen_utility_pvt.put_line( 'expire_relationship');
853: END IF;
854:
855: -- IF the debug level = 2 THEN dump all the parameters values.
856: IF (l_debug_level > 1) THEN

Line 859: CSI_gen_utility_pvt.put_line(

855: -- IF the debug level = 2 THEN dump all the parameters values.
856: IF (l_debug_level > 1) THEN
857:
858:
859: CSI_gen_utility_pvt.put_line(
860: p_api_version ||'-'||
861: p_commit ||'-'||
862: p_init_msg_list ||'-'||
863: p_validation_level

Line 867: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

863: p_validation_level
864: );
865:
866: -- dump the relationship query records
867: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
868: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);
869:
870: END IF;
871:

Line 868: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);

864: );
865:
866: -- dump the relationship query records
867: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
868: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);
869:
870: END IF;
871:
872: /***** srramakr commented for bug # 3304439

Line 874: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

870: END IF;
871:
872: /***** srramakr commented for bug # 3304439
873: -- check for the profile option AND enable trace
874: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
875: -- END enable trace
876: *****/
877:
878: csi_ii_relationships_pvt.expire_relationship(