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_NAME_ADDRESS_FMT_VALIDATE dependencies on FND_MSG_PUB

Line 93: FND_MSG_PUB.ADD;

89: BEGIN
90: IF p_column_value <= 0 THEN
91: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_GREATER_THAN_ZERO' );
92: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
93: FND_MSG_PUB.ADD;
94: x_return_status := FND_API.G_RET_STS_ERROR;
95: END IF;
96:
97: END check_greater_than_zero;

Line 302: FND_MSG_PUB.ADD;

298: where style_code = p_style_rec.style_code;
299:
300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
301: FND_MESSAGE.SET_TOKEN('COLUMN', 'style_code');
302: FND_MSG_PUB.ADD;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304:
305: EXCEPTION
306: WHEN NO_DATA_FOUND THEN

Line 374: fnd_msg_pub.add;

370: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
371: fnd_message.set_token('FK', 'database_object_name');
372: fnd_message.set_token('COLUMN', 'table_name');
373: fnd_message.set_token('TABLE', 'fnd_tables');
374: fnd_msg_pub.add;
375: x_return_status := fnd_api.g_ret_sts_error;
376: END;
377:
378: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 435: FND_MSG_PUB.ADD;

431: where style_name = p_style_rec.style_name
432: and language = userenv('LANG');
433:
434: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_NAME_DUP');
435: FND_MSG_PUB.ADD;
436: x_return_status := FND_API.G_RET_STS_ERROR;
437:
438: EXCEPTION
439: WHEN NO_DATA_FOUND THEN

Line 584: FND_MSG_PUB.ADD;

580: where style_format_code = p_style_format_rec.style_format_code;
581:
582: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
583: FND_MESSAGE.SET_TOKEN('COLUMN', 'style_format_code');
584: FND_MSG_PUB.ADD;
585: x_return_status := FND_API.G_RET_STS_ERROR;
586:
587: EXCEPTION
588: WHEN NO_DATA_FOUND THEN

Line 658: fnd_msg_pub.add;

654: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
655: fnd_message.set_token('FK', 'style_code');
656: fnd_message.set_token('COLUMN', 'style_code');
657: fnd_message.set_token('TABLE', 'hz_styles_b');
658: fnd_msg_pub.add;
659: x_return_status := fnd_api.g_ret_sts_error;
660: END;
661:
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 727: fnd_msg_pub.add;

723: p_style_format_rec.default_flag = 'N' AND
724: l_default_flag = 'Y'
725: THEN
726: fnd_message.set_name('AR', 'HZ_STL_FMT_FLAG_NOT_Y_TO_N');
727: fnd_msg_pub.add;
728: x_return_status := fnd_api.g_ret_sts_error;
729:
730: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
731: hz_utility_v2pub.debug(p_message=>'default_flag cannot be set from Yes to No. ' ||

Line 787: FND_MSG_PUB.ADD;

783: where style_format_name = p_style_format_rec.style_format_name
784: and language = userenv('LANG');
785:
786: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_FMT_NAME_DUP');
787: FND_MSG_PUB.ADD;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789:
790: EXCEPTION
791: WHEN NO_DATA_FOUND THEN

Line 917: fnd_msg_pub.add;

913: -- key is not unique, push an error onto the stack.
914: IF NVL(c_dup%FOUND, FALSE) THEN
915: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
916: fnd_message.set_token('COLUMN', 'style_fmt_locale_id');
917: fnd_msg_pub.add;
918: x_return_status := fnd_api.g_ret_sts_error;
919: END IF;
920: CLOSE c_dup;
921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 997: fnd_msg_pub.add;

993: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
994: fnd_message.set_token('FK', 'style_format_code');
995: fnd_message.set_token('COLUMN', 'style_format_code');
996: fnd_message.set_token('TABLE', 'hz_style_formats_b');
997: fnd_msg_pub.add;
998: x_return_status := fnd_api.g_ret_sts_error;
999: END;
1000: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of hz_style_formats_b. ' ||

Line 1051: fnd_msg_pub.add;

1047: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1048: fnd_message.set_token('FK', 'language_code');
1049: fnd_message.set_token('COLUMN', 'language_code');
1050: fnd_message.set_token('TABLE', 'fnd_languages');
1051: fnd_msg_pub.add;
1052: x_return_status := fnd_api.g_ret_sts_error;
1053: END;
1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'language_code is foreign key of fnd_languages. ' ||

Line 1105: fnd_msg_pub.add;

1101: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1102: fnd_message.set_token('FK', 'territory_code');
1103: fnd_message.set_token('COLUMN', 'territory_code');
1104: fnd_message.set_token('TABLE', 'fnd_territories');
1105: fnd_msg_pub.add;
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: END;
1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1109: hz_utility_v2pub.debug(p_message=>'territory_code is foreign key of fnd_territories. ' ||

Line 1128: FND_MSG_PUB.ADD;

1124: (p_style_fmt_locale_rec.territory_code IS NOT NULL ) AND
1125: p_style_fmt_locale_rec.territory_code <> fnd_api.g_miss_char ) )
1126: THEN
1127: FND_MESSAGE.SET_NAME('AR', 'HZ_STL_FMT_LOC_MISSING_COLUMN');
1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130:
1131: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'Either language_code or territory_code must have a value. ' ||

Line 1188: fnd_msg_pub.add;

1184: p_style_fmt_locale_rec.end_date_active <> fnd_api.g_miss_date AND
1185: p_style_fmt_locale_rec.end_date_active < p_style_fmt_locale_rec.start_date_active
1186: THEN
1187: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1188: fnd_msg_pub.add;
1189: x_return_status := fnd_api.g_ret_sts_error;
1190: END IF;
1191: ELSIF (p_create_update_flag = 'U') THEN
1192: -- old start_date_active, end_date_active has been selected from table

Line 1212: fnd_msg_pub.add;

1208: IF l_end_date_active IS NOT NULL
1209: AND l_end_date_active < l_start_date_active
1210: THEN
1211: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1212: fnd_msg_pub.add;
1213: x_return_status := fnd_api.g_ret_sts_error;
1214: END IF;
1215: END IF;
1216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1249: FND_MSG_PUB.ADD;

1245: p_style_fmt_locale_rec.start_date_active > end_date_active )) AND
1246: rownum =1;
1247:
1248: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_LOC_DUPLICATE_RECORD');
1249: FND_MSG_PUB.ADD;
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251:
1252: EXCEPTION
1253: WHEN NO_DATA_FOUND THEN

Line 1292: FND_MSG_PUB.ADD;

1288: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'style_fmt_locale_id' );
1289: FND_MESSAGE.SET_TOKEN( 'ID', to_char(l_dup_style_fmt_locale_id) );
1290: FND_MESSAGE.SET_TOKEN( 'ALLCOLUMNS', 'style_format_code, language_code, territory_code validation' );
1291:
1292: FND_MSG_PUB.ADD;
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294:
1295: EXCEPTION
1296: WHEN NO_DATA_FOUND THEN

Line 1454: fnd_msg_pub.add;

1450: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1451: fnd_message.set_token('FK', 'style_format_code');
1452: fnd_message.set_token('COLUMN', 'style_format_code');
1453: fnd_message.set_token('TABLE', 'hz_style_formats_b');
1454: fnd_msg_pub.add;
1455: x_return_status := fnd_api.g_ret_sts_error;
1456: END;
1457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1458: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of hz_style_formats_b. ' ||

Line 1514: FND_MSG_PUB.ADD;

1510: where variation_number = p_style_fmt_variation_rec.variation_number
1511: and style_format_code = p_style_fmt_variation_rec.style_format_code;
1512:
1513: FND_MESSAGE.SET_NAME('AR', 'HZ_VARIATION_NO_DUP');
1514: FND_MSG_PUB.ADD;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516:
1517: EXCEPTION
1518: WHEN NO_DATA_FOUND THEN

Line 1581: FND_MSG_PUB.ADD;

1577: where variation_rank = p_style_fmt_variation_rec.variation_rank
1578: and style_format_code = p_style_fmt_variation_rec.style_format_code;
1579:
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_VARIATION_RANK_DUP');
1581: FND_MSG_PUB.ADD;
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583:
1584: EXCEPTION
1585: WHEN NO_DATA_FOUND THEN

Line 1680: fnd_msg_pub.add;

1676: p_style_fmt_variation_rec.end_date_active <> fnd_api.g_miss_date AND
1677: p_style_fmt_variation_rec.end_date_active < p_style_fmt_variation_rec.start_date_active
1678: THEN
1679: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1680: fnd_msg_pub.add;
1681: x_return_status := fnd_api.g_ret_sts_error;
1682: END IF;
1683: ELSIF (p_create_update_flag = 'U') THEN
1684: -- old start_date_active, end_date_active has been selected from table

Line 1704: fnd_msg_pub.add;

1700: IF l_end_date_active IS NOT NULL
1701: AND l_end_date_active < l_start_date_active
1702: THEN
1703: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1704: fnd_msg_pub.add;
1705: x_return_status := fnd_api.g_ret_sts_error;
1706: END IF;
1707: END IF;
1708:

Line 1863: fnd_msg_pub.add;

1859: -- key is not unique, push an error onto the stack.
1860: IF NVL(c_dup%FOUND, FALSE) THEN
1861: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
1862: fnd_message.set_token('COLUMN', 'style_fmt_layout_id');
1863: fnd_msg_pub.add;
1864: x_return_status := fnd_api.g_ret_sts_error;
1865: END IF;
1866: CLOSE c_dup;
1867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2015: fnd_msg_pub.add;

2011:
2012: EXCEPTION
2013: WHEN NO_DATA_FOUND THEN
2014: fnd_message.set_name('AR', 'HZ_LYT_INVALID_START_END_DATE');
2015: fnd_msg_pub.add;
2016: x_return_status := fnd_api.g_ret_sts_error;
2017: END;
2018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2019: hz_utility_v2pub.debug(p_message=>'Start date and end date should be within the time range of the corresponding style format variation.' ||

Line 2029: fnd_msg_pub.add;

2025: EXCEPTION
2026: WHEN NO_DATA_FOUND THEN
2027: fnd_message.set_name('AR', 'HZ_INVALID_FMT_CODE_VAR_NO');
2028: fnd_message.set_token('VARNUM', p_style_fmt_layout_rec.variation_number);
2029: fnd_msg_pub.add;
2030: x_return_status := fnd_api.g_ret_sts_error;
2031: END;
2032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2033: hz_utility_v2pub.debug(p_message=>'style_format_code and variation_number are foreign key of table hz_style_fmt_variations .' ||

Line 2058: fnd_msg_pub.add;

2054:
2055: EXCEPTION
2056: WHEN NO_DATA_FOUND THEN
2057: fnd_message.set_name('AR', 'HZ_LYT_INVALID_START_END_DATE');
2058: fnd_msg_pub.add;
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: END;
2061: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2062: hz_utility_v2pub.debug(p_message=>'Start date and end date should be within the time range of the corresponding style format variation.' ||

Line 2180: fnd_msg_pub.add;

2176: WHEN NO_DATA_FOUND THEN
2177: fnd_message.set_name('AR', 'HZ_INVALID_ATTR_APPID');
2178: fnd_message.SET_TOKEN('ATTRIBUTE_CODE',p_style_fmt_layout_rec.attribute_code);
2179: fnd_message.SET_TOKEN('TABLE',l_database_object_name);
2180: fnd_msg_pub.add;
2181: x_return_status := fnd_api.g_ret_sts_error;
2182: END;
2183: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2184: hz_utility_v2pub.debug(p_message=>'the ATTRIBUTE_CODE' || p_style_fmt_layout_rec.attribute_code ||

Line 2221: FND_MSG_PUB.ADD;

2217: p_style_fmt_layout_rec.start_date_active > end_date_active )) AND
2218: rownum =1;
2219:
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_ATTR_APPID_DUP');
2221: FND_MSG_PUB.ADD;
2222: x_return_status := FND_API.G_RET_STS_ERROR;
2223:
2224: EXCEPTION
2225: WHEN NO_DATA_FOUND THEN

Line 2256: FND_MSG_PUB.ADD;

2252: l_updated_stl_fmt_layout_rec.start_date_active > end_date_active )) AND
2253: rownum =1;
2254:
2255: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_ATTR_APPID_DUP');
2256: FND_MSG_PUB.ADD;
2257: x_return_status := FND_API.G_RET_STS_ERROR;
2258:
2259: EXCEPTION
2260: WHEN NO_DATA_FOUND THEN

Line 2402: FND_MSG_PUB.ADD;

2398: p_style_fmt_layout_rec.start_date_active > end_date_active )) AND
2399: rownum =1;
2400:
2401: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_LINE_POSITION_DUP');
2402: FND_MSG_PUB.ADD;
2403: x_return_status := FND_API.G_RET_STS_ERROR;
2404:
2405: EXCEPTION
2406: WHEN NO_DATA_FOUND THEN

Line 2437: FND_MSG_PUB.ADD;

2433: l_updated_stl_fmt_layout_rec.start_date_active > end_date_active )) AND
2434: rownum =1;
2435:
2436: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_LINE_POSITION_DUP');
2437: FND_MSG_PUB.ADD;
2438: x_return_status := FND_API.G_RET_STS_ERROR;
2439:
2440: EXCEPTION
2441: WHEN NO_DATA_FOUND THEN

Line 2690: fnd_msg_pub.add;

2686: p_style_fmt_layout_rec.end_date_active <> fnd_api.g_miss_date AND
2687: p_style_fmt_layout_rec.end_date_active < p_style_fmt_layout_rec.start_date_active
2688: THEN
2689: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
2690: fnd_msg_pub.add;
2691: x_return_status := fnd_api.g_ret_sts_error;
2692: END IF;
2693: ELSIF (p_create_update_flag = 'U') THEN
2694: -- old start_date_active, end_date_active has been selected from table

Line 2714: fnd_msg_pub.add;

2710: IF l_end_date_active IS NOT NULL
2711: AND l_end_date_active < l_start_date_active
2712: THEN
2713: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
2714: fnd_msg_pub.add;
2715: x_return_status := fnd_api.g_ret_sts_error;
2716: END IF;
2717: END IF;
2718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN