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_JTA_INTEGRATION_GRP dependencies on IBE_UTIL

Line 71: IBE_UTIL.debug('Inside postRejection procedure');

67: BEGIN
68:
69: -- fnd_global.apps_initialize(1007888,22372,671);
70:
71: IBE_UTIL.debug('Inside postRejection procedure');
72: IBE_UTIL.debug('l_Key is '|| l_key);
73:
74: -- Check for the event and get the required WF parameters
75:

Line 72: IBE_UTIL.debug('l_Key is '|| l_key);

68:
69: -- fnd_global.apps_initialize(1007888,22372,671);
70:
71: IBE_UTIL.debug('Inside postRejection procedure');
72: IBE_UTIL.debug('l_Key is '|| l_key);
73:
74: -- Check for the event and get the required WF parameters
75:
76: IBE_UTIL.debug('Getting wf params');

Line 76: IBE_UTIL.debug('Getting wf params');

72: IBE_UTIL.debug('l_Key is '|| l_key);
73:
74: -- Check for the event and get the required WF parameters
75:
76: IBE_UTIL.debug('Getting wf params');
77: l_userreg_id := p_event.getValueForParameter(G_USERTYPEREG_ID);
78: l_usertype_key := p_event.getValueForParameter(G_USERTYPE_KEY);
79: l_usertype_appId := p_event.getValueForParameter(G_USERTYPE_APPID);
80: l_party_id := p_event.getValueForParameter(G_USER_CUSTOMER_ID);

Line 81: IBE_UTIL.debug('l_userreg_id=' || l_userreg_id || 'l_usertype_key=' || l_usertype_key || 'l_usertype_appId=' || l_usertype_appId || 'l_party_id=' || l_party_id);

77: l_userreg_id := p_event.getValueForParameter(G_USERTYPEREG_ID);
78: l_usertype_key := p_event.getValueForParameter(G_USERTYPE_KEY);
79: l_usertype_appId := p_event.getValueForParameter(G_USERTYPE_APPID);
80: l_party_id := p_event.getValueForParameter(G_USER_CUSTOMER_ID);
81: IBE_UTIL.debug('l_userreg_id=' || l_userreg_id || 'l_usertype_key=' || l_usertype_key || 'l_usertype_appId=' || l_usertype_appId || 'l_party_id=' || l_party_id);
82:
83: -- Skip inactivation if username is not released
84:
85: OPEN C_get_user_id(l_userreg_id);

Line 91: IBE_UTIL.debug('l_user_id is released. Hence continue to inactivate contact details');

87: CLOSE C_get_user_id;
88:
89: IF (l_user_id is null) THEN
90:
91: IBE_UTIL.debug('l_user_id is released. Hence continue to inactivate contact details');
92:
93: IF (l_usertype_appId = '671' or l_usertype_appId = '672') THEN
94:
95: -- Skip inactivation for partial registrations

Line 99: IBE_UTIL.debug('l_usertype_partial=' || l_usertype_partial);

95: -- Skip inactivation for partial registrations
96: -- If l_usertype_key is not in Partial_register_usertypes_lookUp Then
97:
98: l_usertype_partial := getIsPartialRegistrationUser(l_userreg_id);
99: IBE_UTIL.debug('l_usertype_partial=' || l_usertype_partial);
100:
101: If l_usertype_partial = FND_API.G_TRUE Then
102: RETURN 'SUCCESS';
103: Else

Line 111: IBE_UTIL.debug('l_party_id=' || l_party_id);

107: FETCH C_get_party_id into l_party_id;
108: CLOSE C_get_party_id;
109: */
110:
111: IBE_UTIL.debug('l_party_id=' || l_party_id);
112:
113: If l_party_id = null Then
114: RETURN 'SUCCESS';
115: End If;

Line 126: IBE_UTIL.debug('l_change_org_status=' || l_change_org_status);

122: IF l_is_primary_usertype is not null THEN
123: l_change_org_status:=getIsUserCompanyToBeExpired(l_party_id);
124: END IF;
125:
126: IBE_UTIL.debug('l_change_org_status=' || l_change_org_status);
127:
128: IBE_UTIL.debug('Calling Inactivation API');
129: -- Call inactivation API
130: ibe_party_v2pvt.Update_Party_Status(

Line 128: IBE_UTIL.debug('Calling Inactivation API');

124: END IF;
125:
126: IBE_UTIL.debug('l_change_org_status=' || l_change_org_status);
127:
128: IBE_UTIL.debug('Calling Inactivation API');
129: -- Call inactivation API
130: ibe_party_v2pvt.Update_Party_Status(
131: p_party_id=>l_party_id,
132: p_party_status=>'I',

Line 139: IBE_UTIL.debug('Called Inactivation API');

135: x_return_status=>l_return_status,
136: x_msg_count=>l_msg_count,
137: x_msg_data=>l_msg_data
138: ) ;
139: IBE_UTIL.debug('Called Inactivation API');
140:
141: -- If ERROR, propogate.
142: If l_return_status = FND_API.G_RET_STS_ERROR Then
143: WF_CORE.CONTEXT('IBE', 'postRejection',

Line 155: IBE_UTIL.debug('l_usertype_partner=' || l_usertype_partner);

151:
152: -- If Partner Usertype, call PRM API using dynamic sql, through dbms_sql
153:
154: l_usertype_partner := getIsPartnerUser(l_userreg_id);
155: IBE_UTIL.debug('l_usertype_partner=' || l_usertype_partner);
156:
157: If l_usertype_partner = FND_API.G_TRUE Then
158:
159: DBMS_SQL.PARSE (cur,

Line 174: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);

170: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
171: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
172: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
173:
174: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);
175: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));
176: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);
177:
178: If x_prm_return_status = FND_API.G_FALSE Then

Line 175: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));

171: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
172: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
173:
174: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);
175: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));
176: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);
177:
178: If x_prm_return_status = FND_API.G_FALSE Then
179: DBMS_SQL.CLOSE_CURSOR (cur);

Line 176: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);

172: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
173:
174: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);
175: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));
176: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);
177:
178: If x_prm_return_status = FND_API.G_FALSE Then
179: DBMS_SQL.CLOSE_CURSOR (cur);
180: IBE_UTIL.debug('Returning ERROR due to PRM');

Line 180: IBE_UTIL.debug('Returning ERROR due to PRM');

176: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);
177:
178: If x_prm_return_status = FND_API.G_FALSE Then
179: DBMS_SQL.CLOSE_CURSOR (cur);
180: IBE_UTIL.debug('Returning ERROR due to PRM');
181: WF_CORE.CONTEXT('IBE', 'postRejection',
182: p_event.getEventName(), p_subscription_guid);
183: WF_EVENT.setErrorInfo(p_event, 'ERROR due to PRM : x_prm_msg_data=' || x_prm_msg_data);
184: RETURN 'ERROR';

Line 195: IBE_UTIL.debug('l_user_id is not released. Hence skipping inactivation of contact details');

191: End If;
192:
193: END IF;
194: ELSE
195: IBE_UTIL.debug('l_user_id is not released. Hence skipping inactivation of contact details');
196: END IF;
197:
198: IBE_UTIL.debug('Returning SUCCESS');
199: RETURN 'SUCCESS';

Line 198: IBE_UTIL.debug('Returning SUCCESS');

194: ELSE
195: IBE_UTIL.debug('l_user_id is not released. Hence skipping inactivation of contact details');
196: END IF;
197:
198: IBE_UTIL.debug('Returning SUCCESS');
199: RETURN 'SUCCESS';
200:
201: EXCEPTION
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 289: IBE_UTIL.debug('Not a partial registration type');

285: BEGIN
286: OPEN C_check_user_type(l_usertype_group);
287: FETCH C_check_user_type into l_usertype_key;
288: IF C_check_user_type%NOTFOUND THEN
289: IBE_UTIL.debug('Not a partial registration type');
290: CLOSE C_check_user_type;
291: RETURN FND_API.G_FALSE;
292: END IF;
293:

Line 294: IBE_UTIL.debug('Is a partial registration type');

290: CLOSE C_check_user_type;
291: RETURN FND_API.G_FALSE;
292: END IF;
293:
294: IBE_UTIL.debug('Is a partial registration type');
295: CLOSE C_check_user_type;
296: RETURN FND_API.G_TRUE;
297:
298: EXCEPTION

Line 340: IBE_UTIL.debug('Not a partner registration type');

336: BEGIN
337: OPEN C_check_user_type(l_usertype_group);
338: FETCH C_check_user_type into l_usertype_key;
339: IF C_check_user_type%NOTFOUND THEN
340: IBE_UTIL.debug('Not a partner registration type');
341: CLOSE C_check_user_type;
342: RETURN FND_API.G_FALSE;
343: END IF;
344: