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 HZ_STYLE_FORMATS_B

Line 499: l_style_format_code HZ_STYLE_FORMATS_B.style_format_code%TYPE;

495: p_rowid IN ROWID,
496: x_return_status IN OUT NOCOPY VARCHAR2
497: )IS
498: l_dummy VARCHAR2(1);
499: l_style_format_code HZ_STYLE_FORMATS_B.style_format_code%TYPE;
500: l_style_code HZ_STYLE_FORMATS_B.style_code%TYPE;
501: l_default_flag HZ_STYLE_FORMATS_B.default_flag%TYPE;
502: l_style_format_name HZ_STYLE_FORMATS_TL.style_format_name%TYPE;
503: l_debug_prefix VARCHAR2(30) := '';

Line 500: l_style_code HZ_STYLE_FORMATS_B.style_code%TYPE;

496: x_return_status IN OUT NOCOPY VARCHAR2
497: )IS
498: l_dummy VARCHAR2(1);
499: l_style_format_code HZ_STYLE_FORMATS_B.style_format_code%TYPE;
500: l_style_code HZ_STYLE_FORMATS_B.style_code%TYPE;
501: l_default_flag HZ_STYLE_FORMATS_B.default_flag%TYPE;
502: l_style_format_name HZ_STYLE_FORMATS_TL.style_format_name%TYPE;
503: l_debug_prefix VARCHAR2(30) := '';
504:

Line 501: l_default_flag HZ_STYLE_FORMATS_B.default_flag%TYPE;

497: )IS
498: l_dummy VARCHAR2(1);
499: l_style_format_code HZ_STYLE_FORMATS_B.style_format_code%TYPE;
500: l_style_code HZ_STYLE_FORMATS_B.style_code%TYPE;
501: l_default_flag HZ_STYLE_FORMATS_B.default_flag%TYPE;
502: l_style_format_name HZ_STYLE_FORMATS_TL.style_format_name%TYPE;
503: l_debug_prefix VARCHAR2(30) := '';
504:
505: BEGIN

Line 527: FROM HZ_STYLE_FORMATS_B b , HZ_STYLE_FORMATS_TL t

523: INTO l_style_format_code,
524: l_style_code,
525: l_default_flag,
526: l_style_format_name
527: FROM HZ_STYLE_FORMATS_B b , HZ_STYLE_FORMATS_TL t
528: WHERE b.ROWID = p_rowid
529: AND t.style_format_code = b.style_format_code
530: AND t.language = userenv('LANG');
531:

Line 579: from HZ_STYLE_FORMATS_B

575: p_style_format_rec.style_format_code IS NOT NULL
576: THEN
577: BEGIN
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');

Line 976: -- style_format_code is foreign key of hz_style_formats_b

972: p_msg_level=>fnd_log.level_statement);
973: END IF;
974: END IF;
975:
976: -- style_format_code is foreign key of hz_style_formats_b
977: -- Do not need to check during update because style_format_code is
978: -- non-updateable.
979:
980: IF p_create_update_flag = 'C'

Line 989: FROM HZ_STYLE_FORMATS_B

985: THEN
986: BEGIN
987: SELECT 'Y'
988: INTO l_dummy
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');

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 1001: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of 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. ' ||
1002: 'x_return_status = ' || x_return_status,
1003: p_prefix =>l_debug_prefix,
1004: p_msg_level=>fnd_log.level_statement);
1005: END IF;

Line 1434: -- style_format_code is foreign key of hz_style_formats_b

1430: p_msg_level=>fnd_log.level_statement);
1431: END IF;
1432: END IF;
1433:
1434: -- style_format_code is foreign key of hz_style_formats_b
1435: -- Do not need to check during update because style_format_code is
1436: -- non-updateable.
1437: IF p_create_update_flag = 'C'
1438: AND

Line 1446: FROM HZ_STYLE_FORMATS_B

1442: THEN
1443: BEGIN
1444: SELECT 'Y'
1445: INTO l_dummy
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');

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 1458: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of 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. ' ||
1459: 'x_return_status = ' || x_return_status,
1460: p_prefix =>l_debug_prefix,
1461: p_msg_level=>fnd_log.level_statement);
1462: END IF;

Line 1981: -- combination of style_format_code, variation_number is foreign key of hz_style_formats_b

1977:
1978: ---------------------------------------------------------------------
1979: -- style_format_code, variation_number validation
1980: ---------------------------------------------------------------------
1981: -- combination of style_format_code, variation_number is foreign key of hz_style_formats_b
1982: -- Do not need to check during update because style_format_code is
1983: -- non-updateable.
1984: IF p_create_update_flag = 'C' AND
1985: p_style_fmt_layout_rec.style_format_code IS NOT NULL AND

Line 2163: FROM hz_style_formats_b sf, hz_styles_b s

2159: THEN
2160: BEGIN
2161: SELECT database_object_name
2162: INTO l_database_object_name
2163: FROM hz_style_formats_b sf, hz_styles_b s
2164: WHERE sf.style_format_code = p_style_fmt_layout_rec.style_format_code AND
2165: s.style_code = sf.style_code;
2166:
2167: SELECT 'Y'