DBA Data[Home] [Help]

APPS.INV_DIAG_MO dependencies on JTF_DIAGNOSTIC_COREAPI

Line 34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

30: l_proc_flag varchar2(1);
31: BEGIN
32: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
33: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: -- accept input
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_acct_period_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctId',inputs);
38: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);

Line 69: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Period Information for Pending Txn in MMTT');

65: end if;
66:
67: sqltxt :=sqltxt||' ORDER BY mp.organization_code, oap.acct_period_id';
68:
69: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Period Information for Pending Txn in MMTT');
70:
71: statusStr := 'SUCCESS';
72: isFatal := 'FALSE';
73:

Line 120: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Error Txn in MMTT');

116: if l_proc_flag is not null then
117: sqltxt :=sqltxt||'AND process_flag= ' ||l_proc_flag;
118: end if;
119:
120: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Error Txn in MMTT');
121:
122: statusStr := 'SUCCESS';
123: isFatal := 'FALSE';
124:

Line 127: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input parameters');

123: isFatal := 'FALSE';
124:
125: /**
126: else
127: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input parameters');
128: statusStr := 'FAILURE';
129: errStr := 'org_id null';
130: fixInfo := 'Org or OrdID input is required ';
131: isFatal := 'SUCCESS';