DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on DBMS_UTILITY

Line 2099: l_start := DBMS_UTILITY.GET_TIME;

2095: IS
2096: l_start NUMBER;
2097: l_end NUMBER;
2098: BEGIN
2099: l_start := DBMS_UTILITY.GET_TIME;
2100: FND_OAM_DSCRAM_BUNDLES_PKG.EXECUTE_BUNDLE(p_run_id => p_run_id,
2101: p_bundle_id => p_bundle_id,
2102: px_worker_id => px_worker_id,
2103: x_return_status => x_return_status,

Line 2105: l_end := DBMS_UTILITY.GET_TIME;

2101: p_bundle_id => p_bundle_id,
2102: px_worker_id => px_worker_id,
2103: x_return_status => x_return_status,
2104: x_return_msg => x_return_msg);
2105: l_end := DBMS_UTILITY.GET_TIME;
2106: fnd_oam_debug.log(1, p_ctxt, 'Execute Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2107: fnd_oam_debug.log(1, p_ctxt, 'Return Status: '||x_return_status);
2108: fnd_oam_debug.log(1, p_ctxt, 'Return Msg: "'||x_return_msg||'"');
2109:

Line 2162: l_start := DBMS_UTILITY.GET_TIME;

2158: IF RUN_NEEDS_INIT(p_run_id,
2159: l_lock_handle) THEN
2160:
2161: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2162: l_start := DBMS_UTILITY.GET_TIME;
2163:
2164: IF NOT INIT_SINGLE_TASK(p_run_id,
2165: p_bundle_id,
2166: l_testnum,

Line 2173: l_end := DBMS_UTILITY.GET_TIME;

2169: RAISE INIT_FAILED;
2170: END IF;
2171:
2172: COMMIT;
2173: l_end := DBMS_UTILITY.GET_TIME;
2174: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2175: l_did_init := TRUE;
2176: END IF;
2177:

Line 2267: l_start := DBMS_UTILITY.GET_TIME;

2263: IF RUN_NEEDS_INIT(p_run_id,
2264: l_lock_handle) THEN
2265:
2266: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2267: l_start := DBMS_UTILITY.GET_TIME;
2268:
2269: --create a single run/bundle/task
2270: IF NOT INIT_SINGLE_DML_UNIT(p_run_id,
2271: p_bundle_id,

Line 2280: l_end := DBMS_UTILITY.GET_TIME;

2276: RAISE INIT_FAILED;
2277: END IF;
2278:
2279: COMMIT;
2280: l_end := DBMS_UTILITY.GET_TIME;
2281: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2282: l_did_init := TRUE;
2283: END IF;
2284:

Line 2401: l_start := DBMS_UTILITY.GET_TIME;

2397: IF RUN_NEEDS_INIT(p_run_id,
2398: l_lock_handle) THEN
2399:
2400: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2401: l_start := DBMS_UTILITY.GET_TIME;
2402:
2403: --create a single run/bundle/task
2404: IF NOT INIT_SINGLE_TASK(p_run_id,
2405: p_bundle_id,

Line 2560: l_end := DBMS_UTILITY.GET_TIME;

2556: RAISE INIT_FAILED;
2557: END IF;
2558:
2559: COMMIT;
2560: l_end := DBMS_UTILITY.GET_TIME;
2561: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2562: l_did_init := TRUE;
2563: END IF;
2564:

Line 2740: l_start := DBMS_UTILITY.GET_TIME;

2736: IF RUN_NEEDS_INIT(p_run_id,
2737: l_lock_handle) THEN
2738:
2739: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2740: l_start := DBMS_UTILITY.GET_TIME;
2741:
2742: --create a single run/bundle
2743: IF NOT MAKE_RUN(p_run_id,
2744: p_name => B_DIAG_RUN_NAME_PREFIX||l_testnum) THEN

Line 2778: l_end := DBMS_UTILITY.GET_TIME;

2774: k := k + 1;
2775: END LOOP;
2776:
2777: COMMIT;
2778: l_end := DBMS_UTILITY.GET_TIME;
2779: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2780: l_did_init := TRUE;
2781: END IF;
2782:

Line 2931: l_start := DBMS_UTILITY.GET_TIME;

2927: IF RUN_NEEDS_INIT(p_run_id,
2928: l_lock_handle) THEN
2929:
2930: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2931: l_start := DBMS_UTILITY.GET_TIME;
2932:
2933: --create a test table to work on
2934: IF NOT MAKE_TEST_TABLE(l_test_table_name,
2935: l_test_table_num_rows) THEN

Line 2987: l_end := DBMS_UTILITY.GET_TIME;

2983: RAISE INIT_FAILED;
2984: END IF;
2985:
2986: COMMIT;
2987: l_end := DBMS_UTILITY.GET_TIME;
2988: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2989: l_did_init := TRUE;
2990: END IF;
2991:

Line 3192: l_start := DBMS_UTILITY.GET_TIME;

3188: IF RUN_NEEDS_INIT(p_run_id,
3189: l_lock_handle) THEN
3190:
3191: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
3192: l_start := DBMS_UTILITY.GET_TIME;
3193:
3194: --create a test table to work on
3195: IF NOT MAKE_TEST_TABLE(l_test_table_name,
3196: l_test_table_num_rows) THEN

Line 3278: l_end := DBMS_UTILITY.GET_TIME;

3274: RAISE INIT_FAILED;
3275: END IF;
3276:
3277: COMMIT;
3278: l_end := DBMS_UTILITY.GET_TIME;
3279: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
3280: l_did_init := TRUE;
3281: END IF;
3282:

Line 3470: l_start := DBMS_UTILITY.GET_TIME;

3466: IF RUN_NEEDS_INIT(p_run_id,
3467: l_lock_handle) THEN
3468:
3469: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
3470: l_start := DBMS_UTILITY.GET_TIME;
3471:
3472: --create a test table to work on
3473: IF NOT MAKE_TEST_TABLE(l_test_table_name,
3474: l_test_table_num_rows) THEN

Line 3619: l_end := DBMS_UTILITY.GET_TIME;

3615: END IF;
3616:
3617:
3618: COMMIT;
3619: l_end := DBMS_UTILITY.GET_TIME;
3620: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
3621: l_did_init := TRUE;
3622: END IF;
3623:

Line 3969: l_start := DBMS_UTILITY.GET_TIME;

3965: IF RUN_NEEDS_INIT(p_run_id,
3966: l_lock_handle) THEN
3967:
3968: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
3969: l_start := DBMS_UTILITY.GET_TIME;
3970:
3971: --create a single run
3972: IF NOT MAKE_RUN(p_run_id,
3973: p_weight => 25,

Line 4285: l_end := DBMS_UTILITY.GET_TIME;

4281: RAISE INIT_FAILED;
4282: END IF;
4283:
4284: COMMIT;
4285: l_end := DBMS_UTILITY.GET_TIME;
4286: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
4287: l_did_init := TRUE;
4288: END IF;
4289:

Line 4563: l_start := DBMS_UTILITY.GET_TIME;

4559: IF RUN_NEEDS_INIT(p_run_id,
4560: l_lock_handle) THEN
4561:
4562: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
4563: l_start := DBMS_UTILITY.GET_TIME;
4564:
4565: --create a test table to work on
4566: IF NOT MAKE_TEST_TABLE(l_test_table_name,
4567: l_test_table_num_rows) THEN

Line 4787: l_end := DBMS_UTILITY.GET_TIME;

4783: RAISE INIT_FAILED;
4784: END IF;
4785:
4786: COMMIT;
4787: l_end := DBMS_UTILITY.GET_TIME;
4788: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
4789: l_did_init := TRUE;
4790: END IF;
4791:

Line 5086: l_start := DBMS_UTILITY.GET_TIME;

5082: IF RUN_NEEDS_INIT(p_run_id,
5083: l_lock_handle) THEN
5084:
5085: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
5086: l_start := DBMS_UTILITY.GET_TIME;
5087:
5088: --create a test table to work on
5089: IF NOT MAKE_TEST_TABLE(l_test_table_name,
5090: l_test_table_num_rows) THEN

Line 5509: l_end := DBMS_UTILITY.GET_TIME;

5505: RAISE INIT_FAILED;
5506: END IF;
5507:
5508: COMMIT;
5509: l_end := DBMS_UTILITY.GET_TIME;
5510: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
5511: l_did_init := TRUE;
5512: END IF;
5513:

Line 5597: l_start := DBMS_UTILITY.GET_TIME;

5593: l_end NUMBER;
5594: l_verdict VARCHAR2(6);
5595: BEGIN
5596: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
5597: l_start := DBMS_UTILITY.GET_TIME;
5598:
5599: EXECUTE_TEST1(l_run_id,
5600: l_bundle_id,
5601: p_num_bundles,

Line 5756: l_end := DBMS_UTILITY.GET_TIME;

5752: RETURN;
5753: END IF;
5754: END IF;
5755:
5756: l_end := DBMS_UTILITY.GET_TIME;
5757: fnd_oam_debug.log(1, l_ctxt, 'Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
5758:
5759: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5760: x_verdict := l_verdict;