APPS.IEX_STRATEGY_CNT_PUB dependencies on DBMS_SESSION

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

330: l_ignore_switch := NVL(p_ignore_switch, 'N');
331: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
332:
333:
334: -- dbms_session.set_sql_trace(true);
335: -- Initialize API return status to SUCCESS
336: l_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: /* Check the required profiles for Strategy Concurrent before starting */

Line 2512: dbms_session.set_sql_trace(TRUE);

2508: -- IF p_trace_mode = 'Y' THEN
2509: fnd_file.put_line(FND_FILE.LOG,'Value of profile IEX: Debug Level is : '|| PG_DEBUG);
2510: IF PG_DEBUG = 1 THEN
2511: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
2512: dbms_session.set_sql_trace(TRUE);
2513: ELSE
2514: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
2515: dbms_session.set_sql_trace(FALSE);
2516: END IF;

Line 2515: dbms_session.set_sql_trace(FALSE);

2511: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
2512: dbms_session.set_sql_trace(TRUE);
2513: ELSE
2514: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
2515: dbms_session.set_sql_trace(FALSE);
2516: END IF;
2517: --Bug# 6870773 Naveen
2518: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
2519: -- l_org_id := fnd_profile.value('ORG_ID');