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_MESSAGE

Line 91: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_GREATER_THAN_ZERO' );

87: ) IS
88:
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;

Line 92: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );

88:
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:

Line 300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

296: select 'Y' into l_dummy
297: from HZ_STYLES_B
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:

Line 301: FND_MESSAGE.SET_TOKEN('COLUMN', 'style_code');

297: from HZ_STYLES_B
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

Line 370: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

366: where t.table_name = p_style_rec.database_object_name ;
367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
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;

Line 371: fnd_message.set_token('FK', 'database_object_name');

367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
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;

Line 372: fnd_message.set_token('COLUMN', 'table_name');

368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
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;

Line 373: fnd_message.set_token('TABLE', 'fnd_tables');

369: WHEN NO_DATA_FOUND THEN
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:

Line 434: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_NAME_DUP');

430: from HZ_STYLES_TL
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

Line 582: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

578: select 'Y' into l_dummy
579: from HZ_STYLE_FORMATS_B
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:

Line 583: FND_MESSAGE.SET_TOKEN('COLUMN', 'style_format_code');

579: from HZ_STYLE_FORMATS_B
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

Line 654: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

650: FROM HZ_STYLES_B
651: WHERE style_code = p_style_format_rec.style_code;
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
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;

Line 655: fnd_message.set_token('FK', 'style_code');

651: WHERE style_code = p_style_format_rec.style_code;
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
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;

Line 656: fnd_message.set_token('COLUMN', 'style_code');

652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
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;

Line 657: fnd_message.set_token('TABLE', 'hz_styles_b');

653: WHEN NO_DATA_FOUND THEN
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:

Line 726: fnd_message.set_name('AR', 'HZ_STL_FMT_FLAG_NOT_Y_TO_N');

722: IF p_create_update_flag = 'U' AND
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

Line 786: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_FMT_NAME_DUP');

782: from HZ_STYLE_FORMATS_TL
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

Line 915: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

911: OPEN c_dup (p_style_fmt_locale_rec.style_fmt_locale_id);
912: FETCH c_dup INTO l_dummy;
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;

Line 916: fnd_message.set_token('COLUMN', 'style_fmt_locale_id');

912: FETCH c_dup INTO l_dummy;
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;

Line 993: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

989: FROM HZ_STYLE_FORMATS_B
990: WHERE style_format_code = p_style_fmt_locale_rec.style_format_code;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
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;

Line 994: fnd_message.set_token('FK', 'style_format_code');

990: WHERE style_format_code = p_style_fmt_locale_rec.style_format_code;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
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;

Line 995: fnd_message.set_token('COLUMN', 'style_format_code');

991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
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;

Line 996: fnd_message.set_token('TABLE', 'hz_style_formats_b');

992: WHEN NO_DATA_FOUND THEN
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

Line 1047: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

1043: FROM FND_LANGUAGES
1044: WHERE language_code = p_style_fmt_locale_rec.language_code;
1045: EXCEPTION
1046: WHEN NO_DATA_FOUND THEN
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;

Line 1048: fnd_message.set_token('FK', 'language_code');

1044: WHERE language_code = p_style_fmt_locale_rec.language_code;
1045: EXCEPTION
1046: WHEN NO_DATA_FOUND THEN
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;

Line 1049: fnd_message.set_token('COLUMN', 'language_code');

1045: EXCEPTION
1046: WHEN NO_DATA_FOUND THEN
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;

Line 1050: fnd_message.set_token('TABLE', 'fnd_languages');

1046: WHEN NO_DATA_FOUND THEN
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

Line 1101: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

1097: FROM FND_TERRITORIES
1098: WHERE territory_code = p_style_fmt_locale_rec.territory_code;
1099: EXCEPTION
1100: WHEN NO_DATA_FOUND THEN
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;

Line 1102: fnd_message.set_token('FK', 'territory_code');

1098: WHERE territory_code = p_style_fmt_locale_rec.territory_code;
1099: EXCEPTION
1100: WHEN NO_DATA_FOUND THEN
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;

Line 1103: fnd_message.set_token('COLUMN', 'territory_code');

1099: EXCEPTION
1100: WHEN NO_DATA_FOUND THEN
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;

Line 1104: fnd_message.set_token('TABLE', 'fnd_territories');

1100: WHEN NO_DATA_FOUND THEN
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

Line 1127: FND_MESSAGE.SET_NAME('AR', 'HZ_STL_FMT_LOC_MISSING_COLUMN');

1123: (p_style_fmt_locale_rec.language_code <> fnd_api.g_miss_char) OR
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

Line 1187: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');

1183: IF p_style_fmt_locale_rec.end_date_active IS NOT NULL AND
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

Line 1211: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');

1207:
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;

Line 1248: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_LOC_DUPLICATE_RECORD');

1244: ( end_date_active is not null and
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

Line 1286: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_DUPLICATE_RECORD');

1282: ( end_date_active is not null and
1283: l_updated_stl_fmt_rec.start_date_active > end_date_active )) AND
1284: rownum =1;
1285:
1286: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_DUPLICATE_RECORD');
1287: FND_MESSAGE.SET_TOKEN( 'TYPE', 'style format locale' );
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' );

Line 1287: FND_MESSAGE.SET_TOKEN( 'TYPE', 'style format locale' );

1283: l_updated_stl_fmt_rec.start_date_active > end_date_active )) AND
1284: rownum =1;
1285:
1286: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_DUPLICATE_RECORD');
1287: FND_MESSAGE.SET_TOKEN( 'TYPE', 'style format locale' );
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:

Line 1288: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'style_fmt_locale_id' );

1284: rownum =1;
1285:
1286: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_DUPLICATE_RECORD');
1287: FND_MESSAGE.SET_TOKEN( 'TYPE', 'style format locale' );
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;

Line 1289: FND_MESSAGE.SET_TOKEN( 'ID', to_char(l_dup_style_fmt_locale_id) );

1285:
1286: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_DUPLICATE_RECORD');
1287: FND_MESSAGE.SET_TOKEN( 'TYPE', 'style format locale' );
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;

Line 1290: FND_MESSAGE.SET_TOKEN( 'ALLCOLUMNS', 'style_format_code, language_code, territory_code validation' );

1286: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_DUPLICATE_RECORD');
1287: FND_MESSAGE.SET_TOKEN( 'TYPE', 'style format locale' );
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:

Line 1450: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

1446: FROM HZ_STYLE_FORMATS_B
1447: WHERE style_format_code = p_style_fmt_variation_rec.style_format_code;
1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
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;

Line 1451: fnd_message.set_token('FK', 'style_format_code');

1447: WHERE style_format_code = p_style_fmt_variation_rec.style_format_code;
1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
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;

Line 1452: fnd_message.set_token('COLUMN', 'style_format_code');

1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
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;

Line 1453: fnd_message.set_token('TABLE', 'hz_style_formats_b');

1449: WHEN NO_DATA_FOUND THEN
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

Line 1513: FND_MESSAGE.SET_NAME('AR', 'HZ_VARIATION_NO_DUP');

1509: from HZ_STYLE_FMT_VARIATIONS
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

Line 1580: FND_MESSAGE.SET_NAME('AR', 'HZ_VARIATION_RANK_DUP');

1576: from HZ_STYLE_FMT_VARIATIONS
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

Line 1679: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');

1675: IF p_style_fmt_variation_rec.end_date_active IS NOT NULL AND
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

Line 1703: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');

1699:
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;

Line 1861: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

1857: OPEN c_dup (p_style_fmt_layout_rec.style_fmt_layout_id);
1858: FETCH c_dup INTO l_dummy;
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;

Line 1862: fnd_message.set_token('COLUMN', 'style_fmt_layout_id');

1858: FETCH c_dup INTO l_dummy;
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;

Line 2014: fnd_message.set_name('AR', 'HZ_LYT_INVALID_START_END_DATE');

2010: AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')));
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

Line 2027: fnd_message.set_name('AR', 'HZ_INVALID_FMT_CODE_VAR_NO');

2023: END IF;
2024:
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;

Line 2028: fnd_message.set_token('VARNUM', p_style_fmt_layout_rec.variation_number);

2024:
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

Line 2057: fnd_message.set_name('AR', 'HZ_LYT_INVALID_START_END_DATE');

2053: AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')));
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

Line 2177: fnd_message.set_name('AR', 'HZ_INVALID_ATTR_APPID');

2173: c.column_name = p_style_fmt_layout_rec.attribute_code;
2174:
2175: EXCEPTION
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;

Line 2178: fnd_message.SET_TOKEN('ATTRIBUTE_CODE',p_style_fmt_layout_rec.attribute_code);

2174:
2175: EXCEPTION
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;

Line 2179: fnd_message.SET_TOKEN('TABLE',l_database_object_name);

2175: EXCEPTION
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

Line 2220: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_ATTR_APPID_DUP');

2216: ( end_date_active is not null and
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

Line 2255: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_ATTR_APPID_DUP');

2251: ( end_date_active is not null and
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

Line 2401: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_LINE_POSITION_DUP');

2397: ( end_date_active is not null and
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

Line 2436: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_LINE_POSITION_DUP');

2432: ( end_date_active is not null and
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

Line 2689: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');

2685: IF p_style_fmt_layout_rec.end_date_active IS NOT NULL AND
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

Line 2713: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');

2709:
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;