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 316: -- Applications PL/SQL standards.

312: l_phone_extension VARCHAR2(20);
313: l_contact_point_purpose VARCHAR2(30);
314:
315: -- Bug 2117973: added following cursors for retrofit to conform to
316: -- Applications PL/SQL standards.
317:
318: CURSOR c_country (p_site_id IN NUMBER) IS
319: SELECT country
320: FROM hz_locations

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

485: ELSIF p_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' AND
486: (l_phone_rec.phone_country_code IS NULL OR
487: l_phone_rec.phone_country_code = fnd_api.g_miss_char)
488: THEN
489: -- Bug 2117973: modified to conform to Applications PL/SQL standards.
490: OPEN c_country(p_contact_point_rec.owner_table_id);
491: FETCH c_country INTO l_country_code;
492: IF c_country%NOTFOUND THEN
493: CLOSE c_country;

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

616: -- ELSE
617: -- p_contact_point_rec.primary_flag := 'N';
618: -- END IF;
619: ELSE
620: -- Bug 2117973: modified to conform to Applications PL/SQL standards.
621: OPEN c_cp (p_contact_point_rec.owner_table_name,
622: p_contact_point_rec.owner_table_id,
623: p_contact_point_rec.contact_point_type);
624: FETCH c_cp INTO l_dummy;

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

1010: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1011: -- Bug 4693719 : Added for local assignment
1012: l_acs hz_contact_points.actual_content_source%TYPE;
1013:
1014: -- Bug 2117973: defined the following cursors for PL/SQL coding standards
1015: -- compliance.
1016: CURSOR c_country (p_owner_table_id IN NUMBER) IS
1017: SELECT country
1018: FROM hz_locations

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

1924: -- 07-23-2001 Jianying Huang o Created.
1925: -- 08-19-2003 Ramesh.Ch o Modified the
1926: -- Signature and logic.
1927: -- 05-05-2006 Praveen Kasturi o Bug No 4355133 : Truncated the value in p_email_address
1928: -- before updating the table to support RFC standards.
1929:
1930: PROCEDURE do_denormalize_contact_point (
1931: p_party_id IN NUMBER,
1932: p_contact_point_type IN VARCHAR2,

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

2538: p_prefix=>l_debug_prefix,
2539: p_msg_level=>fnd_log.level_procedure);
2540: END IF;
2541:
2542: -- Standard call to get message count and if count is 1, get message info.
2543: fnd_msg_pub.count_and_get(
2544: p_encoded => fnd_api.g_false,
2545: p_count => x_msg_count,
2546: p_data => x_msg_data);

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

2760: hz_dqm_sync.sync_contact_point(l_contact_point_rec.contact_point_id, 'C');
2761: END IF;
2762: END IF;
2763:
2764: -- Standard call to get message count and if count is 1, get message info.
2765: fnd_msg_pub.count_and_get(
2766: p_encoded => fnd_api.g_false,
2767: p_count => x_msg_count,
2768: p_data => x_msg_data);

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

3091: hz_dqm_sync.sync_contact_point(l_contact_point_rec.contact_point_id, 'U');
3092:
3093: END IF;
3094:
3095: -- Standard call to get message count and if count is 1, get message info.
3096: fnd_msg_pub.count_and_get(
3097: p_encoded => fnd_api.g_false,
3098: p_count => x_msg_count,
3099: p_data => x_msg_data);

Line 3170: -- Standard start of API savepoint

3166: ) IS
3167: l_debug_prefix VARCHAR2(30) := '';
3168: BEGIN
3169:
3170: -- Standard start of API savepoint
3171: SAVEPOINT create_contact_point;
3172:
3173: -- Check if API is called in debug mode. If yes, enable debug.
3174: --enable_debug;

Line 3341: -- Standard start of API savepoint

3337: ) IS
3338: l_debug_prefix VARCHAR2(30) := '';
3339: BEGIN
3340:
3341: -- Standard start of API savepoint
3342: SAVEPOINT create_edi_contact_point;
3343:
3344: -- Check if API is called in debug mode. If yes, enable debug.
3345: --enable_debug;

Line 3507: -- Standard start of API savepoint

3503: ) IS
3504: l_debug_prefix VARCHAR2(30) := '';
3505: BEGIN
3506:
3507: -- Standard start of API savepoint
3508: SAVEPOINT create_web_contact_point;
3509:
3510: -- Check if API is called in debug mode. If yes, enable debug.
3511: --enable_debug;

Line 3675: -- Standard start of API savepoint

3671: ) IS
3672: l_debug_prefix VARCHAR2(30) := '';
3673: BEGIN
3674:
3675: -- Standard start of API savepoint
3676: SAVEPOINT create_eft_contact_point;
3677:
3678: -- Check if API is called in debug mode. If yes, enable debug.
3679: --enable_debug;

Line 3842: -- Standard start of API savepoint

3838: ) IS
3839: l_debug_prefix VARCHAR2(30) := '';
3840: BEGIN
3841:
3842: -- Standard start of API savepoint
3843: SAVEPOINT create_phone_contact_point;
3844:
3845: -- Check if API is called in debug mode. If yes, enable debug.
3846: --enable_debug;

Line 4009: -- Standard start of API savepoint

4005: ) IS
4006: l_debug_prefix VARCHAR2(30) := '';
4007: BEGIN
4008:
4009: -- Standard start of API savepoint
4010: SAVEPOINT create_telex_contact_point;
4011:
4012: -- Check if API is called in debug mode. If yes, enable debug.
4013: --enable_debug;

Line 4176: -- Standard start of API savepoint

4172: ) IS
4173: l_debug_prefix VARCHAR2(30) := '';
4174: BEGIN
4175:
4176: -- Standard start of API savepoint
4177: SAVEPOINT create_email_contact_point;
4178:
4179: -- Check if API is called in debug mode. If yes, enable debug.
4180: --enable_debug;

Line 4352: -- Standard start of API savepoint

4348: ) IS
4349: l_debug_prefix VARCHAR2(30) := '';
4350: BEGIN
4351:
4352: -- Standard start of API savepoint
4353: SAVEPOINT update_contact_point;
4354:
4355: -- Check if API is called in debug mode. If yes, enable debug.
4356: --enable_debug;

Line 4526: -- Standard start of API savepoint

4522: x_msg_data OUT NOCOPY VARCHAR2
4523: ) IS
4524: l_debug_prefix VARCHAR2(30) := '';
4525: BEGIN
4526: -- Standard start of API savepoint
4527: SAVEPOINT update_edi_contact_point;
4528:
4529: -- Check if API is called in debug mode. If yes, enable debug.
4530: --enable_debug;

Line 4691: -- Standard start of API savepoint

4687: x_msg_data OUT NOCOPY VARCHAR2
4688: ) IS
4689: l_debug_prefix VARCHAR2(30) := '';
4690: BEGIN
4691: -- Standard start of API savepoint
4692: SAVEPOINT update_web_contact_point;
4693:
4694: -- Check if API is called in debug mode. If yes, enable debug.
4695: --enable_debug;

Line 4863: -- Standard start of API savepoint

4859: x_msg_data OUT NOCOPY VARCHAR2
4860: ) IS
4861: l_debug_prefix VARCHAR2(30) := '';
4862: BEGIN
4863: -- Standard start of API savepoint
4864: SAVEPOINT update_eft_contact_point;
4865:
4866: -- Check if API is called in debug mode. If yes, enable debug.
4867: --enable_debug;

Line 5030: -- Standard start of API savepoint

5026: x_msg_data OUT NOCOPY VARCHAR2
5027: ) IS
5028: l_debug_prefix VARCHAR2(30) := '';
5029: BEGIN
5030: -- Standard start of API savepoint
5031: SAVEPOINT update_phone_contact_point;
5032:
5033: -- Check if API is called in debug mode. If yes, enable debug.
5034: --enable_debug;

Line 5199: -- Standard start of API savepoint

5195: x_msg_data OUT NOCOPY VARCHAR2
5196: ) IS
5197: l_debug_prefix VARCHAR2(30) := '';
5198: BEGIN
5199: -- Standard start of API savepoint
5200: SAVEPOINT update_telex_contact_point;
5201:
5202: -- Check if API is called in debug mode. If yes, enable debug.
5203: --enable_debug;

Line 5371: -- Standard start of API savepoint

5367: x_msg_data OUT NOCOPY VARCHAR2
5368: ) IS
5369: l_debug_prefix VARCHAR2(30) := '';
5370: BEGIN
5371: -- Standard start of API savepoint
5372: SAVEPOINT update_email_contact_point;
5373:
5374: -- Check if API is called in debug mode. If yes, enable debug.
5375: --enable_debug;

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

5719: | END IF;
5720: |
5721: | x_phone_country_code := l_phone_country_code; */
5722:
5723: -- Standard call to get message count and if count is 1, get message info.
5724: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5725: p_count => x_msg_count,
5726: p_data => x_msg_data);
5727: