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 1013: x_return_status := fnd_api.g_ret_sts_error;

1009: fnd_message.set_name('AR', 'HZ_API_INVALID_ATTRIBUTE');
1010: fnd_message.set_token('ATTRIBUTE', p_attribute_name);
1011: fnd_message.set_token('ENTITY', l_name);
1012: fnd_msg_pub.add;
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: END IF;
1015:
1016: -- Debug info.
1017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1160: --
1161: -- entity_attr_id
1162: hz_entity_attributes_s.NEXTVAL,
1163: DECODE(p_entity_attribute_rec.entity_name,
1164: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.entity_name),
1165: DECODE(p_entity_attribute_rec.attribute_name,
1166: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),
1167: p_group_name,
1168: DECODE(p_entity_attribute_rec.created_by_module,

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

1162: hz_entity_attributes_s.NEXTVAL,
1163: DECODE(p_entity_attribute_rec.entity_name,
1164: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.entity_name),
1165: DECODE(p_entity_attribute_rec.attribute_name,
1166: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),
1167: p_group_name,
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,

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

1165: DECODE(p_entity_attribute_rec.attribute_name,
1166: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),
1167: p_group_name,
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,

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

1167: p_group_name,
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,

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

1338: *
1339: * ARGUMENTS
1340: * IN:
1341: * p_init_msg_list Initialize message stack if it is set to
1342: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1343: * p_entity_attribute_rec Entity Attribute record.
1344: * p_data_source_tbl PL/SQL Table for Data Source Setup.
1345: * IN/OUT:
1346: * OUT:

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

1345: * IN/OUT:
1346: * OUT:
1347: * x_entity_attr_id Dictionary ID.
1348: * x_return_status Return status after the call. The status can
1349: * be FND_API.G_RET_STS_SUCCESS (success),
1350: * FND_API.G_RET_STS_ERROR (error),
1351: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1352: * x_msg_count Number of messages in message stack.
1353: * x_msg_data Message text if x_msg_count is 1.

Line 1350: * FND_API.G_RET_STS_ERROR (error),

1346: * OUT:
1347: * x_entity_attr_id Dictionary ID.
1348: * x_return_status Return status after the call. The status can
1349: * be FND_API.G_RET_STS_SUCCESS (success),
1350: * FND_API.G_RET_STS_ERROR (error),
1351: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1352: * x_msg_count Number of messages in message stack.
1353: * x_msg_data Message text if x_msg_count is 1.
1354: *

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

1347: * x_entity_attr_id Dictionary ID.
1348: * x_return_status Return status after the call. The status can
1349: * be FND_API.G_RET_STS_SUCCESS (success),
1350: * FND_API.G_RET_STS_ERROR (error),
1351: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1352: * x_msg_count Number of messages in message stack.
1353: * x_msg_data Message text if x_msg_count is 1.
1354: *
1355: * NOTES

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

1359: * 02-12-2002 Jianying Huang o Created.
1360: */
1361:
1362: PROCEDURE Add_EntityAttribute (
1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1364: p_entity_attribute_rec IN ENTITY_ATTRIBUTE_REC_TYPE,
1365: p_data_source_tab IN DATA_SOURCE_TBL,
1366: x_entity_attr_id OUT NOCOPY NUMBER,
1367: x_return_status OUT NOCOPY VARCHAR2,

Line 1388: IF fnd_api.to_Boolean(p_init_msg_list) THEN

1384: p_msg_level=>fnd_log.level_procedure);
1385: END IF;
1386:
1387: -- Initialize message list if p_init_msg_list is set to TRUE.
1388: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1389: fnd_msg_pub.initialize;
1390: END IF;
1391:
1392: -- Initialize API return status to success.

Line 1393: x_return_status := FND_API.G_RET_STS_SUCCESS;

1389: fnd_msg_pub.initialize;
1390: END IF;
1391:
1392: -- Initialize API return status to success.
1393: x_return_status := FND_API.G_RET_STS_SUCCESS;
1394:
1395: -- Call business logic.
1396: do_AddEntityAttribute (
1397: p_entity_attribute_rec,

Line 1404: p_encoded => FND_API.G_FALSE,

1400: x_return_status );
1401:
1402: -- Standard call to get message count and if count is 1, get message info.
1403: fnd_msg_pub.Count_And_Get(
1404: p_encoded => FND_API.G_FALSE,
1405: p_count => x_msg_count,
1406: p_data => x_msg_data );
1407:
1408: -- Debug info.

Line 1425: WHEN FND_API.G_EXC_ERROR THEN

1421: -- Check if API is called in debug mode. If yes, disable debug.
1422: --disable_debug;
1423:
1424: EXCEPTION
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO Add_EntityAttribute;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428:
1429: fnd_msg_pub.Count_And_Get(

Line 1427: x_return_status := FND_API.G_RET_STS_ERROR;

1423:
1424: EXCEPTION
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO Add_EntityAttribute;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428:
1429: fnd_msg_pub.Count_And_Get(
1430: p_encoded => FND_API.G_FALSE,
1431: p_count => x_msg_count,

Line 1430: p_encoded => FND_API.G_FALSE,

1426: ROLLBACK TO Add_EntityAttribute;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428:
1429: fnd_msg_pub.Count_And_Get(
1430: p_encoded => FND_API.G_FALSE,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data );
1433:
1434: -- Debug info.

Line 1450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1446:
1447: -- Check if API is called in debug mode. If yes, disable debug.
1448: --disable_debug;
1449:
1450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1451: ROLLBACK TO Add_EntityAttribute;
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453:
1454: fnd_msg_pub.Count_And_Get(

Line 1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1448: --disable_debug;
1449:
1450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1451: ROLLBACK TO Add_EntityAttribute;
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453:
1454: fnd_msg_pub.Count_And_Get(
1455: p_encoded => FND_API.G_FALSE,
1456: p_count => x_msg_count,

Line 1455: p_encoded => FND_API.G_FALSE,

1451: ROLLBACK TO Add_EntityAttribute;
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453:
1454: fnd_msg_pub.Count_And_Get(
1455: p_encoded => FND_API.G_FALSE,
1456: p_count => x_msg_count,
1457: p_data => x_msg_data );
1458:
1459: -- Debug info.

Line 1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1473: --disable_debug;
1474:
1475: WHEN OTHERS THEN
1476: ROLLBACK TO Add_EntityAttribute;
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478:
1479: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1480: fnd_message.set_token('ERROR',SQLERRM);
1481: fnd_msg_pub.add;

Line 1484: p_encoded => FND_API.G_FALSE,

1480: fnd_message.set_token('ERROR',SQLERRM);
1481: fnd_msg_pub.add;
1482:
1483: fnd_msg_pub.Count_And_Get(
1484: p_encoded => FND_API.G_FALSE,
1485: p_count => x_msg_count,
1486: p_data => x_msg_data );
1487:
1488: -- Debug info.

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

1513: *
1514: * ARGUMENTS
1515: * IN:
1516: * p_init_msg_list Initialize message stack if it is set to
1517: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1518: * p_entity_name Entity Name
1519: * p_attribute_name Attribute Name
1520: * IN/OUT:
1521: * OUT:

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

1520: * IN/OUT:
1521: * OUT:
1522: * x_data_source_tbl PL/SQL Table for Data Source Setup.
1523: * x_return_status Return status after the call. The status can
1524: * be FND_API.G_RET_STS_SUCCESS (success),
1525: * FND_API.G_RET_STS_ERROR (error),
1526: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1527: * x_msg_count Number of messages in message stack.
1528: * x_msg_data Message text if x_msg_count is 1.

Line 1525: * FND_API.G_RET_STS_ERROR (error),

1521: * OUT:
1522: * x_data_source_tbl PL/SQL Table for Data Source Setup.
1523: * x_return_status Return status after the call. The status can
1524: * be FND_API.G_RET_STS_SUCCESS (success),
1525: * FND_API.G_RET_STS_ERROR (error),
1526: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1527: * x_msg_count Number of messages in message stack.
1528: * x_msg_data Message text if x_msg_count is 1.
1529: *

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

1522: * x_data_source_tbl PL/SQL Table for Data Source Setup.
1523: * x_return_status Return status after the call. The status can
1524: * be FND_API.G_RET_STS_SUCCESS (success),
1525: * FND_API.G_RET_STS_ERROR (error),
1526: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1527: * x_msg_count Number of messages in message stack.
1528: * x_msg_data Message text if x_msg_count is 1.
1529: *
1530: * NOTES

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

1534: * 02-12-2002 Jianying Huang o Created.
1535: */
1536:
1537: PROCEDURE Get_EntityAttribute (
1538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1539: p_entity_name IN VARCHAR2,
1540: p_attribute_name IN VARCHAR2,
1541: x_data_source_tbl OUT NOCOPY DATA_SOURCE_TBL,
1542: x_return_status OUT NOCOPY VARCHAR2,

Line 1557: p_attribute_name = FND_API.G_MISS_CHAR)) OR

1553: FROM hz_entity_attributes
1554: WHERE entity_name = p_entity_name
1555: AND ((attribute_name IS NULL AND
1556: (p_attribute_name IS NULL OR
1557: p_attribute_name = FND_API.G_MISS_CHAR)) OR
1558: (attribute_name = p_attribute_name));
1559:
1560: CURSOR c_data_sources (
1561: p_entity_attr_id NUMBER

Line 1581: IF fnd_api.to_Boolean(p_init_msg_list) THEN

1577: p_msg_level=>fnd_log.level_procedure);
1578: END IF;
1579:
1580: -- Initialize message list if p_init_msg_list is set to TRUE.
1581: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1582: fnd_msg_pub.initialize;
1583: END IF;
1584:
1585: -- Initialize API return status to success.

Line 1586: x_return_status := FND_API.G_RET_STS_SUCCESS;

1582: fnd_msg_pub.initialize;
1583: END IF;
1584:
1585: -- Initialize API return status to success.
1586: x_return_status := FND_API.G_RET_STS_SUCCESS;
1587:
1588: -- find the entity and / or attribute in the dictionary
1589: OPEN c_entity;
1590: FETCH c_entity INTO l_entity_attr_id;

Line 1598: RAISE FND_API.G_EXC_ERROR;

1594: fnd_message.set_token('RECORD', 'entity attribute');
1595: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
1596: NVL(p_attribute_name,'null'||'>'));
1597: fnd_msg_pub.add;
1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600: CLOSE c_entity;
1601:
1602: -- select data sources.

Line 1611: p_encoded => FND_API.G_FALSE,

1607: x_data_source_tbl := l_data_source_tbl;
1608:
1609: -- Standard call to get message count and if count is 1, get message info.
1610: fnd_msg_pub.Count_And_Get(
1611: p_encoded => FND_API.G_FALSE,
1612: p_count => x_msg_count,
1613: p_data => x_msg_data );
1614:
1615: -- Debug info.

Line 1634: WHEN FND_API.G_EXC_ERROR THEN

1630: -- Check if API is called in debug mode. If yes, disable debug.
1631: --disable_debug;
1632:
1633: EXCEPTION
1634: WHEN FND_API.G_EXC_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636:
1637: fnd_msg_pub.Count_And_Get(
1638: p_encoded => FND_API.G_FALSE,

Line 1635: x_return_status := FND_API.G_RET_STS_ERROR;

1631: --disable_debug;
1632:
1633: EXCEPTION
1634: WHEN FND_API.G_EXC_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636:
1637: fnd_msg_pub.Count_And_Get(
1638: p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count,

Line 1638: p_encoded => FND_API.G_FALSE,

1634: WHEN FND_API.G_EXC_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636:
1637: fnd_msg_pub.Count_And_Get(
1638: p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count,
1640: p_data => x_msg_data );
1641:
1642: -- Debug info.

Line 1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1655:
1656: -- Check if API is called in debug mode. If yes, disable debug.
1657: --disable_debug;
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661:
1662: fnd_msg_pub.Count_And_Get(
1663: p_encoded => FND_API.G_FALSE,

Line 1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1656: -- Check if API is called in debug mode. If yes, disable debug.
1657: --disable_debug;
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661:
1662: fnd_msg_pub.Count_And_Get(
1663: p_encoded => FND_API.G_FALSE,
1664: p_count => x_msg_count,

Line 1663: p_encoded => FND_API.G_FALSE,

1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661:
1662: fnd_msg_pub.Count_And_Get(
1663: p_encoded => FND_API.G_FALSE,
1664: p_count => x_msg_count,
1665: p_data => x_msg_data );
1666:
1667: -- Debug info.

Line 1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1680: -- Check if API is called in debug mode. If yes, disable debug.
1681: --disable_debug;
1682:
1683: WHEN OTHERS THEN
1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1685:
1686: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1687: fnd_message.set_token('ERROR',SQLERRM);
1688: fnd_msg_pub.add;

Line 1691: p_encoded => FND_API.G_FALSE,

1687: fnd_message.set_token('ERROR',SQLERRM);
1688: fnd_msg_pub.add;
1689:
1690: fnd_msg_pub.Count_And_Get(
1691: p_encoded => FND_API.G_FALSE,
1692: p_count => x_msg_count,
1693: p_data => x_msg_data );
1694:
1695: -- Debug info.

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

1720: *
1721: * ARGUMENTS
1722: * IN:
1723: * p_init_msg_list Initialize message stack if it is set to
1724: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1725: * p_entity_name Entity Name
1726: * p_attribute_name Attribute Name
1727: * IN/OUT:
1728: * OUT:

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

1726: * p_attribute_name Attribute Name
1727: * IN/OUT:
1728: * OUT:
1729: * x_return_status Return status after the call. The status can
1730: * be FND_API.G_RET_STS_SUCCESS (success),
1731: * FND_API.G_RET_STS_ERROR (error),
1732: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1733: * x_msg_count Number of messages in message stack.
1734: * x_msg_data Message text if x_msg_count is 1.

Line 1731: * FND_API.G_RET_STS_ERROR (error),

1727: * IN/OUT:
1728: * OUT:
1729: * x_return_status Return status after the call. The status can
1730: * be FND_API.G_RET_STS_SUCCESS (success),
1731: * FND_API.G_RET_STS_ERROR (error),
1732: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1733: * x_msg_count Number of messages in message stack.
1734: * x_msg_data Message text if x_msg_count is 1.
1735: *

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

1728: * OUT:
1729: * x_return_status Return status after the call. The status can
1730: * be FND_API.G_RET_STS_SUCCESS (success),
1731: * FND_API.G_RET_STS_ERROR (error),
1732: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1733: * x_msg_count Number of messages in message stack.
1734: * x_msg_data Message text if x_msg_count is 1.
1735: *
1736: * NOTES

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

1740: * 02-12-2002 Jianying Huang o Created.
1741: */
1742:
1743: PROCEDURE Remove_EntityAttribute (
1744: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1745: p_entity_name IN VARCHAR2,
1746: p_attribute_name IN VARCHAR2,
1747: x_return_status OUT NOCOPY VARCHAR2,
1748: x_msg_count OUT NOCOPY NUMBER,

Line 1766: p_attribute_name = FND_API.G_MISS_CHAR)) OR

1762: FROM hz_entity_attributes
1763: WHERE entity_name = p_entity_name
1764: AND ((attribute_name IS NULL AND
1765: (p_attribute_name IS NULL OR
1766: p_attribute_name = FND_API.G_MISS_CHAR)) OR
1767: (attribute_name = p_attribute_name));
1768:
1769: CURSOR c_selected_data_source (
1770: p_entity_attr_id NUMBER

Line 1795: IF fnd_api.to_Boolean(p_init_msg_list) THEN

1791: p_msg_level=>fnd_log.level_procedure);
1792: END IF;
1793:
1794: -- Initialize message list if p_init_msg_list is set to TRUE.
1795: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1796: fnd_msg_pub.initialize;
1797: END IF;
1798:
1799: -- Initialize API return status to success.

Line 1800: x_return_status := FND_API.G_RET_STS_SUCCESS;

1796: fnd_msg_pub.initialize;
1797: END IF;
1798:
1799: -- Initialize API return status to success.
1800: x_return_status := FND_API.G_RET_STS_SUCCESS;
1801:
1802: -- find the entity and / or attribute in the dictionary
1803: OPEN c_entity;
1804: FETCH c_entity INTO l_entity_attr_id;

Line 1812: RAISE FND_API.G_EXC_ERROR;

1808: fnd_message.set_token('RECORD', 'entity attribute');
1809: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
1810: NVL(p_attribute_name,'null'||'>'));
1811: fnd_msg_pub.add;
1812: RAISE FND_API.G_EXC_ERROR;
1813: END IF;
1814: CLOSE c_entity;
1815:
1816: -- find the group the attribute belongs to

Line 1819: p_attribute_name <> FND_API.G_MISS_CHAR

1815:
1816: -- find the group the attribute belongs to
1817:
1818: IF p_attribute_name IS NOT NULL AND
1819: p_attribute_name <> FND_API.G_MISS_CHAR
1820: THEN
1821: Find_NameListInAGroup (
1822: p_entity_name => p_entity_name,
1823: p_attribute_name => p_attribute_name,

Line 1862: RAISE FND_API.G_EXC_ERROR;

1858: fnd_message.set_name('AR', 'HZ_API_CANNOT_DELETE_ENTITY');
1859: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||
1860: NVL(p_attribute_name,'null'||'>'));
1861: fnd_msg_pub.add;
1862: RAISE FND_API.G_EXC_ERROR;
1863: END IF;
1864: CLOSE c_selected_data_source;
1865: END LOOP;
1866:

Line 1869: p_encoded => FND_API.G_FALSE,

1865: END LOOP;
1866:
1867: -- Standard call to get message count and if count is 1, get message info.
1868: fnd_msg_pub.Count_And_Get(
1869: p_encoded => FND_API.G_FALSE,
1870: p_count => x_msg_count,
1871: p_data => x_msg_data );
1872:
1873: -- Debug info.

Line 1890: WHEN FND_API.G_EXC_ERROR THEN

1886: -- Check if API is called in debug mode. If yes, disable debug.
1887: --disable_debug;
1888:
1889: EXCEPTION
1890: WHEN FND_API.G_EXC_ERROR THEN
1891: ROLLBACK TO Remove_EntityAttribute;
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893:
1894: fnd_msg_pub.Count_And_Get(

Line 1892: x_return_status := FND_API.G_RET_STS_ERROR;

1888:
1889: EXCEPTION
1890: WHEN FND_API.G_EXC_ERROR THEN
1891: ROLLBACK TO Remove_EntityAttribute;
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893:
1894: fnd_msg_pub.Count_And_Get(
1895: p_encoded => FND_API.G_FALSE,
1896: p_count => x_msg_count,

Line 1895: p_encoded => FND_API.G_FALSE,

1891: ROLLBACK TO Remove_EntityAttribute;
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893:
1894: fnd_msg_pub.Count_And_Get(
1895: p_encoded => FND_API.G_FALSE,
1896: p_count => x_msg_count,
1897: p_data => x_msg_data );
1898:
1899: -- Debug info.

Line 1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1911:
1912: -- Check if API is called in debug mode. If yes, disable debug.
1913: --disable_debug;
1914:
1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1916: ROLLBACK TO Remove_EntityAttribute;
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918:
1919: fnd_msg_pub.Count_And_Get(

Line 1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1913: --disable_debug;
1914:
1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1916: ROLLBACK TO Remove_EntityAttribute;
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918:
1919: fnd_msg_pub.Count_And_Get(
1920: p_encoded => FND_API.G_FALSE,
1921: p_count => x_msg_count,

Line 1920: p_encoded => FND_API.G_FALSE,

1916: ROLLBACK TO Remove_EntityAttribute;
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918:
1919: fnd_msg_pub.Count_And_Get(
1920: p_encoded => FND_API.G_FALSE,
1921: p_count => x_msg_count,
1922: p_data => x_msg_data );
1923:
1924: -- Debug info.

Line 1942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1938: --disable_debug;
1939:
1940: WHEN OTHERS THEN
1941: ROLLBACK TO Remove_EntityAttribute;
1942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1943:
1944: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1945: fnd_message.set_token('ERROR',SQLERRM);
1946: fnd_msg_pub.add;

Line 1949: p_encoded => FND_API.G_FALSE,

1945: fnd_message.set_token('ERROR',SQLERRM);
1946: fnd_msg_pub.add;
1947:
1948: fnd_msg_pub.Count_And_Get(
1949: p_encoded => FND_API.G_FALSE,
1950: p_count => x_msg_count,
1951: p_data => x_msg_data );
1952:
1953: -- Debug info.

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

1979: *
1980: * ARGUMENTS
1981: * IN:
1982: * p_init_msg_list Initialize message stack if it is set to
1983: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1984: * p_entity_name Entity Name
1985: * p_attribute_name Attribute Name
1986: * IN/OUT:
1987: * OUT:

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

1985: * p_attribute_name Attribute Name
1986: * IN/OUT:
1987: * OUT:
1988: * x_return_status Return status after the call. The status can
1989: * be FND_API.G_RET_STS_SUCCESS (success),
1990: * FND_API.G_RET_STS_ERROR (error),
1991: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1992: * x_msg_count Number of messages in message stack.
1993: * x_msg_data Message text if x_msg_count is 1.

Line 1990: * FND_API.G_RET_STS_ERROR (error),

1986: * IN/OUT:
1987: * OUT:
1988: * x_return_status Return status after the call. The status can
1989: * be FND_API.G_RET_STS_SUCCESS (success),
1990: * FND_API.G_RET_STS_ERROR (error),
1991: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1992: * x_msg_count Number of messages in message stack.
1993: * x_msg_data Message text if x_msg_count is 1.
1994: *

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

1987: * OUT:
1988: * x_return_status Return status after the call. The status can
1989: * be FND_API.G_RET_STS_SUCCESS (success),
1990: * FND_API.G_RET_STS_ERROR (error),
1991: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1992: * x_msg_count Number of messages in message stack.
1993: * x_msg_data Message text if x_msg_count is 1.
1994: *
1995: * NOTES

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

1999: * 02-12-2002 Jianying Huang o Created.
2000: */
2001:
2002: PROCEDURE Remove_EntityAttrDataSource (
2003: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2004: p_entity_name IN VARCHAR2,
2005: p_attribute_name IN VARCHAR2,
2006: p_data_source_tbl IN DATA_SOURCE_TBL,
2007: x_return_status OUT NOCOPY VARCHAR2,

Line 2025: p_attribute_name = FND_API.G_MISS_CHAR)) OR

2021: FROM hz_entity_attributes
2022: WHERE entity_name = p_entity_name
2023: AND ((attribute_name IS NULL AND
2024: (p_attribute_name IS NULL OR
2025: p_attribute_name = FND_API.G_MISS_CHAR)) OR
2026: (attribute_name = p_attribute_name));
2027:
2028: CURSOR c_data_source (
2029: p_entity_attr_id NUMBER,

Line 2057: IF fnd_api.to_Boolean(p_init_msg_list) THEN

2053: p_msg_level=>fnd_log.level_procedure);
2054: END IF;
2055:
2056: -- Initialize message list if p_init_msg_list is set to TRUE.
2057: IF fnd_api.to_Boolean(p_init_msg_list) THEN
2058: fnd_msg_pub.initialize;
2059: END IF;
2060:
2061: -- Initialize API return status to success.

Line 2062: x_return_status := FND_API.G_RET_STS_SUCCESS;

2058: fnd_msg_pub.initialize;
2059: END IF;
2060:
2061: -- Initialize API return status to success.
2062: x_return_status := FND_API.G_RET_STS_SUCCESS;
2063:
2064: -- find the entity and / or attribute in the dictionary
2065: OPEN c_entity;
2066: FETCH c_entity INTO l_entity_attr_id;

Line 2074: RAISE FND_API.G_EXC_ERROR;

2070: fnd_message.set_token('RECORD', 'entity attribute');
2071: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
2072: NVL(p_attribute_name,'null'||'>'));
2073: fnd_msg_pub.add;
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;
2076: CLOSE c_entity;
2077:
2078: -- find the group the attribute belongs to

Line 2081: p_attribute_name <> FND_API.G_MISS_CHAR

2077:
2078: -- find the group the attribute belongs to
2079:
2080: IF p_attribute_name IS NOT NULL AND
2081: p_attribute_name <> FND_API.G_MISS_CHAR
2082: THEN
2083: Find_NameListInAGroup (
2084: p_entity_name => p_entity_name,
2085: p_attribute_name => p_attribute_name,

Line 2115: RAISE FND_API.G_EXC_ERROR;

2111: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||
2112: NVL(p_attribute_name,'null'||'>'));
2113: fnd_message.set_token('SOURCE', p_data_source_tbl(i));
2114: fnd_msg_pub.add;
2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;
2117: CLOSE c_data_source;
2118: END LOOP;
2119:

Line 2142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2138: WHERE entity_attr_id = i_entity_attr_id(i);
2139:
2140: END LOOP;
2141:
2142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145:
2146: -- Standard call to get message count and if count is 1, get message info.

Line 2143: RAISE FND_API.G_EXC_ERROR;

2139:
2140: END LOOP;
2141:
2142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145:
2146: -- Standard call to get message count and if count is 1, get message info.
2147: fnd_msg_pub.Count_And_Get(

Line 2148: p_encoded => FND_API.G_FALSE,

2144: END IF;
2145:
2146: -- Standard call to get message count and if count is 1, get message info.
2147: fnd_msg_pub.Count_And_Get(
2148: p_encoded => FND_API.G_FALSE,
2149: p_count => x_msg_count,
2150: p_data => x_msg_data );
2151:
2152: -- Debug info.

Line 2170: WHEN FND_API.G_EXC_ERROR THEN

2166: -- Check if API is called in debug mode. If yes, disable debug.
2167: --disable_debug;
2168:
2169: EXCEPTION
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO Remove_EntityAttrDataSource;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173:
2174: fnd_msg_pub.Count_And_Get(

Line 2172: x_return_status := FND_API.G_RET_STS_ERROR;

2168:
2169: EXCEPTION
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO Remove_EntityAttrDataSource;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173:
2174: fnd_msg_pub.Count_And_Get(
2175: p_encoded => FND_API.G_FALSE,
2176: p_count => x_msg_count,

Line 2175: p_encoded => FND_API.G_FALSE,

2171: ROLLBACK TO Remove_EntityAttrDataSource;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173:
2174: fnd_msg_pub.Count_And_Get(
2175: p_encoded => FND_API.G_FALSE,
2176: p_count => x_msg_count,
2177: p_data => x_msg_data );
2178:
2179: -- Debug info.

Line 2195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2191:
2192: -- Check if API is called in debug mode. If yes, disable debug.
2193: --disable_debug;
2194:
2195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2196: ROLLBACK TO Remove_EntityAttrDataSource;
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2198:
2199: fnd_msg_pub.Count_And_Get(

Line 2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2193: --disable_debug;
2194:
2195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2196: ROLLBACK TO Remove_EntityAttrDataSource;
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2198:
2199: fnd_msg_pub.Count_And_Get(
2200: p_encoded => FND_API.G_FALSE,
2201: p_count => x_msg_count,

Line 2200: p_encoded => FND_API.G_FALSE,

2196: ROLLBACK TO Remove_EntityAttrDataSource;
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2198:
2199: fnd_msg_pub.Count_And_Get(
2200: p_encoded => FND_API.G_FALSE,
2201: p_count => x_msg_count,
2202: p_data => x_msg_data );
2203:
2204: -- Debug info.

Line 2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2218: --disable_debug;
2219:
2220: WHEN OTHERS THEN
2221: ROLLBACK TO Remove_EntityAttrDataSource;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223:
2224: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2225: fnd_message.set_token('ERROR',SQLERRM);
2226: fnd_msg_pub.add;

Line 2229: p_encoded => FND_API.G_FALSE,

2225: fnd_message.set_token('ERROR',SQLERRM);
2226: fnd_msg_pub.add;
2227:
2228: fnd_msg_pub.Count_And_Get(
2229: p_encoded => FND_API.G_FALSE,
2230: p_count => x_msg_count,
2231: p_data => x_msg_data );
2232:
2233: -- Debug info.