DBA Data[Home] [Help]

APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_UTILITY_V2PUB

Line 153: * HZ_UTILITY_V2PUB.enable_debug

149: * DESCRIPTION
150: * Turn on debug mode.
151: *
152: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
153: * HZ_UTILITY_V2PUB.enable_debug
154: *
155: * MODIFICATION HISTORY
156: *
157: * 07-23-2001 Jianying Huang o Created.

Line 169: HZ_UTILITY_V2PUB.enable_debug;

165: IF G_DEBUG_COUNT = 1 THEN
166: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
167: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
168: THEN
169: HZ_UTILITY_V2PUB.enable_debug;
170: G_DEBUG := TRUE;
171: END IF;
172: END IF;
173: END enable_debug;

Line 183: * HZ_UTILITY_V2PUB.disable_debug

179: * DESCRIPTION
180: * Turn off debug mode.
181: *
182: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
183: * HZ_UTILITY_V2PUB.disable_debug
184: *
185: * MODIFICATION HISTORY
186: *
187: * 07-23-2001 Jianying Huang o Created.

Line 197: HZ_UTILITY_V2PUB.disable_debug;

193: IF G_DEBUG THEN
194: G_DEBUG_COUNT := G_DEBUG_COUNT - 1;
195:
196: IF G_DEBUG_COUNT = 0 THEN
197: HZ_UTILITY_V2PUB.disable_debug;
198: G_DEBUG := FALSE;
199: END IF;
200: END IF;
201: END disable_debug;

Line 319: hz_utility_v2pub.debug(p_message=> 'do_AddEntityAttribute (+)',

315: BEGIN
316:
317: -- Debug info.
318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
319: hz_utility_v2pub.debug(p_message=> 'do_AddEntityAttribute (+)',
320: p_prefix=>l_debug_prefix,
321: p_msg_level=>fnd_log.level_procedure);
322: END IF;
323:

Line 414: hz_utility_v2pub.debug(p_message=>'do_AddEntityAttribute (-)',

410: END IF;
411:
412: -- Debug info.
413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug(p_message=>'do_AddEntityAttribute (-)',
415: p_prefix=>l_debug_prefix,
416: p_msg_level=>fnd_log.level_procedure);
417: END IF;
418:

Line 685: hz_utility_v2pub.debug(p_message=>'Validate_EntityAttribute (+)',

681: BEGIN
682:
683: -- Debug info.
684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
685: hz_utility_v2pub.debug(p_message=>'Validate_EntityAttribute (+)',
686: p_prefix=>l_debug_prefix,
687: p_msg_level=>fnd_log.level_procedure);
688: END IF;
689:

Line 696: hz_utility_v2pub.validate_mandatory (

692: --------------------------------------
693:
694: -- entity_name is mandatory field.
695:
696: hz_utility_v2pub.validate_mandatory (
697: p_create_update_flag => 'C',
698: p_column => 'entity_name',
699: p_column_value => p_entity_attribute_rec.entity_name,
700: x_return_status => x_return_status );

Line 707: hz_utility_v2pub.validate_lookup (

703:
704: IF p_entity_attribute_rec.entity_name IS NOT NULL AND
705: p_entity_attribute_rec.entity_name <> FND_API.G_MISS_CHAR
706: THEN
707: hz_utility_v2pub.validate_lookup (
708: p_column => 'entity_name',
709: p_lookup_type => 'ENTITY_NAME',
710: p_column_value => p_entity_attribute_rec.entity_name,
711: x_return_status => x_return_status );

Line 742: hz_utility_v2pub.validate_mandatory (

738: (G_ORG_ENTITY, G_PERSON_ENTITY)
739: THEN
740: -- attribute_name is mandatory field.
741:
742: hz_utility_v2pub.validate_mandatory (
743: p_create_update_flag => 'C',
744: p_column => 'attribute_name',
745: p_column_value => p_entity_attribute_rec.attribute_name,
746: x_return_status => x_return_status );

Line 758: hz_utility_v2pub.validate_lookup (

754: x_return_status => x_return_status );
755: /*
756: -- attribute must be a valid lookup code
757:
758: hz_utility_v2pub.validate_lookup (
759: p_column => 'attribute name',
760: p_lookup_type => p_entity_attribute_rec.entity_name,
761: p_column_value => p_entity_attribute_rec.attribute_name,
762: x_return_status => x_return_status );

Line 771: hz_utility_v2pub.validate_created_by_module(

767: --------------------------------------
768: -- validate created_by_module
769: --------------------------------------
770:
771: hz_utility_v2pub.validate_created_by_module(
772: p_create_update_flag => 'C',
773: p_created_by_module => p_entity_attribute_rec.created_by_module,
774: p_old_created_by_module => null,
775: x_return_status => x_return_status);

Line 801: hz_utility_v2pub.validate_lookup (

797: fnd_msg_pub.add;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: ELSE
800: /*
801: hz_utility_v2pub.validate_lookup (
802: p_column => 'data source',
803: p_lookup_type => 'CONTENT_SOURCE_TYPE',
804: p_column_value => p_data_source_tab(i),
805: x_return_status => x_return_status );

Line 842: hz_utility_v2pub.debug(p_message=>'Validate_EntityAttribute (-)',

838: END IF;
839:
840: -- Debug info.
841: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
842: hz_utility_v2pub.debug(p_message=>'Validate_EntityAttribute (-)',
843: p_prefix=>l_debug_prefix,
844: p_msg_level=>fnd_log.level_procedure);
845: END IF;
846:

Line 963: hz_utility_v2pub.debug(p_message=>'Validate_Attribute (+)',

959: BEGIN
960:
961: -- Debug info.
962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
963: hz_utility_v2pub.debug(p_message=>'Validate_Attribute (+)',
964: p_prefix=>l_debug_prefix,
965: p_msg_level=>fnd_log.level_procedure);
966: END IF;
967:

Line 968: l_apps_schema := hz_utility_v2pub.Get_AppsSchemaName;

964: p_prefix=>l_debug_prefix,
965: p_msg_level=>fnd_log.level_procedure);
966: END IF;
967:
968: l_apps_schema := hz_utility_v2pub.Get_AppsSchemaName;
969: l_ar_schema := hz_utility_v2pub.Get_SchemaName('AR');
970:
971: IF p_entity_name = G_ORG_ENTITY THEN
972: l_name := 'ORGANIZATION';

Line 969: l_ar_schema := hz_utility_v2pub.Get_SchemaName('AR');

965: p_msg_level=>fnd_log.level_procedure);
966: END IF;
967:
968: l_apps_schema := hz_utility_v2pub.Get_AppsSchemaName;
969: l_ar_schema := hz_utility_v2pub.Get_SchemaName('AR');
970:
971: IF p_entity_name = G_ORG_ENTITY THEN
972: l_name := 'ORGANIZATION';
973:

Line 1018: hz_utility_v2pub.debug(p_message=>'Validate_Attribute (-)' ,

1014: END IF;
1015:
1016: -- Debug info.
1017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1018: hz_utility_v2pub.debug(p_message=>'Validate_Attribute (-)' ,
1019: p_prefix=>l_debug_prefix,
1020: p_msg_level=>fnd_log.level_procedure);
1021: END IF;
1022:

Line 1061: hz_utility_v2pub.debug(p_message=>'getIndex (+)',

1057: BEGIN
1058:
1059: -- Debug info.
1060: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1061: hz_utility_v2pub.debug(p_message=>'getIndex (+)',
1062: p_prefix=>l_debug_prefix,
1063: p_msg_level=>fnd_log.level_procedure);
1064: END IF;
1065:

Line 1082: hz_utility_v2pub.debug(p_message=>'getIndex (-)',

1078: RETURN 0;
1079:
1080: -- Debug info.
1081: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1082: hz_utility_v2pub.debug(p_message=>'getIndex (-)',
1083: p_prefix=>l_debug_prefix,
1084: p_msg_level=>fnd_log.level_procedure);
1085: END IF;
1086:

Line 1142: hz_utility_v2pub.debug(p_message=>'db_InsertEntityAttribute (+)',

1138: BEGIN
1139:
1140: -- Debug info.
1141: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1142: hz_utility_v2pub.debug(p_message=>'db_InsertEntityAttribute (+)',
1143: p_prefix=>l_debug_prefix,
1144: p_msg_level=>fnd_log.level_procedure);
1145: END IF;
1146:

Line 1172: hz_utility_v2pub.created_by,

1168: DECODE(p_entity_attribute_rec.created_by_module,
1169: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.created_by_module),
1170: DECODE(p_entity_attribute_rec.application_id,
1171: FND_API.G_MISS_NUM, NULL, p_entity_attribute_rec.application_id),
1172: hz_utility_v2pub.created_by,
1173: SYSDATE,
1174: hz_utility_v2pub.last_update_login,
1175: SYSDATE,
1176: hz_utility_v2pub.last_updated_by )

Line 1174: hz_utility_v2pub.last_update_login,

1170: DECODE(p_entity_attribute_rec.application_id,
1171: FND_API.G_MISS_NUM, NULL, p_entity_attribute_rec.application_id),
1172: hz_utility_v2pub.created_by,
1173: SYSDATE,
1174: hz_utility_v2pub.last_update_login,
1175: SYSDATE,
1176: hz_utility_v2pub.last_updated_by )
1177: RETURNING entity_attr_id INTO x_entity_attr_id;
1178:

Line 1176: hz_utility_v2pub.last_updated_by )

1172: hz_utility_v2pub.created_by,
1173: SYSDATE,
1174: hz_utility_v2pub.last_update_login,
1175: SYSDATE,
1176: hz_utility_v2pub.last_updated_by )
1177: RETURNING entity_attr_id INTO x_entity_attr_id;
1178:
1179: /*
1180: OPEN c_user_overwrite_rule;

Line 1199: hz_utility_v2pub.created_by,

1195: i_rule_id(i),
1196: x_entity_attr_id,
1197: -- by default, user can overwrite third party data.
1198: 'Y',
1199: hz_utility_v2pub.created_by,
1200: SYSDATE,
1201: hz_utility_v2pub.last_update_login,
1202: SYSDATE,
1203: hz_utility_v2pub.last_updated_by );

Line 1201: hz_utility_v2pub.last_update_login,

1197: -- by default, user can overwrite third party data.
1198: 'Y',
1199: hz_utility_v2pub.created_by,
1200: SYSDATE,
1201: hz_utility_v2pub.last_update_login,
1202: SYSDATE,
1203: hz_utility_v2pub.last_updated_by );
1204: */
1205: /*

Line 1203: hz_utility_v2pub.last_updated_by );

1199: hz_utility_v2pub.created_by,
1200: SYSDATE,
1201: hz_utility_v2pub.last_update_login,
1202: SYSDATE,
1203: hz_utility_v2pub.last_updated_by );
1204: */
1205: /*
1206: OPEN c_third_party_rule;
1207: FETCH c_third_party_rule INTO l_dummy;

Line 1227: hz_utility_v2pub.created_by,

1223: VALUES (
1224: x_entity_attr_id,
1225: -- by default, third party can not overwrite user data.
1226: 'N',
1227: hz_utility_v2pub.created_by,
1228: SYSDATE,
1229: hz_utility_v2pub.last_update_login,
1230: SYSDATE,
1231: hz_utility_v2pub.last_updated_by

Line 1229: hz_utility_v2pub.last_update_login,

1225: -- by default, third party can not overwrite user data.
1226: 'N',
1227: hz_utility_v2pub.created_by,
1228: SYSDATE,
1229: hz_utility_v2pub.last_update_login,
1230: SYSDATE,
1231: hz_utility_v2pub.last_updated_by
1232: );
1233: END IF;

Line 1231: hz_utility_v2pub.last_updated_by

1227: hz_utility_v2pub.created_by,
1228: SYSDATE,
1229: hz_utility_v2pub.last_update_login,
1230: SYSDATE,
1231: hz_utility_v2pub.last_updated_by
1232: );
1233: END IF;
1234: */
1235: -- Debug info.

Line 1237: hz_utility_v2pub.debug(p_message=>'db_InsertEntityAttribute (-)',

1233: END IF;
1234: */
1235: -- Debug info.
1236: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1237: hz_utility_v2pub.debug(p_message=>'db_InsertEntityAttribute (-)',
1238: p_prefix=>l_debug_prefix,
1239: p_msg_level=>fnd_log.level_procedure);
1240: END IF;
1241:

Line 1280: hz_utility_v2pub.debug(p_message=>'db_InsertDataSource (+)',

1276: BEGIN
1277:
1278: -- Debug info.
1279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1280: hz_utility_v2pub.debug(p_message=>'db_InsertDataSource (+)',
1281: p_prefix=>l_debug_prefix,
1282: p_msg_level=>fnd_log.level_procedure);
1283: END IF;
1284:

Line 1305: hz_utility_v2pub.created_by,

1301: DECODE(p_new_item_flag,
1302: 'Y', DECODE(p_data_source_tab(i), 'USER_ENTERED', 1, 0),
1303: 'O',1, -- For other entities.
1304: 0),
1305: hz_utility_v2pub.created_by,
1306: SYSDATE,
1307: hz_utility_v2pub.last_update_login,
1308: SYSDATE,
1309: hz_utility_v2pub.last_updated_by

Line 1307: hz_utility_v2pub.last_update_login,

1303: 'O',1, -- For other entities.
1304: 0),
1305: hz_utility_v2pub.created_by,
1306: SYSDATE,
1307: hz_utility_v2pub.last_update_login,
1308: SYSDATE,
1309: hz_utility_v2pub.last_updated_by
1310: FROM dual
1311: WHERE NOT EXISTS (

Line 1309: hz_utility_v2pub.last_updated_by

1305: hz_utility_v2pub.created_by,
1306: SYSDATE,
1307: hz_utility_v2pub.last_update_login,
1308: SYSDATE,
1309: hz_utility_v2pub.last_updated_by
1310: FROM dual
1311: WHERE NOT EXISTS (
1312: SELECT 'Y'
1313: FROM hz_select_data_sources source2

Line 1320: hz_utility_v2pub.debug(p_message=>'db_InsertDataSource (-)',

1316:
1317: -- Debug info.
1318:
1319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1320: hz_utility_v2pub.debug(p_message=>'db_InsertDataSource (-)',
1321: p_prefix=>l_debug_prefix,
1322: p_msg_level=>fnd_log.level_procedure);
1323: END IF;
1324:

Line 1382: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (+)',

1378: --enable_debug;
1379:
1380: -- Debug info.
1381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (+)',
1383: p_prefix=>l_debug_prefix,
1384: p_msg_level=>fnd_log.level_procedure);
1385: END IF;
1386:

Line 1410: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1406: p_data => x_msg_data );
1407:
1408: -- Debug info.
1409: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1410: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1411: p_msg_data=>x_msg_data,
1412: p_msg_type=>'WARNING',
1413: p_msg_level=>fnd_log.level_exception);
1414: END IF;

Line 1416: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (-)',

1412: p_msg_type=>'WARNING',
1413: p_msg_level=>fnd_log.level_exception);
1414: END IF;
1415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1416: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (-)',
1417: p_prefix=>l_debug_prefix,
1418: p_msg_level=>fnd_log.level_procedure);
1419: END IF;
1420:

Line 1436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1432: p_data => x_msg_data );
1433:
1434: -- Debug info.
1435: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1437: p_msg_data=>x_msg_data,
1438: p_msg_type=>'ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;

Line 1442: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (-)',

1438: p_msg_type=>'ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;
1441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1442: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (-)',
1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;
1446:

Line 1461: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1457: p_data => x_msg_data );
1458:
1459: -- Debug info.
1460: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1462: p_msg_data=>x_msg_data,
1463: p_msg_type=>'UNEXPECTED ERROR',
1464: p_msg_level=>fnd_log.level_error);
1465: END IF;

Line 1467: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (-)',

1463: p_msg_type=>'UNEXPECTED ERROR',
1464: p_msg_level=>fnd_log.level_error);
1465: END IF;
1466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1467: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (-)',
1468: p_prefix=>l_debug_prefix,
1469: p_msg_level=>fnd_log.level_procedure);
1470: END IF;
1471:

Line 1490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1486: p_data => x_msg_data );
1487:
1488: -- Debug info.
1489: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1491: p_msg_data=>x_msg_data,
1492: p_msg_type=>'SQL ERROR',
1493: p_msg_level=>fnd_log.level_error);
1494: END IF;

Line 1496: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (-)',

1492: p_msg_type=>'SQL ERROR',
1493: p_msg_level=>fnd_log.level_error);
1494: END IF;
1495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1496: hz_utility_v2pub.debug(p_message=>'Add_EntityAttribute (-)',
1497: p_prefix=>l_debug_prefix,
1498: p_msg_level=>fnd_log.level_procedure);
1499: END IF;
1500:

Line 1575: hz_utility_v2pub.debug(p_message=>'Get_EntityAttribute (+)',

1571:
1572: -- Debug info.
1573:
1574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1575: hz_utility_v2pub.debug(p_message=>'Get_EntityAttribute (+)',
1576: p_prefix=>l_debug_prefix,
1577: p_msg_level=>fnd_log.level_procedure);
1578: END IF;
1579:

Line 1618: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1614:
1615: -- Debug info.
1616:
1617: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1618: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1619: p_msg_data=>x_msg_data,
1620: p_msg_type=>'WARNING',
1621: p_msg_level=>fnd_log.level_exception);
1622: END IF;

Line 1624: hz_utility_v2pub.debug(p_message=>'Get_EntityAttribute (-)',

1620: p_msg_type=>'WARNING',
1621: p_msg_level=>fnd_log.level_exception);
1622: END IF;
1623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1624: hz_utility_v2pub.debug(p_message=>'Get_EntityAttribute (-)',
1625: p_prefix=>l_debug_prefix,
1626: p_msg_level=>fnd_log.level_procedure);
1627: END IF;
1628:

Line 1644: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1640: p_data => x_msg_data );
1641:
1642: -- Debug info.
1643: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1644: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1645: p_msg_data=>x_msg_data,
1646: p_msg_type=>'ERROR',
1647: p_msg_level=>fnd_log.level_error);
1648: END IF;

Line 1650: hz_utility_v2pub.debug(p_message=>'Get_EntityAttribute (-)',

1646: p_msg_type=>'ERROR',
1647: p_msg_level=>fnd_log.level_error);
1648: END IF;
1649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1650: hz_utility_v2pub.debug(p_message=>'Get_EntityAttribute (-)',
1651: p_prefix=>l_debug_prefix,
1652: p_msg_level=>fnd_log.level_procedure);
1653: END IF;
1654:

Line 1669: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1665: p_data => x_msg_data );
1666:
1667: -- Debug info.
1668: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1669: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1670: p_msg_data=>x_msg_data,
1671: p_msg_type=>'UNEXPECTED ERROR',
1672: p_msg_level=>fnd_log.level_error);
1673: END IF;

Line 1675: hz_utility_v2pub.debug(p_message=>'Get_EntityAttribute (-)',

1671: p_msg_type=>'UNEXPECTED ERROR',
1672: p_msg_level=>fnd_log.level_error);
1673: END IF;
1674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1675: hz_utility_v2pub.debug(p_message=>'Get_EntityAttribute (-)',
1676: p_prefix=>l_debug_prefix,
1677: p_msg_level=>fnd_log.level_procedure);
1678: END IF;
1679:

Line 1697: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1693: p_data => x_msg_data );
1694:
1695: -- Debug info.
1696: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1697: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1698: p_msg_data=>x_msg_data,
1699: p_msg_type=>'SQL ERROR',
1700: p_msg_level=>fnd_log.level_error);
1701: END IF;

Line 1703: hz_utility_v2pub.debug(p_message=> 'Get_EntityAttribute (-)',

1699: p_msg_type=>'SQL ERROR',
1700: p_msg_level=>fnd_log.level_error);
1701: END IF;
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_message=> 'Get_EntityAttribute (-)',
1704: p_prefix=>l_debug_prefix,
1705: p_msg_level=>fnd_log.level_procedure);
1706: END IF;
1707:

Line 1789: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (+)',

1785: --enable_debug;
1786:
1787: -- Debug info.
1788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1789: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (+)',
1790: p_prefix=>l_debug_prefix,
1791: p_msg_level=>fnd_log.level_procedure);
1792: END IF;
1793:

Line 1875: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1871: p_data => x_msg_data );
1872:
1873: -- Debug info.
1874: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1875: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1876: p_msg_data=>x_msg_data,
1877: p_msg_type=>'WARNING',
1878: p_msg_level=>fnd_log.level_exception);
1879: END IF;

Line 1881: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (-)',

1877: p_msg_type=>'WARNING',
1878: p_msg_level=>fnd_log.level_exception);
1879: END IF;
1880: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1881: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (-)',
1882: p_prefix=>l_debug_prefix,
1883: p_msg_level=>fnd_log.level_procedure);
1884: END IF;
1885:

Line 1901: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1897: p_data => x_msg_data );
1898:
1899: -- Debug info.
1900: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1901: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1902: p_msg_data=>x_msg_data,
1903: p_msg_type=>'ERROR',
1904: p_msg_level=>fnd_log.level_error);
1905: END IF;

Line 1907: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (-)',

1903: p_msg_type=>'ERROR',
1904: p_msg_level=>fnd_log.level_error);
1905: END IF;
1906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1907: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (-)',
1908: p_prefix=>l_debug_prefix,
1909: p_msg_level=>fnd_log.level_procedure);
1910: END IF;
1911:

Line 1926: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1922: p_data => x_msg_data );
1923:
1924: -- Debug info.
1925: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1927: p_msg_data=>x_msg_data,
1928: p_msg_type=>'UNEXPECTED ERROR',
1929: p_msg_level=>fnd_log.level_error);
1930: END IF;

Line 1932: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (-)',

1928: p_msg_type=>'UNEXPECTED ERROR',
1929: p_msg_level=>fnd_log.level_error);
1930: END IF;
1931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1932: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (-)',
1933: p_prefix=>l_debug_prefix,
1934: p_msg_level=>fnd_log.level_procedure);
1935: END IF;
1936:

Line 1955: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1951: p_data => x_msg_data );
1952:
1953: -- Debug info.
1954: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1955: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1956: p_msg_data=>x_msg_data,
1957: p_msg_type=>'SQL ERROR',
1958: p_msg_level=>fnd_log.level_error);
1959: END IF;

Line 1961: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (-)',

1957: p_msg_type=>'SQL ERROR',
1958: p_msg_level=>fnd_log.level_error);
1959: END IF;
1960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1961: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttribute (-)',
1962: p_prefix=>l_debug_prefix,
1963: p_msg_level=>fnd_log.level_procedure);
1964: END IF;
1965:

Line 2051: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (+)',

2047: --enable_debug;
2048:
2049: -- Debug info.
2050: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2051: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (+)',
2052: p_prefix=>l_debug_prefix,
2053: p_msg_level=>fnd_log.level_procedure);
2054: END IF;
2055:

Line 2154: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2150: p_data => x_msg_data );
2151:
2152: -- Debug info.
2153: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2154: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2155: p_msg_data=>x_msg_data,
2156: p_msg_type=>'WARNING',
2157: p_msg_level=>fnd_log.level_exception);
2158: END IF;

Line 2160: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (-)',

2156: p_msg_type=>'WARNING',
2157: p_msg_level=>fnd_log.level_exception);
2158: END IF;
2159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2160: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (-)',
2161: p_prefix=>l_debug_prefix,
2162: p_msg_level=>fnd_log.level_procedure);
2163: END IF;
2164:

Line 2181: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2177: p_data => x_msg_data );
2178:
2179: -- Debug info.
2180: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2181: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2182: p_msg_data=>x_msg_data,
2183: p_msg_type=>'ERROR',
2184: p_msg_level=>fnd_log.level_error);
2185: END IF;

Line 2187: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (-)',

2183: p_msg_type=>'ERROR',
2184: p_msg_level=>fnd_log.level_error);
2185: END IF;
2186: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2187: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (-)',
2188: p_prefix=>l_debug_prefix,
2189: p_msg_level=>fnd_log.level_procedure);
2190: END IF;
2191:

Line 2206: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2202: p_data => x_msg_data );
2203:
2204: -- Debug info.
2205: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2206: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2207: p_msg_data=>x_msg_data,
2208: p_msg_type=>'UNEXPECTED ERROR',
2209: p_msg_level=>fnd_log.level_error);
2210: END IF;

Line 2212: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (-)',

2208: p_msg_type=>'UNEXPECTED ERROR',
2209: p_msg_level=>fnd_log.level_error);
2210: END IF;
2211: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2212: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (-)',
2213: p_prefix=>l_debug_prefix,
2214: p_msg_level=>fnd_log.level_procedure);
2215: END IF;
2216:

Line 2235: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2231: p_data => x_msg_data );
2232:
2233: -- Debug info.
2234: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2235: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2236: p_msg_data=>x_msg_data,
2237: p_msg_type=>'SQL ERROR',
2238: p_msg_level=>fnd_log.level_error);
2239: END IF;

Line 2241: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (-)',

2237: p_msg_type=>'SQL ERROR',
2238: p_msg_level=>fnd_log.level_error);
2239: END IF;
2240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2241: hz_utility_v2pub.debug(p_message=>'Remove_EntityAttrDataSource (-)',
2242: p_prefix=>l_debug_prefix,
2243: p_msg_level=>fnd_log.level_procedure);
2244: END IF;
2245: