DBA Data[Home] [Help]

APPS.INV_RCV_DIAG_LCM_05 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 RCV_TRANSACTIONS_INTERFACE Data
38: JTF_DIAGNOSTIC_COREAPI.insert_html('');
39: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE[Top]');

Line 38: JTF_DIAGNOSTIC_COREAPI.insert_html('');

34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36:
37: -- Printing RCV_TRANSACTIONS_INTERFACE Data
38: JTF_DIAGNOSTIC_COREAPI.insert_html('');
39: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE[Top]');
40: sqltxt := ' SELECT rti.* ' ||
41: ' FROM rcv_transactions_interface rti,' ||
42: ' rcv_parameters rp,' ||

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

35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36:
37: -- Printing RCV_TRANSACTIONS_INTERFACE Data
38: JTF_DIAGNOSTIC_COREAPI.insert_html('');
39: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE[Top]');
40: sqltxt := ' SELECT rti.* ' ||
41: ' FROM rcv_transactions_interface rti,' ||
42: ' rcv_parameters rp,' ||
43: ' po_line_locations_all pll' ||

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

48: ' AND rp.pre_receive <> ''Y'' ' ||
49: ' AND rti.transaction_type in (''RECEIVE'', ''SHIP'')' ||
50: ' AND rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')' ||
51: ' AND rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;
52: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
53: JTF_DIAGNOSTIC_COREAPI.BRPrint;
54:
55: -- Printing PO_LINE_LOCATIONS_ALL Data
56: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 53: JTF_DIAGNOSTIC_COREAPI.BRPrint;

49: ' AND rti.transaction_type in (''RECEIVE'', ''SHIP'')' ||
50: ' AND rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')' ||
51: ' AND rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;
52: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
53: JTF_DIAGNOSTIC_COREAPI.BRPrint;
54:
55: -- Printing PO_LINE_LOCATIONS_ALL Data
56: JTF_DIAGNOSTIC_COREAPI.insert_html('');
57: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL[Top]');

Line 56: JTF_DIAGNOSTIC_COREAPI.insert_html('');

52: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
53: JTF_DIAGNOSTIC_COREAPI.BRPrint;
54:
55: -- Printing PO_LINE_LOCATIONS_ALL Data
56: JTF_DIAGNOSTIC_COREAPI.insert_html('');
57: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL[Top]');
58: sqltxt := ' SELECT pll.* ' ||
59: ' FROM rcv_transactions_interface rti,' ||
60: ' rcv_parameters rp,' ||

Line 57: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL[Top]');

53: JTF_DIAGNOSTIC_COREAPI.BRPrint;
54:
55: -- Printing PO_LINE_LOCATIONS_ALL Data
56: JTF_DIAGNOSTIC_COREAPI.insert_html('');
57: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL[Top]');
58: sqltxt := ' SELECT pll.* ' ||
59: ' FROM rcv_transactions_interface rti,' ||
60: ' rcv_parameters rp,' ||
61: ' po_line_locations_all pll' ||

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

66: ' AND rp.pre_receive <> ''Y'' ' ||
67: ' AND rti.transaction_type in (''RECEIVE'', ''SHIP'')' ||
68: ' AND rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')' ||
69: ' AND rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;
70: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
71: JTF_DIAGNOSTIC_COREAPI.BRPrint;
72:
73: -- Printing RCV_PARAMETERS Data
74: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 71: JTF_DIAGNOSTIC_COREAPI.BRPrint;

67: ' AND rti.transaction_type in (''RECEIVE'', ''SHIP'')' ||
68: ' AND rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')' ||
69: ' AND rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;
70: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
71: JTF_DIAGNOSTIC_COREAPI.BRPrint;
72:
73: -- Printing RCV_PARAMETERS Data
74: JTF_DIAGNOSTIC_COREAPI.insert_html('');
75: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');

Line 74: JTF_DIAGNOSTIC_COREAPI.insert_html('');

70: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
71: JTF_DIAGNOSTIC_COREAPI.BRPrint;
72:
73: -- Printing RCV_PARAMETERS Data
74: JTF_DIAGNOSTIC_COREAPI.insert_html('');
75: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');
76: sqltxt := ' SELECT rp.* ' ||
77: ' FROM rcv_transactions_interface rti,' ||
78: ' rcv_parameters rp,' ||

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

71: JTF_DIAGNOSTIC_COREAPI.BRPrint;
72:
73: -- Printing RCV_PARAMETERS Data
74: JTF_DIAGNOSTIC_COREAPI.insert_html('');
75: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');
76: sqltxt := ' SELECT rp.* ' ||
77: ' FROM rcv_transactions_interface rti,' ||
78: ' rcv_parameters rp,' ||
79: ' po_line_locations_all pll' ||

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

84: ' AND rp.pre_receive <> ''Y'' ' ||
85: ' AND rti.transaction_type in (''RECEIVE'', ''SHIP'')' ||
86: ' AND rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')' ||
87: ' AND rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;
88: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
89: JTF_DIAGNOSTIC_COREAPI.BRPrint;
90:
91: -- Test Completed successfully.
92: statusStr := 'SUCCESS';

Line 89: JTF_DIAGNOSTIC_COREAPI.BRPrint;

85: ' AND rti.transaction_type in (''RECEIVE'', ''SHIP'')' ||
86: ' AND rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')' ||
87: ' AND rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;
88: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'');
89: JTF_DIAGNOSTIC_COREAPI.BRPrint;
90:
91: -- Test Completed successfully.
92: statusStr := 'SUCCESS';
93: isFatal := 'FALSE';

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

95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96:
97: EXCEPTION
98: when others then
99: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
100: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
101: statusStr := 'FAILURE';
102: errStr := sqlerrm ||' occurred in script Exception handled';
103: fixInfo := 'Unexpected Exception in INVDP08B.pls';

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

96:
97: EXCEPTION
98: when others then
99: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
100: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
101: statusStr := 'FAILURE';
102: errStr := sqlerrm ||' occurred in script Exception handled';
103: fixInfo := 'Unexpected Exception in INVDP08B.pls';
104: isFatal := 'FALSE';