APPS.QP_BULK_VALIDATE dependencies on DBMS_SESSION

Line 337: dbms_session.set_sql_trace(TRUE);

333: nvl_check2 VARCHAR2(10);
334: -- Bug 5092813 END RAVI
335:
336: BEGIN
337: dbms_session.set_sql_trace(TRUE);
338: qp_bulk_loader_pub.write_log('Entering Duplicate Line Check');
339: BEGIN
340: FOR i_mode IN 1..2
341: LOOP

Line 653: dbms_session.set_sql_trace(FALSE);

649: EXCEPTION
650: WHEN NO_DATA_FOUND THEN--no duplicate line for this line
651: Null;
652: END;
653: dbms_session.set_sql_trace(FALSE);
654: qp_bulk_loader_pub.write_log('Leaving Duplicate line check');
655:
656: EXCEPTION
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN