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.JTF_UM_BUSINESS_USER_PVT dependencies on FND_API

Line 38: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

34: */
35: Procedure RegisterBusinessUser
36: (
37: P_Api_Version_Number IN NUMBER,
38: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
39: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
40: P_self_service_user IN VARCHAR2 := FND_API.G_FALSE,
41: P_um_person_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Person_Rec_type,
42: P_um_organization_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Organization_Rec_type,

Line 39: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

35: Procedure RegisterBusinessUser
36: (
37: P_Api_Version_Number IN NUMBER,
38: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
39: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
40: P_self_service_user IN VARCHAR2 := FND_API.G_FALSE,
41: P_um_person_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Person_Rec_type,
42: P_um_organization_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Organization_Rec_type,
43: X_Return_Status out NOCOPY VARCHAR2,

Line 40: P_self_service_user IN VARCHAR2 := FND_API.G_FALSE,

36: (
37: P_Api_Version_Number IN NUMBER,
38: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
39: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
40: P_self_service_user IN VARCHAR2 := FND_API.G_FALSE,
41: P_um_person_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Person_Rec_type,
42: P_um_organization_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Organization_Rec_type,
43: X_Return_Status out NOCOPY VARCHAR2,
44: X_Msg_Count out NOCOPY NUMBER,

Line 75: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME ) THEN

71: p_message => l_api_name);
72: -- Standard Start of API savepoint
73: SAVEPOINT RegisterBusinessUser;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME ) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: -- Standard Start of API savepoint
73: SAVEPOINT RegisterBusinessUser;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME ) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN
80: FND_MSG_PUB.initialize;

Line 79: IF FND_API.to_Boolean( p_init_msg_list ) THEN

75: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME ) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82: -- Initialize API return status to success
83: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 83: x_return_status := FND_API.G_RET_STS_SUCCESS;

79: IF FND_API.to_Boolean( p_init_msg_list ) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82: -- Initialize API return status to success
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84: --
85: -- API body
86: --
87: -- creating a person in TCA schema

Line 102: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

98: x_profile_id => l_profile_id,
99: x_return_status => X_Return_Status,
100: x_msg_count => X_Msg_Count,
101: x_msg_data => X_Msg_Data);
102: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: end if;
105: IF ( P_um_organization_Rec.organization_number is null ) then
106: --l_check_existing_org_option := nvl(fnd_profile.get('JTF_CHECK_EXISTING_ORG', l_check_existing_org_option ), l_check_existing_org_option );

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: x_return_status => X_Return_Status,
100: x_msg_count => X_Msg_Count,
101: x_msg_data => X_Msg_Data);
102: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: end if;
105: IF ( P_um_organization_Rec.organization_number is null ) then
106: --l_check_existing_org_option := nvl(fnd_profile.get('JTF_CHECK_EXISTING_ORG', l_check_existing_org_option ), l_check_existing_org_option );
107: l_create_organization := true;

Line 124: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

120: P_um_organization_Rec => P_um_organization_Rec,
121: X_Return_Status => X_Return_Status,
122: X_Msg_Count => X_Msg_Count,
123: X_Msg_data => X_Msg_data );
124: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: end if;
127: end if;
128: else

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: X_Return_Status => X_Return_Status,
122: X_Msg_Count => X_Msg_Count,
123: X_Msg_data => X_Msg_data );
124: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: end if;
127: end if;
128: else
129: Create_Organization(

Line 138: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

134: P_um_organization_Rec => P_um_organization_Rec,
135: X_Return_Status => X_Return_Status,
136: X_Msg_Count => X_Msg_Count,
137: X_Msg_data => X_Msg_data );
138: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: end if;
141: end if;
142: ELSE

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: X_Return_Status => X_Return_Status,
136: X_Msg_Count => X_Msg_Count,
137: X_Msg_data => X_Msg_data );
138: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: end if;
141: end if;
142: ELSE
143: l_search_value := P_um_organization_Rec.organization_number;

Line 150: RAISE FND_API.G_EXC_ERROR;

146: p_search_value => l_search_value,
147: p_use_name => false ) ) then
148: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_ORGANIZATION_NOT_FOUND');
149: FND_MSG_PUB.ADD;
150: RAISE FND_API.G_EXC_ERROR;
151: end if;
152: END IF;
153: --l_party_rel_rec.party_rec.total_num_of_orders := 0;
154: l_party_rel_rec.subject_id := p_um_person_rec.party_id;

Line 179: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

175: x_return_status => X_Return_Status,
176: x_msg_count => X_Msg_Count,
177: x_msg_data => X_Msg_data
178: );
179: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: end if;
182: /*if ( l_create_organization ) then
183: --JTF_UM_USERTYPE_CREDENTIALS.ASSIGN_ACCOUNT(P_um_organization_Rec.org_contact_party_id, 'PRIMARYUSERNEW', P_um_organization_Rec.org_party_id );

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176: x_msg_count => X_Msg_Count,
177: x_msg_data => X_Msg_data
178: );
179: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: end if;
182: /*if ( l_create_organization ) then
183: --JTF_UM_USERTYPE_CREDENTIALS.ASSIGN_ACCOUNT(P_um_organization_Rec.org_contact_party_id, 'PRIMARYUSERNEW', P_um_organization_Rec.org_party_id );
184: -- should send l_party_id as the param which is the

Line 190: if (p_self_service_user = FND_API.G_TRUE) then

186: end if;
187: */
188: -- if it is a self service user then set the password date to sysdate so
189: -- that the user is not prompted at the first logon
190: if (p_self_service_user = FND_API.G_TRUE) then
191: l_password_date := sysdate;
192: end if;
193: --Start Changes for Reserve-Release User Name: 3899304
194: /*

Line 255: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

251: x_contact_point_id => l_contact_point_id,
252: x_return_status => X_Return_Status,
253: x_msg_count => X_Msg_Count,
254: x_msg_data => X_Msg_Data );
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,

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: x_return_status => X_Return_Status,
253: x_msg_count => X_Msg_Count,
254: x_msg_data => X_Msg_Data );
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');

Line 279: --p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

275: l_contact_preference_rec.requested_by := 'PARTY';
276: l_contact_preference_rec.created_by_module := G_CREATED_BY_MODULE;
277: l_contact_preference_rec.application_id := 690;
278: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(
279: --p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
280: p_contact_preference_rec => l_contact_preference_rec,
281: x_contact_preference_id => l_contact_preference_id,
282: x_return_status => x_return_status,
283: x_msg_count => x_msg_count,

Line 290: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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;
292: end if;
293: -- Standard check for p_commit
294: IF FND_API.to_Boolean( p_commit )

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
292: end if;
293: -- Standard check for p_commit
294: IF FND_API.to_Boolean( p_commit )
295: THEN

Line 294: IF FND_API.to_Boolean( p_commit )

290: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: end if;
293: -- Standard check for p_commit
294: IF FND_API.to_Boolean( p_commit )
295: THEN
296: COMMIT WORK;
297: END IF;
298: -- Standard call to get message count and if count is 1, get message info.

Line 306: WHEN FND_API.G_EXC_ERROR THEN

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

Line 316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

312: ,P_SQLERRM => SQLERRM
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

Line 360: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

356: */
357: Procedure Create_Organization
358: (
359: P_Api_Version_Number IN NUMBER,
360: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
361: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
362: P_um_person_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Person_Rec_type,
363: P_um_organization_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Organization_Rec_type,
364: X_Return_Status out NOCOPY VARCHAR2,

Line 361: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

357: Procedure Create_Organization
358: (
359: P_Api_Version_Number IN NUMBER,
360: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
361: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
362: P_um_person_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Person_Rec_type,
363: P_um_organization_Rec IN out NOCOPY JTF_UM_REGISTER_USER_PVT.Organization_Rec_type,
364: X_Return_Status out NOCOPY VARCHAR2,
365: X_Msg_Count out NOCOPY NUMBER,

Line 387: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME )

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 )
388: THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 )
388: THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list ) THEN
393: FND_MSG_PUB.initialize;

Line 392: IF FND_API.to_Boolean( p_init_msg_list ) THEN

388: THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list ) THEN
393: FND_MSG_PUB.initialize;
394: END IF;
395: -- Initialize API return status to success
396: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 396: x_return_status := FND_API.G_RET_STS_SUCCESS;

392: IF FND_API.to_Boolean( p_init_msg_list ) THEN
393: FND_MSG_PUB.initialize;
394: END IF;
395: -- Initialize API return status to success
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397: --
398: -- API body
399: --
400: l_HzOrganizationRec.organization_name := P_um_organization_Rec.organization_name;

Line 413: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

409: x_party_id => P_um_organization_Rec.org_party_id,
410: x_party_number => P_um_organization_Rec.organization_number, --check to see if this is null or not, if null get nextval from HZ_GENERATE_PARTY_NUMBER
411: x_profile_id => l_profile_id
412: );
413: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: end if;
416: l_location_rec.address1 := P_um_organization_Rec.address1;
417: l_location_rec.address2 := P_um_organization_Rec.address2;

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410: x_party_number => P_um_organization_Rec.organization_number, --check to see if this is null or not, if null get nextval from HZ_GENERATE_PARTY_NUMBER
411: x_profile_id => l_profile_id
412: );
413: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: end if;
416: l_location_rec.address1 := P_um_organization_Rec.address1;
417: l_location_rec.address2 := P_um_organization_Rec.address2;
418: l_location_rec.address3 := P_um_organization_Rec.address3;

Line 436: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

432: x_location_id => l_location_id,
433: x_return_status => X_Return_Status,
434: x_msg_count => X_Msg_Count,
435: x_msg_data => X_Msg_data );
436: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: end if;
439: l_party_site_rec.location_id := l_location_id;
440: l_party_site_rec.party_id := P_um_organization_Rec.org_party_id;

Line 437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

433: x_return_status => X_Return_Status,
434: x_msg_count => X_Msg_Count,
435: x_msg_data => X_Msg_data );
436: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: end if;
439: l_party_site_rec.location_id := l_location_id;
440: l_party_site_rec.party_id := P_um_organization_Rec.org_party_id;
441: l_party_site_rec.created_by_module := G_CREATED_BY_MODULE;

Line 451: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

447: x_party_site_number => l_party_site_number,
448: x_return_status => X_Return_Status,
449: x_msg_count => X_Msg_Count,
450: x_msg_data => X_Msg_data );
451: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: end if;
454: l_contact_point_rec.status := 'A';
455: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

448: x_return_status => X_Return_Status,
449: x_msg_count => X_Msg_Count,
450: x_msg_data => X_Msg_data );
451: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: end if;
454: l_contact_point_rec.status := 'A';
455: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
456: l_contact_point_rec.owner_table_id := P_um_organization_Rec.org_party_id;

Line 473: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

469: x_contact_point_id => l_contact_point_id,
470: x_return_status => X_Return_Status,
471: x_msg_count => X_Msg_Count,
472: x_msg_data => X_Msg_Data );
473: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: end if;
476: end if;
477: l_contact_point_rec.primary_flag := 'N';

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: x_return_status => X_Return_Status,
471: x_msg_count => X_Msg_Count,
472: x_msg_data => X_Msg_Data );
473: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: end if;
476: end if;
477: l_contact_point_rec.primary_flag := 'N';
478: if ( p_um_organization_rec.fax_number is not NULL ) then

Line 491: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

487: x_contact_point_id => l_contact_point_id,
488: x_return_status => X_Return_Status,
489: x_msg_count => X_Msg_Count,
490: x_msg_data => X_Msg_Data );
491: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: end if;
494: end if;
495: -- Standard check for p_commit

Line 492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

488: x_return_status => X_Return_Status,
489: x_msg_count => X_Msg_Count,
490: x_msg_data => X_Msg_Data );
491: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: end if;
494: end if;
495: -- Standard check for p_commit
496: IF FND_API.to_Boolean( p_commit )

Line 496: IF FND_API.to_Boolean( p_commit )

492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: end if;
494: end if;
495: -- Standard check for p_commit
496: IF FND_API.to_Boolean( p_commit )
497: THEN
498: COMMIT WORK;
499: END IF;
500: -- Standard call to get message count and if count is 1, get message info.