31: l_usertype_appId VARCHAR2(240);
32: l_usertype_partial VARCHAR2(240);
33: l_party_id NUMBER;
34: l_user_id NUMBER;
35: l_change_org_status VARCHAR2(240):=FND_API.G_FALSE;
36: l_return_status VARCHAR2(1);
37: l_msg_count NUMBER;
38: l_msg_data VARCHAR2(240);
39: l_usertype_partner VARCHAR2(240);
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
104: -- Get the party_id corresponding to the l_Userreg_id
105: /*
130: ibe_party_v2pvt.Update_Party_Status(
131: p_party_id=>l_party_id,
132: p_party_status=>'I',
133: p_change_org_status=>l_change_org_status,
134: p_commit=>FND_API.G_TRUE,
135: x_return_status=>l_return_status,
136: x_msg_count=>l_msg_count,
137: x_msg_data=>l_msg_data
138: ) ;
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',
144: p_event.getEventName(), p_subscription_guid);
145: WF_EVENT.setErrorInfo(p_event, 'l_msg_data=' || l_msg_data);
146: RETURN 'ERROR';
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,
160: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
161: DBMS_SQL.NATIVE);
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');
181: WF_CORE.CONTEXT('IBE', 'postRejection',
182: p_event.getEventName(), p_subscription_guid);
198: IBE_UTIL.debug('Returning SUCCESS');
199: RETURN 'SUCCESS';
200:
201: EXCEPTION
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: WF_CORE.CONTEXT('IBE', 'postRejection',
204: p_event.getEventName(), p_subscription_guid);
205: WF_EVENT.setErrorInfo(p_event, 'UNEXPECTED ERROR');
206: RETURN 'ERROR';
240: and relationship_code='EMPLOYEE_OF'
241: )
242: and status<>'I';
243: IF l_company_rel_count < 2 THEN
244: RETURN FND_API.G_TRUE;
245: ELSE
246: RETURN FND_API.G_FALSE;
247: END IF;
248: EXCEPTION
242: and status<>'I';
243: IF l_company_rel_count < 2 THEN
244: RETURN FND_API.G_TRUE;
245: ELSE
246: RETURN FND_API.G_FALSE;
247: END IF;
248: EXCEPTION
249: WHEN NO_DATA_FOUND THEN
250: -- must be B2C
247: END IF;
248: EXCEPTION
249: WHEN NO_DATA_FOUND THEN
250: -- must be B2C
251: RETURN FND_API.G_FALSE;
252: END;
253:
254:
255:
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:
294: IBE_UTIL.debug('Is a partial registration type');
295: CLOSE C_check_user_type;
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
299: WHEN NO_DATA_FOUND THEN
300: RETURN FND_API.G_FALSE;
296: RETURN FND_API.G_TRUE;
297:
298: EXCEPTION
299: WHEN NO_DATA_FOUND THEN
300: RETURN FND_API.G_FALSE;
301: WHEN OTHERS THEN
302: RETURN FND_API.G_FALSE;
303: END;
304:
298: EXCEPTION
299: WHEN NO_DATA_FOUND THEN
300: RETURN FND_API.G_FALSE;
301: WHEN OTHERS THEN
302: RETURN FND_API.G_FALSE;
303: END;
304:
305:
306:
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:
345: IBE_UTIL.debug('Is a partner registration type');
346: CLOSE C_check_user_type;
343: END IF;
344:
345: IBE_UTIL.debug('Is a partner registration type');
346: CLOSE C_check_user_type;
347: RETURN FND_API.G_TRUE;
348:
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351: RETURN FND_API.G_FALSE;
347: RETURN FND_API.G_TRUE;
348:
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351: RETURN FND_API.G_FALSE;
352: WHEN OTHERS THEN
353: RETURN FND_API.G_FALSE;
354: END;
355:
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351: RETURN FND_API.G_FALSE;
352: WHEN OTHERS THEN
353: RETURN FND_API.G_FALSE;
354: END;
355:
356:
357: