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_INDICATOR_RESPS_PKG dependencies on BIS_UTILITIES_PUB

Line 69: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 1 ' ) ;

65: l_error_msg VARCHAR2(100);
66:
67: BEGIN
68:
69: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 1 ' ) ;
70:
71: resp_value_id_conversion
72: ( p_responsibility_key => p_responsibility_short_name
73: ,x_responsibility_id => l_responsibility_id

Line 78: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 1.1 ' || l_return_status1 ) ;

74: ,x_return_status => l_return_status1
75: ,x_return_msg => l_return_msg1
76: ) ;
77:
78: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 1.1 ' || l_return_status1 ) ;
79:
80: tgt_level_value_id_conversion
81: ( p_target_level_short_name => p_target_level_short_name
82: , x_target_level_id => l_target_level_id

Line 87: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 1.2 ' ) ;

83: , x_return_status => l_return_status2
84: , x_return_msg => l_return_msg2
85: );
86:
87: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 1.2 ' ) ;
88:
89: IF ( (l_return_status1 = 'S') AND (l_return_status2 = 'S') ) THEN -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 2 ' ) ;
90:
91: /*

Line 89: IF ( (l_return_status1 = 'S') AND (l_return_status2 = 'S') ) THEN -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 2 ' ) ;

85: );
86:
87: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 1.2 ' ) ;
88:
89: IF ( (l_return_status1 = 'S') AND (l_return_status2 = 'S') ) THEN -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 2 ' ) ;
90:
91: /*
92: SELECT BIS_INDICATOR_RESPS_S.nextval
93: INTO l_indicator_resp_id

Line 97: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

93: INTO l_indicator_resp_id
94: FROM DUAL;
95: */
96:
97: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
98: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
99: ELSE
100: l_user_id := fnd_global.user_id;
101: END IF;

Line 98: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

94: FROM DUAL;
95: */
96:
97: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
98: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
99: ELSE
100: l_user_id := fnd_global.user_id;
101: END IF;
102:

Line 126: IF ( l_exists = FALSE ) THEN -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 3 ' ) ;

122: , x_exists => l_exists
123: );
124:
125:
126: IF ( l_exists = FALSE ) THEN -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 3 ' ) ;
127:
128: Insert_Row
129: (
130: x_rowid => l_row_id

Line 141: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 3.1 ' ) ;

137: ,x_last_update_date => sysdate
138: ,x_last_update_login => l_login_id
139: );
140:
141: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 3.1 ' ) ;
142:
143: ELSE
144:
145: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 4 ' ) ;

Line 145: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 4 ' ) ;

141: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 3.1 ' ) ;
142:
143: ELSE
144:
145: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 4 ' ) ;
146:
147: Update_Row(
148: x_indicator_resp_id => l_target_level_id
149: ,x_target_level_id => l_target_level_id

Line 156: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 4.1 ' ) ;

152: ,x_last_update_date => sysdate
153: ,x_last_update_login => l_login_id
154: );
155:
156: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 4.1 ' ) ;
157:
158: END IF;
159:
160: ELSE

Line 171: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;

167: , p_msg_param2 => 'SUM_LVL'
168: , p_msg_param2_val => p_target_level_short_name
169: ), 1, 100) ;
170:
171: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
172:
173: END IF;
174:
175: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 5 ' ) ;

Line 175: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 5 ' ) ;

171: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
172:
173: END IF;
174:
175: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside load row 5 ' ) ;
176:
177: EXCEPTION
178:
179: WHEN OTHERS THEN

Line 189: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;

185: , p_msg_param2 => 'SUM_LVL'
186: , p_msg_param2_val => p_target_level_short_name
187: ) ;
188:
189: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
190:
191:
192: END;
193:

Line 211: AND responsibility_id = p_responsibility_id; -- BIS_UTILITIES_PUB.put_line(p_text => ' l_count = ' || l_count ) ;

207: SELECT count(1)
208: INTO l_count
209: FROM bis_indicator_resps
210: WHERE target_level_id = p_target_level_id
211: AND responsibility_id = p_responsibility_id; -- BIS_UTILITIES_PUB.put_line(p_text => ' l_count = ' || l_count ) ;
212:
213: IF ( l_count = 0 ) THEN
214: x_exists := FALSE;
215: ELSE -- IF (l_count = 1 ) THEN

Line 218: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in CHECK_SECURITY_EXISTS: One Summary level has the same responsibility more than once ' ) ;

214: x_exists := FALSE;
215: ELSE -- IF (l_count = 1 ) THEN
216: x_exists := TRUE;
217: -- ELSE
218: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in CHECK_SECURITY_EXISTS: One Summary level has the same responsibility more than once ' ) ;
219: END IF;
220:
221: EXCEPTION
222: WHEN OTHERS THEN

Line 223: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in CHECK_SECURITY_EXISTS: in when others ' ) ;

219: END IF;
220:
221: EXCEPTION
222: WHEN OTHERS THEN
223: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in CHECK_SECURITY_EXISTS: in when others ' ) ;
224: x_exists := TRUE; -- We don't want to upload it.
225:
226: END;
227:

Line 243: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside resp val id conv 1 ' || p_responsibility_key ) ;

239: l_error_msg VARCHAR2(100);
240:
241: BEGIN
242:
243: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside resp val id conv 1 ' || p_responsibility_key ) ;
244:
245: SELECT responsibility_id
246: INTO l_responsibility_id
247: FROM fnd_responsibility

Line 250: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside resp val id conv 2 ' ) ;

246: INTO l_responsibility_id
247: FROM fnd_responsibility
248: WHERE responsibility_key = p_responsibility_key ;
249:
250: -- BIS_UTILITIES_PUB.put_line(p_text => ' inside resp val id conv 2 ' ) ;
251:
252: x_responsibility_id := l_responsibility_id ;
253: x_return_status := 'S';
254:

Line 266: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;

262: , p_msg_param1 => 'RESP_KEY'
263: , p_msg_param1_val => p_responsibility_key
264: ) ;
265:
266: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
267:
268: x_return_msg := l_error_msg ;
269: x_return_status := 'E';
270:

Line 279: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;

275: , p_msg_param1 => 'RESP_KEY'
276: , p_msg_param1_val => p_responsibility_key
277: ) ;
278:
279: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
280:
281: x_return_msg := l_error_msg ;
282: x_return_status := 'U';
283:

Line 321: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;

317: , p_msg_param1 => 'SUM_LVL'
318: , p_msg_param1_val => p_target_level_short_name
319: ),1,80) ;
320:
321: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
322:
323: x_return_msg := l_error_msg ;
324: x_return_status := 'E';
325:

Line 334: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;

330: , p_msg_param1 => 'SUM_LVL'
331: , p_msg_param1_val => p_target_level_short_name
332: ) ;
333:
334: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
335:
336: x_return_msg := l_error_msg ;
337: x_return_status := 'U';
338: