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.IBE_INSTALLBASE_PVT dependencies on IBE_UTIL

Line 46: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

42: INTO l_config_inst_header_id, l_config_inst_revision_number
43: FROM CSI_ITEM_INSTANCES CSII
44: WHERE CSII.INSTANCE_ID = p_instance_id;
45:
46: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
47: IBE_Util.Debug('l_config_inst_header_id : '||l_config_inst_header_id);
48: IBE_Util.Debug('l_config_inst_revision_number : '||l_config_inst_revision_number);
49: END IF;
50:

Line 47: IBE_Util.Debug('l_config_inst_header_id : '||l_config_inst_header_id);

43: FROM CSI_ITEM_INSTANCES CSII
44: WHERE CSII.INSTANCE_ID = p_instance_id;
45:
46: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
47: IBE_Util.Debug('l_config_inst_header_id : '||l_config_inst_header_id);
48: IBE_Util.Debug('l_config_inst_revision_number : '||l_config_inst_revision_number);
49: END IF;
50:
51:

Line 48: IBE_Util.Debug('l_config_inst_revision_number : '||l_config_inst_revision_number);

44: WHERE CSII.INSTANCE_ID = p_instance_id;
45:
46: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
47: IBE_Util.Debug('l_config_inst_header_id : '||l_config_inst_header_id);
48: IBE_Util.Debug('l_config_inst_revision_number : '||l_config_inst_revision_number);
49: END IF;
50:
51:
52: l_config_query_table(0).config_header_id := l_config_inst_header_id ;

Line 64: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

60: x_return_status => x_return_status,
61: x_return_message => x_return_message
62: );
63:
64: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
65: IBE_Util.Debug('After Call to CSI API::x_return_status:'||x_return_status);
66: END IF;
67:
68: -- If Ret Status is true and there is atleast one connected-to instance

Line 65: IBE_Util.Debug('After Call to CSI API::x_return_status:'||x_return_status);

61: x_return_message => x_return_message
62: );
63:
64: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
65: IBE_Util.Debug('After Call to CSI API::x_return_status:'||x_return_status);
66: END IF;
67:
68: -- If Ret Status is true and there is atleast one connected-to instance
69: IF (x_return_status = FND_API.G_RET_STS_SUCCESS)

Line 74: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

70: THEN
71: -- then construct a comma separated string of Instance Id
72: IF l_config_pair_table.first is not null THEN
73:
74: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
75: IBE_Util.Debug('Ret Status is success and config pair table exists l_config_pair_table.first is not null');
76: END IF;
77:
78: FOR l_iteration in l_config_pair_table.first .. l_config_pair_table.last

Line 75: IBE_Util.Debug('Ret Status is success and config pair table exists l_config_pair_table.first is not null');

71: -- then construct a comma separated string of Instance Id
72: IF l_config_pair_table.first is not null THEN
73:
74: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
75: IBE_Util.Debug('Ret Status is success and config pair table exists l_config_pair_table.first is not null');
76: END IF;
77:
78: FOR l_iteration in l_config_pair_table.first .. l_config_pair_table.last
79: LOOP

Line 92: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

88: l_instance_string := l_instance_string||','||l_instance_id;
89: END IF;
90: CLOSE c_connected_to_inst_id;
91: END IF;
92: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
93: IBE_Util.Debug('l_iteration::'||l_iteration||'l_instance_string::'||l_instance_string);
94: END IF;
95: END LOOP;
96: END IF;

Line 93: IBE_Util.Debug('l_iteration::'||l_iteration||'l_instance_string::'||l_instance_string);

89: END IF;
90: CLOSE c_connected_to_inst_id;
91: END IF;
92: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
93: IBE_Util.Debug('l_iteration::'||l_iteration||'l_instance_string::'||l_instance_string);
94: END IF;
95: END LOOP;
96: END IF;
97:

Line 98: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

94: END IF;
95: END LOOP;
96: END IF;
97:
98: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
99: IBE_Util.Debug('After Loop : l_instance_string :: '||l_instance_string);
100: END IF;
101: -- If there is atleast one Connected-to Instance
102: IF(l_instance_string is not null)

Line 99: IBE_Util.Debug('After Loop : l_instance_string :: '||l_instance_string);

95: END LOOP;
96: END IF;
97:
98: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
99: IBE_Util.Debug('After Loop : l_instance_string :: '||l_instance_string);
100: END IF;
101: -- If there is atleast one Connected-to Instance
102: IF(l_instance_string is not null)
103: THEN

Line 104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

100: END IF;
101: -- If there is atleast one Connected-to Instance
102: IF(l_instance_string is not null)
103: THEN
104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
105: IBE_Util.Debug('Inside if bef call to lead import');
106: END IF;
107: -- Initialise key and call the API to put the values in the temp table
108: -- Out var would be a query which can be used with the key bound to

Line 105: IBE_Util.Debug('Inside if bef call to lead import');

101: -- If there is atleast one Connected-to Instance
102: IF(l_instance_string is not null)
103: THEN
104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
105: IBE_Util.Debug('Inside if bef call to lead import');
106: END IF;
107: -- Initialise key and call the API to put the values in the temp table
108: -- Out var would be a query which can be used with the key bound to
109: -- value of p_number

Line 118: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

114: p_keyString => x_parse_key,
115: p_number => p_key_bind_value,
116: x_QueryString => x_query_inst_id
117: );
118: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
119: IBE_Util.Debug('After call to parse Input,x_QueryString : '||x_query_inst_id);
120: END IF;
121: END IF;
122: ELSE

Line 119: IBE_Util.Debug('After call to parse Input,x_QueryString : '||x_query_inst_id);

115: p_number => p_key_bind_value,
116: x_QueryString => x_query_inst_id
117: );
118: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
119: IBE_Util.Debug('After call to parse Input,x_QueryString : '||x_query_inst_id);
120: END IF;
121: END IF;
122: ELSE
123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

119: IBE_Util.Debug('After call to parse Input,x_QueryString : '||x_query_inst_id);
120: END IF;
121: END IF;
122: ELSE
123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
124: IBE_Util.Debug('Return Status is not successful, Message : '||x_return_message);
125: END IF;
126: END IF;
127:

Line 124: IBE_Util.Debug('Return Status is not successful, Message : '||x_return_message);

120: END IF;
121: END IF;
122: ELSE
123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
124: IBE_Util.Debug('Return Status is not successful, Message : '||x_return_message);
125: END IF;
126: END IF;
127:
128: EXCEPTION

Line 130: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

126: END IF;
127:
128: EXCEPTION
129: WHEN others THEN
130: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
131: IBE_Util.Debug('Exception caught : ' ||sqlerrm);
132: RAISE;
133: END IF;
134: END Get_Connected_Instances;

Line 131: IBE_Util.Debug('Exception caught : ' ||sqlerrm);

127:
128: EXCEPTION
129: WHEN others THEN
130: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
131: IBE_Util.Debug('Exception caught : ' ||sqlerrm);
132: RAISE;
133: END IF;
134: END Get_Connected_Instances;
135:

Line 146: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

142: l_return_value VARCHAR2(1);
143: l_true VARCHAR2(1);
144: BEGIN
145: l_true := FND_API.G_TRUE;
146: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
147: IBE_Util.Debug('IS_ITEM_IN_MSITE BEGIN ');
148: END IF;
149:
150: l_return_value := 'N'; -- Initialize return value to be N.

Line 147: IBE_Util.Debug('IS_ITEM_IN_MSITE BEGIN ');

143: l_true VARCHAR2(1);
144: BEGIN
145: l_true := FND_API.G_TRUE;
146: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
147: IBE_Util.Debug('IS_ITEM_IN_MSITE BEGIN ');
148: END IF;
149:
150: l_return_value := 'N'; -- Initialize return value to be N.
151:

Line 155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

151:
152: -- If inventory item id and minisite id is passed
153: IF(p_inventory_item_id is not null and p_minisite_id is not null)
154: THEN
155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
156: IBE_Util.Debug('p_inventory_item_id : '||p_inventory_item_id||' :: p_minisite_id : '||p_minisite_id);
157: END IF;
158:
159: SELECT 'Y' INTO l_return_value -- Set return val to Y if item exists in Msite

Line 156: IBE_Util.Debug('p_inventory_item_id : '||p_inventory_item_id||' :: p_minisite_id : '||p_minisite_id);

152: -- If inventory item id and minisite id is passed
153: IF(p_inventory_item_id is not null and p_minisite_id is not null)
154: THEN
155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
156: IBE_Util.Debug('p_inventory_item_id : '||p_inventory_item_id||' :: p_minisite_id : '||p_minisite_id);
157: END IF;
158:
159: SELECT 'Y' INTO l_return_value -- Set return val to Y if item exists in Msite
160: FROM DUAL

Line 172: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

168: );
169:
170: END IF;
171:
172: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
173: IBE_Util.Debug('Retrun Value : '||l_return_value);
174: END IF;
175:
176: RETURN(l_return_value);

Line 173: IBE_Util.Debug('Retrun Value : '||l_return_value);

169:
170: END IF;
171:
172: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
173: IBE_Util.Debug('Retrun Value : '||l_return_value);
174: END IF;
175:
176: RETURN(l_return_value);
177: -- Handle any exception, return 'N'

Line 181: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

177: -- Handle any exception, return 'N'
178: EXCEPTION
179: WHEN OTHERS THEN
180: BEGIN
181: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
182: IBE_Util.Debug('Exception caught'||sqlerrm);
183: END IF;
184: RETURN(l_return_value) ;
185: END;

Line 182: IBE_Util.Debug('Exception caught'||sqlerrm);

178: EXCEPTION
179: WHEN OTHERS THEN
180: BEGIN
181: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
182: IBE_Util.Debug('Exception caught'||sqlerrm);
183: END IF;
184: RETURN(l_return_value) ;
185: END;
186: END IS_ITEM_IN_MSITE;