DBA Data[Home] [Help]

APPS.IBE_JTA_INTEGRATION_GRP dependencies on FND_API

Line 35: l_change_org_status VARCHAR2(240):=FND_API.G_FALSE;

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);

Line 101: If l_usertype_partial = FND_API.G_TRUE 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
104: -- Get the party_id corresponding to the l_Userreg_id
105: /*

Line 134: p_commit=>FND_API.G_TRUE,

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: ) ;

Line 142: If l_return_status = FND_API.G_RET_STS_ERROR Then

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';

Line 157: If l_usertype_partner = FND_API.G_TRUE Then

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);

Line 178: If x_prm_return_status = FND_API.G_FALSE Then

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);

Line 202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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';

Line 244: RETURN FND_API.G_TRUE;

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

Line 246: RETURN FND_API.G_FALSE;

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

Line 251: RETURN FND_API.G_FALSE;

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:

Line 291: RETURN FND_API.G_FALSE;

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;

Line 296: RETURN FND_API.G_TRUE;

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;

Line 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:

Line 302: RETURN FND_API.G_FALSE;

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:

Line 342: RETURN FND_API.G_FALSE;

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;

Line 347: RETURN FND_API.G_TRUE;

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;

Line 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:

Line 353: RETURN FND_API.G_FALSE;

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: