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 DBMS_SESSION

Line 30: dbms_session.set_sql_trace(true);

26:
27: /**** Commented for Bug 3304439
28: -- Check for the profile option and disable the trace
29: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
30: dbms_session.set_sql_trace(true);
31: END IF;
32: ****/
33:
34: l_found := csi_t_txn_details_pvt.check_txn_details_exist(

Line 40: dbms_session.set_sql_trace(false);

36:
37: /**** Commented for Bug 3304439
38: -- Check for the profile option and disable the trace
39: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
40: dbms_session.set_sql_trace(false);
41: END IF;
42: ****/
43:
44: csi_t_gen_utility_pvt.set_debug_off;

Line 165: dbms_session.set_sql_trace(TRUE);

161:
162: /**** Commented for Bug 3304439
163: -- Check for the profile option and enable trace
164: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
165: dbms_session.set_sql_trace(TRUE);
166: END IF;
167: ****/
168:
169: -- Main API code

Line 377: dbms_session.set_sql_trace(false);

373: /**** Commented for Bug 3304439
374: -- Check for the profile option and disable the trace
375: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y')
376: THEN
377: dbms_session.set_sql_trace(false);
378: END IF;
379: ****/
380:
381: -- Standard call to get message count and if count is get message info.

Line 430: dbms_session.set_sql_trace(false);

426:
427: /**** Commented for Bug 3304439
428: -- Check for the profile option and disable the trace
429: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
430: dbms_session.set_sql_trace(false);
431: END IF;
432: ****/
433:
434: -- Standard call to get message count and if count is get message info.

Line 551: dbms_session.set_sql_trace(TRUE);

547:
548: /**** Commented for Bug 3304439
549: -- Check for the profile option and enable trace
550: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
551: dbms_session.set_sql_trace(TRUE);
552: END IF;
553: ****/
554:
555: -- main code starts here

Line 635: dbms_session.set_sql_trace(false);

631:
632: /**** Commented for Bug 3304439
633: -- Check for the profile option and disable the trace
634: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
635: dbms_session.set_sql_trace(false);
636: END IF;
637: ****/
638:
639: -- Standard call to get message count and if count is get message info.

Line 758: dbms_session.set_sql_trace(TRUE);

754:
755: /**** Commented for Bug 3304439
756: -- Check for the profile option and enable trace
757: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
758: dbms_session.set_sql_trace(TRUE);
759: END IF;
760: ****/
761:
762: -- Main API code

Line 811: dbms_session.set_sql_trace(false);

807:
808: /**** Commented for Bug 3304439
809: -- Check for the profile option and disable the trace
810: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
811: dbms_session.set_sql_trace(false);
812: END IF;
813: ****/
814:
815: -- Standard call to get message count and if count is get message info.

Line 939: dbms_session.set_sql_trace(TRUE);

935:
936: /**** Commented for Bug 3304439
937: -- Check for the profile option and enable trace
938: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
939: dbms_session.set_sql_trace(TRUE);
940: END IF;
941: ****/
942:
943: -- Main API code

Line 995: dbms_session.set_sql_trace(false);

991:
992: /**** Commented for Bug 3304439
993: -- Check for the profile option and disable the trace
994: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
995: dbms_session.set_sql_trace(false);
996: END IF;
997: ****/
998:
999:

Line 1114: dbms_session.set_sql_trace(TRUE);

1110:
1111: /**** Commented for Bug 3304439
1112: -- Check for the profile option and enable trace
1113: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
1114: dbms_session.set_sql_trace(TRUE);
1115: END IF;
1116: ****/
1117:
1118: -- Main API code

Line 1156: dbms_session.set_sql_trace(false);

1152:
1153: /**** Commented for Bug 3304439
1154: -- Check for the profile option and disable the trace
1155: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
1156: dbms_session.set_sql_trace(false);
1157: END IF;
1158: ****/
1159:
1160: -- Standard call to get message count and if count is get message info.

Line 1434: dbms_session.set_sql_trace(TRUE);

1430: END IF;
1431:
1432: -- Check for the profile option and enable trace
1433: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
1434: dbms_session.set_sql_trace(TRUE);
1435: END IF;
1436:
1437: -- Main API code
1438: --

Line 1474: dbms_session.set_sql_trace(false);

1470: END IF;
1471:
1472: -- Check for the profile option and disable the trace
1473: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
1474: dbms_session.set_sql_trace(false);
1475: END IF;
1476:
1477: -- Standard call to get message count and if count is get message info.
1478: FND_MSG_PUB.Count_And_Get(