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_CONTACT_POINT_V2PUB dependencies on STANDARD

Line 326: -- Applications PL/SQL standards.

322: l_phone_extension VARCHAR2(20);
323: l_contact_point_purpose VARCHAR2(30);
324:
325: -- Bug 2117973: added following cursors for retrofit to conform to
326: -- Applications PL/SQL standards.
327:
328: CURSOR c_country (p_site_id IN NUMBER) IS
329: SELECT country
330: FROM hz_locations

Line 499: -- Bug 2117973: modified to conform to Applications PL/SQL standards.

495: ELSIF p_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' AND
496: (l_phone_rec.phone_country_code IS NULL OR
497: l_phone_rec.phone_country_code = fnd_api.g_miss_char)
498: THEN
499: -- Bug 2117973: modified to conform to Applications PL/SQL standards.
500: OPEN c_country(p_contact_point_rec.owner_table_id);
501: FETCH c_country INTO l_country_code;
502: IF c_country%NOTFOUND THEN
503: CLOSE c_country;

Line 630: -- Bug 2117973: modified to conform to Applications PL/SQL standards.

626: -- ELSE
627: -- p_contact_point_rec.primary_flag := 'N';
628: -- END IF;
629: ELSE
630: -- Bug 2117973: modified to conform to Applications PL/SQL standards.
631: OPEN c_cp (p_contact_point_rec.owner_table_name,
632: p_contact_point_rec.owner_table_id,
633: p_contact_point_rec.contact_point_type);
634: FETCH c_cp INTO l_dummy;

Line 1027: -- Bug 2117973: defined the following cursors for PL/SQL coding standards

1023: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1024: -- Bug 4693719 : Added for local assignment
1025: l_acs hz_contact_points.actual_content_source%TYPE;
1026:
1027: -- Bug 2117973: defined the following cursors for PL/SQL coding standards
1028: -- compliance.
1029: CURSOR c_country (p_owner_table_id IN NUMBER) IS
1030: SELECT country
1031: FROM hz_locations

Line 2015: -- before updating the table to support RFC standards.

2011: -- 07-23-2001 Jianying Huang o Created.
2012: -- 08-19-2003 Ramesh.Ch o Modified the
2013: -- Signature and logic.
2014: -- 05-05-2006 Praveen Kasturi o Bug No 4355133 : Truncated the value in p_email_address
2015: -- before updating the table to support RFC standards.
2016:
2017: PROCEDURE do_denormalize_contact_point (
2018: p_party_id IN NUMBER,
2019: p_contact_point_type IN VARCHAR2,

Line 2695: -- Standard call to get message count and if count is 1, get message info.

2691: p_prefix=>l_debug_prefix,
2692: p_msg_level=>fnd_log.level_procedure);
2693: END IF;
2694:
2695: -- Standard call to get message count and if count is 1, get message info.
2696: fnd_msg_pub.count_and_get(
2697: p_encoded => fnd_api.g_false,
2698: p_count => x_msg_count,
2699: p_data => x_msg_data);

Line 2920: -- Standard call to get message count and if count is 1, get message info.

2916: END IF;
2917: */
2918: END IF;
2919:
2920: -- Standard call to get message count and if count is 1, get message info.
2921: fnd_msg_pub.count_and_get(
2922: p_encoded => fnd_api.g_false,
2923: p_count => x_msg_count,
2924: p_data => x_msg_data);

Line 3251: -- Standard call to get message count and if count is 1, get message info.

3247: hz_dqm_sync.sync_contact_point(l_contact_point_rec.contact_point_id, 'U');
3248:
3249: END IF;
3250:
3251: -- Standard call to get message count and if count is 1, get message info.
3252: fnd_msg_pub.count_and_get(
3253: p_encoded => fnd_api.g_false,
3254: p_count => x_msg_count,
3255: p_data => x_msg_data);

Line 3326: -- Standard start of API savepoint

3322: ) IS
3323: l_debug_prefix VARCHAR2(30) := '';
3324: BEGIN
3325:
3326: -- Standard start of API savepoint
3327: SAVEPOINT create_contact_point;
3328:
3329: -- Check if API is called in debug mode. If yes, enable debug.
3330: --enable_debug;

Line 3497: -- Standard start of API savepoint

3493: ) IS
3494: l_debug_prefix VARCHAR2(30) := '';
3495: BEGIN
3496:
3497: -- Standard start of API savepoint
3498: SAVEPOINT create_edi_contact_point;
3499:
3500: -- Check if API is called in debug mode. If yes, enable debug.
3501: --enable_debug;

Line 3663: -- Standard start of API savepoint

3659: ) IS
3660: l_debug_prefix VARCHAR2(30) := '';
3661: BEGIN
3662:
3663: -- Standard start of API savepoint
3664: SAVEPOINT create_web_contact_point;
3665:
3666: -- Check if API is called in debug mode. If yes, enable debug.
3667: --enable_debug;

Line 3831: -- Standard start of API savepoint

3827: ) IS
3828: l_debug_prefix VARCHAR2(30) := '';
3829: BEGIN
3830:
3831: -- Standard start of API savepoint
3832: SAVEPOINT create_eft_contact_point;
3833:
3834: -- Check if API is called in debug mode. If yes, enable debug.
3835: --enable_debug;

Line 3998: -- Standard start of API savepoint

3994: ) IS
3995: l_debug_prefix VARCHAR2(30) := '';
3996: BEGIN
3997:
3998: -- Standard start of API savepoint
3999: SAVEPOINT create_phone_contact_point;
4000:
4001: -- Check if API is called in debug mode. If yes, enable debug.
4002: --enable_debug;

Line 4165: -- Standard start of API savepoint

4161: ) IS
4162: l_debug_prefix VARCHAR2(30) := '';
4163: BEGIN
4164:
4165: -- Standard start of API savepoint
4166: SAVEPOINT create_telex_contact_point;
4167:
4168: -- Check if API is called in debug mode. If yes, enable debug.
4169: --enable_debug;

Line 4332: -- Standard start of API savepoint

4328: ) IS
4329: l_debug_prefix VARCHAR2(30) := '';
4330: BEGIN
4331:
4332: -- Standard start of API savepoint
4333: SAVEPOINT create_email_contact_point;
4334:
4335: -- Check if API is called in debug mode. If yes, enable debug.
4336: --enable_debug;

Line 4508: -- Standard start of API savepoint

4504: ) IS
4505: l_debug_prefix VARCHAR2(30) := '';
4506: BEGIN
4507:
4508: -- Standard start of API savepoint
4509: SAVEPOINT update_contact_point;
4510:
4511: -- Check if API is called in debug mode. If yes, enable debug.
4512: --enable_debug;

Line 4682: -- Standard start of API savepoint

4678: x_msg_data OUT NOCOPY VARCHAR2
4679: ) IS
4680: l_debug_prefix VARCHAR2(30) := '';
4681: BEGIN
4682: -- Standard start of API savepoint
4683: SAVEPOINT update_edi_contact_point;
4684:
4685: -- Check if API is called in debug mode. If yes, enable debug.
4686: --enable_debug;

Line 4847: -- Standard start of API savepoint

4843: x_msg_data OUT NOCOPY VARCHAR2
4844: ) IS
4845: l_debug_prefix VARCHAR2(30) := '';
4846: BEGIN
4847: -- Standard start of API savepoint
4848: SAVEPOINT update_web_contact_point;
4849:
4850: -- Check if API is called in debug mode. If yes, enable debug.
4851: --enable_debug;

Line 5019: -- Standard start of API savepoint

5015: x_msg_data OUT NOCOPY VARCHAR2
5016: ) IS
5017: l_debug_prefix VARCHAR2(30) := '';
5018: BEGIN
5019: -- Standard start of API savepoint
5020: SAVEPOINT update_eft_contact_point;
5021:
5022: -- Check if API is called in debug mode. If yes, enable debug.
5023: --enable_debug;

Line 5186: -- Standard start of API savepoint

5182: x_msg_data OUT NOCOPY VARCHAR2
5183: ) IS
5184: l_debug_prefix VARCHAR2(30) := '';
5185: BEGIN
5186: -- Standard start of API savepoint
5187: SAVEPOINT update_phone_contact_point;
5188:
5189: -- Check if API is called in debug mode. If yes, enable debug.
5190: --enable_debug;

Line 5355: -- Standard start of API savepoint

5351: x_msg_data OUT NOCOPY VARCHAR2
5352: ) IS
5353: l_debug_prefix VARCHAR2(30) := '';
5354: BEGIN
5355: -- Standard start of API savepoint
5356: SAVEPOINT update_telex_contact_point;
5357:
5358: -- Check if API is called in debug mode. If yes, enable debug.
5359: --enable_debug;

Line 5527: -- Standard start of API savepoint

5523: x_msg_data OUT NOCOPY VARCHAR2
5524: ) IS
5525: l_debug_prefix VARCHAR2(30) := '';
5526: BEGIN
5527: -- Standard start of API savepoint
5528: SAVEPOINT update_email_contact_point;
5529:
5530: -- Check if API is called in debug mode. If yes, enable debug.
5531: --enable_debug;

Line 5879: -- Standard call to get message count and if count is 1, get message info.

5875: | END IF;
5876: |
5877: | x_phone_country_code := l_phone_country_code; */
5878:
5879: -- Standard call to get message count and if count is 1, get message info.
5880: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5881: p_count => x_msg_count,
5882: p_data => x_msg_data);
5883: