APPS.CSI_T_TXN_DETAILS_GRP dependencies on FND_PROFILE

Line 29: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

25: BEGIN
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:

Line 39: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

35: p_txn_line_rec => p_txn_line_rec);
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:

Line 164: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

160: END IF;
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:

Line 375: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y')

371: END IF;
372:
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: ****/

Line 429: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

425: END IF;
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:

Line 550: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

546: END IF;
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:

Line 634: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

630: END IF;
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:

Line 757: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

753: END IF;
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:

Line 810: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

806: END IF;
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:

Line 938: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

934: END IF;
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:

Line 994: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

990: END IF;
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:

Line 1113: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

1109: END IF;
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:

Line 1155: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

1151: END IF;
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:

Line 1433: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

1429:
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

Line 1473: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

1469: COMMIT WORK;
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.