APPS.IEX_STRATEGY_CNT_PUB dependencies on DBMS_SESSION

Line 171: -- dbms_session.set_sql_trace(true);

167: l_ignore_switch := NVL(p_ignore_switch, 'N');
168: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
169:
170:
171: -- dbms_session.set_sql_trace(true);
172: -- Initialize API return status to SUCCESS
173: l_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: /* Check the required profiles for Strategy Concurrent before starting */

Line 1622: dbms_session.set_sql_trace(TRUE);

1618: -- IF p_trace_mode = 'Y' THEN
1619: fnd_file.put_line(FND_FILE.LOG,'Value of profile IEX: Debug Level is : '|| PG_DEBUG);
1620: IF PG_DEBUG = 1 THEN
1621: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
1622: dbms_session.set_sql_trace(TRUE);
1623: ELSE
1624: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
1625: dbms_session.set_sql_trace(FALSE);
1626: END IF;

Line 1625: dbms_session.set_sql_trace(FALSE);

1621: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
1622: dbms_session.set_sql_trace(TRUE);
1623: ELSE
1624: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
1625: dbms_session.set_sql_trace(FALSE);
1626: END IF;
1627: --Bug# 6870773 Naveen
1628: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
1629: -- l_org_id := fnd_profile.value('ORG_ID');