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.BIS_CONCURRENT_MANAGER_PVT dependencies on BIS_UTILITIES_PUB

Line 52: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

48: PROCEDURE Manage_Alert_Registrations
49: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
50: , x_request_scheduled OUT NOCOPY VARCHAR2
51: , x_return_status OUT NOCOPY VARCHAR2
52: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
53: )
54: IS
55:
56: l_request_id NUMBER;

Line 71: BIS_UTILITIES_PUB.put_line(p_text =>'Managing alert registrations (concurrent manager mode)');

67: l_request_scheduled BOOLEAN := FALSE;
68:
69: BEGIN
70:
71: BIS_UTILITIES_PUB.put_line(p_text =>'Managing alert registrations (concurrent manager mode)');
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: Get_All_Requests
75: ( p_Param_Set_rec => p_Param_Set_rec

Line 81: -- BIS_UTILITIES_PUB.put_line(p_text =>'l_debug_text :'||l_debug_text);

77: , x_return_status => x_return_status
78: );
79:
80: IF l_Concurrent_Request_tbl.COUNT > 0 THEN
81: -- BIS_UTILITIES_PUB.put_line(p_text =>'l_debug_text :'||l_debug_text);
82: null;
83: ELSE
84: -- BIS_UTILITIES_PUB.put_line(p_text =>'l_debug_text :'||l_debug_text);
85: null;

Line 84: -- BIS_UTILITIES_PUB.put_line(p_text =>'l_debug_text :'||l_debug_text);

80: IF l_Concurrent_Request_tbl.COUNT > 0 THEN
81: -- BIS_UTILITIES_PUB.put_line(p_text =>'l_debug_text :'||l_debug_text);
82: null;
83: ELSE
84: -- BIS_UTILITIES_PUB.put_line(p_text =>'l_debug_text :'||l_debug_text);
85: null;
86: END IF;
87:
88: FOR i IN 1..l_Concurrent_Request_tbl.COUNT LOOP

Line 103: BIS_UTILITIES_PUB.put_line(p_text =>'Concurrent request phase: '||l_dev_phase

99: AND ((l_dev_status = G_CONC_REQUEST_SCHEDULED) OR (l_dev_status = C_CONC_REQUEST_NORMAL)))
100: THEN
101: l_request_scheduled := TRUE;
102: l_request_id := l_Concurrent_Request_tbl(i).request_id;
103: BIS_UTILITIES_PUB.put_line(p_text =>'Concurrent request phase: '||l_dev_phase
104: ||', status: '||l_dev_status);
105: exit;
106: END IF;
107: END LOOP;

Line 115: BIS_UTILITIES_PUB.put_line(p_text =>'Managing request by target level: '

111: ELSE
112: x_request_scheduled := FND_API.G_FALSE;
113:
114: IF p_Param_Set_Rec.Target_Level_id IS NOT NULL THEN
115: BIS_UTILITIES_PUB.put_line(p_text =>'Managing request by target level: '
116: ||p_Param_Set_Rec.Target_Level_id );
117:
118: IF (p_param_set_rec.notify_owner_flag <> 'N') THEN
119: BIS_PMF_ALERT_REG_PVT.Retrieve_Parameter_set

Line 130: BIS_UTILITIES_PUB.put_line(p_text =>'Managing request by measure: '

126: END IF;
127: ELSIF p_Param_Set_Rec.performance_measure_id IS NOT NULL
128: AND p_Param_Set_Rec.target_level_id IS NULL
129: THEN
130: BIS_UTILITIES_PUB.put_line(p_text =>'Managing request by measure: '
131: ||p_Param_Set_Rec.performance_measure_id
132: ||', time: '||p_Param_Set_Rec.time_dimension_level_id);
133:
134: BIS_PMF_ALERT_REG_PVT.Retrieve_Parameter_set

Line 145: BIS_UTILITIES_PUB.put_line(p_text =>'Deleting '||i||'th parameter set. Registration id: '

141: );
142: END IF;
143:
144: FOR i IN 1..l_param_set_tbl.COUNT LOOP
145: BIS_UTILITIES_PUB.put_line(p_text =>'Deleting '||i||'th parameter set. Registration id: '
146: ||l_param_set_tbl(i).registration_id);
147:
148: BEGIN
149: BIS_PMF_ALERT_REG_PVT.Delete_Parameter_Set

Line 164: BIS_UTILITIES_PUB.put_line(p_text =>i||'th param set did not get deleted.');

160: );
161: 2562678 */
162: EXCEPTION
163: WHEN OTHERS THEN
164: BIS_UTILITIES_PUB.put_line(p_text =>i||'th param set did not get deleted.');
165: END;
166: BIS_UTILITIES_PUB.put_line(p_text =>i||'th deleted.');
167: END LOOP;
168:

Line 166: BIS_UTILITIES_PUB.put_line(p_text =>i||'th deleted.');

162: EXCEPTION
163: WHEN OTHERS THEN
164: BIS_UTILITIES_PUB.put_line(p_text =>i||'th param set did not get deleted.');
165: END;
166: BIS_UTILITIES_PUB.put_line(p_text =>i||'th deleted.');
167: END LOOP;
168:
169: END IF;
170:

Line 174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);

170:
171: EXCEPTION
172: when FND_API.G_EXC_ERROR then
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);
175: when FND_API.G_EXC_UNEXPECTED_ERROR then
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
178: when others then

Line 177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);

173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);
175: when FND_API.G_EXC_UNEXPECTED_ERROR then
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
178: when others then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);
181: BIS_UTILITIES_PVT.Add_Error_Message

Line 180: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);

176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
178: when others then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);
181: BIS_UTILITIES_PVT.Add_Error_Message
182: ( p_error_msg_id => SQLCODE
183: , p_error_description => SQLERRM
184: , p_error_proc_name => G_PKG_NAME||'.Manage_Alert_Registrations'

Line 263: BIS_UTILITIES_PUB.put_line(p_text =>'Getting request information. measure id: '

259: l_debug_text VARCHAR2(32000);
260:
261: BEGIN
262:
263: BIS_UTILITIES_PUB.put_line(p_text =>'Getting request information. measure id: '
264: ||p_param_set_rec.performance_measure_id||', target level id: '
265: ||p_param_set_rec.target_level_id
266: );
267:

Line 269: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving target level information ');

265: ||p_param_set_rec.target_level_id
266: );
267:
268: IF p_param_set_rec.target_level_id IS NOT NULL THEN
269: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving target level information ');
270:
271: Get_PMF_Concurrent_Program_ID
272: ( x_Concurrent_Program_ID => l_Concurrent_Program_ID
273: , x_Application_ID => l_Application_ID

Line 281: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved target level: '

277: select * into l_target_level_rec
278: from bisbv_target_levels
279: where target_level_id = p_param_set_rec.target_level_id;
280:
281: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved target level: '
282: ||l_target_level_rec.TARGET_LEVEL_SHORT_NAME);
283: EXCEPTION
284: WHEN OTHERS THEN
285: BIS_UTILITIES_PUB.put_line(p_text =>'exception while getting target level');

Line 285: BIS_UTILITIES_PUB.put_line(p_text =>'exception while getting target level');

281: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved target level: '
282: ||l_target_level_rec.TARGET_LEVEL_SHORT_NAME);
283: EXCEPTION
284: WHEN OTHERS THEN
285: BIS_UTILITIES_PUB.put_line(p_text =>'exception while getting target level');
286: return;
287: END;
288:
289: FOR cr_conc IN cr_conc_req_tl LOOP

Line 302: BIS_UTILITIES_PUB.put_line(p_text =>'conc target level: '||l_Concurrent_Request_Rec.argument3);

298: ||l_Concurrent_Request_Rec.request_id||', start: '
299: ||l_Concurrent_Request_Rec.ACTUAL_START_DATE||', end: '
300: ||l_Concurrent_Request_Rec.ACTUAL_COMPLETION_DATE
301: ;
302: BIS_UTILITIES_PUB.put_line(p_text =>'conc target level: '||l_Concurrent_Request_Rec.argument3);
303: BIS_UTILITIES_PUB.put_line(p_text =>'conc plan: '||l_Concurrent_Request_Rec.argument5);
304: BIS_UTILITIES_PUB.put_line(p_text =>'conc org id: '||l_Concurrent_Request_Rec.argument8);
305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);
306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);

Line 303: BIS_UTILITIES_PUB.put_line(p_text =>'conc plan: '||l_Concurrent_Request_Rec.argument5);

299: ||l_Concurrent_Request_Rec.ACTUAL_START_DATE||', end: '
300: ||l_Concurrent_Request_Rec.ACTUAL_COMPLETION_DATE
301: ;
302: BIS_UTILITIES_PUB.put_line(p_text =>'conc target level: '||l_Concurrent_Request_Rec.argument3);
303: BIS_UTILITIES_PUB.put_line(p_text =>'conc plan: '||l_Concurrent_Request_Rec.argument5);
304: BIS_UTILITIES_PUB.put_line(p_text =>'conc org id: '||l_Concurrent_Request_Rec.argument8);
305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);
306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);
307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );

Line 304: BIS_UTILITIES_PUB.put_line(p_text =>'conc org id: '||l_Concurrent_Request_Rec.argument8);

300: ||l_Concurrent_Request_Rec.ACTUAL_COMPLETION_DATE
301: ;
302: BIS_UTILITIES_PUB.put_line(p_text =>'conc target level: '||l_Concurrent_Request_Rec.argument3);
303: BIS_UTILITIES_PUB.put_line(p_text =>'conc plan: '||l_Concurrent_Request_Rec.argument5);
304: BIS_UTILITIES_PUB.put_line(p_text =>'conc org id: '||l_Concurrent_Request_Rec.argument8);
305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);
306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);
307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );
308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );

Line 305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);

301: ;
302: BIS_UTILITIES_PUB.put_line(p_text =>'conc target level: '||l_Concurrent_Request_Rec.argument3);
303: BIS_UTILITIES_PUB.put_line(p_text =>'conc plan: '||l_Concurrent_Request_Rec.argument5);
304: BIS_UTILITIES_PUB.put_line(p_text =>'conc org id: '||l_Concurrent_Request_Rec.argument8);
305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);
306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);
307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );
308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );
309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );

Line 306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);

302: BIS_UTILITIES_PUB.put_line(p_text =>'conc target level: '||l_Concurrent_Request_Rec.argument3);
303: BIS_UTILITIES_PUB.put_line(p_text =>'conc plan: '||l_Concurrent_Request_Rec.argument5);
304: BIS_UTILITIES_PUB.put_line(p_text =>'conc org id: '||l_Concurrent_Request_Rec.argument8);
305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);
306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);
307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );
308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );
309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );
310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );

Line 307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );

303: BIS_UTILITIES_PUB.put_line(p_text =>'conc plan: '||l_Concurrent_Request_Rec.argument5);
304: BIS_UTILITIES_PUB.put_line(p_text =>'conc org id: '||l_Concurrent_Request_Rec.argument8);
305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);
306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);
307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );
308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );
309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );
310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );

Line 308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );

304: BIS_UTILITIES_PUB.put_line(p_text =>'conc org id: '||l_Concurrent_Request_Rec.argument8);
305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);
306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);
307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );
308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );
309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );
310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);

Line 309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );

305: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument9);
306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);
307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );
308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );
309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );
310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);

Line 310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );

306: BIS_UTILITIES_PUB.put_line(p_text =>'conc time id: '||l_Concurrent_Request_Rec.argument11);
307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );
308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );
309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );
310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);

Line 311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );

307: BIS_UTILITIES_PUB.put_line(p_text =>'param3: ' || l_Concurrent_Request_Rec.argument3 );
308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );
309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );
310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);

Line 312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);

308: BIS_UTILITIES_PUB.put_line(p_text =>'param6: ' || l_Concurrent_Request_Rec.argument6 );
309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );
310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);

Line 313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);

309: BIS_UTILITIES_PUB.put_line(p_text =>'param7 : '|| l_Concurrent_Request_Rec.argument7 );
310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);

Line 314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);

310: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);

Line 315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);

311: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);

Line 316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);

312: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);

Line 317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);

313: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);

Line 318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);

314: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
322: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);

Line 319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);

315: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
322: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
323: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);

Line 320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);

316: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
322: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
323: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
324: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);

Line 321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);

317: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
322: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
323: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
324: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);
325: */

Line 322: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);

318: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
322: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
323: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
324: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);
325: */
326:

Line 323: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);

319: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
322: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
323: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
324: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);
325: */
326:
327: END LOOP;

Line 324: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);

320: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
321: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
322: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
323: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
324: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);
325: */
326:
327: END LOOP;
328:

Line 337: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving measure information ');

333: , x_Concurrent_Program_ID => l_Concurrent_Program_ID
334: , x_Application_ID => l_Application_ID
335: );
336:
337: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving measure information ');
338: FOR cr_conc IN cr_conc_req_meas LOOP
339: l_count := l_count+1;
340: l_Concurrent_Request_Rec := cr_conc;
341: l_Concurrent_Request_tbl(l_Concurrent_Request_tbl.COUNT+1)

Line 345: BIS_UTILITIES_PUB.put_line(p_text =>'conc measure: '||l_Concurrent_Request_Rec.argument1);

341: l_Concurrent_Request_tbl(l_Concurrent_Request_tbl.COUNT+1)
342: := l_Concurrent_Request_Rec;
343:
344: /*
345: BIS_UTILITIES_PUB.put_line(p_text =>'conc measure: '||l_Concurrent_Request_Rec.argument1);
346: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument7);
347:
348: l_debug_text := l_debug_text
349: ||'param1 : '|| l_Concurrent_Request_Rec.argument1 ;

Line 346: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument7);

342: := l_Concurrent_Request_Rec;
343:
344: /*
345: BIS_UTILITIES_PUB.put_line(p_text =>'conc measure: '||l_Concurrent_Request_Rec.argument1);
346: BIS_UTILITIES_PUB.put_line(p_text =>'conc time level: '||l_Concurrent_Request_Rec.argument7);
347:
348: l_debug_text := l_debug_text
349: ||'param1 : '|| l_Concurrent_Request_Rec.argument1 ;
350: l_debug_text := l_debug_text

Line 354: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );

350: l_debug_text := l_debug_text
351: ||'param3 : '|| l_Concurrent_Request_Rec.argument3 ;
352: l_debug_text := l_debug_text
353: ||'param7 : '|| l_Concurrent_Request_Rec.argument7 ;
354: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
355: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
356: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);

Line 355: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );

351: ||'param3 : '|| l_Concurrent_Request_Rec.argument3 ;
352: l_debug_text := l_debug_text
353: ||'param7 : '|| l_Concurrent_Request_Rec.argument7 ;
354: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
355: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
356: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);

Line 356: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);

352: l_debug_text := l_debug_text
353: ||'param7 : '|| l_Concurrent_Request_Rec.argument7 ;
354: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
355: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
356: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);

Line 357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);

353: ||'param7 : '|| l_Concurrent_Request_Rec.argument7 ;
354: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
355: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
356: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);

Line 358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);

354: BIS_UTILITIES_PUB.put_line(p_text =>'param8: ' || l_Concurrent_Request_Rec.argument8 );
355: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
356: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);

Line 359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);

355: BIS_UTILITIES_PUB.put_line(p_text =>'param9 : '|| l_Concurrent_Request_Rec.argument9 );
356: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);

Line 360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);

356: BIS_UTILITIES_PUB.put_line(p_text =>'param10: '|| l_Concurrent_Request_Rec.argument10);
357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
364: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);

Line 361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);

357: BIS_UTILITIES_PUB.put_line(p_text =>'param11: '|| l_Concurrent_Request_Rec.argument11);
358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
364: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
365: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);

Line 362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);

358: BIS_UTILITIES_PUB.put_line(p_text =>'param12: '|| l_Concurrent_Request_Rec.argument12);
359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
364: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
365: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
366: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);

Line 363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);

359: BIS_UTILITIES_PUB.put_line(p_text =>'param14: '|| l_Concurrent_Request_Rec.argument14);
360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
364: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
365: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
366: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);
367:

Line 364: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);

360: BIS_UTILITIES_PUB.put_line(p_text =>'param15: '|| l_Concurrent_Request_Rec.argument15);
361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
364: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
365: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
366: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);
367:
368: l_debug_text := l_debug_text ||'count: '

Line 365: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);

361: BIS_UTILITIES_PUB.put_line(p_text =>'param17: '|| l_Concurrent_Request_Rec.argument17);
362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
364: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
365: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
366: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);
367:
368: l_debug_text := l_debug_text ||'count: '
369: ||l_count||', req id: '

Line 366: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);

362: BIS_UTILITIES_PUB.put_line(p_text =>'param18: '|| l_Concurrent_Request_Rec.argument18);
363: BIS_UTILITIES_PUB.put_line(p_text =>'param20: '|| l_Concurrent_Request_Rec.argument20);
364: BIS_UTILITIES_PUB.put_line(p_text =>'param21: '|| l_Concurrent_Request_Rec.argument21);
365: BIS_UTILITIES_PUB.put_line(p_text =>'param23: '|| l_Concurrent_Request_Rec.argument23);
366: BIS_UTILITIES_PUB.put_line(p_text =>'param24: '|| l_Concurrent_Request_Rec.argument24);
367:
368: l_debug_text := l_debug_text ||'count: '
369: ||l_count||', req id: '
370: ||l_Concurrent_Request_Rec.request_id||', start: '

Line 385: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Get_All_Requests: '||SQLERRM);

381: x_Concurrent_Request_tbl := l_Concurrent_Request_tbl;
382:
383: EXCEPTION
384: WHEN OTHERS THEN
385: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Get_All_Requests: '||SQLERRM);
386:
387: END Get_All_Requests;
388:
389: Procedure Get_PMF_Concurrent_Program_ID

Line 414: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Get_PMF_Concurrent_Program_ID: '||SQLERRM);

410: = BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME;
411:
412: EXCEPTION
413: WHEN OTHERS THEN
414: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Get_PMF_Concurrent_Program_ID: '||SQLERRM);
415:
416: END Get_PMF_Concurrent_Program_ID;
417:
418: Procedure Submit_Concurrent_Request

Line 420: , x_request_id_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL

416: END Get_PMF_Concurrent_Program_ID;
417:
418: Procedure Submit_Concurrent_Request
419: ( p_Concurrent_Request_Tbl IN PMF_Request_Tbl_Type
420: , x_request_id_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
421: , x_errbuf OUT NOCOPY VARCHAR2
422: , x_retcode OUT NOCOPY VARCHAR2
423: )
424: IS

Line 455: BIS_UTILITIES_PUB.put_line(p_text =>'concurrent request '||i||' of '

451: l_time_format VARCHAR2(200);
452: l_req_time_format VARCHAR2(200) := 'DD-MON-YYYY HH24:MI:SS';
453: BEGIN
454: /*
455: BIS_UTILITIES_PUB.put_line(p_text =>'concurrent request '||i||' of '
456: ||p_Concurrent_Request_Tbl.COUNT||' being submitted');
457: BIS_UTILITIES_PUB.put_line(p_text =>'Organization id: '||p_Concurrent_Request_Tbl(i).argument8);
458: BIS_UTILITIES_PUB.put_line(p_text =>'time id: '||p_Concurrent_Request_Tbl(i).argument9;
459: BIS_UTILITIES_PUB.put_line(p_text =>'dim1 id: '||p_Concurrent_Request_Tbl(i).argument14);

Line 457: BIS_UTILITIES_PUB.put_line(p_text =>'Organization id: '||p_Concurrent_Request_Tbl(i).argument8);

453: BEGIN
454: /*
455: BIS_UTILITIES_PUB.put_line(p_text =>'concurrent request '||i||' of '
456: ||p_Concurrent_Request_Tbl.COUNT||' being submitted');
457: BIS_UTILITIES_PUB.put_line(p_text =>'Organization id: '||p_Concurrent_Request_Tbl(i).argument8);
458: BIS_UTILITIES_PUB.put_line(p_text =>'time id: '||p_Concurrent_Request_Tbl(i).argument9;
459: BIS_UTILITIES_PUB.put_line(p_text =>'dim1 id: '||p_Concurrent_Request_Tbl(i).argument14);
460: BIS_UTILITIES_PUB.put_line(p_text =>'dim2 id: '||p_Concurrent_Request_Tbl(i).argument17);
461: BIS_UTILITIES_PUB.put_line(p_text =>'target_id: '||p_Concurrent_Request_Tbl(i).argument27);

Line 458: BIS_UTILITIES_PUB.put_line(p_text =>'time id: '||p_Concurrent_Request_Tbl(i).argument9;

454: /*
455: BIS_UTILITIES_PUB.put_line(p_text =>'concurrent request '||i||' of '
456: ||p_Concurrent_Request_Tbl.COUNT||' being submitted');
457: BIS_UTILITIES_PUB.put_line(p_text =>'Organization id: '||p_Concurrent_Request_Tbl(i).argument8);
458: BIS_UTILITIES_PUB.put_line(p_text =>'time id: '||p_Concurrent_Request_Tbl(i).argument9;
459: BIS_UTILITIES_PUB.put_line(p_text =>'dim1 id: '||p_Concurrent_Request_Tbl(i).argument14);
460: BIS_UTILITIES_PUB.put_line(p_text =>'dim2 id: '||p_Concurrent_Request_Tbl(i).argument17);
461: BIS_UTILITIES_PUB.put_line(p_text =>'target_id: '||p_Concurrent_Request_Tbl(i).argument27);
462: */

Line 459: BIS_UTILITIES_PUB.put_line(p_text =>'dim1 id: '||p_Concurrent_Request_Tbl(i).argument14);

455: BIS_UTILITIES_PUB.put_line(p_text =>'concurrent request '||i||' of '
456: ||p_Concurrent_Request_Tbl.COUNT||' being submitted');
457: BIS_UTILITIES_PUB.put_line(p_text =>'Organization id: '||p_Concurrent_Request_Tbl(i).argument8);
458: BIS_UTILITIES_PUB.put_line(p_text =>'time id: '||p_Concurrent_Request_Tbl(i).argument9;
459: BIS_UTILITIES_PUB.put_line(p_text =>'dim1 id: '||p_Concurrent_Request_Tbl(i).argument14);
460: BIS_UTILITIES_PUB.put_line(p_text =>'dim2 id: '||p_Concurrent_Request_Tbl(i).argument17);
461: BIS_UTILITIES_PUB.put_line(p_text =>'target_id: '||p_Concurrent_Request_Tbl(i).argument27);
462: */
463:

Line 460: BIS_UTILITIES_PUB.put_line(p_text =>'dim2 id: '||p_Concurrent_Request_Tbl(i).argument17);

456: ||p_Concurrent_Request_Tbl.COUNT||' being submitted');
457: BIS_UTILITIES_PUB.put_line(p_text =>'Organization id: '||p_Concurrent_Request_Tbl(i).argument8);
458: BIS_UTILITIES_PUB.put_line(p_text =>'time id: '||p_Concurrent_Request_Tbl(i).argument9;
459: BIS_UTILITIES_PUB.put_line(p_text =>'dim1 id: '||p_Concurrent_Request_Tbl(i).argument14);
460: BIS_UTILITIES_PUB.put_line(p_text =>'dim2 id: '||p_Concurrent_Request_Tbl(i).argument17);
461: BIS_UTILITIES_PUB.put_line(p_text =>'target_id: '||p_Concurrent_Request_Tbl(i).argument27);
462: */
463:
464: --BIS_UTILITIES_PUB.put_line(p_text =>'program: '||p_concurrent_Request_rec.program);

Line 461: BIS_UTILITIES_PUB.put_line(p_text =>'target_id: '||p_Concurrent_Request_Tbl(i).argument27);

457: BIS_UTILITIES_PUB.put_line(p_text =>'Organization id: '||p_Concurrent_Request_Tbl(i).argument8);
458: BIS_UTILITIES_PUB.put_line(p_text =>'time id: '||p_Concurrent_Request_Tbl(i).argument9;
459: BIS_UTILITIES_PUB.put_line(p_text =>'dim1 id: '||p_Concurrent_Request_Tbl(i).argument14);
460: BIS_UTILITIES_PUB.put_line(p_text =>'dim2 id: '||p_Concurrent_Request_Tbl(i).argument17);
461: BIS_UTILITIES_PUB.put_line(p_text =>'target_id: '||p_Concurrent_Request_Tbl(i).argument27);
462: */
463:
464: --BIS_UTILITIES_PUB.put_line(p_text =>'program: '||p_concurrent_Request_rec.program);
465: -- use teh ICX date format mask while submitting request too.

Line 464: --BIS_UTILITIES_PUB.put_line(p_text =>'program: '||p_concurrent_Request_rec.program);

460: BIS_UTILITIES_PUB.put_line(p_text =>'dim2 id: '||p_Concurrent_Request_Tbl(i).argument17);
461: BIS_UTILITIES_PUB.put_line(p_text =>'target_id: '||p_Concurrent_Request_Tbl(i).argument27);
462: */
463:
464: --BIS_UTILITIES_PUB.put_line(p_text =>'program: '||p_concurrent_Request_rec.program);
465: -- use teh ICX date format mask while submitting request too.
466: l_time_format := NVL(fnd_profile.value_Specific('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY') ||' HH24:MI:SS';
467:
468: IF p_concurrent_Request_rec.program = G_ALERT_PROGRAM THEN

Line 469: BIS_UTILITIES_PUB.put_line(p_text =>'argument1: '||p_concurrent_Request_rec.argument1);

465: -- use teh ICX date format mask while submitting request too.
466: l_time_format := NVL(fnd_profile.value_Specific('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY') ||' HH24:MI:SS';
467:
468: IF p_concurrent_Request_rec.program = G_ALERT_PROGRAM THEN
469: BIS_UTILITIES_PUB.put_line(p_text =>'argument1: '||p_concurrent_Request_rec.argument1);
470: BIS_UTILITIES_PUB.put_line(p_text =>'argument2: '||p_concurrent_Request_rec.argument2);
471: BIS_UTILITIES_PUB.put_line(p_text =>'argument9: '||p_concurrent_Request_rec.argument9);
472: BIS_UTILITIES_PUB.put_line(p_text =>'argument40: '||p_concurrent_Request_rec.argument40);
473: BIS_UTILITIES_PUB.put_line(p_text =>'argument42: '||p_concurrent_Request_rec.argument42);

Line 470: BIS_UTILITIES_PUB.put_line(p_text =>'argument2: '||p_concurrent_Request_rec.argument2);

466: l_time_format := NVL(fnd_profile.value_Specific('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY') ||' HH24:MI:SS';
467:
468: IF p_concurrent_Request_rec.program = G_ALERT_PROGRAM THEN
469: BIS_UTILITIES_PUB.put_line(p_text =>'argument1: '||p_concurrent_Request_rec.argument1);
470: BIS_UTILITIES_PUB.put_line(p_text =>'argument2: '||p_concurrent_Request_rec.argument2);
471: BIS_UTILITIES_PUB.put_line(p_text =>'argument9: '||p_concurrent_Request_rec.argument9);
472: BIS_UTILITIES_PUB.put_line(p_text =>'argument40: '||p_concurrent_Request_rec.argument40);
473: BIS_UTILITIES_PUB.put_line(p_text =>'argument42: '||p_concurrent_Request_rec.argument42);
474:

Line 471: BIS_UTILITIES_PUB.put_line(p_text =>'argument9: '||p_concurrent_Request_rec.argument9);

467:
468: IF p_concurrent_Request_rec.program = G_ALERT_PROGRAM THEN
469: BIS_UTILITIES_PUB.put_line(p_text =>'argument1: '||p_concurrent_Request_rec.argument1);
470: BIS_UTILITIES_PUB.put_line(p_text =>'argument2: '||p_concurrent_Request_rec.argument2);
471: BIS_UTILITIES_PUB.put_line(p_text =>'argument9: '||p_concurrent_Request_rec.argument9);
472: BIS_UTILITIES_PUB.put_line(p_text =>'argument40: '||p_concurrent_Request_rec.argument40);
473: BIS_UTILITIES_PUB.put_line(p_text =>'argument42: '||p_concurrent_Request_rec.argument42);
474:
475: -- Setting unused columns to null

Line 472: BIS_UTILITIES_PUB.put_line(p_text =>'argument40: '||p_concurrent_Request_rec.argument40);

468: IF p_concurrent_Request_rec.program = G_ALERT_PROGRAM THEN
469: BIS_UTILITIES_PUB.put_line(p_text =>'argument1: '||p_concurrent_Request_rec.argument1);
470: BIS_UTILITIES_PUB.put_line(p_text =>'argument2: '||p_concurrent_Request_rec.argument2);
471: BIS_UTILITIES_PUB.put_line(p_text =>'argument9: '||p_concurrent_Request_rec.argument9);
472: BIS_UTILITIES_PUB.put_line(p_text =>'argument40: '||p_concurrent_Request_rec.argument40);
473: BIS_UTILITIES_PUB.put_line(p_text =>'argument42: '||p_concurrent_Request_rec.argument42);
474:
475: -- Setting unused columns to null
476: --

Line 473: BIS_UTILITIES_PUB.put_line(p_text =>'argument42: '||p_concurrent_Request_rec.argument42);

469: BIS_UTILITIES_PUB.put_line(p_text =>'argument1: '||p_concurrent_Request_rec.argument1);
470: BIS_UTILITIES_PUB.put_line(p_text =>'argument2: '||p_concurrent_Request_rec.argument2);
471: BIS_UTILITIES_PUB.put_line(p_text =>'argument9: '||p_concurrent_Request_rec.argument9);
472: BIS_UTILITIES_PUB.put_line(p_text =>'argument40: '||p_concurrent_Request_rec.argument40);
473: BIS_UTILITIES_PUB.put_line(p_text =>'argument42: '||p_concurrent_Request_rec.argument42);
474:
475: -- Setting unused columns to null
476: --
477: l_request_number :=

Line 581: BIS_UTILITIES_PUB.put_line(p_text =>'Not a valid PMF concurrent program');

577: , p_concurrent_Request_rec.argument43 -- p_alert_based_on (target or current)
578: , p_concurrent_Request_rec.argument42 -- p_current_row (current or previous)
579: );
580: ELSE
581: BIS_UTILITIES_PUB.put_line(p_text =>'Not a valid PMF concurrent program');
582: l_request_number := 0;
583: END IF;
584:
585: COMMIT;

Line 691: BIS_UTILITIES_PUB.put_line(p_text =>x_return_status);

687:
688: EXCEPTION
689: WHEN OTHERS THEN
690: x_return_status := 'error at Get_Request_Schedule_Info: '||sqlerrm;
691: BIS_UTILITIES_PUB.put_line(p_text =>x_return_status);
692:
693: END Get_Request_Schedule_Info;
694:
695: Procedure Get_Request_Schedule_Info

Line 739: --BIS_UTILITIES_PUB.put_line(p_text =>'Number of rows: '||l_Concurrent_Request_tbl.COUNT);

735: ( p_Param_Set_rec => p_Param_Set_Rec
736: , x_Concurrent_Request_tbl => l_Concurrent_Request_tbl
737: , x_return_status => x_return_status
738: );
739: --BIS_UTILITIES_PUB.put_line(p_text =>'Number of rows: '||l_Concurrent_Request_tbl.COUNT);
740:
741:
742: l_date_format := 'DD/MM/RRRR';
743: l_time_format := 'HH24:MI:SS';

Line 791: --BIS_UTILITIES_PUB.put_line(p_text =>'got request status.');

787: exit;
788: ELSIF (l_dev_phase = G_CONC_REQUEST_PENDING
789: AND l_dev_status = G_CONC_REQUEST_SCHEDULED)
790: THEN
791: --BIS_UTILITIES_PUB.put_line(p_text =>'got request status.');
792: --
793: l_description := l_Concurrent_Request_tbl(i).DESCRIPTION;
794: l_schedule_date
795: := to_char(l_Concurrent_Request_tbl(i).REQUEST_DATE,l_date_format);

Line 830: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_date: '||l_schedule_date);

826: := to_char(l_Concurrent_Request_tbl(i).REQUESTED_START_DATE
827: ,l_time_format);
828:
829: /*
830: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_date: '||l_schedule_date);
831: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_unit: '||l_schedule_unit);
832: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_freq: '||l_schedule_freq);
833: BIS_UTILITIES_PUB.put_line(p_text =>'l_next_run_time: '||l_next_run_time);
834: BIS_UTILITIES_PUB.put_line(p_text =>'l_description: '|| l_description);

Line 831: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_unit: '||l_schedule_unit);

827: ,l_time_format);
828:
829: /*
830: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_date: '||l_schedule_date);
831: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_unit: '||l_schedule_unit);
832: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_freq: '||l_schedule_freq);
833: BIS_UTILITIES_PUB.put_line(p_text =>'l_next_run_time: '||l_next_run_time);
834: BIS_UTILITIES_PUB.put_line(p_text =>'l_description: '|| l_description);
835: */

Line 832: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_freq: '||l_schedule_freq);

828:
829: /*
830: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_date: '||l_schedule_date);
831: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_unit: '||l_schedule_unit);
832: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_freq: '||l_schedule_freq);
833: BIS_UTILITIES_PUB.put_line(p_text =>'l_next_run_time: '||l_next_run_time);
834: BIS_UTILITIES_PUB.put_line(p_text =>'l_description: '|| l_description);
835: */
836: exit;

Line 833: BIS_UTILITIES_PUB.put_line(p_text =>'l_next_run_time: '||l_next_run_time);

829: /*
830: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_date: '||l_schedule_date);
831: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_unit: '||l_schedule_unit);
832: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_freq: '||l_schedule_freq);
833: BIS_UTILITIES_PUB.put_line(p_text =>'l_next_run_time: '||l_next_run_time);
834: BIS_UTILITIES_PUB.put_line(p_text =>'l_description: '|| l_description);
835: */
836: exit;
837: END IF;

Line 834: BIS_UTILITIES_PUB.put_line(p_text =>'l_description: '|| l_description);

830: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_date: '||l_schedule_date);
831: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_unit: '||l_schedule_unit);
832: BIS_UTILITIES_PUB.put_line(p_text =>'l_schedule_freq: '||l_schedule_freq);
833: BIS_UTILITIES_PUB.put_line(p_text =>'l_next_run_time: '||l_next_run_time);
834: BIS_UTILITIES_PUB.put_line(p_text =>'l_description: '|| l_description);
835: */
836: exit;
837: END IF;
838: END LOOP;

Line 854: BIS_UTILITIES_PUB.put_line(p_text =>'error at Get_Request_Schedule_Info: '||sqlerrm);

850: x_return_status := l_return_status;
851:
852: EXCEPTION
853: WHEN OTHERS THEN
854: BIS_UTILITIES_PUB.put_line(p_text =>'error at Get_Request_Schedule_Info: '||sqlerrm);
855: x_return_status := 'error at Get_Request_Schedule_Info: '||sqlerrm;
856: END Get_Request_Schedule_Info;
857:
858: -- then non-nls compliant way to handle plural units

Line 886: --BIS_UTILITIES_PUB.put_line(p_text =>'x_schedule_freq_unit: '||x_schedule_freq_unit);

882: l_schedule_freq_unit := lower(l_schedule_unit);
883: END IF;
884:
885: x_schedule_freq_unit := l_schedule_freq_unit;
886: --BIS_UTILITIES_PUB.put_line(p_text =>'x_schedule_freq_unit: '||x_schedule_freq_unit);
887:
888: EXCEPTION
889: WHEN OTHERS THEN
890: x_schedule_freq_unit := null;

Line 891: BIS_UTILITIES_PUB.put_line(p_text =>'error at Format_Schedule_Freq_Unit: '||sqlerrm);

887:
888: EXCEPTION
889: WHEN OTHERS THEN
890: x_schedule_freq_unit := null;
891: BIS_UTILITIES_PUB.put_line(p_text =>'error at Format_Schedule_Freq_Unit: '||sqlerrm);
892:
893: END Format_Schedule_Freq_Unit;
894:
895: FUNCTION Get_Freq_Display_Unit(p_freq_unit_code IN VARCHAR2)

Line 903: --BIS_UTILITIES_PUB.put_line(p_text =>'Translating unit code: '||p_freq_unit_code);

899: l_every VARCHAR2(32000);
900:
901: BEGIN
902:
903: --BIS_UTILITIES_PUB.put_line(p_text =>'Translating unit code: '||p_freq_unit_code);
904: IF (UPPER(p_freq_unit_code) = 'ONCE') THEN
905: l_repeat_unit := BIS_UTILITIES_PVT.Get_FND_Message(
906: p_message_name => 'BIS_PMF_ALERT_ONCE');
907: RETURN l_repeat_unit;

Line 935: BIS_UTILITIES_PUB.put_line(p_text =>'error at Get_Display_Unit: '||sqlerrm);

931:
932: EXCEPTION
933: WHEN OTHERS THEN
934: l_repeat_unit := null;
935: BIS_UTILITIES_PUB.put_line(p_text =>'error at Get_Display_Unit: '||sqlerrm);
936: return l_repeat_unit;
937:
938: END Get_Freq_Display_Unit;
939:

Line 1031: BIS_UTILITIES_PUB.put_line(p_text =>'exception in Set_Repeat_Options: '||sqlerrm);

1027: x_result := FND_API.G_RET_STS_SUCCESS;
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: BIS_UTILITIES_PUB.put_line(p_text =>'exception in Set_Repeat_Options: '||sqlerrm);
1032: x_result := l_debug_text||'exception in Set_Repeat_Options: '||sqlerrm;
1033:
1034: END Set_Repeat_Options;
1035: