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

Line 72: CSI_gen_utility_pvt.put_line( 'get_systems');

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

Line 77: CSI_gen_utility_pvt.put_line(

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

Line 85: csi_gen_utility_pvt.dump_sys_query_rec(p_system_query_rec);

81: p_validation_level ||'-'||
82: p_time_stamp );
83:
84: -- dump the system query records
85: csi_gen_utility_pvt.dump_sys_query_rec(p_system_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 224: CSI_gen_utility_pvt.put_line( 'create_system');

220:
221: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
222: -- if debug_level = 1 then dump the procedure name
223: IF (l_debug_level > 0) THEN
224: CSI_gen_utility_pvt.put_line( 'create_system');
225: END IF;
226:
227: -- if the debug level = 2 then dump all the parameters values.
228: IF (l_debug_level > 1) THEN

Line 231: CSI_gen_utility_pvt.put_line(

227: -- if the debug level = 2 then dump all the parameters values.
228: IF (l_debug_level > 1) THEN
229:
230:
231: CSI_gen_utility_pvt.put_line(
232: p_api_version ||'-'||
233: p_commit ||'-'||
234: p_init_msg_list ||'-'||
235: p_validation_level );

Line 238: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);

234: p_init_msg_list ||'-'||
235: p_validation_level );
236:
237: -- dump the systems query records
238: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
239: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
240:
241: END IF;
242:

Line 239: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

235: p_validation_level );
236:
237: -- dump the systems query records
238: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
239: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
240:
241: END IF;
242:
243: /***** srramakr commented for bug # 3304439

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

241: END IF;
242:
243: /***** srramakr commented for bug # 3304439
244: -- check for the profile option and enable trace
245: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
246: -- END enable trace
247: ****/
248:
249: -- calling private package: create_system

Line 430: CSI_gen_utility_pvt.put_line( 'update_system');

426:
427: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
428: -- if debug_level = 1 then dump the procedure name
429: IF (l_debug_level > 0) THEN
430: CSI_gen_utility_pvt.put_line( 'update_system');
431: END IF;
432:
433: -- if the debug level = 2 then dump all the parameters values.
434: IF (l_debug_level > 1) THEN

Line 437: CSI_gen_utility_pvt.put_line(

433: -- if the debug level = 2 then dump all the parameters values.
434: IF (l_debug_level > 1) THEN
435:
436:
437: CSI_gen_utility_pvt.put_line(
438: p_api_version ||'-'||
439: p_commit ||'-'||
440: p_init_msg_list ||'-'||
441: p_validation_level );

Line 444: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);

440: p_init_msg_list ||'-'||
441: p_validation_level );
442:
443: -- dump the systems query records
444: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
445: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
446:
447: END IF;
448:

Line 445: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

441: p_validation_level );
442:
443: -- dump the systems query records
444: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
445: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
446:
447: END IF;
448:
449: /***** srramakr commented for bug # 3304439

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

447: END IF;
448:
449: /***** srramakr commented for bug # 3304439
450: -- check for the profile option and enable trace
451: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
452: -- END enable trace
453: ****/
454:
455: csi_systems_pvt.update_system(

Line 627: csi_gen_utility_pvt.put_line('Updating Child System ID - ' || l_child_system_rec.system_id);

623: l_child_system_rec.SHIP_TO_SITE_CHANGE_FLAG := FND_API.G_MISS_CHAR;
624: l_child_system_rec.INSTALL_TO_SITE_CHANGE_FLAG := FND_API.G_MISS_CHAR;
625: l_child_system_rec.CASCADE_CUST_TO_INS_FLAG := FND_API.G_MISS_CHAR;
626:
627: csi_gen_utility_pvt.put_line('Updating Child System ID - ' || l_child_system_rec.system_id);
628: csi_gen_utility_pvt.put_line('Corresponding Parent System ID - ' || l_child_system_rec.parent_system_id);
629:
630: csi_systems_pvt.update_system(
631: p_api_version => p_api_version,

Line 628: csi_gen_utility_pvt.put_line('Corresponding Parent System ID - ' || l_child_system_rec.parent_system_id);

624: l_child_system_rec.INSTALL_TO_SITE_CHANGE_FLAG := FND_API.G_MISS_CHAR;
625: l_child_system_rec.CASCADE_CUST_TO_INS_FLAG := FND_API.G_MISS_CHAR;
626:
627: csi_gen_utility_pvt.put_line('Updating Child System ID - ' || l_child_system_rec.system_id);
628: csi_gen_utility_pvt.put_line('Corresponding Parent System ID - ' || l_child_system_rec.parent_system_id);
629:
630: csi_systems_pvt.update_system(
631: p_api_version => p_api_version,
632: p_commit => fnd_api.g_false,

Line 644: csi_gen_utility_pvt.put_line( 'Into Others Exception in Cascade to Child Systems');

640: );
641:
642: EXCEPTION
643: WHEN OTHERS THEN
644: csi_gen_utility_pvt.put_line( 'Into Others Exception in Cascade to Child Systems');
645: csi_gen_utility_pvt.put_line( 'SQLCODE - ' || SQLCODE);
646: csi_gen_utility_pvt.put_line( 'SQLERRM - ' || substr(SQLERRM, 1, 200));
647: END;
648: END LOOP; -- child_system_rec in CHILD_SYSTEM_CUR(p_system_rec.system_id)

Line 645: csi_gen_utility_pvt.put_line( 'SQLCODE - ' || SQLCODE);

641:
642: EXCEPTION
643: WHEN OTHERS THEN
644: csi_gen_utility_pvt.put_line( 'Into Others Exception in Cascade to Child Systems');
645: csi_gen_utility_pvt.put_line( 'SQLCODE - ' || SQLCODE);
646: csi_gen_utility_pvt.put_line( 'SQLERRM - ' || substr(SQLERRM, 1, 200));
647: END;
648: END LOOP; -- child_system_rec in CHILD_SYSTEM_CUR(p_system_rec.system_id)
649:

Line 646: csi_gen_utility_pvt.put_line( 'SQLERRM - ' || substr(SQLERRM, 1, 200));

642: EXCEPTION
643: WHEN OTHERS THEN
644: csi_gen_utility_pvt.put_line( 'Into Others Exception in Cascade to Child Systems');
645: csi_gen_utility_pvt.put_line( 'SQLCODE - ' || SQLCODE);
646: csi_gen_utility_pvt.put_line( 'SQLERRM - ' || substr(SQLERRM, 1, 200));
647: END;
648: END LOOP; -- child_system_rec in CHILD_SYSTEM_CUR(p_system_rec.system_id)
649:
650: END IF; -- NVL(p_system_rec.CASCADE_CUST_TO_INS_FLAG,'N') = 'Y'

Line 758: CSI_gen_utility_pvt.put_line( 'update_system');

754:
755: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
756: -- if debug_level = 1 then dump the procedure name
757: IF (l_debug_level > 0) THEN
758: CSI_gen_utility_pvt.put_line( 'update_system');
759: END IF;
760:
761: -- if the debug level = 2 then dump all the parameters values.
762: IF (l_debug_level > 1) THEN

Line 765: CSI_gen_utility_pvt.put_line(

761: -- if the debug level = 2 then dump all the parameters values.
762: IF (l_debug_level > 1) THEN
763:
764:
765: CSI_gen_utility_pvt.put_line(
766: p_api_version ||'-'||
767: p_commit ||'-'||
768: p_init_msg_list ||'-'||
769: p_validation_level

Line 773: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);

769: p_validation_level
770: );
771:
772: -- dump the systems query records
773: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
774: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
775:
776:
777: END IF;

Line 774: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

770: );
771:
772: -- dump the systems query records
773: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
774: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
775:
776:
777: END IF;
778:

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

777: END IF;
778:
779: /***** srramakr commented for bug # 3304439
780: -- check for the profile option and enable trace
781: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
782: -- end enable trace
783: ****/
784:
785: csi_systems_pvt.expire_system(