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(
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;
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
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.
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.
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
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.
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
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.
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
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:
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
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.
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: --
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(