DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on FND_OAM_USER_INFO

Line 1099: FND_OAM_USER_INFO.HZ_PARTY_NAME_TO_ID(x_person_party_name,

1095:
1096: /* PARTY */
1097: l_person_party_id := null;
1098: begin
1099: FND_OAM_USER_INFO.HZ_PARTY_NAME_TO_ID(x_person_party_name,
1100: l_person_party_id,
1101: l_party_type);
1102: exception
1103: when no_data_found then

Line 2797: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(my_partyid, ptyName, l_party_type);

2793: -- end bug 4318754
2794:
2795: -- begin 2850261
2796: begin
2797: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(my_partyid, ptyName, l_party_type);
2798: exception
2799: when no_data_found then
2800: ptyName := p_user_name;
2801: end;

Line 3195: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_customer_id,

3191: -- *** Derive party for customer_id ***
3192: if (l_customer_id is not NULL) then
3193: -- Get party type of current customer_id
3194: begin
3195: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_customer_id,
3196: l_party_name, l_party_type);
3197: exception
3198: when no_data_found then
3199: if (log_exception = 'Y') then

Line 3221: FND_OAM_USER_INFO.GET_ORGANIZATION_ID(l_customer_id);

3217: -- This is a relationship party. Get the person_party
3218: -- associated with this relationship as the party_id
3219: begin
3220: l_cust_person_party_id :=
3221: FND_OAM_USER_INFO.GET_ORGANIZATION_ID(l_customer_id);
3222: exception
3223: when no_data_found then
3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');

Line 3273: l_emp_person_party_id := FND_OAM_USER_INFO.GET_PARTY_ID(l_employee_id);

3269: */
3270:
3271: -- Modified above SQL for bug 3094664
3272:
3273: l_emp_person_party_id := FND_OAM_USER_INFO.GET_PARTY_ID(l_employee_id);
3274: exception
3275: when no_data_found then
3276: if (log_exception = 'Y') then
3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');

Line 3298: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_cust_person_party_id,

3294: -- Both found, check for mismatch
3295: if (l_cust_person_party_id <> l_emp_person_party_id) then
3296: if (log_exception = 'Y') then
3297: begin
3298: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_cust_person_party_id,
3299: l_cust_person_party_name,
3300: l_party_type);
3301: exception
3302: when no_data_found then

Line 3315: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_emp_person_party_id,

3311: app_exception.raise_exception;
3312: end;
3313:
3314: begin
3315: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_emp_person_party_id,
3316: l_emp_person_party_name,
3317: l_party_type);
3318: exception
3319: when no_data_found then

Line 3405: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_person_party_id,

3401:
3402: -- Validate person_party_id is correct type
3403: if (l_person_party_id is not null) then
3404: begin
3405: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_person_party_id,
3406: l_person_party_name,
3407: l_party_type);
3408: exception
3409: when no_data_found then