DBA Data[Home] [Help]

APPS.JTF_UM_BUSINESS_USER_PVT dependencies on JTF_DEBUG_PUB

Line 12: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(G_MODULE);

8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'JTFVUBRB.pls';
9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
11: G_MODULE VARCHAR2(40) := 'JTF.UM.PLSQL.REGBUSINESSUSER';
12: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(G_MODULE);
13: NEWLINE VARCHAR2(1) := fnd_global.newline;
14: G_CREATED_BY_MODULE VARCHAR2(20):= 'JTA_USER_MANAGEMENT';
15: /**
16: * Procedure : RegisterBusinessUser

Line 70: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => G_MODULE,

66: l_create_organization boolean := false;
67: l_privacy_preference varchar2(5);
68: cursor c_user_id(p_user_name in varchar2) is select user_id from fnd_user where user_name = p_user_name;
69: BEGIN
70: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => G_MODULE,
71: p_message => l_api_name);
72: -- Standard Start of API savepoint
73: SAVEPOINT RegisterBusinessUser;
74: -- Standard call to check for call compatibility.

Line 88: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_PARTY_V2PUB.create_person with first and last name');

84: --
85: -- API body
86: --
87: -- creating a person in TCA schema
88: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_PARTY_V2PUB.create_person with first and last name');
89: l_person_rec.person_first_name := P_um_person_Rec.first_name;
90: l_person_rec.person_last_name := P_um_person_Rec.last_name;
91: l_person_rec.created_by_module := G_CREATED_BY_MODULE;
92: l_person_rec.application_id := 690;

Line 259: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE,

255: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: end if;
258: end if;
259: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE,
260: p_message => 'invoking JTF_UM_USERTYPE_CREDENTIALS.ASSIGN_ACCOUNT with party id ' || p_um_person_rec.party_id || ' usertypekey INDIVIDUALUSER');
261: --JTF_UM_USERTYPE_CREDENTIALS.ASSIGN_ACCOUNT(p_um_person_rec.party_id, 'BUSINESSUSER');
262: if (l_privacy_preference = 'YES') then
263: l_contact_preference_rec.preference_code := 'DO';

Line 269: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE,

265: l_contact_preference_rec.preference_code := 'DO_NOT';
266: end if;
267: -- call Hz_contact_preference api to populate the
268: -- preference to recieve marketing/promotion mails
269: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE,
270: p_message => 'invoking HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference for creating preference of receiving email preference:'||l_privacy_preference);
271: l_contact_preference_rec.contact_level_table := 'HZ_PARTIES';
272: -- populate contact level id with l_party_id which is the relationship_id
273: l_contact_preference_rec.contact_level_table_id := l_party_id;

Line 287: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => G_MODULE,

283: x_msg_count => x_msg_count,
284: x_msg_data => x_msg_data
285: );
286: if l_is_debug_parameter_on then
287: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => G_MODULE,
288: p_message => 'create contact preferece'||' l_cont_preference_id:'||l_contact_preference_id || ' returnStatus:'||x_return_status);
289: end if;
290: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 302: JTF_DEBUG_PUB.LOG_EXITING_METHOD(

298: -- Standard call to get message count and if count is 1, get message info.
299: FND_MSG_PUB.Count_And_Get(
300: p_count => x_msg_count,
301: p_data => x_msg_data);
302: JTF_DEBUG_PUB.LOG_EXITING_METHOD(
303: p_module => G_MODULE,
304: p_message => l_api_name);
305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN

Line 307: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(

303: p_module => G_MODULE,
304: p_message => l_api_name);
305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN
307: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
308: P_API_NAME => L_API_NAME
309: ,P_PKG_NAME => G_PKG_NAME
310: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
311: ,P_SQLCODE => SQLCODE

Line 317: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(

313: ,X_MSG_COUNT => X_MSG_COUNT
314: ,X_MSG_DATA => X_MSG_DATA
315: ,X_RETURN_STATUS => X_RETURN_STATUS);
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
318: P_API_NAME => L_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
321: ,P_SQLCODE => SQLCODE

Line 327: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(

323: ,X_MSG_COUNT => X_MSG_COUNT
324: ,X_MSG_DATA => X_MSG_DATA
325: ,X_RETURN_STATUS => X_RETURN_STATUS);
326: WHEN OTHERS THEN
327: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
328: P_API_NAME => L_API_NAME
329: ,P_PKG_NAME => G_PKG_NAME
330: ,P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS
331: ,P_SQLCODE => SQLCODE

Line 330: ,P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS

326: WHEN OTHERS THEN
327: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
328: P_API_NAME => L_API_NAME
329: ,P_PKG_NAME => G_PKG_NAME
330: ,P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS
331: ,P_SQLCODE => SQLCODE
332: ,P_SQLERRM => SQLERRM
333: ,X_MSG_COUNT => X_MSG_COUNT
334: ,X_MSG_DATA => X_MSG_DATA

Line 383: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => G_MODULE, p_message => l_api_name);

379: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
380: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
381: l_api_name varchar2(50) := 'Create_Organization';
382: BEGIN
383: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => G_MODULE, p_message => l_api_name);
384: -- Standard Start of API savepoint
385: SAVEPOINT create_organization;
386: -- Standard call to check for call compatibility.
387: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME )

Line 465: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');

461: l_contact_point_rec.contact_point_type := 'PHONE';
462: l_phone_rec.phone_area_code := nvl( P_um_organization_Rec.phone_area_code, '' );
463: l_phone_rec.phone_number := P_um_organization_Rec.phone_number;
464: l_phone_rec.phone_line_type := 'GEN';
465: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');
466: HZ_CONTACT_POINT_V2PUB.create_contact_point (
467: p_contact_point_rec => l_contact_point_rec,
468: p_phone_rec => l_phone_rec,
469: x_contact_point_id => l_contact_point_id,

Line 483: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');

479: l_contact_point_rec.contact_point_type := 'PHONE';
480: l_phone_rec.phone_area_code := nvl( P_um_organization_Rec.fax_area_code, '' );
481: l_phone_rec.phone_number := P_um_organization_Rec.fax_number;
482: l_phone_rec.phone_line_type := 'FAX';
483: JTF_DEBUG_PUB. LOG_EVENT( p_module => G_MODULE, p_message => 'invoking HZ_CONTACT_POINT_V2PUB.create_contact_point for creating phone');
484: HZ_CONTACT_POINT_V2PUB.create_contact_point (
485: p_contact_point_rec => l_contact_point_rec,
486: p_phone_rec => l_phone_rec,
487: x_contact_point_id => l_contact_point_id,

Line 504: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => G_MODULE,

500: -- Standard call to get message count and if count is 1, get message info.
501: FND_MSG_PUB.Count_And_Get(
502: p_count => x_msg_count,
503: p_data => x_msg_data);
504: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => G_MODULE,
505: p_message => l_api_name);
506: END Create_Organization;
507: /**
508: * Procedure : Find_Organization