eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_RULE_MIGRATE dependencies on FND_CONC_GLOBAL

Line 410: IF (FND_CONC_GLOBAL.request_data is null) THEN

406: IF P_LEVEL = 'HDR' THEN
407: -------------------------------------------------------------------------------------------
408: -- Code to validate the Header rule. --
409: -------------------------------------------------------------------------------------------
410: IF (FND_CONC_GLOBAL.request_data is null) THEN
411:
412: trunc_curs := DBMS_SQL.OPEN_CURSOR;
413: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
414: rc := dbms_sql.execute(trunc_curs);

Line 487: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',

483: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request '||to_char(l_ret)||' submitted');
484: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request '||to_char(l_ret)||' p_low_id ==> '|| range_arr(idx).lo || ' l_hig_id ==> '||range_arr(idx).hi );
485: END IF;
486: END LOOP;
487: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',
488: request_data => to_char(l_sub_requests));
489: errbuf := to_char(l_sub_requests) || ' sub-requests submitted';
490: retcode := 0;
491: return;

Line 500: IF (FND_CONC_GLOBAL.request_data is null) THEN

496: ELSIF P_LEVEL = 'HDRH' THEN
497: -------------------------------------------------------------------------------------------
498: -- Code to validate the Header History rule. --
499: -------------------------------------------------------------------------------------------
500: IF (FND_CONC_GLOBAL.request_data is null) THEN
501:
502: trunc_curs := DBMS_SQL.OPEN_CURSOR;
503: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
504: rc := dbms_sql.execute(trunc_curs);

Line 572: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',

568: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request '||to_char(l_ret)||' submitted');
569: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request '||to_char(l_ret)||' p_low_id ==> '|| range_arr(idx).lo || ' l_hig_id ==> '||range_arr(idx).hi );
570: END IF;
571: END LOOP;
572: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',
573: request_data => to_char(l_sub_requests));
574: errbuf := to_char(l_sub_requests) || ' sub-requests submitted';
575: retcode := 0;
576: return;

Line 589: IF (FND_CONC_GLOBAL.request_data is null) THEN

585: ELSIF P_LEVEL = 'LINE' THEN
586: -------------------------------------------------------------------------------------------
587: -- Code to validate the Line rule. --
588: -------------------------------------------------------------------------------------------
589: IF (FND_CONC_GLOBAL.request_data is null) THEN
590:
591: trunc_curs := DBMS_SQL.OPEN_CURSOR;
592: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
593: rc := dbms_sql.execute(trunc_curs);

Line 661: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',

657: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request '||to_char(l_ret)||' submitted');
658: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request '||to_char(l_ret)||' p_low_id ==> '|| range_arr(idx).lo || ' l_hig_id ==> '||range_arr(idx).hi );
659: END IF;
660: END LOOP;
661: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',
662: request_data => to_char(l_sub_requests));
663: errbuf := to_char(l_sub_requests) || ' sub-requests submitted';
664: retcode := 0;
665: return;

Line 674: IF (FND_CONC_GLOBAL.request_data is null) THEN

670: ELSIF P_LEVEL = 'LINEH' THEN
671: -------------------------------------------------------------------------------------------
672: -- Code to validate the Line History rule. --
673: -------------------------------------------------------------------------------------------
674: IF (FND_CONC_GLOBAL.request_data is null) THEN
675:
676: trunc_curs := DBMS_SQL.OPEN_CURSOR;
677: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
678: rc := dbms_sql.execute(trunc_curs);

Line 747: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',

743: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request '||to_char(l_ret)||' submitted');
744: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request '||to_char(l_ret)||' p_low_id ==> '|| range_arr(idx).lo || ' l_hig_id ==> '||range_arr(idx).hi );
745: END IF;
746: END LOOP;
747: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',
748: request_data => to_char(l_sub_requests));
749: errbuf := to_char(l_sub_requests) || ' sub-requests submitted';
750: retcode := 0;
751: return;

Line 761: IF (FND_CONC_GLOBAL.request_data is null) THEN

757: ELSIF P_LEVEL = 'ALL' THEN
758: -------------------------------------------------------------------------------------------
759: -- Code to validate the ALL rules. --
760: -------------------------------------------------------------------------------------------
761: IF (FND_CONC_GLOBAL.request_data is null) THEN
762:
763: trunc_curs := DBMS_SQL.OPEN_CURSOR;
764: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
765: rc := dbms_sql.execute(trunc_curs);

Line 885: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',

881: END IF;
882: END LOOP;
883:
884:
885: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',
886: request_data => to_char(l_sub_requests));
887: errbuf := to_char(l_sub_requests) || ' sub-requests submitted';
888: retcode := 0;
889: return;

Line 39000: IF (FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN

38996:
38997: -------------------------------------------------------------------------------------
38998: -- Code for Synchronization phase --
38999: -------------------------------------------------------------------------------------
39000: IF (FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN
39001: trunc_curs := DBMS_SQL.OPEN_CURSOR;
39002: DBMS_SQL.PARSE(trunc_curs,l_truncate_string,dbms_sql.native);
39003: rc := dbms_sql.execute(trunc_curs);
39004: DBMS_SQL.CLOSE_CURSOR(trunc_curs);

Line 39046: FND_CONC_GLOBAL.SET_REQ_GLOBALS(CONC_STATUS => 'PAUSED',

39042: END IF;
39043: END LOOP;
39044: CLOSE L_UPGRD_CSR;
39045: IF( I > 0) THEN
39046: FND_CONC_GLOBAL.SET_REQ_GLOBALS(CONC_STATUS => 'PAUSED',
39047: REQUEST_DATA => TO_CHAR(IP_SUB_REQUESTS));
39048: ERRBUF := TO_CHAR(I) || ' SUB-REQUESTS SUBMITTED';
39049: RETCODE := 0;
39050: RETURN;

Line 39052: ELSIF ((FND_CONC_GLOBAL.REQUEST_DATA IS NOT NULL) AND (FND_CONC_GLOBAL.REQUEST_DATA <> 'REPROCESS' )) THEN

39048: ERRBUF := TO_CHAR(I) || ' SUB-REQUESTS SUBMITTED';
39049: RETCODE := 0;
39050: RETURN;
39051: END IF;
39052: ELSIF ((FND_CONC_GLOBAL.REQUEST_DATA IS NOT NULL) AND (FND_CONC_GLOBAL.REQUEST_DATA <> 'REPROCESS' )) THEN
39053: COMMIT;
39054: RETCODE := 0;
39055: END IF;
39056: -------------------------------------------------------------------------------------

Line 39059: IF (FND_CONC_GLOBAL.REQUEST_DATA not in ('REPROCESS') OR FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN

39055: END IF;
39056: -------------------------------------------------------------------------------------
39057: -- Code for Reprocessing phase --
39058: -------------------------------------------------------------------------------------
39059: IF (FND_CONC_GLOBAL.REQUEST_DATA not in ('REPROCESS') OR FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN
39060:
39061: OPEN L_REPROCESS_CNT_CSR;
39062: FETCH L_REPROCESS_CNT_CSR INTO L_REPROC_CNT;
39063: CLOSE L_REPROCESS_CNT_CSR;

Line 39102: FND_CONC_GLOBAL.SET_REQ_GLOBALS(CONC_STATUS => 'PAUSED',

39098: END LOOP;
39099:
39100: CLOSE L_REPROC_CSR;
39101: IF( I > 0) THEN
39102: FND_CONC_GLOBAL.SET_REQ_GLOBALS(CONC_STATUS => 'PAUSED',
39103: REQUEST_DATA => 'REPROCESS' );
39104: ERRBUF := TO_CHAR(I) || ' SUB-REQUESTS SUBMITTED';
39105: RETCODE := 0;
39106: RETURN;

Line 39108: ELSIF ((FND_CONC_GLOBAL.REQUEST_DATA IS NOT NULL)) THEN

39104: ERRBUF := TO_CHAR(I) || ' SUB-REQUESTS SUBMITTED';
39105: RETCODE := 0;
39106: RETURN;
39107: END IF;
39108: ELSIF ((FND_CONC_GLOBAL.REQUEST_DATA IS NOT NULL)) THEN
39109: COMMIT;
39110: RETCODE := 0;
39111: -- RETURN;
39112: END IF;

Line 39117: IF (FND_CONC_GLOBAL.REQUEST_DATA <> 'CREDITCARD' OR FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN

39113: /* Commenting out the code as request ...Need to check with Hari if this code is required
39114: -------------------------------------------------------------------------------------
39115: -- Code for processing credit card records --
39116: -------------------------------------------------------------------------------------
39117: IF (FND_CONC_GLOBAL.REQUEST_DATA <> 'CREDITCARD' OR FND_CONC_GLOBAL.REQUEST_DATA IS NULL) THEN
39118:
39119: l_ret := FND_REQUEST.submit_request('OKS',
39120: 'OKSMIGCC',
39121: null, -- UI job display

Line 39136: FND_CONC_GLOBAL.SET_REQ_GLOBALS(CONC_STATUS => 'PAUSED',

39132: ELSE
39133: FND_FILE.PUT_LINE (FND_FILE.LOG, 'SUB-REQUEST '||TO_CHAR(L_RET)||' SUBMITTED');
39134: FND_FILE.PUT_LINE (FND_FILE.LOG, 'SUB-REQUEST '||TO_CHAR(L_RET)||' LOW_ID ==>'||START_ID||' HIG_ID ==>'||END_ID);
39135:
39136: FND_CONC_GLOBAL.SET_REQ_GLOBALS(CONC_STATUS => 'PAUSED',
39137: REQUEST_DATA => 'CREDITCARD' );
39138: ERRBUF := TO_CHAR(I) || ' SUB-REQUESTS SUBMITTED';
39139: RETCODE := 0;
39140: RETURN;

Line 39142: ELSIF ((FND_CONC_GLOBAL.REQUEST_DATA IS NOT NULL)) THEN

39138: ERRBUF := TO_CHAR(I) || ' SUB-REQUESTS SUBMITTED';
39139: RETCODE := 0;
39140: RETURN;
39141: END IF;
39142: ELSIF ((FND_CONC_GLOBAL.REQUEST_DATA IS NOT NULL)) THEN
39143: COMMIT;
39144: RETCODE := 0;
39145: RETURN;
39146: