1252: * DESCRIPTION
1253: * Creates person profile.
1254: *
1255: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1256: * hz_person_profiles_pkg.Insert_Row
1257: *
1258: * ARGUMENTS
1259: * IN:
1260: * p_party_id
1299:
1300: -- Debug info.
1301: /*IF g_debug THEN
1302: hz_utility_v2pub.debug (
1303: 'hz_person_profiles_pkg.Insert_Row (+)', l_debug_prefix);
1304: END IF;
1305: */
1306:
1307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1304: END IF;
1305: */
1306:
1307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1308: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (+)',
1309: p_msg_level=>fnd_log.level_procedure);
1310: END IF;
1311:
1312: -- call table-handler.
1309: p_msg_level=>fnd_log.level_procedure);
1310: END IF;
1311:
1312: -- call table-handler.
1313: HZ_person_profiles_pkg.Insert_Row (
1314: x_rowid => l_rowid,
1315: x_person_profile_id => l_person_profile_id,
1316: x_party_id => p_party_id,
1317: x_person_name => do_create_person_name(p_person_rec),
1388:
1389: -- Debug info.
1390: /*IF g_debug THEN
1391: hz_utility_v2pub.debug (
1392: 'hz_person_profiles_pkg.Insert_Row (-) ' ||
1393: 'x_profile_id = ' || x_profile_id, l_debug_prefix);
1394: END IF;
1395: */
1396:
1394: END IF;
1395: */
1396:
1397: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1398: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (-) '||'x_profile_id = ' || x_profile_id,
1399: p_msg_level=>fnd_log.level_procedure);
1400: END IF;
1401:
1402: -- Debug info.
1417: * DESCRIPTION
1418: * Updates person profile.
1419: *
1420: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1421: * hz_person_profiles_pkg.Update_Row
1422: *
1423: * ARGUMENTS
1424: * IN:
1425: * p_data_source_type
1608: -- Debug info.
1609: /*IF g_debug THEN
1610: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
1611: hz_utility_v2pub.debug (
1612: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1613: END IF;
1614: */
1615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1616: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',
1612: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1613: END IF;
1614: */
1615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1616: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',
1617: p_msg_level=>fnd_log.level_procedure);
1618: END IF;
1619: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1620: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,
1622: p_msg_level=>fnd_log.level_statement);
1623: END IF;
1624:
1625: -- call table-handler.
1626: HZ_person_profiles_pkg.Update_Row (
1627: x_rowid => l_rowid,
1628: x_person_profile_id => x_profile_id,
1629: x_party_id => null,
1630: x_person_name => l_person_name,
1698:
1699: -- Debug info.
1700: /*IF g_debug THEN
1701: hz_utility_v2pub.debug (
1702: 'hz_person_profiles_pkg.Update_Row (-) ',
1703: l_debug_prefix);
1704: END IF;
1705: */
1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: l_debug_prefix);
1704: END IF;
1705: */
1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1707: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (-)',
1708: p_msg_level=>fnd_log.level_procedure);
1709:
1710: END IF;
1711:
7295: * DESCRIPTION
7296: * Gets person record.
7297: *
7298: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
7299: * hz_person_profiles_pkg.Select_Row
7300: *
7301: * ARGUMENTS
7302: * IN:
7303: * p_init_msg_list Initialize message stack if it is set to
7425: fnd_msg_pub.add;
7426: RAISE fnd_api.g_exc_error;
7427: END IF;
7428:
7429: HZ_person_profiles_pkg.Select_Row (
7430: x_person_profile_id => l_profile_id,
7431: x_party_id => l_party_id,
7432: x_attribute_category => x_person_rec.attribute_category,
7433: x_attribute1 => x_person_rec.attribute1,