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.WMS_UT_PKG dependencies on WMS_UT_PKG

Line 1: PACKAGE BODY wms_ut_pkg AS

1: PACKAGE BODY wms_ut_pkg AS
2: /* $Header: WMSUTTSB.pls 120.6.12010000.3 2008/09/19 09:48:16 haluthra ship $ */
3:
4:
5: TYPE demandinfo_rec_type IS RECORD

Line 2797: ||' l_data wms_ut_pkg.dblarrchartabtype150;'

2793: ||' '
2794: ||' l_test_id NUMBER;'
2795: ||' l_indx NUMBER;'
2796: ||' l_ctr VARCHAR2(10);'
2797: ||' l_data wms_ut_pkg.dblarrchartabtype150;'
2798: ||' l_data_clear wms_ut_pkg.dblarrchartabtype150;'
2799: ||' l_text wms_ut_pkg.arrchartabtype150;'
2800: ||' l_text_clear wms_ut_pkg.arrchartabtype150;'
2801: ||' l_file_name VARCHAR2(80);'

Line 2798: ||' l_data_clear wms_ut_pkg.dblarrchartabtype150;'

2794: ||' l_test_id NUMBER;'
2795: ||' l_indx NUMBER;'
2796: ||' l_ctr VARCHAR2(10);'
2797: ||' l_data wms_ut_pkg.dblarrchartabtype150;'
2798: ||' l_data_clear wms_ut_pkg.dblarrchartabtype150;'
2799: ||' l_text wms_ut_pkg.arrchartabtype150;'
2800: ||' l_text_clear wms_ut_pkg.arrchartabtype150;'
2801: ||' l_file_name VARCHAR2(80);'
2802: ||' l_path VARCHAR2(80);'

Line 2799: ||' l_text wms_ut_pkg.arrchartabtype150;'

2795: ||' l_indx NUMBER;'
2796: ||' l_ctr VARCHAR2(10);'
2797: ||' l_data wms_ut_pkg.dblarrchartabtype150;'
2798: ||' l_data_clear wms_ut_pkg.dblarrchartabtype150;'
2799: ||' l_text wms_ut_pkg.arrchartabtype150;'
2800: ||' l_text_clear wms_ut_pkg.arrchartabtype150;'
2801: ||' l_file_name VARCHAR2(80);'
2802: ||' l_path VARCHAR2(80);'
2803: ||' l_flag boolean;'

Line 2800: ||' l_text_clear wms_ut_pkg.arrchartabtype150;'

2796: ||' l_ctr VARCHAR2(10);'
2797: ||' l_data wms_ut_pkg.dblarrchartabtype150;'
2798: ||' l_data_clear wms_ut_pkg.dblarrchartabtype150;'
2799: ||' l_text wms_ut_pkg.arrchartabtype150;'
2800: ||' l_text_clear wms_ut_pkg.arrchartabtype150;'
2801: ||' l_file_name VARCHAR2(80);'
2802: ||' l_path VARCHAR2(80);'
2803: ||' l_flag boolean;'
2804: ||' l_batch_name VARCHAR2(20);'

Line 2829: ||' wms_ut_pkg.initialize;'

2825: ||' AND upper(IN_OUT) <> ''OUT'';'
2826: ||' '
2827: ||' BEGIN'
2828: ||' '
2829: ||' wms_ut_pkg.initialize;'
2830: ||' '
2831: ||' FOR l_test_rec in c_get_testids LOOP'
2832: ||' '
2833: ||' l_batch_name := RTRIM(LTRIM(l_test_rec.testname));'

Line 2842: ||' wms_ut_pkg.print_debug(''Done setting up logging''); '

2838: ||' l_path := ''/appslog/dist_top/utl/wmsdv11i/log/'';'
2839: ||' commit;'
2840: ||' l_flag :=FND_PROFILE.SAVE(''INV_DEBUG_FILE'', l_path||l_file_name, ''USER'', p_user_id);'
2841: ||' fnd_global.apps_initialize(p_user_id,21676, 385);'
2842: ||' wms_ut_pkg.print_debug(''Done setting up logging''); '
2843: ||' '
2844: ||' l_data := l_data_clear;'
2845: ||' l_test_id := l_test_rec.test_id;'
2846: ||' g_test_id := l_test_id;'

Line 2849: ||' wms_ut_pkg.print_debug(''Setting datatype : '' || l_dtypes.datatype);'

2845: ||' l_test_id := l_test_rec.test_id;'
2846: ||' g_test_id := l_test_id;'
2847: ||' FOR l_dtypes in c_get_testdtypes(l_test_id) LOOP'
2848: ||' l_indx := 0;'
2849: ||' wms_ut_pkg.print_debug(''Setting datatype : '' || l_dtypes.datatype);'
2850: ||' l_text := l_text_clear;'
2851: ||' FOR l_t in c_get_testtext(l_test_id, l_dtypes.datatype) LOOP '
2852: ||' wms_ut_pkg.print_debug(''Setting text : '' || l_t.text); '
2853: ||' l_indx := l_indx + 1; '

Line 2852: ||' wms_ut_pkg.print_debug(''Setting text : '' || l_t.text); '

2848: ||' l_indx := 0;'
2849: ||' wms_ut_pkg.print_debug(''Setting datatype : '' || l_dtypes.datatype);'
2850: ||' l_text := l_text_clear;'
2851: ||' FOR l_t in c_get_testtext(l_test_id, l_dtypes.datatype) LOOP '
2852: ||' wms_ut_pkg.print_debug(''Setting text : '' || l_t.text); '
2853: ||' l_indx := l_indx + 1; '
2854: ||' l_text(l_indx) := wms_ut_pkg.parse_text(l_t.text, '',''); '
2855: ||' END LOOP;'
2856: ||' l_indx := wms_ut_pkg.get_datatype_id(l_dtypes.datatype); '

Line 2854: ||' l_text(l_indx) := wms_ut_pkg.parse_text(l_t.text, '',''); '

2850: ||' l_text := l_text_clear;'
2851: ||' FOR l_t in c_get_testtext(l_test_id, l_dtypes.datatype) LOOP '
2852: ||' wms_ut_pkg.print_debug(''Setting text : '' || l_t.text); '
2853: ||' l_indx := l_indx + 1; '
2854: ||' l_text(l_indx) := wms_ut_pkg.parse_text(l_t.text, '',''); '
2855: ||' END LOOP;'
2856: ||' l_indx := wms_ut_pkg.get_datatype_id(l_dtypes.datatype); '
2857: ||' l_data(l_indx) := l_text;'
2858: ||' END LOOP;'

Line 2856: ||' l_indx := wms_ut_pkg.get_datatype_id(l_dtypes.datatype); '

2852: ||' wms_ut_pkg.print_debug(''Setting text : '' || l_t.text); '
2853: ||' l_indx := l_indx + 1; '
2854: ||' l_text(l_indx) := wms_ut_pkg.parse_text(l_t.text, '',''); '
2855: ||' END LOOP;'
2856: ||' l_indx := wms_ut_pkg.get_datatype_id(l_dtypes.datatype); '
2857: ||' l_data(l_indx) := l_text;'
2858: ||' END LOOP;'
2859: ||' '
2860: ||' l_org_code := wms_ut_pkg.get_value(l_data, ''ORG'');'

Line 2860: ||' l_org_code := wms_ut_pkg.get_value(l_data, ''ORG'');'

2856: ||' l_indx := wms_ut_pkg.get_datatype_id(l_dtypes.datatype); '
2857: ||' l_data(l_indx) := l_text;'
2858: ||' END LOOP;'
2859: ||' '
2860: ||' l_org_code := wms_ut_pkg.get_value(l_data, ''ORG'');'
2861: ||' select organization_id'
2862: ||' into l_org_id'
2863: ||' from mtl_parameters'
2864: ||' where organization_code = l_org_code;'

Line 2867: ||' wms_ut_pkg.gather_and_setup(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id, l_test_id);'

2863: ||' from mtl_parameters'
2864: ||' where organization_code = l_org_code;'
2865: ||' '
2866: ||' g_testname := l_test_rec.testname;'
2867: ||' wms_ut_pkg.gather_and_setup(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id, l_test_id);'
2868: ||' '
2869: ||' wms_ut_pkg.g_start_time := SYSDATE; '
2870: ||' wms_ut_pkg.execute_ut_test_flow(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id,l_test_id);'
2871: ||' wms_ut_pkg.g_end_time := SYSDATE; '

Line 2869: ||' wms_ut_pkg.g_start_time := SYSDATE; '

2865: ||' '
2866: ||' g_testname := l_test_rec.testname;'
2867: ||' wms_ut_pkg.gather_and_setup(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id, l_test_id);'
2868: ||' '
2869: ||' wms_ut_pkg.g_start_time := SYSDATE; '
2870: ||' wms_ut_pkg.execute_ut_test_flow(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id,l_test_id);'
2871: ||' wms_ut_pkg.g_end_time := SYSDATE; '
2872: ||' wms_ut_pkg.write_ut_test_output(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, l_test_rec.testset_id, l_test_id, p_run_id, l_file_name, l_path); '
2873: ||' commit;'

Line 2870: ||' wms_ut_pkg.execute_ut_test_flow(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id,l_test_id);'

2866: ||' g_testname := l_test_rec.testname;'
2867: ||' wms_ut_pkg.gather_and_setup(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id, l_test_id);'
2868: ||' '
2869: ||' wms_ut_pkg.g_start_time := SYSDATE; '
2870: ||' wms_ut_pkg.execute_ut_test_flow(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id,l_test_id);'
2871: ||' wms_ut_pkg.g_end_time := SYSDATE; '
2872: ||' wms_ut_pkg.write_ut_test_output(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, l_test_rec.testset_id, l_test_id, p_run_id, l_file_name, l_path); '
2873: ||' commit;'
2874: ||' END LOOP;'

Line 2871: ||' wms_ut_pkg.g_end_time := SYSDATE; '

2867: ||' wms_ut_pkg.gather_and_setup(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id, l_test_id);'
2868: ||' '
2869: ||' wms_ut_pkg.g_start_time := SYSDATE; '
2870: ||' wms_ut_pkg.execute_ut_test_flow(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id,l_test_id);'
2871: ||' wms_ut_pkg.g_end_time := SYSDATE; '
2872: ||' wms_ut_pkg.write_ut_test_output(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, l_test_rec.testset_id, l_test_id, p_run_id, l_file_name, l_path); '
2873: ||' commit;'
2874: ||' END LOOP;'
2875: ||' '

Line 2872: ||' wms_ut_pkg.write_ut_test_output(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, l_test_rec.testset_id, l_test_id, p_run_id, l_file_name, l_path); '

2868: ||' '
2869: ||' wms_ut_pkg.g_start_time := SYSDATE; '
2870: ||' wms_ut_pkg.execute_ut_test_flow(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id,l_test_id);'
2871: ||' wms_ut_pkg.g_end_time := SYSDATE; '
2872: ||' wms_ut_pkg.write_ut_test_output(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, l_test_rec.testset_id, l_test_id, p_run_id, l_file_name, l_path); '
2873: ||' commit;'
2874: ||' END LOOP;'
2875: ||' '
2876: ||' END run_ut_test; '

Line 3042: --p_cur_tests wms_ut_pkg.cur_tests;

3038: outputfile UTL_FILE.FILE_TYPE;
3039: l_last_testset_id NUMBER := -1;
3040: l_last_test_id NUMBER := -1;
3041:
3042: --p_cur_tests wms_ut_pkg.cur_tests;
3043:
3044: CURSOR c_tests IS
3045: SELECT datatype || ' : ' || text as test_text, testset, testname, testset_id, test_id
3046: FROM wms_ut_tab

Line 3172: wms_ut_pkg.initialize;

3168: l_flow_ctr INTEGER;
3169: l_datatype VARCHAR2(150);
3170: l_text VARCHAR2(2000);
3171: BEGIN
3172: wms_ut_pkg.initialize;
3173: IF P_MASK is not NULL THEN
3174: l_flow_ctr := 1;
3175: FOR l_ctr IN 1..wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype.count LOOP
3176: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;

Line 3175: FOR l_ctr IN 1..wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype.count LOOP

3171: BEGIN
3172: wms_ut_pkg.initialize;
3173: IF P_MASK is not NULL THEN
3174: l_flow_ctr := 1;
3175: FOR l_ctr IN 1..wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype.count LOOP
3176: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;
3177: IF P_MASK = l_datatype THEN
3178: l_text := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dmask;
3179: RETURN P_MASK || ' : ' ||l_Text;

Line 3176: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;

3172: wms_ut_pkg.initialize;
3173: IF P_MASK is not NULL THEN
3174: l_flow_ctr := 1;
3175: FOR l_ctr IN 1..wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype.count LOOP
3176: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;
3177: IF P_MASK = l_datatype THEN
3178: l_text := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dmask;
3179: RETURN P_MASK || ' : ' ||l_Text;
3180: END IF;

Line 3178: l_text := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dmask;

3174: l_flow_ctr := 1;
3175: FOR l_ctr IN 1..wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype.count LOOP
3176: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;
3177: IF P_MASK = l_datatype THEN
3178: l_text := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dmask;
3179: RETURN P_MASK || ' : ' ||l_Text;
3180: END IF;
3181: END LOOP;
3182: END IF;

Line 3195: FOR l_ctr IN 1..wms_ut_pkg.g_data_masks.count LOOP

3191: l_datatype VARCHAR2(150);
3192: l_text VARCHAR2(2000);
3193: BEGIN
3194: IF P_MASK is not NULL THEN
3195: FOR l_ctr IN 1..wms_ut_pkg.g_data_masks.count LOOP
3196: l_datatype := wms_ut_pkg.g_data_masks(l_ctr).dtype;
3197: IF P_MASK = l_datatype THEN
3198: l_text := wms_ut_pkg.g_data_masks(l_ctr).dmask;
3199: RETURN P_MASK || ' : ' ||l_Text;

Line 3196: l_datatype := wms_ut_pkg.g_data_masks(l_ctr).dtype;

3192: l_text VARCHAR2(2000);
3193: BEGIN
3194: IF P_MASK is not NULL THEN
3195: FOR l_ctr IN 1..wms_ut_pkg.g_data_masks.count LOOP
3196: l_datatype := wms_ut_pkg.g_data_masks(l_ctr).dtype;
3197: IF P_MASK = l_datatype THEN
3198: l_text := wms_ut_pkg.g_data_masks(l_ctr).dmask;
3199: RETURN P_MASK || ' : ' ||l_Text;
3200: END IF;

Line 3198: l_text := wms_ut_pkg.g_data_masks(l_ctr).dmask;

3194: IF P_MASK is not NULL THEN
3195: FOR l_ctr IN 1..wms_ut_pkg.g_data_masks.count LOOP
3196: l_datatype := wms_ut_pkg.g_data_masks(l_ctr).dtype;
3197: IF P_MASK = l_datatype THEN
3198: l_text := wms_ut_pkg.g_data_masks(l_ctr).dmask;
3199: RETURN P_MASK || ' : ' ||l_Text;
3200: END IF;
3201: END LOOP;
3202: END IF;

Line 3324: wms_ut_pkg.initialize;

3320: l_runid := p_runid;
3321:
3322: If l_flow_type_id IS NOT NULL OR l_testset_id IS NOT NULL OR l_test_id IS NOT NULL THEN
3323:
3324: wms_ut_pkg.initialize;
3325: FOR l_ctr IN 1..wms_ut_pkg.g_data_masks.count LOOP
3326: --- for each flow type , set l_flow_ctr
3327: l_flow_ctr := 1;
3328:

Line 3325: FOR l_ctr IN 1..wms_ut_pkg.g_data_masks.count LOOP

3321:
3322: If l_flow_type_id IS NOT NULL OR l_testset_id IS NOT NULL OR l_test_id IS NOT NULL THEN
3323:
3324: wms_ut_pkg.initialize;
3325: FOR l_ctr IN 1..wms_ut_pkg.g_data_masks.count LOOP
3326: --- for each flow type , set l_flow_ctr
3327: l_flow_ctr := 1;
3328:
3329: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;

Line 3329: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;

3325: FOR l_ctr IN 1..wms_ut_pkg.g_data_masks.count LOOP
3326: --- for each flow type , set l_flow_ctr
3327: l_flow_ctr := 1;
3328:
3329: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;
3330: l_text := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dmask;
3331:
3332:
3333: EXECUTE IMMEDIATE

Line 3330: l_text := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dmask;

3326: --- for each flow type , set l_flow_ctr
3327: l_flow_ctr := 1;
3328:
3329: l_datatype := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dtype;
3330: l_text := wms_ut_pkg.g_data_masks( wms_ut_pkg.g_flow_type_datatypes(l_flow_ctr).datatype(l_ctr)).dmask;
3331:
3332:
3333: EXECUTE IMMEDIATE
3334: ' INSERT INTO wms_ut_tab' ||

Line 3366: END wms_ut_pkg;

3362: NULL;
3363: END Create_ut_datatypes;
3364:
3365:
3366: END wms_ut_pkg;
3367:
3368: