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

Line 271: * be FND_API.G_RET_STS_SUCCESS (success),

267: * p_entity_attribute_rec Entity Attribute record.
268: * p_data_source_tab PL/SQL table for data source setup.
269: * IN/OUT:
270: * x_return_status Return status after the call. The status can
271: * be FND_API.G_RET_STS_SUCCESS (success),
272: * FND_API.G_RET_STS_ERROR (error),
273: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
274: * OUT:
275: * x_entity_attr_id Dictionary ID.

Line 272: * FND_API.G_RET_STS_ERROR (error),

268: * p_data_source_tab PL/SQL table for data source setup.
269: * IN/OUT:
270: * x_return_status Return status after the call. The status can
271: * be FND_API.G_RET_STS_SUCCESS (success),
272: * FND_API.G_RET_STS_ERROR (error),
273: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
274: * OUT:
275: * x_entity_attr_id Dictionary ID.
276: *

Line 273: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

269: * IN/OUT:
270: * x_return_status Return status after the call. The status can
271: * be FND_API.G_RET_STS_SUCCESS (success),
272: * FND_API.G_RET_STS_ERROR (error),
273: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
274: * OUT:
275: * x_entity_attr_id Dictionary ID.
276: *
277: * NOTES

Line 312: p_attribute_name = FND_API.G_MISS_CHAR)) OR

308: FROM hz_entity_attributes
309: WHERE entity_name = p_entity_name
310: AND ((attribute_name IS NULL AND
311: (p_attribute_name IS NULL OR
312: p_attribute_name = FND_API.G_MISS_CHAR)) OR
313: (attribute_name = p_attribute_name));
314:
315: BEGIN
316:

Line 338: p_entity_attribute_rec.entity_name <> FND_API.G_MISS_CHAR AND

334:
335: -- find the group the attribute belongs to.
336:
337: IF p_entity_attribute_rec.entity_name IS NOT NULL AND
338: p_entity_attribute_rec.entity_name <> FND_API.G_MISS_CHAR AND
339: p_entity_attribute_rec.attribute_name IS NOT NULL AND
340: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR
341: THEN
342: Find_NameListInAGroup (

Line 340: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR

336:
337: IF p_entity_attribute_rec.entity_name IS NOT NULL AND
338: p_entity_attribute_rec.entity_name <> FND_API.G_MISS_CHAR AND
339: p_entity_attribute_rec.attribute_name IS NOT NULL AND
340: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR
341: THEN
342: Find_NameListInAGroup (
343: p_create_update_flag => l_create_update_flag,
344: p_entity_name => p_entity_attribute_rec.entity_name,

Line 363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

359: p_entity_attribute_rec => l_entity_attribute_rec,
360: p_data_source_tab => p_data_source_tab,
361: x_return_status => x_return_status);
362:
363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: db_InsertEntityAttribute (

Line 364: RAISE FND_API.G_EXC_ERROR;

360: p_data_source_tab => p_data_source_tab,
361: x_return_status => x_return_status);
362:
363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: db_InsertEntityAttribute (
368: p_entity_attribute_rec => l_entity_attribute_rec,

Line 660: * be FND_API.G_RET_STS_SUCCESS (success),

656: * p_entity_attribute_rec Entity Attribute record.
657: * p_data_source_tab PL/SQL table for data source setup.
658: * IN/OUT:
659: * x_return_status Return status after the call. The status can
660: * be FND_API.G_RET_STS_SUCCESS (success),
661: * FND_API.G_RET_STS_ERROR (error),
662: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
663: * OUT:
664: *

Line 661: * FND_API.G_RET_STS_ERROR (error),

657: * p_data_source_tab PL/SQL table for data source setup.
658: * IN/OUT:
659: * x_return_status Return status after the call. The status can
660: * be FND_API.G_RET_STS_SUCCESS (success),
661: * FND_API.G_RET_STS_ERROR (error),
662: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
663: * OUT:
664: *
665: * NOTES

Line 662: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

658: * IN/OUT:
659: * x_return_status Return status after the call. The status can
660: * be FND_API.G_RET_STS_SUCCESS (success),
661: * FND_API.G_RET_STS_ERROR (error),
662: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
663: * OUT:
664: *
665: * NOTES
666: *

Line 705: p_entity_attribute_rec.entity_name <> FND_API.G_MISS_CHAR

701:
702: -- entity_name is lookup code in lookup type ENTITY_NAME
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',

Line 717: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

713:
714: -- the validation for attribute_name only makes sense when the entity_name
715: -- has a valid value.
716:
717: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
718:
719: --------------------------------------
720: -- validate attribute_name
721: --------------------------------------

Line 730: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR

726:
727: IF p_entity_attribute_rec.entity_name NOT IN
728: (G_ORG_ENTITY, G_PERSON_ENTITY) AND
729: p_entity_attribute_rec.attribute_name IS NOT NULL AND
730: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR
731: THEN
732: fnd_message.set_name('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
733: fnd_message.set_token('COLUMN','attribute_name');
734: fnd_message.set_token('TABLE','hz_entity_attributes');

Line 736: x_return_status := FND_API.G_RET_STS_ERROR;

732: fnd_message.set_name('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
733: fnd_message.set_token('COLUMN','attribute_name');
734: fnd_message.set_token('TABLE','hz_entity_attributes');
735: fnd_msg_pub.add;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: ELSIF p_entity_attribute_rec.entity_name IN
738: (G_ORG_ENTITY, G_PERSON_ENTITY)
739: THEN
740: -- attribute_name is mandatory field.

Line 790: x_return_status := FND_API.G_RET_STS_ERROR;

786: -- and will not be a lookup of type CONTENT_SOURCE_TYPE.
787: IF p_data_source_tab.COUNT = 0 THEN
788: fnd_message.set_name('AR', 'HZ_API_NO_DATA_SOURCE');
789: fnd_msg_pub.add;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: ELSE
792: FOR i IN 1..p_data_source_tab.COUNT LOOP
793: IF p_data_source_tab(i) IS NULL OR
794: p_data_source_tab(i) = 'SST'

Line 798: x_return_status := FND_API.G_RET_STS_ERROR;

794: p_data_source_tab(i) = 'SST'
795: THEN
796: fnd_message.set_name('AR', 'HZ_API_INVALID_DATA_SOURCE');
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',

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEM_B');
823: FND_MESSAGE.SET_TOKEN('COLUMN','ORIG_SYSTEM');
824: FND_MESSAGE.SET_TOKEN('FK','DATA SOURCE');
825: FND_MSG_PUB.ADD;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: END IF;
828: END LOOP;
829: CLOSE c_valid_data_source;
830: EXCEPTION

Line 832: x_return_status := FND_API.G_RET_STS_ERROR;

828: END LOOP;
829: CLOSE c_valid_data_source;
830: EXCEPTION
831: WHEN OTHERS THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: RAISE FND_API.G_EXC_ERROR;
834: END;
835:
836: END IF;

Line 833: RAISE FND_API.G_EXC_ERROR;

829: CLOSE c_valid_data_source;
830: EXCEPTION
831: WHEN OTHERS THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: RAISE FND_API.G_EXC_ERROR;
834: END;
835:
836: END IF;
837: END LOOP;

Line 863: * be FND_API.G_RET_STS_SUCCESS (success),

859: * p_entity_name Entity Name
860: * p_attribute_name Attribute Name
861: * IN/OUT:
862: * x_return_status Return status after the call. The status can
863: * be FND_API.G_RET_STS_SUCCESS (success),
864: * FND_API.G_RET_STS_ERROR (error),
865: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
866: *
867: * NOTES

Line 864: * FND_API.G_RET_STS_ERROR (error),

860: * p_attribute_name Attribute Name
861: * IN/OUT:
862: * x_return_status Return status after the call. The status can
863: * be FND_API.G_RET_STS_SUCCESS (success),
864: * FND_API.G_RET_STS_ERROR (error),
865: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
866: *
867: * NOTES
868: *

Line 865: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

861: * IN/OUT:
862: * x_return_status Return status after the call. The status can
863: * be FND_API.G_RET_STS_SUCCESS (success),
864: * FND_API.G_RET_STS_ERROR (error),
865: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
866: *
867: * NOTES
868: *
869: * MODIFICATION HISTORY

Line 991: x_return_status := fnd_api.g_ret_sts_error;

987: fnd_message.set_name('AR', 'HZ_API_INVALID_ATTRIBUTE');
988: fnd_message.set_token('ATTRIBUTE', p_attribute_name);
989: fnd_message.set_token('ENTITY', l_name);
990: fnd_msg_pub.add;
991: x_return_status := fnd_api.g_ret_sts_error;
992: END IF;
993:
994: -- Debug info.
995: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1142: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.entity_name),

1138: --
1139: -- entity_attr_id
1140: hz_entity_attributes_s.NEXTVAL,
1141: DECODE(p_entity_attribute_rec.entity_name,
1142: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.entity_name),
1143: DECODE(p_entity_attribute_rec.attribute_name,
1144: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),
1145: p_group_name,
1146: DECODE(p_entity_attribute_rec.created_by_module,

Line 1144: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),

1140: hz_entity_attributes_s.NEXTVAL,
1141: DECODE(p_entity_attribute_rec.entity_name,
1142: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.entity_name),
1143: DECODE(p_entity_attribute_rec.attribute_name,
1144: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),
1145: p_group_name,
1146: DECODE(p_entity_attribute_rec.created_by_module,
1147: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.created_by_module),
1148: DECODE(p_entity_attribute_rec.application_id,

Line 1147: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.created_by_module),

1143: DECODE(p_entity_attribute_rec.attribute_name,
1144: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),
1145: p_group_name,
1146: DECODE(p_entity_attribute_rec.created_by_module,
1147: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.created_by_module),
1148: DECODE(p_entity_attribute_rec.application_id,
1149: FND_API.G_MISS_NUM, NULL, p_entity_attribute_rec.application_id),
1150: hz_utility_v2pub.created_by,
1151: SYSDATE,

Line 1149: FND_API.G_MISS_NUM, NULL, p_entity_attribute_rec.application_id),

1145: p_group_name,
1146: DECODE(p_entity_attribute_rec.created_by_module,
1147: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.created_by_module),
1148: DECODE(p_entity_attribute_rec.application_id,
1149: FND_API.G_MISS_NUM, NULL, p_entity_attribute_rec.application_id),
1150: hz_utility_v2pub.created_by,
1151: SYSDATE,
1152: hz_utility_v2pub.last_update_login,
1153: SYSDATE,

Line 1320: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

1316: *
1317: * ARGUMENTS
1318: * IN:
1319: * p_init_msg_list Initialize message stack if it is set to
1320: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1321: * p_entity_attribute_rec Entity Attribute record.
1322: * p_data_source_tbl PL/SQL Table for Data Source Setup.
1323: * IN/OUT:
1324: * OUT:

Line 1327: * be FND_API.G_RET_STS_SUCCESS (success),

1323: * IN/OUT:
1324: * OUT:
1325: * x_entity_attr_id Dictionary ID.
1326: * x_return_status Return status after the call. The status can
1327: * be FND_API.G_RET_STS_SUCCESS (success),
1328: * FND_API.G_RET_STS_ERROR (error),
1329: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1330: * x_msg_count Number of messages in message stack.
1331: * x_msg_data Message text if x_msg_count is 1.

Line 1328: * FND_API.G_RET_STS_ERROR (error),

1324: * OUT:
1325: * x_entity_attr_id Dictionary ID.
1326: * x_return_status Return status after the call. The status can
1327: * be FND_API.G_RET_STS_SUCCESS (success),
1328: * FND_API.G_RET_STS_ERROR (error),
1329: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1330: * x_msg_count Number of messages in message stack.
1331: * x_msg_data Message text if x_msg_count is 1.
1332: *

Line 1329: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1325: * x_entity_attr_id Dictionary ID.
1326: * x_return_status Return status after the call. The status can
1327: * be FND_API.G_RET_STS_SUCCESS (success),
1328: * FND_API.G_RET_STS_ERROR (error),
1329: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1330: * x_msg_count Number of messages in message stack.
1331: * x_msg_data Message text if x_msg_count is 1.
1332: *
1333: * NOTES

Line 1341: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1337: * 02-12-2002 Jianying Huang o Created.
1338: */
1339:
1340: PROCEDURE Add_EntityAttribute (
1341: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1342: p_entity_attribute_rec IN ENTITY_ATTRIBUTE_REC_TYPE,
1343: p_data_source_tab IN DATA_SOURCE_TBL,
1344: x_entity_attr_id OUT NOCOPY NUMBER,
1345: x_return_status OUT NOCOPY VARCHAR2,

Line 1366: IF fnd_api.to_Boolean(p_init_msg_list) THEN

1362: p_msg_level=>fnd_log.level_procedure);
1363: END IF;
1364:
1365: -- Initialize message list if p_init_msg_list is set to TRUE.
1366: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1367: fnd_msg_pub.initialize;
1368: END IF;
1369:
1370: -- Initialize API return status to success.

Line 1371: x_return_status := FND_API.G_RET_STS_SUCCESS;

1367: fnd_msg_pub.initialize;
1368: END IF;
1369:
1370: -- Initialize API return status to success.
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372:
1373: -- Call business logic.
1374: do_AddEntityAttribute (
1375: p_entity_attribute_rec,

Line 1382: p_encoded => FND_API.G_FALSE,

1378: x_return_status );
1379:
1380: -- Standard call to get message count and if count is 1, get message info.
1381: fnd_msg_pub.Count_And_Get(
1382: p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,
1384: p_data => x_msg_data );
1385:
1386: -- Debug info.

Line 1403: WHEN FND_API.G_EXC_ERROR THEN

1399: -- Check if API is called in debug mode. If yes, disable debug.
1400: --disable_debug;
1401:
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR THEN
1404: ROLLBACK TO Add_EntityAttribute;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: fnd_msg_pub.Count_And_Get(

Line 1405: x_return_status := FND_API.G_RET_STS_ERROR;

1401:
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR THEN
1404: ROLLBACK TO Add_EntityAttribute;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: fnd_msg_pub.Count_And_Get(
1408: p_encoded => FND_API.G_FALSE,
1409: p_count => x_msg_count,

Line 1408: p_encoded => FND_API.G_FALSE,

1404: ROLLBACK TO Add_EntityAttribute;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: fnd_msg_pub.Count_And_Get(
1408: p_encoded => FND_API.G_FALSE,
1409: p_count => x_msg_count,
1410: p_data => x_msg_data );
1411:
1412: -- Debug info.

Line 1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1424:
1425: -- Check if API is called in debug mode. If yes, disable debug.
1426: --disable_debug;
1427:
1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: ROLLBACK TO Add_EntityAttribute;
1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1431:
1432: fnd_msg_pub.Count_And_Get(

Line 1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1426: --disable_debug;
1427:
1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: ROLLBACK TO Add_EntityAttribute;
1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1431:
1432: fnd_msg_pub.Count_And_Get(
1433: p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,

Line 1433: p_encoded => FND_API.G_FALSE,

1429: ROLLBACK TO Add_EntityAttribute;
1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1431:
1432: fnd_msg_pub.Count_And_Get(
1433: p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,
1435: p_data => x_msg_data );
1436:
1437: -- Debug info.

Line 1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1451: --disable_debug;
1452:
1453: WHEN OTHERS THEN
1454: ROLLBACK TO Add_EntityAttribute;
1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1456:
1457: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1458: fnd_message.set_token('ERROR',SQLERRM);
1459: fnd_msg_pub.add;

Line 1462: p_encoded => FND_API.G_FALSE,

1458: fnd_message.set_token('ERROR',SQLERRM);
1459: fnd_msg_pub.add;
1460:
1461: fnd_msg_pub.Count_And_Get(
1462: p_encoded => FND_API.G_FALSE,
1463: p_count => x_msg_count,
1464: p_data => x_msg_data );
1465:
1466: -- Debug info.

Line 1495: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

1491: *
1492: * ARGUMENTS
1493: * IN:
1494: * p_init_msg_list Initialize message stack if it is set to
1495: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1496: * p_entity_name Entity Name
1497: * p_attribute_name Attribute Name
1498: * IN/OUT:
1499: * OUT:

Line 1502: * be FND_API.G_RET_STS_SUCCESS (success),

1498: * IN/OUT:
1499: * OUT:
1500: * x_data_source_tbl PL/SQL Table for Data Source Setup.
1501: * x_return_status Return status after the call. The status can
1502: * be FND_API.G_RET_STS_SUCCESS (success),
1503: * FND_API.G_RET_STS_ERROR (error),
1504: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1505: * x_msg_count Number of messages in message stack.
1506: * x_msg_data Message text if x_msg_count is 1.

Line 1503: * FND_API.G_RET_STS_ERROR (error),

1499: * OUT:
1500: * x_data_source_tbl PL/SQL Table for Data Source Setup.
1501: * x_return_status Return status after the call. The status can
1502: * be FND_API.G_RET_STS_SUCCESS (success),
1503: * FND_API.G_RET_STS_ERROR (error),
1504: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1505: * x_msg_count Number of messages in message stack.
1506: * x_msg_data Message text if x_msg_count is 1.
1507: *

Line 1504: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1500: * x_data_source_tbl PL/SQL Table for Data Source Setup.
1501: * x_return_status Return status after the call. The status can
1502: * be FND_API.G_RET_STS_SUCCESS (success),
1503: * FND_API.G_RET_STS_ERROR (error),
1504: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1505: * x_msg_count Number of messages in message stack.
1506: * x_msg_data Message text if x_msg_count is 1.
1507: *
1508: * NOTES

Line 1516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1512: * 02-12-2002 Jianying Huang o Created.
1513: */
1514:
1515: PROCEDURE Get_EntityAttribute (
1516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1517: p_entity_name IN VARCHAR2,
1518: p_attribute_name IN VARCHAR2,
1519: x_data_source_tbl OUT NOCOPY DATA_SOURCE_TBL,
1520: x_return_status OUT NOCOPY VARCHAR2,

Line 1535: p_attribute_name = FND_API.G_MISS_CHAR)) OR

1531: FROM hz_entity_attributes
1532: WHERE entity_name = p_entity_name
1533: AND ((attribute_name IS NULL AND
1534: (p_attribute_name IS NULL OR
1535: p_attribute_name = FND_API.G_MISS_CHAR)) OR
1536: (attribute_name = p_attribute_name));
1537:
1538: CURSOR c_data_sources (
1539: p_entity_attr_id NUMBER

Line 1559: IF fnd_api.to_Boolean(p_init_msg_list) THEN

1555: p_msg_level=>fnd_log.level_procedure);
1556: END IF;
1557:
1558: -- Initialize message list if p_init_msg_list is set to TRUE.
1559: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1560: fnd_msg_pub.initialize;
1561: END IF;
1562:
1563: -- Initialize API return status to success.

Line 1564: x_return_status := FND_API.G_RET_STS_SUCCESS;

1560: fnd_msg_pub.initialize;
1561: END IF;
1562:
1563: -- Initialize API return status to success.
1564: x_return_status := FND_API.G_RET_STS_SUCCESS;
1565:
1566: -- find the entity and / or attribute in the dictionary
1567: OPEN c_entity;
1568: FETCH c_entity INTO l_entity_attr_id;

Line 1576: RAISE FND_API.G_EXC_ERROR;

1572: fnd_message.set_token('RECORD', 'entity attribute');
1573: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
1574: NVL(p_attribute_name,'null'||'>'));
1575: fnd_msg_pub.add;
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578: CLOSE c_entity;
1579:
1580: -- select data sources.

Line 1589: p_encoded => FND_API.G_FALSE,

1585: x_data_source_tbl := l_data_source_tbl;
1586:
1587: -- Standard call to get message count and if count is 1, get message info.
1588: fnd_msg_pub.Count_And_Get(
1589: p_encoded => FND_API.G_FALSE,
1590: p_count => x_msg_count,
1591: p_data => x_msg_data );
1592:
1593: -- Debug info.

Line 1612: WHEN FND_API.G_EXC_ERROR THEN

1608: -- Check if API is called in debug mode. If yes, disable debug.
1609: --disable_debug;
1610:
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: x_return_status := FND_API.G_RET_STS_ERROR;
1614:
1615: fnd_msg_pub.Count_And_Get(
1616: p_encoded => FND_API.G_FALSE,

Line 1613: x_return_status := FND_API.G_RET_STS_ERROR;

1609: --disable_debug;
1610:
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: x_return_status := FND_API.G_RET_STS_ERROR;
1614:
1615: fnd_msg_pub.Count_And_Get(
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => x_msg_count,

Line 1616: p_encoded => FND_API.G_FALSE,

1612: WHEN FND_API.G_EXC_ERROR THEN
1613: x_return_status := FND_API.G_RET_STS_ERROR;
1614:
1615: fnd_msg_pub.Count_And_Get(
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data );
1619:
1620: -- Debug info.

Line 1637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1633:
1634: -- Check if API is called in debug mode. If yes, disable debug.
1635: --disable_debug;
1636:
1637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639:
1640: fnd_msg_pub.Count_And_Get(
1641: p_encoded => FND_API.G_FALSE,

Line 1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1634: -- Check if API is called in debug mode. If yes, disable debug.
1635: --disable_debug;
1636:
1637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639:
1640: fnd_msg_pub.Count_And_Get(
1641: p_encoded => FND_API.G_FALSE,
1642: p_count => x_msg_count,

Line 1641: p_encoded => FND_API.G_FALSE,

1637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639:
1640: fnd_msg_pub.Count_And_Get(
1641: p_encoded => FND_API.G_FALSE,
1642: p_count => x_msg_count,
1643: p_data => x_msg_data );
1644:
1645: -- Debug info.

Line 1662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1658: -- Check if API is called in debug mode. If yes, disable debug.
1659: --disable_debug;
1660:
1661: WHEN OTHERS THEN
1662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1663:
1664: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1665: fnd_message.set_token('ERROR',SQLERRM);
1666: fnd_msg_pub.add;

Line 1669: p_encoded => FND_API.G_FALSE,

1665: fnd_message.set_token('ERROR',SQLERRM);
1666: fnd_msg_pub.add;
1667:
1668: fnd_msg_pub.Count_And_Get(
1669: p_encoded => FND_API.G_FALSE,
1670: p_count => x_msg_count,
1671: p_data => x_msg_data );
1672:
1673: -- Debug info.

Line 1702: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

1698: *
1699: * ARGUMENTS
1700: * IN:
1701: * p_init_msg_list Initialize message stack if it is set to
1702: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1703: * p_entity_name Entity Name
1704: * p_attribute_name Attribute Name
1705: * IN/OUT:
1706: * OUT:

Line 1708: * be FND_API.G_RET_STS_SUCCESS (success),

1704: * p_attribute_name Attribute Name
1705: * IN/OUT:
1706: * OUT:
1707: * x_return_status Return status after the call. The status can
1708: * be FND_API.G_RET_STS_SUCCESS (success),
1709: * FND_API.G_RET_STS_ERROR (error),
1710: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1711: * x_msg_count Number of messages in message stack.
1712: * x_msg_data Message text if x_msg_count is 1.

Line 1709: * FND_API.G_RET_STS_ERROR (error),

1705: * IN/OUT:
1706: * OUT:
1707: * x_return_status Return status after the call. The status can
1708: * be FND_API.G_RET_STS_SUCCESS (success),
1709: * FND_API.G_RET_STS_ERROR (error),
1710: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1711: * x_msg_count Number of messages in message stack.
1712: * x_msg_data Message text if x_msg_count is 1.
1713: *

Line 1710: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1706: * OUT:
1707: * x_return_status Return status after the call. The status can
1708: * be FND_API.G_RET_STS_SUCCESS (success),
1709: * FND_API.G_RET_STS_ERROR (error),
1710: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1711: * x_msg_count Number of messages in message stack.
1712: * x_msg_data Message text if x_msg_count is 1.
1713: *
1714: * NOTES

Line 1722: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1718: * 02-12-2002 Jianying Huang o Created.
1719: */
1720:
1721: PROCEDURE Remove_EntityAttribute (
1722: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1723: p_entity_name IN VARCHAR2,
1724: p_attribute_name IN VARCHAR2,
1725: x_return_status OUT NOCOPY VARCHAR2,
1726: x_msg_count OUT NOCOPY NUMBER,

Line 1744: p_attribute_name = FND_API.G_MISS_CHAR)) OR

1740: FROM hz_entity_attributes
1741: WHERE entity_name = p_entity_name
1742: AND ((attribute_name IS NULL AND
1743: (p_attribute_name IS NULL OR
1744: p_attribute_name = FND_API.G_MISS_CHAR)) OR
1745: (attribute_name = p_attribute_name));
1746:
1747: CURSOR c_selected_data_source (
1748: p_entity_attr_id NUMBER

Line 1773: IF fnd_api.to_Boolean(p_init_msg_list) THEN

1769: p_msg_level=>fnd_log.level_procedure);
1770: END IF;
1771:
1772: -- Initialize message list if p_init_msg_list is set to TRUE.
1773: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1774: fnd_msg_pub.initialize;
1775: END IF;
1776:
1777: -- Initialize API return status to success.

Line 1778: x_return_status := FND_API.G_RET_STS_SUCCESS;

1774: fnd_msg_pub.initialize;
1775: END IF;
1776:
1777: -- Initialize API return status to success.
1778: x_return_status := FND_API.G_RET_STS_SUCCESS;
1779:
1780: -- find the entity and / or attribute in the dictionary
1781: OPEN c_entity;
1782: FETCH c_entity INTO l_entity_attr_id;

Line 1790: RAISE FND_API.G_EXC_ERROR;

1786: fnd_message.set_token('RECORD', 'entity attribute');
1787: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
1788: NVL(p_attribute_name,'null'||'>'));
1789: fnd_msg_pub.add;
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;
1792: CLOSE c_entity;
1793:
1794: -- find the group the attribute belongs to

Line 1797: p_attribute_name <> FND_API.G_MISS_CHAR

1793:
1794: -- find the group the attribute belongs to
1795:
1796: IF p_attribute_name IS NOT NULL AND
1797: p_attribute_name <> FND_API.G_MISS_CHAR
1798: THEN
1799: Find_NameListInAGroup (
1800: p_entity_name => p_entity_name,
1801: p_attribute_name => p_attribute_name,

Line 1840: RAISE FND_API.G_EXC_ERROR;

1836: fnd_message.set_name('AR', 'HZ_API_CANNOT_DELETE_ENTITY');
1837: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||
1838: NVL(p_attribute_name,'null'||'>'));
1839: fnd_msg_pub.add;
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842: CLOSE c_selected_data_source;
1843: END LOOP;
1844:

Line 1847: p_encoded => FND_API.G_FALSE,

1843: END LOOP;
1844:
1845: -- Standard call to get message count and if count is 1, get message info.
1846: fnd_msg_pub.Count_And_Get(
1847: p_encoded => FND_API.G_FALSE,
1848: p_count => x_msg_count,
1849: p_data => x_msg_data );
1850:
1851: -- Debug info.

Line 1868: WHEN FND_API.G_EXC_ERROR THEN

1864: -- Check if API is called in debug mode. If yes, disable debug.
1865: --disable_debug;
1866:
1867: EXCEPTION
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: ROLLBACK TO Remove_EntityAttribute;
1870: x_return_status := FND_API.G_RET_STS_ERROR;
1871:
1872: fnd_msg_pub.Count_And_Get(

Line 1870: x_return_status := FND_API.G_RET_STS_ERROR;

1866:
1867: EXCEPTION
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: ROLLBACK TO Remove_EntityAttribute;
1870: x_return_status := FND_API.G_RET_STS_ERROR;
1871:
1872: fnd_msg_pub.Count_And_Get(
1873: p_encoded => FND_API.G_FALSE,
1874: p_count => x_msg_count,

Line 1873: p_encoded => FND_API.G_FALSE,

1869: ROLLBACK TO Remove_EntityAttribute;
1870: x_return_status := FND_API.G_RET_STS_ERROR;
1871:
1872: fnd_msg_pub.Count_And_Get(
1873: p_encoded => FND_API.G_FALSE,
1874: p_count => x_msg_count,
1875: p_data => x_msg_data );
1876:
1877: -- Debug info.

Line 1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1889:
1890: -- Check if API is called in debug mode. If yes, disable debug.
1891: --disable_debug;
1892:
1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1894: ROLLBACK TO Remove_EntityAttribute;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:
1897: fnd_msg_pub.Count_And_Get(

Line 1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1891: --disable_debug;
1892:
1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1894: ROLLBACK TO Remove_EntityAttribute;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:
1897: fnd_msg_pub.Count_And_Get(
1898: p_encoded => FND_API.G_FALSE,
1899: p_count => x_msg_count,

Line 1898: p_encoded => FND_API.G_FALSE,

1894: ROLLBACK TO Remove_EntityAttribute;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:
1897: fnd_msg_pub.Count_And_Get(
1898: p_encoded => FND_API.G_FALSE,
1899: p_count => x_msg_count,
1900: p_data => x_msg_data );
1901:
1902: -- Debug info.

Line 1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1916: --disable_debug;
1917:
1918: WHEN OTHERS THEN
1919: ROLLBACK TO Remove_EntityAttribute;
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921:
1922: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1923: fnd_message.set_token('ERROR',SQLERRM);
1924: fnd_msg_pub.add;

Line 1927: p_encoded => FND_API.G_FALSE,

1923: fnd_message.set_token('ERROR',SQLERRM);
1924: fnd_msg_pub.add;
1925:
1926: fnd_msg_pub.Count_And_Get(
1927: p_encoded => FND_API.G_FALSE,
1928: p_count => x_msg_count,
1929: p_data => x_msg_data );
1930:
1931: -- Debug info.

Line 1961: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

1957: *
1958: * ARGUMENTS
1959: * IN:
1960: * p_init_msg_list Initialize message stack if it is set to
1961: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1962: * p_entity_name Entity Name
1963: * p_attribute_name Attribute Name
1964: * IN/OUT:
1965: * OUT:

Line 1967: * be FND_API.G_RET_STS_SUCCESS (success),

1963: * p_attribute_name Attribute Name
1964: * IN/OUT:
1965: * OUT:
1966: * x_return_status Return status after the call. The status can
1967: * be FND_API.G_RET_STS_SUCCESS (success),
1968: * FND_API.G_RET_STS_ERROR (error),
1969: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1970: * x_msg_count Number of messages in message stack.
1971: * x_msg_data Message text if x_msg_count is 1.

Line 1968: * FND_API.G_RET_STS_ERROR (error),

1964: * IN/OUT:
1965: * OUT:
1966: * x_return_status Return status after the call. The status can
1967: * be FND_API.G_RET_STS_SUCCESS (success),
1968: * FND_API.G_RET_STS_ERROR (error),
1969: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1970: * x_msg_count Number of messages in message stack.
1971: * x_msg_data Message text if x_msg_count is 1.
1972: *

Line 1969: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1965: * OUT:
1966: * x_return_status Return status after the call. The status can
1967: * be FND_API.G_RET_STS_SUCCESS (success),
1968: * FND_API.G_RET_STS_ERROR (error),
1969: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1970: * x_msg_count Number of messages in message stack.
1971: * x_msg_data Message text if x_msg_count is 1.
1972: *
1973: * NOTES

Line 1981: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1977: * 02-12-2002 Jianying Huang o Created.
1978: */
1979:
1980: PROCEDURE Remove_EntityAttrDataSource (
1981: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1982: p_entity_name IN VARCHAR2,
1983: p_attribute_name IN VARCHAR2,
1984: p_data_source_tbl IN DATA_SOURCE_TBL,
1985: x_return_status OUT NOCOPY VARCHAR2,

Line 2003: p_attribute_name = FND_API.G_MISS_CHAR)) OR

1999: FROM hz_entity_attributes
2000: WHERE entity_name = p_entity_name
2001: AND ((attribute_name IS NULL AND
2002: (p_attribute_name IS NULL OR
2003: p_attribute_name = FND_API.G_MISS_CHAR)) OR
2004: (attribute_name = p_attribute_name));
2005:
2006: CURSOR c_data_source (
2007: p_entity_attr_id NUMBER,

Line 2035: IF fnd_api.to_Boolean(p_init_msg_list) THEN

2031: p_msg_level=>fnd_log.level_procedure);
2032: END IF;
2033:
2034: -- Initialize message list if p_init_msg_list is set to TRUE.
2035: IF fnd_api.to_Boolean(p_init_msg_list) THEN
2036: fnd_msg_pub.initialize;
2037: END IF;
2038:
2039: -- Initialize API return status to success.

Line 2040: x_return_status := FND_API.G_RET_STS_SUCCESS;

2036: fnd_msg_pub.initialize;
2037: END IF;
2038:
2039: -- Initialize API return status to success.
2040: x_return_status := FND_API.G_RET_STS_SUCCESS;
2041:
2042: -- find the entity and / or attribute in the dictionary
2043: OPEN c_entity;
2044: FETCH c_entity INTO l_entity_attr_id;

Line 2052: RAISE FND_API.G_EXC_ERROR;

2048: fnd_message.set_token('RECORD', 'entity attribute');
2049: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
2050: NVL(p_attribute_name,'null'||'>'));
2051: fnd_msg_pub.add;
2052: RAISE FND_API.G_EXC_ERROR;
2053: END IF;
2054: CLOSE c_entity;
2055:
2056: -- find the group the attribute belongs to

Line 2059: p_attribute_name <> FND_API.G_MISS_CHAR

2055:
2056: -- find the group the attribute belongs to
2057:
2058: IF p_attribute_name IS NOT NULL AND
2059: p_attribute_name <> FND_API.G_MISS_CHAR
2060: THEN
2061: Find_NameListInAGroup (
2062: p_entity_name => p_entity_name,
2063: p_attribute_name => p_attribute_name,

Line 2093: RAISE FND_API.G_EXC_ERROR;

2089: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||
2090: NVL(p_attribute_name,'null'||'>'));
2091: fnd_message.set_token('SOURCE', p_data_source_tbl(i));
2092: fnd_msg_pub.add;
2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;
2095: CLOSE c_data_source;
2096: END LOOP;
2097:

Line 2120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2116: WHERE entity_attr_id = i_entity_attr_id(i);
2117:
2118: END LOOP;
2119:
2120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2121: RAISE FND_API.G_EXC_ERROR;
2122: END IF;
2123:
2124: -- Standard call to get message count and if count is 1, get message info.

Line 2121: RAISE FND_API.G_EXC_ERROR;

2117:
2118: END LOOP;
2119:
2120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2121: RAISE FND_API.G_EXC_ERROR;
2122: END IF;
2123:
2124: -- Standard call to get message count and if count is 1, get message info.
2125: fnd_msg_pub.Count_And_Get(

Line 2126: p_encoded => FND_API.G_FALSE,

2122: END IF;
2123:
2124: -- Standard call to get message count and if count is 1, get message info.
2125: fnd_msg_pub.Count_And_Get(
2126: p_encoded => FND_API.G_FALSE,
2127: p_count => x_msg_count,
2128: p_data => x_msg_data );
2129:
2130: -- Debug info.

Line 2148: WHEN FND_API.G_EXC_ERROR THEN

2144: -- Check if API is called in debug mode. If yes, disable debug.
2145: --disable_debug;
2146:
2147: EXCEPTION
2148: WHEN FND_API.G_EXC_ERROR THEN
2149: ROLLBACK TO Remove_EntityAttrDataSource;
2150: x_return_status := FND_API.G_RET_STS_ERROR;
2151:
2152: fnd_msg_pub.Count_And_Get(

Line 2150: x_return_status := FND_API.G_RET_STS_ERROR;

2146:
2147: EXCEPTION
2148: WHEN FND_API.G_EXC_ERROR THEN
2149: ROLLBACK TO Remove_EntityAttrDataSource;
2150: x_return_status := FND_API.G_RET_STS_ERROR;
2151:
2152: fnd_msg_pub.Count_And_Get(
2153: p_encoded => FND_API.G_FALSE,
2154: p_count => x_msg_count,

Line 2153: p_encoded => FND_API.G_FALSE,

2149: ROLLBACK TO Remove_EntityAttrDataSource;
2150: x_return_status := FND_API.G_RET_STS_ERROR;
2151:
2152: fnd_msg_pub.Count_And_Get(
2153: p_encoded => FND_API.G_FALSE,
2154: p_count => x_msg_count,
2155: p_data => x_msg_data );
2156:
2157: -- Debug info.

Line 2173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2169:
2170: -- Check if API is called in debug mode. If yes, disable debug.
2171: --disable_debug;
2172:
2173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2174: ROLLBACK TO Remove_EntityAttrDataSource;
2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2176:
2177: fnd_msg_pub.Count_And_Get(

Line 2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2171: --disable_debug;
2172:
2173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2174: ROLLBACK TO Remove_EntityAttrDataSource;
2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2176:
2177: fnd_msg_pub.Count_And_Get(
2178: p_encoded => FND_API.G_FALSE,
2179: p_count => x_msg_count,

Line 2178: p_encoded => FND_API.G_FALSE,

2174: ROLLBACK TO Remove_EntityAttrDataSource;
2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2176:
2177: fnd_msg_pub.Count_And_Get(
2178: p_encoded => FND_API.G_FALSE,
2179: p_count => x_msg_count,
2180: p_data => x_msg_data );
2181:
2182: -- Debug info.

Line 2200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2196: --disable_debug;
2197:
2198: WHEN OTHERS THEN
2199: ROLLBACK TO Remove_EntityAttrDataSource;
2200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2201:
2202: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2203: fnd_message.set_token('ERROR',SQLERRM);
2204: fnd_msg_pub.add;

Line 2207: p_encoded => FND_API.G_FALSE,

2203: fnd_message.set_token('ERROR',SQLERRM);
2204: fnd_msg_pub.add;
2205:
2206: fnd_msg_pub.Count_And_Get(
2207: p_encoded => FND_API.G_FALSE,
2208: p_count => x_msg_count,
2209: p_data => x_msg_data );
2210:
2211: -- Debug info.