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_FORMAT_PHONE_V2PUB dependencies on FND_API

Line 36: g_international_flag VARCHAR2(1):= fnd_api.g_miss_char;

32: format_area_code_size_tab var_indexed_num_table;
33: format_phone_country_tab var_indexed_table;
34:
35: g_debug_count NUMBER := 0;
36: g_international_flag VARCHAR2(1):= fnd_api.g_miss_char;
37: g_user_territory_code HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE%TYPE:=
38: fnd_api.g_miss_char;
39: g_user_phone_country_code HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE%TYPE :=
40: fnd_api.g_miss_char;

Line 38: fnd_api.g_miss_char;

34:
35: g_debug_count NUMBER := 0;
36: g_international_flag VARCHAR2(1):= fnd_api.g_miss_char;
37: g_user_territory_code HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE%TYPE:=
38: fnd_api.g_miss_char;
39: g_user_phone_country_code HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE%TYPE :=
40: fnd_api.g_miss_char;
41:
42: --------------------------------------

Line 40: fnd_api.g_miss_char;

36: g_international_flag VARCHAR2(1):= fnd_api.g_miss_char;
37: g_user_territory_code HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE%TYPE:=
38: fnd_api.g_miss_char;
39: g_user_phone_country_code HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE%TYPE :=
40: fnd_api.g_miss_char;
41:
42: --------------------------------------
43: -- declaration of private procedures
44: --------------------------------------

Line 64: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

60: x_phone_territory_code OUT NOCOPY VARCHAR2
61: );
62:
63: PROCEDURE get_phone_format (
64: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
65: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
66: p_area_code IN VARCHAR2,
67: x_phone_country_code OUT NOCOPY VARCHAR2,
68: x_phone_format_style OUT NOCOPY VARCHAR2,

Line 65: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

61: );
62:
63: PROCEDURE get_phone_format (
64: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
65: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
66: p_area_code IN VARCHAR2,
67: x_phone_country_code OUT NOCOPY VARCHAR2,
68: x_phone_format_style OUT NOCOPY VARCHAR2,
69: x_area_code_size OUT NOCOPY NUMBER,

Line 74: p_with_iprefix IN VARCHAR2 := fnd_api.g_miss_char,

70: x_msg OUT NOCOPY VARCHAR2
71: );
72:
73: PROCEDURE parse_intl_prefix(
74: p_with_iprefix IN VARCHAR2 := fnd_api.g_miss_char,
75: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
76: x_intl_prefix OUT NOCOPY VARCHAR2,
77: x_without_iprefix OUT NOCOPY VARCHAR2) ;
78:

Line 75: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

71: );
72:
73: PROCEDURE parse_intl_prefix(
74: p_with_iprefix IN VARCHAR2 := fnd_api.g_miss_char,
75: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
76: x_intl_prefix OUT NOCOPY VARCHAR2,
77: x_without_iprefix OUT NOCOPY VARCHAR2) ;
78:
79: PROCEDURE parse_trunk_prefix(

Line 80: p_with_tprefix IN VARCHAR2 := fnd_api.g_miss_char,

76: x_intl_prefix OUT NOCOPY VARCHAR2,
77: x_without_iprefix OUT NOCOPY VARCHAR2) ;
78:
79: PROCEDURE parse_trunk_prefix(
80: p_with_tprefix IN VARCHAR2 := fnd_api.g_miss_char,
81: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
82: x_trunk_prefix OUT NOCOPY VARCHAR2,
83: x_without_tprefix OUT NOCOPY VARCHAR2);
84:

Line 81: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

77: x_without_iprefix OUT NOCOPY VARCHAR2) ;
78:
79: PROCEDURE parse_trunk_prefix(
80: p_with_tprefix IN VARCHAR2 := fnd_api.g_miss_char,
81: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
82: x_trunk_prefix OUT NOCOPY VARCHAR2,
83: x_without_tprefix OUT NOCOPY VARCHAR2);
84:
85: PROCEDURE parse_country_code(

Line 86: p_with_country_code IN VARCHAR2 := fnd_api.g_miss_char,

82: x_trunk_prefix OUT NOCOPY VARCHAR2,
83: x_without_tprefix OUT NOCOPY VARCHAR2);
84:
85: PROCEDURE parse_country_code(
86: p_with_country_code IN VARCHAR2 := fnd_api.g_miss_char,
87: x_country_code OUT NOCOPY VARCHAR2,
88: x_without_country_code OUT NOCOPY VARCHAR2);
89:
90: PROCEDURE parse_area_code(

Line 91: p_with_area_code IN VARCHAR2 := fnd_api.g_miss_char,

87: x_country_code OUT NOCOPY VARCHAR2,
88: x_without_country_code OUT NOCOPY VARCHAR2);
89:
90: PROCEDURE parse_area_code(
91: p_with_area_code IN VARCHAR2 := fnd_api.g_miss_char,
92: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
93: x_parsed_area_code OUT NOCOPY VARCHAR2,
94: x_parsed_phone_number OUT NOCOPY VARCHAR2 ) ;
95:

Line 92: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,

88: x_without_country_code OUT NOCOPY VARCHAR2);
89:
90: PROCEDURE parse_area_code(
91: p_with_area_code IN VARCHAR2 := fnd_api.g_miss_char,
92: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
93: x_parsed_area_code OUT NOCOPY VARCHAR2,
94: x_parsed_phone_number OUT NOCOPY VARCHAR2 ) ;
95:
96: FUNCTION filter_phone_number (

Line 102: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

98: p_isformat IN NUMBER := 0
99: ) RETURN VARCHAR2;
100:
101: PROCEDURE translate_raw_phone_number (
102: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
103: p_phone_format_style IN VARCHAR2 := fnd_api.g_miss_char,
104: x_formatted_phone_number OUT NOCOPY VARCHAR2
105: );
106:

Line 103: p_phone_format_style IN VARCHAR2 := fnd_api.g_miss_char,

99: ) RETURN VARCHAR2;
100:
101: PROCEDURE translate_raw_phone_number (
102: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
103: p_phone_format_style IN VARCHAR2 := fnd_api.g_miss_char,
104: x_formatted_phone_number OUT NOCOPY VARCHAR2
105: );
106:
107: --

Line 118: -- FND_API.G_TRUE. Default is fnd_api.g_false.

114: --
115: -- ARGUMENTS
116: -- IN:
117: -- p_init_msg_list Initialize message stack if it is set to
118: -- FND_API.G_TRUE. Default is fnd_api.g_false.
119: -- p_raw_phone_number Raw phone number.
120: -- p_territory_code Optional parameter for supplying the
121: -- territory code of the Phone No.
122: -- OUT:

Line 128: -- be fnd_api.g_ret_sts_success (success),

124: -- x_phone_area_code Phone area code.
125: -- x_phone_number Phone number.
126: -- x_mobile_flag Flag indicating if the Number is mobile
127: -- x_return_status Return status after the call. The status can
128: -- be fnd_api.g_ret_sts_success (success),
129: -- fnd_api.g_ret_sts_error (error),
130: -- fnd_api.g_ret_sts_unexp_error
131: -- (unexpected error).
132: -- x_msg_count Number of messages in message stack.

Line 129: -- fnd_api.g_ret_sts_error (error),

125: -- x_phone_number Phone number.
126: -- x_mobile_flag Flag indicating if the Number is mobile
127: -- x_return_status Return status after the call. The status can
128: -- be fnd_api.g_ret_sts_success (success),
129: -- fnd_api.g_ret_sts_error (error),
130: -- fnd_api.g_ret_sts_unexp_error
131: -- (unexpected error).
132: -- x_msg_count Number of messages in message stack.
133: -- x_msg_data Message text if x_msg_count is 1.

Line 130: -- fnd_api.g_ret_sts_unexp_error

126: -- x_mobile_flag Flag indicating if the Number is mobile
127: -- x_return_status Return status after the call. The status can
128: -- be fnd_api.g_ret_sts_success (success),
129: -- fnd_api.g_ret_sts_error (error),
130: -- fnd_api.g_ret_sts_unexp_error
131: -- (unexpected error).
132: -- x_msg_count Number of messages in message stack.
133: -- x_msg_data Message text if x_msg_count is 1.
134: --

Line 144: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

140: --
141: --
142:
143: PROCEDURE phone_parse (
144: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
145: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
146: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
147: x_phone_country_code OUT NOCOPY VARCHAR2,
148: x_phone_area_code OUT NOCOPY VARCHAR2,

Line 145: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

141: --
142:
143: PROCEDURE phone_parse (
144: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
145: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
146: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
147: x_phone_country_code OUT NOCOPY VARCHAR2,
148: x_phone_area_code OUT NOCOPY VARCHAR2,
149: x_phone_number OUT NOCOPY VARCHAR2,

Line 146: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

142:
143: PROCEDURE phone_parse (
144: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
145: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
146: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
147: x_phone_country_code OUT NOCOPY VARCHAR2,
148: x_phone_area_code OUT NOCOPY VARCHAR2,
149: x_phone_number OUT NOCOPY VARCHAR2,
150: x_mobile_flag OUT NOCOPY VARCHAR2,

Line 216: IF fnd_api.to_boolean(p_init_msg_list) THEN

212: p_msg_level=>fnd_log.level_procedure);
213: END IF;
214:
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF fnd_api.to_boolean(p_init_msg_list) THEN
217: fnd_msg_pub.initialize;
218: END IF;
219:
220: -- Initialize API return status to success.

Line 221: x_return_status := fnd_api.g_ret_sts_success;

217: fnd_msg_pub.initialize;
218: END IF;
219:
220: -- Initialize API return status to success.
221: x_return_status := fnd_api.g_ret_sts_success;
222:
223: -- Check if raw phone number is passed
224: IF p_raw_phone_number IS NOT NULL AND
225: p_raw_phone_number <> fnd_api.g_miss_char THEN

Line 225: p_raw_phone_number <> fnd_api.g_miss_char THEN

221: x_return_status := fnd_api.g_ret_sts_success;
222:
223: -- Check if raw phone number is passed
224: IF p_raw_phone_number IS NOT NULL AND
225: p_raw_phone_number <> fnd_api.g_miss_char THEN
226: l_raw_phone_number := p_raw_phone_number;
227: END IF;
228:
229:

Line 291: lp_phone_country_code <> fnd_api.g_miss_char THEN

287: lp_phone_country_code:= NULL;
288: END IF;
289:
290: IF lp_phone_country_code IS NOT NULL AND
291: lp_phone_country_code <> fnd_api.g_miss_char THEN
292:
293: --Do not need to parse the country code
294: g_international_flag := 'N';
295:

Line 436: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

432: x_msg_data );
433:
434:
435: -- Standard call to get msg count and if count is 1, get msg info.
436: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
437: p_count => x_msg_count,
438: p_data => x_msg_data);
439:
440: -- Debug info.

Line 457: WHEN fnd_api.g_exc_error THEN

453: -- Check if API is called in debug mode. If yes, disable debug.
454: --disable_debug;
455:
456: EXCEPTION
457: WHEN fnd_api.g_exc_error THEN
458: x_return_status := fnd_api.g_ret_sts_error;
459:
460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
461: p_count => x_msg_count,

Line 458: x_return_status := fnd_api.g_ret_sts_error;

454: --disable_debug;
455:
456: EXCEPTION
457: WHEN fnd_api.g_exc_error THEN
458: x_return_status := fnd_api.g_ret_sts_error;
459:
460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
461: p_count => x_msg_count,
462: p_data => x_msg_data);

Line 460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

456: EXCEPTION
457: WHEN fnd_api.g_exc_error THEN
458: x_return_status := fnd_api.g_ret_sts_error;
459:
460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
461: p_count => x_msg_count,
462: p_data => x_msg_data);
463:
464: -- Debug info.

Line 480: WHEN fnd_api.g_exc_unexpected_error THEN

476:
477: -- Check if API is called in debug mode. If yes, disable debug.
478: --disable_debug;
479:
480: WHEN fnd_api.g_exc_unexpected_error THEN
481: x_return_status := fnd_api.g_ret_sts_unexp_error;
482:
483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
484: p_count => x_msg_count,

Line 481: x_return_status := fnd_api.g_ret_sts_unexp_error;

477: -- Check if API is called in debug mode. If yes, disable debug.
478: --disable_debug;
479:
480: WHEN fnd_api.g_exc_unexpected_error THEN
481: x_return_status := fnd_api.g_ret_sts_unexp_error;
482:
483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
484: p_count => x_msg_count,
485: p_data => x_msg_data);

Line 483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

479:
480: WHEN fnd_api.g_exc_unexpected_error THEN
481: x_return_status := fnd_api.g_ret_sts_unexp_error;
482:
483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
484: p_count => x_msg_count,
485: p_data => x_msg_data);
486:
487: -- Debug info.

Line 504: x_return_status := fnd_api.g_ret_sts_unexp_error;

500: -- Check if API is called in debug mode. If yes, disable debug.
501: --disable_debug;
502:
503: WHEN OTHERS THEN
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505:
506: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
507: fnd_message.set_token('ERROR' ,SQLERRM);
508: fnd_msg_pub.add;

Line 510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

506: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
507: fnd_message.set_token('ERROR' ,SQLERRM);
508: fnd_msg_pub.add;
509:
510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
511: p_count => x_msg_count,
512: p_data => x_msg_data);
513:
514: -- Debug info.

Line 542: -- FND_API.G_TRUE. Default is fnd_api.g_false.

538: --
539: -- ARGUMENTS
540: -- IN:
541: -- p_init_msg_list Initialize message stack if it is set to
542: -- FND_API.G_TRUE. Default is fnd_api.g_false.
543: -- p_contact_point_id Contact point id of TYPE PHONE
544: -- territory code of the Phone No.
545: -- OUT:
546: -- x_formatted_number Number formatted acc. to defaults set in

Line 549: -- be fnd_api.g_ret_sts_success (success),

545: -- OUT:
546: -- x_formatted_number Number formatted acc. to defaults set in
547: -- HZ_PHONE_FORMATS or default format
548: -- x_return_status Return status after the call. The status can
549: -- be fnd_api.g_ret_sts_success (success),
550: -- fnd_api.g_ret_sts_error (error),
551: -- fnd_api.g_ret_sts_unexp_error
552: -- (unexpected error).
553: -- x_msg_count Number of messages in message stack.

Line 550: -- fnd_api.g_ret_sts_error (error),

546: -- x_formatted_number Number formatted acc. to defaults set in
547: -- HZ_PHONE_FORMATS or default format
548: -- x_return_status Return status after the call. The status can
549: -- be fnd_api.g_ret_sts_success (success),
550: -- fnd_api.g_ret_sts_error (error),
551: -- fnd_api.g_ret_sts_unexp_error
552: -- (unexpected error).
553: -- x_msg_count Number of messages in message stack.
554: -- x_msg_data Message text if x_msg_count is 1.

Line 551: -- fnd_api.g_ret_sts_unexp_error

547: -- HZ_PHONE_FORMATS or default format
548: -- x_return_status Return status after the call. The status can
549: -- be fnd_api.g_ret_sts_success (success),
550: -- fnd_api.g_ret_sts_error (error),
551: -- fnd_api.g_ret_sts_unexp_error
552: -- (unexpected error).
553: -- x_msg_count Number of messages in message stack.
554: -- x_msg_data Message text if x_msg_count is 1.
555: --

Line 571: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

567: --
568: --
569:
570: PROCEDURE phone_display(
571: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
572: p_contact_point_id IN NUMBER,
573: x_formatted_phone_number OUT NOCOPY VARCHAR2,
574: x_return_status OUT NOCOPY VARCHAR2,
575: x_msg_count OUT NOCOPY NUMBER,

Line 638: IF FND_API.to_Boolean(p_init_msg_list) THEN

634: p_msg_level=>fnd_log.level_procedure);
635: END IF;
636:
637: -- initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean(p_init_msg_list) THEN
639: FND_MSG_PUB.initialize;
640: END IF;
641:
642: -- initialize API return status to success.

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: FND_MSG_PUB.initialize;
640: END IF;
641:
642: -- initialize API return status to success.
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645:
646: -- Initialize return variables
647: x_phone_format_style := fnd_api.g_miss_char;

Line 647: x_phone_format_style := fnd_api.g_miss_char;

643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645:
646: -- Initialize return variables
647: x_phone_format_style := fnd_api.g_miss_char;
648:
649: --If the contact_point_is of wrong type raise the error
650: BEGIN
651: select contact_point_type

Line 661: RAISE fnd_api.g_exc_error;

657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
658: fnd_message.set_token('RECORD', 'Contact Point');
659: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
660: fnd_msg_pub.add;
661: RAISE fnd_api.g_exc_error;
662: END ;
663:
664:
665: IF l_contact_point_type <> 'PHONE' THEN

Line 668: RAISE fnd_api.g_exc_error;

664:
665: IF l_contact_point_type <> 'PHONE' THEN
666: fnd_message.set_name('AR', 'HZ_WRONG_CONTACT_POINT_TYPE');
667: fnd_msg_pub.add;
668: RAISE fnd_api.g_exc_error;
669: END IF;
670:
671: /*--------------------------------------------------------
672: Get the user preferences

Line 715: RAISE fnd_api.g_exc_error;

711: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
712: fnd_message.set_token('RECORD', 'Contact Point');
713: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
714: fnd_msg_pub.add;
715: RAISE fnd_api.g_exc_error;
716: END ;
717:
718: IF l_phone_area_code IS NULL OR
719: l_phone_area_code = fnd_api.g_miss_char THEN

Line 719: l_phone_area_code = fnd_api.g_miss_char THEN

715: RAISE fnd_api.g_exc_error;
716: END ;
717:
718: IF l_phone_area_code IS NULL OR
719: l_phone_area_code = fnd_api.g_miss_char THEN
720: l_raw_phone_number := filter_phone_number(l_phone_number);
721: ELSE
722: l_raw_phone_number := filter_phone_number(l_phone_area_code ||
723: l_phone_number);

Line 799: l_phone_country_code <> fnd_api.g_miss_char --Bug 4578945

795: IF ((l_phone_country_code <> l_user_country_code) OR
796: (l_user_country_code IS NULL))
797: THEN
798: IF l_phone_country_code IS NOT NULL AND
799: l_phone_country_code <> fnd_api.g_miss_char --Bug 4578945
800: THEN
801: IF l_display_all_prefixes = 'Y' THEN
802: l_formatted_phone_number := l_phone_country_code ||' '||l_formatted_phone_number;
803: ELSE

Line 821: and l_phone_area_code <> fnd_api.g_miss_char

817: l_formatted_phone_number := l_phone_number;
818: ELSE
819:
820: if l_phone_area_code is not null
821: and l_phone_area_code <> fnd_api.g_miss_char
822: then
823: l_prefix := 'T';
824: else
825: l_prefix := null;

Line 853: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

849:
850: x_formatted_phone_number := l_formatted_phone_number;
851:
852: -- Standard call to get msg count and if count is 1, get msg info.
853: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
854: p_count => x_msg_count,
855: p_data => x_msg_data);
856:
857: -- Debug info.

Line 875: WHEN fnd_api.g_exc_error THEN

871: --disable_debug;
872:
873: EXCEPTION
874:
875: WHEN fnd_api.g_exc_error THEN
876: x_return_status := fnd_api.g_ret_sts_error;
877:
878: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
879: p_count => x_msg_count,

Line 876: x_return_status := fnd_api.g_ret_sts_error;

872:
873: EXCEPTION
874:
875: WHEN fnd_api.g_exc_error THEN
876: x_return_status := fnd_api.g_ret_sts_error;
877:
878: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
879: p_count => x_msg_count,
880: p_data => x_msg_data);

Line 878: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

874:
875: WHEN fnd_api.g_exc_error THEN
876: x_return_status := fnd_api.g_ret_sts_error;
877:
878: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
879: p_count => x_msg_count,
880: p_data => x_msg_data);
881:
882: -- Debug info.

Line 898: WHEN fnd_api.g_exc_unexpected_error THEN

894:
895: -- Check if API is called in debug mode. If yes, disable debug.
896: --disable_debug;
897:
898: WHEN fnd_api.g_exc_unexpected_error THEN
899: x_return_status := fnd_api.g_ret_sts_unexp_error;
900:
901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
902: p_count => x_msg_count,

Line 899: x_return_status := fnd_api.g_ret_sts_unexp_error;

895: -- Check if API is called in debug mode. If yes, disable debug.
896: --disable_debug;
897:
898: WHEN fnd_api.g_exc_unexpected_error THEN
899: x_return_status := fnd_api.g_ret_sts_unexp_error;
900:
901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data);

Line 901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

897:
898: WHEN fnd_api.g_exc_unexpected_error THEN
899: x_return_status := fnd_api.g_ret_sts_unexp_error;
900:
901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data);
904:
905: -- Debug info.

Line 923: x_return_status := fnd_api.g_ret_sts_unexp_error;

919: -- Check if API is called in debug mode. If yes, disable debug.
920: --disable_debug;
921:
922: WHEN OTHERS THEN
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924:
925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
926: fnd_message.set_token('ERROR' ,SQLERRM);
927: fnd_msg_pub.add;

Line 929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
926: fnd_message.set_token('ERROR' ,SQLERRM);
927: fnd_msg_pub.add;
928:
929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
930: p_count => x_msg_count,
931: p_data => x_msg_data);
932:
933: -- Debug info.

Line 961: -- FND_API.G_TRUE. Default is fnd_api.g_false.

957: --
958: -- ARGUMENTS
959: -- IN:
960: -- p_init_msg_list Initialize message stack if it is set to
961: -- FND_API.G_TRUE. Default is fnd_api.g_false.
962: -- p_territory_code Optional parameter for supplying the
963: -- territory code of the Phone No.
964: -- p_phone_country code Country code of the phone number
965: -- p_phone_area_code Area code

Line 972: -- be fnd_api.g_ret_sts_success (success),

968: -- OUT:
969: -- x_formatted_number Number formatted acc. to defaults set in
970: -- HZ_PHONE_FORMATS or default format
971: -- x_return_status Return status after the call. The status can
972: -- be fnd_api.g_ret_sts_success (success),
973: -- fnd_api.g_ret_sts_error (error),
974: -- fnd_api.g_ret_sts_unexp_error
975: -- (unexpected error).
976: -- x_msg_count Number of messages in message stack.

Line 973: -- fnd_api.g_ret_sts_error (error),

969: -- x_formatted_number Number formatted acc. to defaults set in
970: -- HZ_PHONE_FORMATS or default format
971: -- x_return_status Return status after the call. The status can
972: -- be fnd_api.g_ret_sts_success (success),
973: -- fnd_api.g_ret_sts_error (error),
974: -- fnd_api.g_ret_sts_unexp_error
975: -- (unexpected error).
976: -- x_msg_count Number of messages in message stack.
977: -- x_msg_data Message text if x_msg_count is 1.

Line 974: -- fnd_api.g_ret_sts_unexp_error

970: -- HZ_PHONE_FORMATS or default format
971: -- x_return_status Return status after the call. The status can
972: -- be fnd_api.g_ret_sts_success (success),
973: -- fnd_api.g_ret_sts_error (error),
974: -- fnd_api.g_ret_sts_unexp_error
975: -- (unexpected error).
976: -- x_msg_count Number of messages in message stack.
977: -- x_msg_data Message text if x_msg_count is 1.
978: --

Line 990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

986: -- p_phone_area_code,p_phone_number are null.
987: --
988:
989: PROCEDURE phone_display(
990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
991: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
992: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
993: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
994: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

Line 991: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

987: --
988:
989: PROCEDURE phone_display(
990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
991: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
992: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
993: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
994: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
995: x_formatted_phone_number OUT NOCOPY VARCHAR2,

Line 992: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,

988:
989: PROCEDURE phone_display(
990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
991: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
992: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
993: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
994: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
995: x_formatted_phone_number OUT NOCOPY VARCHAR2,
996: x_return_status OUT NOCOPY VARCHAR2,

Line 993: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,

989: PROCEDURE phone_display(
990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
991: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
992: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
993: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
994: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
995: x_formatted_phone_number OUT NOCOPY VARCHAR2,
996: x_return_status OUT NOCOPY VARCHAR2,
997: x_msg_count OUT NOCOPY NUMBER,

Line 994: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
991: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
992: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
993: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
994: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
995: x_formatted_phone_number OUT NOCOPY VARCHAR2,
996: x_return_status OUT NOCOPY VARCHAR2,
997: x_msg_count OUT NOCOPY NUMBER,
998: x_msg_data OUT NOCOPY VARCHAR2

Line 1044: IF FND_API.to_Boolean(p_init_msg_list) THEN

1040: p_msg_level => fnd_log.level_procedure);
1041: END IF;
1042:
1043: -- initialize message list if p_init_msg_list is set to TRUE.
1044: IF FND_API.to_Boolean(p_init_msg_list) THEN
1045: FND_MSG_PUB.initialize;
1046: END IF;
1047:
1048: -- initialize API return status to success.

Line 1049: x_return_status := FND_API.G_RET_STS_SUCCESS;

1045: FND_MSG_PUB.initialize;
1046: END IF;
1047:
1048: -- initialize API return status to success.
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:
1051: -- Initialize return variables
1052: x_phone_format_style := fnd_api.g_miss_char;
1053:

Line 1052: x_phone_format_style := fnd_api.g_miss_char;

1048: -- initialize API return status to success.
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:
1051: -- Initialize return variables
1052: x_phone_format_style := fnd_api.g_miss_char;
1053:
1054: IF p_phone_country_code <> fnd_api.g_miss_char THEN
1055: l_phone_country_code := p_phone_country_code;
1056: END IF;

Line 1054: IF p_phone_country_code <> fnd_api.g_miss_char THEN

1050:
1051: -- Initialize return variables
1052: x_phone_format_style := fnd_api.g_miss_char;
1053:
1054: IF p_phone_country_code <> fnd_api.g_miss_char THEN
1055: l_phone_country_code := p_phone_country_code;
1056: END IF;
1057: IF p_phone_area_code <> fnd_api.g_miss_char THEN
1058: l_phone_area_code := p_phone_area_code;

Line 1057: IF p_phone_area_code <> fnd_api.g_miss_char THEN

1053:
1054: IF p_phone_country_code <> fnd_api.g_miss_char THEN
1055: l_phone_country_code := p_phone_country_code;
1056: END IF;
1057: IF p_phone_area_code <> fnd_api.g_miss_char THEN
1058: l_phone_area_code := p_phone_area_code;
1059: END IF;
1060: IF p_phone_number <> fnd_api.g_miss_char THEN
1061: l_phone_number := p_phone_number;

Line 1060: IF p_phone_number <> fnd_api.g_miss_char THEN

1056: END IF;
1057: IF p_phone_area_code <> fnd_api.g_miss_char THEN
1058: l_phone_area_code := p_phone_area_code;
1059: END IF;
1060: IF p_phone_number <> fnd_api.g_miss_char THEN
1061: l_phone_number := p_phone_number;
1062: END IF;
1063:
1064: -- Get the user preferences

Line 1094: l_phone_area_code = fnd_api.g_miss_char

1090: l_user_country_code := null;
1091: END IF;
1092:
1093: IF l_phone_area_code IS NULL OR
1094: l_phone_area_code = fnd_api.g_miss_char
1095: THEN
1096: l_raw_phone_number := filter_phone_number(l_phone_number);
1097: ELSE
1098: l_raw_phone_number := filter_phone_number(l_phone_area_code || l_phone_number);

Line 1106: p_territory_code <> fnd_api.g_miss_char

1102: ---e.g. US , Canada they will have similar format styles
1103: ---GET the Phone number's territory from the phone_country_code
1104:
1105: IF p_territory_code IS NOT NULL AND
1106: p_territory_code <> fnd_api.g_miss_char
1107: THEN
1108: l_phone_territory_code := p_territory_code;
1109: ELSE
1110: IF l_phone_country_code IS NOT NULL THEN

Line 1169: l_phone_country_code <> fnd_api.g_miss_char --Bug 4578945

1165: IF ((l_phone_country_code <> l_user_country_code) OR
1166: (l_user_country_code IS NULL))
1167: THEN
1168: IF l_phone_country_code IS NOT NULL AND
1169: l_phone_country_code <> fnd_api.g_miss_char --Bug 4578945
1170: THEN
1171: IF l_display_all_prefixes = 'Y' THEN
1172: l_formatted_phone_number := l_phone_country_code ||' '||l_formatted_phone_number;
1173: ELSE

Line 1191: l_phone_area_code <> fnd_api.g_miss_char

1187: ELSE
1188: l_formatted_phone_number := l_formatted_phone_number;
1189:
1190: IF l_phone_area_code IS NOT NULL AND
1191: l_phone_area_code <> fnd_api.g_miss_char
1192: THEN
1193: l_prefix := 'T';
1194: ELSE
1195: l_prefix := null;

Line 1224: p_encoded => fnd_api.g_false,

1220: x_formatted_phone_number := l_formatted_phone_number;
1221:
1222: -- Standard call to get msg count and if count is 1, get msg info.
1223: fnd_msg_pub.count_and_get(
1224: p_encoded => fnd_api.g_false,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data);
1227:
1228: -- Debug info.

Line 1244: WHEN fnd_api.g_exc_error THEN

1240: p_msg_level => fnd_log.level_procedure);
1241: END IF;
1242:
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: x_return_status := fnd_api.g_ret_sts_error;
1246: fnd_msg_pub.count_and_get(
1247: p_encoded => fnd_api.g_false,
1248: p_count => x_msg_count,

Line 1245: x_return_status := fnd_api.g_ret_sts_error;

1241: END IF;
1242:
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: x_return_status := fnd_api.g_ret_sts_error;
1246: fnd_msg_pub.count_and_get(
1247: p_encoded => fnd_api.g_false,
1248: p_count => x_msg_count,
1249: p_data => x_msg_data);

Line 1247: p_encoded => fnd_api.g_false,

1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: x_return_status := fnd_api.g_ret_sts_error;
1246: fnd_msg_pub.count_and_get(
1247: p_encoded => fnd_api.g_false,
1248: p_count => x_msg_count,
1249: p_data => x_msg_data);
1250:
1251: -- Debug info.

Line 1267: WHEN fnd_api.g_exc_unexpected_error THEN

1263: p_msg_level => fnd_log.level_procedure);
1264: END IF;
1265:
1266:
1267: WHEN fnd_api.g_exc_unexpected_error THEN
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.count_and_get(
1270: p_encoded => fnd_api.g_false,
1271: p_count => x_msg_count,

Line 1268: x_return_status := fnd_api.g_ret_sts_unexp_error;

1264: END IF;
1265:
1266:
1267: WHEN fnd_api.g_exc_unexpected_error THEN
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.count_and_get(
1270: p_encoded => fnd_api.g_false,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data);

Line 1270: p_encoded => fnd_api.g_false,

1266:
1267: WHEN fnd_api.g_exc_unexpected_error THEN
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.count_and_get(
1270: p_encoded => fnd_api.g_false,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data);
1273:
1274: -- Debug info.

Line 1290: x_return_status := fnd_api.g_ret_sts_unexp_error;

1286: p_msg_level => fnd_log.level_procedure);
1287: END IF;
1288:
1289: WHEN OTHERS THEN
1290: x_return_status := fnd_api.g_ret_sts_unexp_error;
1291:
1292: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1293: fnd_message.set_token('ERROR' ,SQLERRM);
1294: fnd_msg_pub.add;

Line 1297: p_encoded => fnd_api.g_false,

1293: fnd_message.set_token('ERROR' ,SQLERRM);
1294: fnd_msg_pub.add;
1295:
1296: fnd_msg_pub.count_and_get(
1297: p_encoded => fnd_api.g_false,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300:
1301: -- Debug info.

Line 1329: -- FND_API.G_TRUE. Default is fnd_api.g_false.

1325: --
1326: -- ARGUMENTS
1327: -- IN:
1328: -- p_init_msg_list Initialize message stack if it is set to
1329: -- FND_API.G_TRUE. Default is fnd_api.g_false.
1330: -- p_phone_country code Country code of the phone number
1331: -- p_phone_area_code Area code
1332: -- p_phone_number Phone Number
1333: --

Line 1338: -- be fnd_api.g_ret_sts_success (success),

1334: -- OUT:
1335: -- x_mobile_flag Flag indicating if the number is mobile
1336: -- HZ_PHONE_FORMATS or default format
1337: -- x_return_status Return status after the call. The status can
1338: -- be fnd_api.g_ret_sts_success (success),
1339: -- fnd_api.g_ret_sts_error (error),
1340: -- fnd_api.g_ret_sts_unexp_error
1341: -- (unexpected error).
1342: -- x_msg_count Number of messages in message stack.

Line 1339: -- fnd_api.g_ret_sts_error (error),

1335: -- x_mobile_flag Flag indicating if the number is mobile
1336: -- HZ_PHONE_FORMATS or default format
1337: -- x_return_status Return status after the call. The status can
1338: -- be fnd_api.g_ret_sts_success (success),
1339: -- fnd_api.g_ret_sts_error (error),
1340: -- fnd_api.g_ret_sts_unexp_error
1341: -- (unexpected error).
1342: -- x_msg_count Number of messages in message stack.
1343: -- x_msg_data Message text if x_msg_count is 1.

Line 1340: -- fnd_api.g_ret_sts_unexp_error

1336: -- HZ_PHONE_FORMATS or default format
1337: -- x_return_status Return status after the call. The status can
1338: -- be fnd_api.g_ret_sts_success (success),
1339: -- fnd_api.g_ret_sts_error (error),
1340: -- fnd_api.g_ret_sts_unexp_error
1341: -- (unexpected error).
1342: -- x_msg_count Number of messages in message stack.
1343: -- x_msg_data Message text if x_msg_count is 1.
1344: --

Line 1353: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1349: -- 01-10-2002 Jyoti Pandey o Created.
1350:
1351:
1352: PROCEDURE check_mobile_phone (
1353: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1354: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
1355: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
1356: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
1357: x_mobile_flag OUT NOCOPY VARCHAR2,

Line 1354: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,

1350:
1351:
1352: PROCEDURE check_mobile_phone (
1353: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1354: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
1355: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
1356: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
1357: x_mobile_flag OUT NOCOPY VARCHAR2,
1358: x_return_status OUT NOCOPY VARCHAR2,

Line 1355: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,

1351:
1352: PROCEDURE check_mobile_phone (
1353: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1354: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
1355: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
1356: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
1357: x_mobile_flag OUT NOCOPY VARCHAR2,
1358: x_return_status OUT NOCOPY VARCHAR2,
1359: x_msg_count OUT NOCOPY NUMBER,

Line 1356: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

1352: PROCEDURE check_mobile_phone (
1353: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1354: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
1355: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
1356: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
1357: x_mobile_flag OUT NOCOPY VARCHAR2,
1358: x_return_status OUT NOCOPY VARCHAR2,
1359: x_msg_count OUT NOCOPY NUMBER,
1360: x_msg_data OUT NOCOPY VARCHAR2)IS

Line 1385: IF FND_API.to_Boolean(p_init_msg_list) THEN

1381: p_msg_level=>fnd_log.level_procedure);
1382: END IF;
1383:
1384: -- initialize message list if p_init_msg_list is set to TRUE.
1385: IF FND_API.to_Boolean(p_init_msg_list) THEN
1386: FND_MSG_PUB.initialize;
1387: END IF;
1388:
1389: -- initialize API return status to success.

Line 1390: x_return_status := FND_API.G_RET_STS_SUCCESS;

1386: FND_MSG_PUB.initialize;
1387: END IF;
1388:
1389: -- initialize API return status to success.
1390: x_return_status := FND_API.G_RET_STS_SUCCESS;
1391:
1392:
1393: IF p_phone_country_code is NOT NULL THEN
1394:

Line 1448: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1444: x_mobile_flag := 'N';
1445: END IF; ---p_phone_country_code is NULL
1446:
1447: -- Standard call to get msg count and if count is 1, get msg info.
1448: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1449: p_count => x_msg_count,
1450: p_data => x_msg_data);
1451:
1452: -- Debug info.

Line 1469: WHEN fnd_api.g_exc_error THEN

1465: -- Check if API is called in debug mode. If yes, disable debug.
1466: --disable_debug;
1467:
1468: EXCEPTION
1469: WHEN fnd_api.g_exc_error THEN
1470: x_return_status := fnd_api.g_ret_sts_error;
1471:
1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1473: p_count => x_msg_count,

Line 1470: x_return_status := fnd_api.g_ret_sts_error;

1466: --disable_debug;
1467:
1468: EXCEPTION
1469: WHEN fnd_api.g_exc_error THEN
1470: x_return_status := fnd_api.g_ret_sts_error;
1471:
1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);

Line 1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1468: EXCEPTION
1469: WHEN fnd_api.g_exc_error THEN
1470: x_return_status := fnd_api.g_ret_sts_error;
1471:
1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1475:
1476: -- Debug info.

Line 1492: WHEN fnd_api.g_exc_unexpected_error THEN

1488:
1489: -- Check if API is called in debug mode. If yes, disable debug.
1490: --disable_debug;
1491:
1492: WHEN fnd_api.g_exc_unexpected_error THEN
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494:
1495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1496: p_count => x_msg_count,

Line 1493: x_return_status := fnd_api.g_ret_sts_unexp_error;

1489: -- Check if API is called in debug mode. If yes, disable debug.
1490: --disable_debug;
1491:
1492: WHEN fnd_api.g_exc_unexpected_error THEN
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494:
1495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data);

Line 1495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1491:
1492: WHEN fnd_api.g_exc_unexpected_error THEN
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494:
1495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data);
1498:
1499: -- Debug info.

Line 1517: x_return_status := fnd_api.g_ret_sts_unexp_error;

1513: -- Check if API is called in debug mode. If yes, disable debug.
1514: --disable_debug;
1515:
1516: WHEN OTHERS THEN
1517: x_return_status := fnd_api.g_ret_sts_unexp_error;
1518:
1519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1520: fnd_message.set_token('ERROR' ,SQLERRM);
1521: fnd_msg_pub.add;

Line 1523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1520: fnd_message.set_token('ERROR' ,SQLERRM);
1521: fnd_msg_pub.add;
1522:
1523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1524: p_count => x_msg_count,
1525: p_data => x_msg_data);
1526:
1527: -- Debug info.

Line 1717: p_with_iprefix IN VARCHAR2 := fnd_api.g_miss_char,

1713:
1714: /*----------------------parse_intl_prefix--------------------------*/
1715:
1716: PROCEDURE parse_intl_prefix(
1717: p_with_iprefix IN VARCHAR2 := fnd_api.g_miss_char,
1718: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
1719: x_intl_prefix OUT NOCOPY VARCHAR2,
1720: x_without_iprefix OUT NOCOPY VARCHAR2) IS
1721:

Line 1718: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

1714: /*----------------------parse_intl_prefix--------------------------*/
1715:
1716: PROCEDURE parse_intl_prefix(
1717: p_with_iprefix IN VARCHAR2 := fnd_api.g_miss_char,
1718: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
1719: x_intl_prefix OUT NOCOPY VARCHAR2,
1720: x_without_iprefix OUT NOCOPY VARCHAR2) IS
1721:
1722: l_with_iprefix VARCHAR2(30);

Line 1791: RAISE fnd_api.g_exc_unexpected_error;

1787: x_intl_prefix := NULL;
1788: x_without_iprefix := l_with_iprefix;
1789:
1790: WHEN OTHERS THEN
1791: RAISE fnd_api.g_exc_unexpected_error;
1792:
1793: END parse_intl_prefix;
1794:
1795: /*---------------------parse_trunk_prefix------------------------*/

Line 1798: p_with_tprefix IN VARCHAR2 := fnd_api.g_miss_char,

1794:
1795: /*---------------------parse_trunk_prefix------------------------*/
1796:
1797: PROCEDURE parse_trunk_prefix(
1798: p_with_tprefix IN VARCHAR2 := fnd_api.g_miss_char,
1799: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
1800: x_trunk_prefix OUT NOCOPY VARCHAR2,
1801: x_without_tprefix OUT NOCOPY VARCHAR2) IS
1802:

Line 1799: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

1795: /*---------------------parse_trunk_prefix------------------------*/
1796:
1797: PROCEDURE parse_trunk_prefix(
1798: p_with_tprefix IN VARCHAR2 := fnd_api.g_miss_char,
1799: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
1800: x_trunk_prefix OUT NOCOPY VARCHAR2,
1801: x_without_tprefix OUT NOCOPY VARCHAR2) IS
1802:
1803: l_with_tprefix VARCHAR2(30);

Line 1874: RAISE fnd_api.g_exc_unexpected_error;

1870: x_trunk_prefix := NULL;
1871: x_without_tprefix := l_with_tprefix;
1872:
1873: WHEN OTHERS THEN
1874: RAISE fnd_api.g_exc_unexpected_error;
1875:
1876: END parse_trunk_prefix;
1877:
1878: -------PARSE COUNTRY CODE ----------------------

Line 1880: p_with_country_code IN VARCHAR2 := fnd_api.g_miss_char,

1876: END parse_trunk_prefix;
1877:
1878: -------PARSE COUNTRY CODE ----------------------
1879: PROCEDURE parse_country_code(
1880: p_with_country_code IN VARCHAR2 := fnd_api.g_miss_char,
1881: x_country_code OUT NOCOPY VARCHAR2,
1882: x_without_country_code OUT NOCOPY VARCHAR2) IS
1883:
1884: x_parsed_country_code VARCHAR2(5);

Line 1946: RAISE fnd_api.g_exc_unexpected_error;

1942: END IF;
1943:
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: RAISE fnd_api.g_exc_unexpected_error;
1947:
1948: end parse_country_code;
1949:
1950: ---------PARSE AREA CODE AND PHONE NUMBER-----------------

Line 1952: p_with_area_code IN VARCHAR2 := fnd_api.g_miss_char,

1948: end parse_country_code;
1949:
1950: ---------PARSE AREA CODE AND PHONE NUMBER-----------------
1951: PROCEDURE parse_area_code(
1952: p_with_area_code IN VARCHAR2 := fnd_api.g_miss_char,
1953: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
1954: x_parsed_area_code OUT NOCOPY VARCHAR2,
1955: x_parsed_phone_number OUT NOCOPY VARCHAR2) IS
1956:

Line 1953: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,

1949:
1950: ---------PARSE AREA CODE AND PHONE NUMBER-----------------
1951: PROCEDURE parse_area_code(
1952: p_with_area_code IN VARCHAR2 := fnd_api.g_miss_char,
1953: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
1954: x_parsed_area_code OUT NOCOPY VARCHAR2,
1955: x_parsed_phone_number OUT NOCOPY VARCHAR2) IS
1956:
1957: l_with_area_code varchar2(30);

Line 2122: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

2118: END filter_phone_number;
2119:
2120:
2121: PROCEDURE get_phone_format (
2122: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
2123: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
2124: p_area_code IN VARCHAR2,
2125: x_phone_country_code OUT NOCOPY VARCHAR2,
2126: x_phone_format_style OUT NOCOPY VARCHAR2,

Line 2123: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

2119:
2120:
2121: PROCEDURE get_phone_format (
2122: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
2123: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
2124: p_area_code IN VARCHAR2,
2125: x_phone_country_code OUT NOCOPY VARCHAR2,
2126: x_phone_format_style OUT NOCOPY VARCHAR2,
2127: x_area_code_size OUT NOCOPY NUMBER,

Line 2228: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

2224:
2225: /*------------------------translate_raw_phone_number----------------*/
2226:
2227: PROCEDURE translate_raw_phone_number (
2228: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
2229: p_phone_format_style IN VARCHAR2 := fnd_api.g_miss_char,
2230: x_formatted_phone_number OUT NOCOPY VARCHAR2
2231: ) IS
2232:

Line 2229: p_phone_format_style IN VARCHAR2 := fnd_api.g_miss_char,

2225: /*------------------------translate_raw_phone_number----------------*/
2226:
2227: PROCEDURE translate_raw_phone_number (
2228: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
2229: p_phone_format_style IN VARCHAR2 := fnd_api.g_miss_char,
2230: x_formatted_phone_number OUT NOCOPY VARCHAR2
2231: ) IS
2232:
2233: l_debug_prefix VARCHAR2(30) := ''; -- translate_raw_phone_number

Line 2278: p_display_purpose IN VARCHAR2 := fnd_api.g_true)

2274:
2275:
2276: FUNCTION get_formatted_phone(
2277: p_contact_point_id IN NUMBER,
2278: p_display_purpose IN VARCHAR2 := fnd_api.g_true)
2279: RETURN VARCHAR2 IS
2280: --3865843
2281: x_formatted_phone_number VARCHAR2(220);
2282: x_return_status VARCHAR2(1);

Line 2300: fnd_api.g_true,

2296: RETURN NULL;
2297: END IF;
2298:
2299: phone_display(
2300: fnd_api.g_true,
2301: p_contact_point_id,
2302: x_formatted_phone_number,
2303: x_return_status,
2304: x_msg_count,

Line 2316: IF p_display_purpose = fnd_api.g_true THEN

2312: IF x_phone_extension IS NOT NULL THEN
2313: x_formatted_phone_number := x_formatted_phone_number || ' x' || x_phone_extension;
2314: END IF;
2315:
2316: IF p_display_purpose = fnd_api.g_true THEN
2317: x_formatted_phone_number := x_formatted_phone_number || ' (' || x_phone_line_type || ')';
2318: END IF;
2319: RETURN x_formatted_phone_number;
2320:

Line 2338: * When the value is FND_API.G_TRUE, return

2334: * p_phone_number phone number
2335: * p_phone_extension phone extension
2336: * p_phone_line_type phone line type
2337: * p_display_purpose If the return is for display purpose.
2338: * When the value is FND_API.G_TRUE, return
2339: * formatted phone number (phone line type)
2340: *
2341: * RETURNS : VARCHAR2
2342: *

Line 2365: l_display_purpose := fnd_api.g_true;

2361:
2362: BEGIN
2363:
2364: IF p_display_purpose IS NULL THEN
2365: l_display_purpose := fnd_api.g_true;
2366: ELSE
2367: l_display_purpose := p_display_purpose;
2368: END IF;
2369:

Line 2387: AND p_phone_line_type<>fnd_api.g_miss_char

2383: END IF;
2384:
2385:
2386: IF p_phone_line_type IS NOT NULL -- Bug 4917862
2387: AND p_phone_line_type<>fnd_api.g_miss_char
2388: AND l_display_purpose = fnd_api.g_true
2389: THEN
2390: l_phone_line_meaning :=
2391: hz_utility_v2pub.get_lookupmeaning('AR_LOOKUPS', 'PHONE_LINE_TYPE', p_phone_line_type);

Line 2388: AND l_display_purpose = fnd_api.g_true

2384:
2385:
2386: IF p_phone_line_type IS NOT NULL -- Bug 4917862
2387: AND p_phone_line_type<>fnd_api.g_miss_char
2388: AND l_display_purpose = fnd_api.g_true
2389: THEN
2390: l_phone_line_meaning :=
2391: hz_utility_v2pub.get_lookupmeaning('AR_LOOKUPS', 'PHONE_LINE_TYPE', p_phone_line_type);
2392: