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.

[Home] [Help]

APPS.ASO_BI_POPULATE_APPR_FACTS dependencies on BIS_COLLECTION_UTILITIES

Line 22: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_POPULATE_APPR_FACTS');

18: BEGIN
19: retcode := 0 ;
20:
21: --Refresh Log
22: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_POPULATE_APPR_FACTS');
23:
24:
25: IF(BIS_COLLECTION_UTILITIES.Setup(
26: p_object_name => 'ASO_BI_POPULATE_APPR_FACTS') = false)

Line 25: IF(BIS_COLLECTION_UTILITIES.Setup(

21: --Refresh Log
22: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_POPULATE_APPR_FACTS');
23:
24:
25: IF(BIS_COLLECTION_UTILITIES.Setup(
26: p_object_name => 'ASO_BI_POPULATE_APPR_FACTS') = false)
27: Then
28: errbuf := FND_MESSAGE.Get;
29: retcode := -1;

Line 33: BIS_COLLECTION_UTILITIES.debug('Start Initial Load for approvals and rules Fact');

29: retcode := -1;
30: RAISE_APPLICATION_ERROR(-20000,errbuf);
31: End if;
32:
33: BIS_COLLECTION_UTILITIES.debug('Start Initial Load for approvals and rules Fact');
34:
35: -- Initialize
36: BIS_COLLECTION_UTILITIES.debug('Initialization');
37:

Line 36: BIS_COLLECTION_UTILITIES.debug('Initialization');

32:
33: BIS_COLLECTION_UTILITIES.debug('Start Initial Load for approvals and rules Fact');
34:
35: -- Initialize
36: BIS_COLLECTION_UTILITIES.debug('Initialization');
37:
38: ASO_BI_UTIL_PVT.INIT;
39:
40: -- Truncate the processing tables

Line 41: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');

37:
38: ASO_BI_UTIL_PVT.INIT;
39:
40: -- Truncate the processing tables
41: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
42:
43: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
44:
45: --As this is a initial load the Base Fact Table is assumed to be empty

Line 61: BIS_COLLECTION_UTILITIES.Debug('The date Range for collection is from ' ||

57: Retcode := -1;
58: Return;
59: End If;
60:
61: BIS_COLLECTION_UTILITIES.Debug('The date Range for collection is from ' ||
62: p_from_date || ' to ' || p_to_date);
63:
64: BIS_COLLECTION_UTILITIES.Debug('Start populating ASO_BI_QUOTE_IDS: ' ||
65: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));

Line 64: BIS_COLLECTION_UTILITIES.Debug('Start populating ASO_BI_QUOTE_IDS: ' ||

60:
61: BIS_COLLECTION_UTILITIES.Debug('The date Range for collection is from ' ||
62: p_from_date || ' to ' || p_to_date);
63:
64: BIS_COLLECTION_UTILITIES.Debug('Start populating ASO_BI_QUOTE_IDS: ' ||
65: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
66:
67: ASO_BI_QUOTE_FACT_PVT.InitLoad_Quote_Ids(
68: p_from_date => l_from_date,

Line 71: BIS_COLLECTION_UTILITIES.Debug('End populating ASO_BI_QUOTE_IDS: ' ||

67: ASO_BI_QUOTE_FACT_PVT.InitLoad_Quote_Ids(
68: p_from_date => l_from_date,
69: p_to_date => l_to_date) ;
70:
71: BIS_COLLECTION_UTILITIES.Debug('End populating ASO_BI_QUOTE_IDS: ' ||
72: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
73:
74: -- Call the initial load
75: ASO_BI_APPR_FACT_PVT.Appr_Init_Load;

Line 78: BIS_COLLECTION_UTILITIES.wrapup(

74: -- Call the initial load
75: ASO_BI_APPR_FACT_PVT.Appr_Init_Load;
76: ASO_BI_APPR_FACT_PVT.Rul_Init_Load;
77:
78: BIS_COLLECTION_UTILITIES.wrapup(
79: p_status => TRUE ,
80: p_count => 0,
81: p_period_from => l_from_date,
82: p_period_to => l_to_date);

Line 89: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of APPROVALS AND RULES Fact:'||errbuf);

85: EXCEPTION
86: WHEN OTHERS THEN
87: retcode := -1;
88: errbuf := sqlerrm;
89: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of APPROVALS AND RULES Fact:'||errbuf);
90:
91: BIS_COLLECTION_UTILITIES.wrapup(
92: p_status => FALSE ,
93: p_message => sqlerrm,

Line 91: BIS_COLLECTION_UTILITIES.wrapup(

87: retcode := -1;
88: errbuf := sqlerrm;
89: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of APPROVALS AND RULES Fact:'||errbuf);
90:
91: BIS_COLLECTION_UTILITIES.wrapup(
92: p_status => FALSE ,
93: p_message => sqlerrm,
94: p_count => 0,
95: p_period_from => l_from_date,

Line 116: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_POPULATE_APPR_FACTS');

112: BEGIN
113: retcode := 0 ;
114:
115: --Refresh Log
116: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_POPULATE_APPR_FACTS');
117:
118:
119: IF(BIS_COLLECTION_UTILITIES.Setup(
120: p_object_name => 'ASO_BI_POPULATE_APPR_FACTS') = false)

Line 119: IF(BIS_COLLECTION_UTILITIES.Setup(

115: --Refresh Log
116: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_POPULATE_APPR_FACTS');
117:
118:
119: IF(BIS_COLLECTION_UTILITIES.Setup(
120: p_object_name => 'ASO_BI_POPULATE_APPR_FACTS') = false)
121: Then
122: errbuf := FND_MESSAGE.Get;
123: retcode := -1;

Line 127: BIS_COLLECTION_UTILITIES.debug('Start Initial Load for approvals and rules Fact');

123: retcode := -1;
124: RAISE_APPLICATION_ERROR(-20000,errbuf);
125: End if;
126:
127: BIS_COLLECTION_UTILITIES.debug('Start Initial Load for approvals and rules Fact');
128:
129: -- Initialize
130: BIS_COLLECTION_UTILITIES.debug('Initialization');
131:

Line 130: BIS_COLLECTION_UTILITIES.debug('Initialization');

126:
127: BIS_COLLECTION_UTILITIES.debug('Start Initial Load for approvals and rules Fact');
128:
129: -- Initialize
130: BIS_COLLECTION_UTILITIES.debug('Initialization');
131:
132: ASO_BI_UTIL_PVT.INIT;
133:
134: -- Truncate the processing tables

Line 135: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');

131:
132: ASO_BI_UTIL_PVT.INIT;
133:
134: -- Truncate the processing tables
135: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
136: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
137:
138: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
139: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 - ONE_SECOND;

Line 150: BIS_COLLECTION_UTILITIES.Debug('The date Range for collection is from ' ||

146: Retcode := -1;
147: Return;
148: End If;
149:
150: BIS_COLLECTION_UTILITIES.Debug('The date Range for collection is from ' ||
151: p_from_date || ' to ' || p_to_date);
152:
153: BIS_COLLECTION_UTILITIES.Debug('Start populating ASO_BI_QUOTE_IDS: ' ||
154: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));

Line 153: BIS_COLLECTION_UTILITIES.Debug('Start populating ASO_BI_QUOTE_IDS: ' ||

149:
150: BIS_COLLECTION_UTILITIES.Debug('The date Range for collection is from ' ||
151: p_from_date || ' to ' || p_to_date);
152:
153: BIS_COLLECTION_UTILITIES.Debug('Start populating ASO_BI_QUOTE_IDS: ' ||
154: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
155:
156: -- Pick up all the modified quotes 4 d period
157: ASO_BI_QUOTE_FACT_PVT.InitLoad_Quote_Ids(

Line 161: BIS_COLLECTION_UTILITIES.Debug('End populating ASO_BI_QUOTE_IDS: ' ||

157: ASO_BI_QUOTE_FACT_PVT.InitLoad_Quote_Ids(
158: p_from_date => l_from_date,
159: p_to_date => l_to_date) ;
160:
161: BIS_COLLECTION_UTILITIES.Debug('End populating ASO_BI_QUOTE_IDS: ' ||
162: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
163:
164: ASO_BI_APPR_FACT_PVT.Appr_Incremental_Load;
165: ASO_BI_APPR_FACT_PVT.Rul_Incremental_Load;

Line 168: BIS_COLLECTION_UTILITIES.wrapup(

164: ASO_BI_APPR_FACT_PVT.Appr_Incremental_Load;
165: ASO_BI_APPR_FACT_PVT.Rul_Incremental_Load;
166:
167:
168: BIS_COLLECTION_UTILITIES.wrapup(
169: p_status => TRUE ,
170: p_count => 0,
171: p_period_from => l_from_date,
172: p_period_to => l_to_date);

Line 179: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of APPROVALS AND RULES Fact:'||errbuf);

175: EXCEPTION
176: WHEN OTHERS THEN
177: retcode := -1;
178: errbuf := sqlerrm;
179: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of APPROVALS AND RULES Fact:'||errbuf);
180:
181: BIS_COLLECTION_UTILITIES.wrapup(
182: p_status => FALSE ,
183: p_message => sqlerrm,

Line 181: BIS_COLLECTION_UTILITIES.wrapup(

177: retcode := -1;
178: errbuf := sqlerrm;
179: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of APPROVALS AND RULES Fact:'||errbuf);
180:
181: BIS_COLLECTION_UTILITIES.wrapup(
182: p_status => FALSE ,
183: p_message => sqlerrm,
184: p_count => 0,
185: p_period_from => l_from_date,