[Home] [Help]
1531: l_msg_count number;
1532: l_msg_data varchar2 (280);
1533: l_formatted_name varchar2 (300);
1534: l_formatted_lines_cnt number;
1535: l_formatted_name_tbl hz_format_pub.string_tbl_type;
1536:
1537: l_ad_hoc_role WF_ACTIVITY_ATTRIBUTES.text_default%type;
1538:
1539: BEGIN
1592:
1593: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1594: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1595: 'fnd.plsql.UMXUTILB.createadhocrole',
1596: 'calling hz_format_pub.format_name with ' ||
1597: 'p_person_first_name=>' || l_person_first_name ||
1598: ', p_person_middle_name=>' || l_person_middle_name ||
1599: ', p_person_last_name=>' || l_person_last_name ||
1600: ', p_person_title=>' || l_prefix ||
1600: ', p_person_title=>' || l_prefix ||
1601: ', and p_person_name_suffix=>' || l_suffix);
1602: end if;
1603:
1604: hz_format_pub.format_name (
1605: p_person_first_name => l_person_first_name ,
1606: p_person_middle_name => l_person_middle_name,
1607: p_person_last_name => l_person_last_name,
1608: p_person_title => l_prefix,
1616:
1617: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1618: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1619: 'fnd.plsql.UMXUTILB.createadhocrole',
1620: 'Done calling hz_format_pub.format_name with ' ||
1621: 'x_return_status=>' || l_return_status ||
1622: ', x_msg_count=>' || l_msg_data ||
1623: ', x_formatted_name=>' || l_formatted_name ||
1624: ', x_formatted_lines_cnt=>' || l_formatted_lines_cnt);
1625: end if;
1626:
1627: l_ad_hoc_role := '~UMX_' || item_key;
1628:
1629: -- We don't care if hz_format_pub fails, just create a formatted name
1630: -- with first name and last name.
1631: if (l_formatted_name is null) then
1632: l_formatted_name := l_person_first_name || ' ' || l_person_last_name;
1633: end if;