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.INV_RCV_DIAG_LCM_01 dependencies on JTF_DIAGNOSTIC_COREAPI

Line 22: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

18: reportClob OUT NOCOPY CLOB) IS
19:
20: reportStr LONG;
21: counter NUMBER;
22: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
23: c_userid VARCHAR2(50);
24: statusStr VARCHAR2(50);
25: errStr VARCHAR2(4000);
26: fixInfo VARCHAR2(4000);

Line 35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

31: BEGIN
32:
33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36:
37: -- Printing ORG_ORGANIZATION_DEFINITIONS Data
38: JTF_DIAGNOSTIC_COREAPI.insert_html('');
39: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS[Top]');

Line 38: JTF_DIAGNOSTIC_COREAPI.insert_html('');

34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36:
37: -- Printing ORG_ORGANIZATION_DEFINITIONS Data
38: JTF_DIAGNOSTIC_COREAPI.insert_html('');
39: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS[Top]');
40: sqltxt := ' SELECT ood.*' ||
41: ' FROM org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp' ||
42: ' WHERE ood.organization_id = mp.organization_id' ||

Line 39: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS[Top]');

35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36:
37: -- Printing ORG_ORGANIZATION_DEFINITIONS Data
38: JTF_DIAGNOSTIC_COREAPI.insert_html('');
39: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS[Top]');
40: sqltxt := ' SELECT ood.*' ||
41: ' FROM org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp' ||
42: ' WHERE ood.organization_id = mp.organization_id' ||
43: ' AND mp.organization_id = rp.organization_id' ||

Line 47: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');

43: ' AND mp.organization_id = rp.organization_id' ||
44: ' AND mp.lcm_enabled_flag = ''N'' ' ||
45: ' AND rp.pre_receive = ''Y'' ';
46:
47: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
48: JTF_DIAGNOSTIC_COREAPI.BRPrint;
49:
50: -- Printing MTL_PARAMETERS Data
51: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 48: JTF_DIAGNOSTIC_COREAPI.BRPrint;

44: ' AND mp.lcm_enabled_flag = ''N'' ' ||
45: ' AND rp.pre_receive = ''Y'' ';
46:
47: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
48: JTF_DIAGNOSTIC_COREAPI.BRPrint;
49:
50: -- Printing MTL_PARAMETERS Data
51: JTF_DIAGNOSTIC_COREAPI.insert_html('');
52: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS[Top]');

Line 51: JTF_DIAGNOSTIC_COREAPI.insert_html('');

47: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
48: JTF_DIAGNOSTIC_COREAPI.BRPrint;
49:
50: -- Printing MTL_PARAMETERS Data
51: JTF_DIAGNOSTIC_COREAPI.insert_html('');
52: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS[Top]');
53: sqltxt := ' SELECT mp.*' ||
54: ' FROM org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp' ||
55: ' WHERE ood.organization_id = mp.organization_id' ||

Line 52: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS[Top]');

48: JTF_DIAGNOSTIC_COREAPI.BRPrint;
49:
50: -- Printing MTL_PARAMETERS Data
51: JTF_DIAGNOSTIC_COREAPI.insert_html('');
52: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS[Top]');
53: sqltxt := ' SELECT mp.*' ||
54: ' FROM org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp' ||
55: ' WHERE ood.organization_id = mp.organization_id' ||
56: ' AND mp.organization_id = rp.organization_id' ||

Line 59: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');

55: ' WHERE ood.organization_id = mp.organization_id' ||
56: ' AND mp.organization_id = rp.organization_id' ||
57: ' AND mp.lcm_enabled_flag = ''N'' ' ||
58: ' AND rp.pre_receive = ''Y'' ';
59: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61:
62: -- Printing RCV_PARAMETERS Data
63: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 60: JTF_DIAGNOSTIC_COREAPI.BRPrint;

56: ' AND mp.organization_id = rp.organization_id' ||
57: ' AND mp.lcm_enabled_flag = ''N'' ' ||
58: ' AND rp.pre_receive = ''Y'' ';
59: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61:
62: -- Printing RCV_PARAMETERS Data
63: JTF_DIAGNOSTIC_COREAPI.insert_html('');
64: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');

Line 63: JTF_DIAGNOSTIC_COREAPI.insert_html('');

59: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61:
62: -- Printing RCV_PARAMETERS Data
63: JTF_DIAGNOSTIC_COREAPI.insert_html('');
64: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');
65: sqltxt := ' SELECT rp.*' ||
66: ' FROM org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp' ||
67: ' WHERE ood.organization_id = mp.organization_id' ||

Line 64: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');

60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61:
62: -- Printing RCV_PARAMETERS Data
63: JTF_DIAGNOSTIC_COREAPI.insert_html('');
64: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');
65: sqltxt := ' SELECT rp.*' ||
66: ' FROM org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp' ||
67: ' WHERE ood.organization_id = mp.organization_id' ||
68: ' AND mp.organization_id = rp.organization_id' ||

Line 72: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');

68: ' AND mp.organization_id = rp.organization_id' ||
69: ' AND mp.lcm_enabled_flag = ''N'' ' ||
70: ' AND rp.pre_receive = ''Y'' ';
71:
72: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74:
75: -- Test Completed successfully.
76: statusStr := 'SUCCESS';

Line 73: JTF_DIAGNOSTIC_COREAPI.BRPrint;

69: ' AND mp.lcm_enabled_flag = ''N'' ' ||
70: ' AND rp.pre_receive = ''Y'' ';
71:
72: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74:
75: -- Test Completed successfully.
76: statusStr := 'SUCCESS';
77: isFatal := 'FALSE';

Line 83: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

79: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
80:
81: EXCEPTION
82: when others then
83: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
84: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
85: statusStr := 'FAILURE';
86: errStr := sqlerrm ||' occurred in script Exception handled';
87: fixInfo := 'Unexpected Exception in INVDP08B.pls';

Line 84: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');

80:
81: EXCEPTION
82: when others then
83: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
84: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
85: statusStr := 'FAILURE';
86: errStr := sqlerrm ||' occurred in script Exception handled';
87: fixInfo := 'Unexpected Exception in INVDP08B.pls';
88: isFatal := 'FALSE';