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

Line 43: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.

39: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
40: --
41: -- ARGUMENTS
42: -- IN:
43: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
44: -- p_phone_id phone ID. If this id is passed in, return only one obj.
45: --
46: -- p_parent_id parent_id
47: -- p_parent_table_name parent_table name

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

47: -- p_parent_table_name parent_table name
48: -- OUT:
49: -- x_phone_obj Logical phone record.
50: -- x_return_status Return status after the call. The status can
51: -- be fnd_api.g_ret_sts_success (success),
52: -- fnd_api.g_ret_sts_error (error),
53: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
54: -- x_msg_count Number of messages in message stack.
55: -- x_msg_data Message text if x_msg_count is 1.

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

48: -- OUT:
49: -- x_phone_obj Logical phone record.
50: -- x_return_status Return status after the call. The status can
51: -- be fnd_api.g_ret_sts_success (success),
52: -- fnd_api.g_ret_sts_error (error),
53: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
54: -- x_msg_count Number of messages in message stack.
55: -- x_msg_data Message text if x_msg_count is 1.
56: --

Line 53: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

49: -- x_phone_obj Logical phone record.
50: -- x_return_status Return status after the call. The status can
51: -- be fnd_api.g_ret_sts_success (success),
52: -- fnd_api.g_ret_sts_error (error),
53: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
54: -- x_msg_count Number of messages in message stack.
55: -- x_msg_data Message text if x_msg_count is 1.
56: --
57: -- NOTES

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

63: --
64:
65:
66: PROCEDURE get_phone_bos(
67: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
68: p_phone_id IN NUMBER,
69: p_parent_id IN NUMBER,
70: p_parent_table_name IN VARCHAR2,
71: p_action_type IN VARCHAR2 := NULL,

Line 217: x_return_status := FND_API.G_RET_STS_SUCCESS;

213: BEGIN
214:
215:
216: -- initialize API return status to success.
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218:
219: -- Initialize message list if p_init_msg_list is set to TRUE
220: IF FND_API.to_Boolean(p_init_msg_list) THEN
221: FND_MSG_PUB.initialize;

Line 220: IF FND_API.to_Boolean(p_init_msg_list) THEN

216: -- initialize API return status to success.
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218:
219: -- Initialize message list if p_init_msg_list is set to TRUE
220: IF FND_API.to_Boolean(p_init_msg_list) THEN
221: FND_MSG_PUB.initialize;
222: END IF;
223:
224:

Line 255: WHEN fnd_api.g_exc_error THEN

251:
252:
253: EXCEPTION
254:
255: WHEN fnd_api.g_exc_error THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257:
258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
259: p_count => x_msg_count,

Line 256: x_return_status := fnd_api.g_ret_sts_error;

252:
253: EXCEPTION
254:
255: WHEN fnd_api.g_exc_error THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257:
258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data);

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

254:
255: WHEN fnd_api.g_exc_error THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257:
258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data);
261:
262: -- Debug info.

Line 274: WHEN fnd_api.g_exc_unexpected_error THEN

270: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
274: WHEN fnd_api.g_exc_unexpected_error THEN
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276:
277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
278: p_count => x_msg_count,

Line 275: x_return_status := fnd_api.g_ret_sts_unexp_error;

271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
274: WHEN fnd_api.g_exc_unexpected_error THEN
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276:
277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
278: p_count => x_msg_count,
279: p_data => x_msg_data);

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

273: END IF;
274: WHEN fnd_api.g_exc_unexpected_error THEN
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276:
277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
278: p_count => x_msg_count,
279: p_data => x_msg_data);
280:
281: -- Debug info.

Line 294: x_return_status := fnd_api.g_ret_sts_unexp_error;

290: p_prefix=>l_debug_prefix,
291: p_msg_level=>fnd_log.level_procedure);
292: END IF;
293: WHEN OTHERS THEN
294: x_return_status := fnd_api.g_ret_sts_unexp_error;
295:
296: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
297: fnd_message.set_token('ERROR' ,SQLERRM);
298: fnd_msg_pub.add;

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

296: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
297: fnd_message.set_token('ERROR' ,SQLERRM);
298: fnd_msg_pub.add;
299:
300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
301: p_count => x_msg_count,
302: p_data => x_msg_data);
303:
304: -- Debug info.

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

337:
338: -- OUT:
339: -- x_telex_objs Logical telex record.
340: -- x_return_status Return status after the call. The status can
341: -- be fnd_api.g_ret_sts_success (success),
342: -- fnd_api.g_ret_sts_error (error),
343: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
344: -- x_msg_count Number of messages in message stack.
345: -- x_msg_data Message text if x_msg_count is 1.

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

338: -- OUT:
339: -- x_telex_objs Logical telex record.
340: -- x_return_status Return status after the call. The status can
341: -- be fnd_api.g_ret_sts_success (success),
342: -- fnd_api.g_ret_sts_error (error),
343: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
344: -- x_msg_count Number of messages in message stack.
345: -- x_msg_data Message text if x_msg_count is 1.
346: --

Line 343: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

339: -- x_telex_objs Logical telex record.
340: -- x_return_status Return status after the call. The status can
341: -- be fnd_api.g_ret_sts_success (success),
342: -- fnd_api.g_ret_sts_error (error),
343: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
344: -- x_msg_count Number of messages in message stack.
345: -- x_msg_data Message text if x_msg_count is 1.
346: --
347: -- NOTES

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

354:
355:
356:
357: PROCEDURE get_telex_bos(
358: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
359: p_telex_id IN NUMBER,
360: p_parent_id IN NUMBER,
361: p_parent_table_name IN VARCHAR2,
362: p_action_type IN VARCHAR2 := NULL,

Line 499: x_return_status := FND_API.G_RET_STS_SUCCESS;

495:
496: begin
497:
498: -- initialize API return status to success.
499: x_return_status := FND_API.G_RET_STS_SUCCESS;
500:
501: -- Initialize message list if p_init_msg_list is set to TRUE
502: IF FND_API.to_Boolean(p_init_msg_list) THEN
503: FND_MSG_PUB.initialize;

Line 502: IF FND_API.to_Boolean(p_init_msg_list) THEN

498: -- initialize API return status to success.
499: x_return_status := FND_API.G_RET_STS_SUCCESS;
500:
501: -- Initialize message list if p_init_msg_list is set to TRUE
502: IF FND_API.to_Boolean(p_init_msg_list) THEN
503: FND_MSG_PUB.initialize;
504: END IF;
505:
506: -- Debug info.

Line 538: WHEN fnd_api.g_exc_error THEN

534: END IF;
535:
536: EXCEPTION
537:
538: WHEN fnd_api.g_exc_error THEN
539: x_return_status := fnd_api.g_ret_sts_error;
540:
541: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
542: p_count => x_msg_count,

Line 539: x_return_status := fnd_api.g_ret_sts_error;

535:
536: EXCEPTION
537:
538: WHEN fnd_api.g_exc_error THEN
539: x_return_status := fnd_api.g_ret_sts_error;
540:
541: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
542: p_count => x_msg_count,
543: p_data => x_msg_data);

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

537:
538: WHEN fnd_api.g_exc_error THEN
539: x_return_status := fnd_api.g_ret_sts_error;
540:
541: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
542: p_count => x_msg_count,
543: p_data => x_msg_data);
544:
545: -- Debug info.

Line 557: WHEN fnd_api.g_exc_unexpected_error THEN

553: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;
557: WHEN fnd_api.g_exc_unexpected_error THEN
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559:
560: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
561: p_count => x_msg_count,

Line 558: x_return_status := fnd_api.g_ret_sts_unexp_error;

554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;
557: WHEN fnd_api.g_exc_unexpected_error THEN
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559:
560: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
561: p_count => x_msg_count,
562: p_data => x_msg_data);

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

556: END IF;
557: WHEN fnd_api.g_exc_unexpected_error THEN
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559:
560: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
561: p_count => x_msg_count,
562: p_data => x_msg_data);
563:
564: -- Debug info.

Line 577: x_return_status := fnd_api.g_ret_sts_unexp_error;

573: p_prefix=>l_debug_prefix,
574: p_msg_level=>fnd_log.level_procedure);
575: END IF;
576: WHEN OTHERS THEN
577: x_return_status := fnd_api.g_ret_sts_unexp_error;
578:
579: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
580: fnd_message.set_token('ERROR' ,SQLERRM);
581: fnd_msg_pub.add;

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

579: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
580: fnd_message.set_token('ERROR' ,SQLERRM);
581: fnd_msg_pub.add;
582:
583: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
584: p_count => x_msg_count,
585: p_data => x_msg_data);
586:
587: -- Debug info.

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

617: -- p_parent_table_name parent_table name
618: -- OUT:
619: -- x_email_objs Logical email record.
620: -- x_return_status Return status after the call. The status can
621: -- be fnd_api.g_ret_sts_success (success),
622: -- fnd_api.g_ret_sts_error (error),
623: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
624: -- x_msg_count Number of messages in message stack.
625: -- x_msg_data Message text if x_msg_count is 1.

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

618: -- OUT:
619: -- x_email_objs Logical email record.
620: -- x_return_status Return status after the call. The status can
621: -- be fnd_api.g_ret_sts_success (success),
622: -- fnd_api.g_ret_sts_error (error),
623: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
624: -- x_msg_count Number of messages in message stack.
625: -- x_msg_data Message text if x_msg_count is 1.
626: --

Line 623: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

619: -- x_email_objs Logical email record.
620: -- x_return_status Return status after the call. The status can
621: -- be fnd_api.g_ret_sts_success (success),
622: -- fnd_api.g_ret_sts_error (error),
623: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
624: -- x_msg_count Number of messages in message stack.
625: -- x_msg_data Message text if x_msg_count is 1.
626: --
627: -- NOTES

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

634:
635:
636:
637: PROCEDURE get_email_bos(
638: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
639: p_email_id IN NUMBER,
640: p_parent_id IN NUMBER,
641: p_parent_table_name IN VARCHAR2,
642: p_action_type IN VARCHAR2 := NULL,

Line 780: x_return_status := FND_API.G_RET_STS_SUCCESS;

776:
777: BEGIN
778:
779: -- initialize API return status to success.
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: -- Initialize message list if p_init_msg_list is set to TRUE
783: IF FND_API.to_Boolean(p_init_msg_list) THEN
784: FND_MSG_PUB.initialize;

Line 783: IF FND_API.to_Boolean(p_init_msg_list) THEN

779: -- initialize API return status to success.
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: -- Initialize message list if p_init_msg_list is set to TRUE
783: IF FND_API.to_Boolean(p_init_msg_list) THEN
784: FND_MSG_PUB.initialize;
785: END IF;
786:
787: -- Debug info.

Line 818: WHEN fnd_api.g_exc_error THEN

814: END IF;
815:
816: EXCEPTION
817:
818: WHEN fnd_api.g_exc_error THEN
819: x_return_status := fnd_api.g_ret_sts_error;
820:
821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
822: p_count => x_msg_count,

Line 819: x_return_status := fnd_api.g_ret_sts_error;

815:
816: EXCEPTION
817:
818: WHEN fnd_api.g_exc_error THEN
819: x_return_status := fnd_api.g_ret_sts_error;
820:
821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
822: p_count => x_msg_count,
823: p_data => x_msg_data);

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

817:
818: WHEN fnd_api.g_exc_error THEN
819: x_return_status := fnd_api.g_ret_sts_error;
820:
821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
822: p_count => x_msg_count,
823: p_data => x_msg_data);
824:
825: -- Debug info.

Line 837: WHEN fnd_api.g_exc_unexpected_error THEN

833: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
834: p_prefix=>l_debug_prefix,
835: p_msg_level=>fnd_log.level_procedure);
836: END IF;
837: WHEN fnd_api.g_exc_unexpected_error THEN
838: x_return_status := fnd_api.g_ret_sts_unexp_error;
839:
840: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
841: p_count => x_msg_count,

Line 838: x_return_status := fnd_api.g_ret_sts_unexp_error;

834: p_prefix=>l_debug_prefix,
835: p_msg_level=>fnd_log.level_procedure);
836: END IF;
837: WHEN fnd_api.g_exc_unexpected_error THEN
838: x_return_status := fnd_api.g_ret_sts_unexp_error;
839:
840: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
841: p_count => x_msg_count,
842: p_data => x_msg_data);

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

836: END IF;
837: WHEN fnd_api.g_exc_unexpected_error THEN
838: x_return_status := fnd_api.g_ret_sts_unexp_error;
839:
840: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
841: p_count => x_msg_count,
842: p_data => x_msg_data);
843:
844: -- Debug info.

Line 857: x_return_status := fnd_api.g_ret_sts_unexp_error;

853: p_prefix=>l_debug_prefix,
854: p_msg_level=>fnd_log.level_procedure);
855: END IF;
856: WHEN OTHERS THEN
857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858:
859: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
860: fnd_message.set_token('ERROR' ,SQLERRM);
861: fnd_msg_pub.add;

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

859: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
860: fnd_message.set_token('ERROR' ,SQLERRM);
861: fnd_msg_pub.add;
862:
863: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
864: p_count => x_msg_count,
865: p_data => x_msg_data);
866:
867: -- Debug info.

Line 896: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.

892: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
893: --
894: -- ARGUMENTS
895: -- IN:
896: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
897: -- p_web_id web ID. If this id is passed in, return only one obj.
898: -- p_parent_id parent_id
899: -- p_parent_table_name parent_table name
900: --

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

900: --
901: -- OUT:
902: -- x_web_objs Logical web record.
903: -- x_return_status Return status after the call. The status can
904: -- be fnd_api.g_ret_sts_success (success),
905: -- fnd_api.g_ret_sts_error (error),
906: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
907: -- x_msg_count Number of messages in message stack.
908: -- x_msg_data Message text if x_msg_count is 1.

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

901: -- OUT:
902: -- x_web_objs Logical web record.
903: -- x_return_status Return status after the call. The status can
904: -- be fnd_api.g_ret_sts_success (success),
905: -- fnd_api.g_ret_sts_error (error),
906: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
907: -- x_msg_count Number of messages in message stack.
908: -- x_msg_data Message text if x_msg_count is 1.
909: --

Line 906: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

902: -- x_web_objs Logical web record.
903: -- x_return_status Return status after the call. The status can
904: -- be fnd_api.g_ret_sts_success (success),
905: -- fnd_api.g_ret_sts_error (error),
906: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
907: -- x_msg_count Number of messages in message stack.
908: -- x_msg_data Message text if x_msg_count is 1.
909: --
910: -- NOTES

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

917:
918:
919:
920: PROCEDURE get_web_bos(
921: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
922: p_web_id IN NUMBER,
923: p_parent_id IN NUMBER,
924: p_parent_table_name IN VARCHAR2,
925: p_action_type IN VARCHAR2 := NULL,

Line 1064: x_return_status := FND_API.G_RET_STS_SUCCESS;

1060:
1061: BEGIN
1062:
1063: -- initialize API return status to success.
1064: x_return_status := FND_API.G_RET_STS_SUCCESS;
1065:
1066: -- Initialize message list if p_init_msg_list is set to TRUE
1067: IF FND_API.to_Boolean(p_init_msg_list) THEN
1068: FND_MSG_PUB.initialize;

Line 1067: IF FND_API.to_Boolean(p_init_msg_list) THEN

1063: -- initialize API return status to success.
1064: x_return_status := FND_API.G_RET_STS_SUCCESS;
1065:
1066: -- Initialize message list if p_init_msg_list is set to TRUE
1067: IF FND_API.to_Boolean(p_init_msg_list) THEN
1068: FND_MSG_PUB.initialize;
1069: END IF;
1070:
1071: -- Debug info.

Line 1103: WHEN fnd_api.g_exc_error THEN

1099: END IF;
1100:
1101: EXCEPTION
1102:
1103: WHEN fnd_api.g_exc_error THEN
1104: x_return_status := fnd_api.g_ret_sts_error;
1105:
1106: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1107: p_count => x_msg_count,

Line 1104: x_return_status := fnd_api.g_ret_sts_error;

1100:
1101: EXCEPTION
1102:
1103: WHEN fnd_api.g_exc_error THEN
1104: x_return_status := fnd_api.g_ret_sts_error;
1105:
1106: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1107: p_count => x_msg_count,
1108: p_data => x_msg_data);

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

1102:
1103: WHEN fnd_api.g_exc_error THEN
1104: x_return_status := fnd_api.g_ret_sts_error;
1105:
1106: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1107: p_count => x_msg_count,
1108: p_data => x_msg_data);
1109:
1110: -- Debug info.

Line 1122: WHEN fnd_api.g_exc_unexpected_error THEN

1118: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1119: p_prefix=>l_debug_prefix,
1120: p_msg_level=>fnd_log.level_procedure);
1121: END IF;
1122: WHEN fnd_api.g_exc_unexpected_error THEN
1123: x_return_status := fnd_api.g_ret_sts_unexp_error;
1124:
1125: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1126: p_count => x_msg_count,

Line 1123: x_return_status := fnd_api.g_ret_sts_unexp_error;

1119: p_prefix=>l_debug_prefix,
1120: p_msg_level=>fnd_log.level_procedure);
1121: END IF;
1122: WHEN fnd_api.g_exc_unexpected_error THEN
1123: x_return_status := fnd_api.g_ret_sts_unexp_error;
1124:
1125: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data);

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

1121: END IF;
1122: WHEN fnd_api.g_exc_unexpected_error THEN
1123: x_return_status := fnd_api.g_ret_sts_unexp_error;
1124:
1125: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data);
1128:
1129: -- Debug info.

Line 1142: x_return_status := fnd_api.g_ret_sts_unexp_error;

1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141: WHEN OTHERS THEN
1142: x_return_status := fnd_api.g_ret_sts_unexp_error;
1143:
1144: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1145: fnd_message.set_token('ERROR' ,SQLERRM);
1146: fnd_msg_pub.add;

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

1144: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1145: fnd_message.set_token('ERROR' ,SQLERRM);
1146: fnd_msg_pub.add;
1147:
1148: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data);
1151:
1152: -- Debug info.

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

1186:
1187: -- OUT:
1188: -- x_edi_objs Logical edi record.
1189: -- x_return_status Return status after the call. The status can
1190: -- be fnd_api.g_ret_sts_success (success),
1191: -- fnd_api.g_ret_sts_error (error),
1192: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1193: -- x_msg_count Number of messages in message stack.
1194: -- x_msg_data Message text if x_msg_count is 1.

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

1187: -- OUT:
1188: -- x_edi_objs Logical edi record.
1189: -- x_return_status Return status after the call. The status can
1190: -- be fnd_api.g_ret_sts_success (success),
1191: -- fnd_api.g_ret_sts_error (error),
1192: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1193: -- x_msg_count Number of messages in message stack.
1194: -- x_msg_data Message text if x_msg_count is 1.
1195: --

Line 1192: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1188: -- x_edi_objs Logical edi record.
1189: -- x_return_status Return status after the call. The status can
1190: -- be fnd_api.g_ret_sts_success (success),
1191: -- fnd_api.g_ret_sts_error (error),
1192: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1193: -- x_msg_count Number of messages in message stack.
1194: -- x_msg_data Message text if x_msg_count is 1.
1195: --
1196: -- NOTES

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

1203:
1204:
1205:
1206: PROCEDURE get_edi_bos(
1207: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1208: p_edi_id IN NUMBER,
1209: p_parent_id IN NUMBER,
1210: p_parent_table_name IN VARCHAR2,
1211: p_action_type IN VARCHAR2 := NULL,

Line 1355: x_return_status := FND_API.G_RET_STS_SUCCESS;

1351:
1352: BEGIN
1353:
1354: -- initialize API return status to success.
1355: x_return_status := FND_API.G_RET_STS_SUCCESS;
1356:
1357: -- Initialize message list if p_init_msg_list is set to TRUE
1358: IF FND_API.to_Boolean(p_init_msg_list) THEN
1359: FND_MSG_PUB.initialize;

Line 1358: IF FND_API.to_Boolean(p_init_msg_list) THEN

1354: -- initialize API return status to success.
1355: x_return_status := FND_API.G_RET_STS_SUCCESS;
1356:
1357: -- Initialize message list if p_init_msg_list is set to TRUE
1358: IF FND_API.to_Boolean(p_init_msg_list) THEN
1359: FND_MSG_PUB.initialize;
1360: END IF;
1361:
1362: -- Debug info.

Line 1392: WHEN fnd_api.g_exc_error THEN

1388: END IF;
1389:
1390: EXCEPTION
1391:
1392: WHEN fnd_api.g_exc_error THEN
1393: x_return_status := fnd_api.g_ret_sts_error;
1394:
1395: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1396: p_count => x_msg_count,

Line 1393: x_return_status := fnd_api.g_ret_sts_error;

1389:
1390: EXCEPTION
1391:
1392: WHEN fnd_api.g_exc_error THEN
1393: x_return_status := fnd_api.g_ret_sts_error;
1394:
1395: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1396: p_count => x_msg_count,
1397: p_data => x_msg_data);

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

1391:
1392: WHEN fnd_api.g_exc_error THEN
1393: x_return_status := fnd_api.g_ret_sts_error;
1394:
1395: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1396: p_count => x_msg_count,
1397: p_data => x_msg_data);
1398:
1399: -- Debug info.

Line 1411: WHEN fnd_api.g_exc_unexpected_error THEN

1407: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1408: p_prefix=>l_debug_prefix,
1409: p_msg_level=>fnd_log.level_procedure);
1410: END IF;
1411: WHEN fnd_api.g_exc_unexpected_error THEN
1412: x_return_status := fnd_api.g_ret_sts_unexp_error;
1413:
1414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1415: p_count => x_msg_count,

Line 1412: x_return_status := fnd_api.g_ret_sts_unexp_error;

1408: p_prefix=>l_debug_prefix,
1409: p_msg_level=>fnd_log.level_procedure);
1410: END IF;
1411: WHEN fnd_api.g_exc_unexpected_error THEN
1412: x_return_status := fnd_api.g_ret_sts_unexp_error;
1413:
1414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1415: p_count => x_msg_count,
1416: p_data => x_msg_data);

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

1410: END IF;
1411: WHEN fnd_api.g_exc_unexpected_error THEN
1412: x_return_status := fnd_api.g_ret_sts_unexp_error;
1413:
1414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1415: p_count => x_msg_count,
1416: p_data => x_msg_data);
1417:
1418: -- Debug info.

Line 1431: x_return_status := fnd_api.g_ret_sts_unexp_error;

1427: p_prefix=>l_debug_prefix,
1428: p_msg_level=>fnd_log.level_procedure);
1429: END IF;
1430: WHEN OTHERS THEN
1431: x_return_status := fnd_api.g_ret_sts_unexp_error;
1432:
1433: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1434: fnd_message.set_token('ERROR' ,SQLERRM);
1435: fnd_msg_pub.add;

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

1433: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1434: fnd_message.set_token('ERROR' ,SQLERRM);
1435: fnd_msg_pub.add;
1436:
1437: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1438: p_count => x_msg_count,
1439: p_data => x_msg_data);
1440:
1441: -- Debug info.

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

1474:
1475: -- OUT:
1476: -- x_eft_objs Logical eft record.
1477: -- x_return_status Return status after the call. The status can
1478: -- be fnd_api.g_ret_sts_success (success),
1479: -- fnd_api.g_ret_sts_error (error),
1480: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1481: -- x_msg_count Number of messages in message stack.
1482: -- x_msg_data Message text if x_msg_count is 1.

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

1475: -- OUT:
1476: -- x_eft_objs Logical eft record.
1477: -- x_return_status Return status after the call. The status can
1478: -- be fnd_api.g_ret_sts_success (success),
1479: -- fnd_api.g_ret_sts_error (error),
1480: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1481: -- x_msg_count Number of messages in message stack.
1482: -- x_msg_data Message text if x_msg_count is 1.
1483: --

Line 1480: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1476: -- x_eft_objs Logical eft record.
1477: -- x_return_status Return status after the call. The status can
1478: -- be fnd_api.g_ret_sts_success (success),
1479: -- fnd_api.g_ret_sts_error (error),
1480: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1481: -- x_msg_count Number of messages in message stack.
1482: -- x_msg_data Message text if x_msg_count is 1.
1483: --
1484: -- NOTES

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

1491:
1492:
1493:
1494: PROCEDURE get_eft_bos(
1495: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1496: p_eft_id IN NUMBER,
1497: p_parent_id IN NUMBER,
1498: p_parent_table_name IN VARCHAR2,
1499: p_action_type IN VARCHAR2 := NULL,

Line 1639: x_return_status := FND_API.G_RET_STS_SUCCESS;

1635:
1636: BEGIN
1637:
1638: -- initialize API return status to success.
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;
1640:
1641: -- Initialize message list if p_init_msg_list is set to TRUE
1642: IF FND_API.to_Boolean(p_init_msg_list) THEN
1643: FND_MSG_PUB.initialize;

Line 1642: IF FND_API.to_Boolean(p_init_msg_list) THEN

1638: -- initialize API return status to success.
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;
1640:
1641: -- Initialize message list if p_init_msg_list is set to TRUE
1642: IF FND_API.to_Boolean(p_init_msg_list) THEN
1643: FND_MSG_PUB.initialize;
1644: END IF;
1645:
1646: -- Debug info.

Line 1676: WHEN fnd_api.g_exc_error THEN

1672: END IF;
1673:
1674: EXCEPTION
1675:
1676: WHEN fnd_api.g_exc_error THEN
1677: x_return_status := fnd_api.g_ret_sts_error;
1678:
1679: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1680: p_count => x_msg_count,

Line 1677: x_return_status := fnd_api.g_ret_sts_error;

1673:
1674: EXCEPTION
1675:
1676: WHEN fnd_api.g_exc_error THEN
1677: x_return_status := fnd_api.g_ret_sts_error;
1678:
1679: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1680: p_count => x_msg_count,
1681: p_data => x_msg_data);

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

1675:
1676: WHEN fnd_api.g_exc_error THEN
1677: x_return_status := fnd_api.g_ret_sts_error;
1678:
1679: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1680: p_count => x_msg_count,
1681: p_data => x_msg_data);
1682:
1683: -- Debug info.

Line 1695: WHEN fnd_api.g_exc_unexpected_error THEN

1691: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1692: p_prefix=>l_debug_prefix,
1693: p_msg_level=>fnd_log.level_procedure);
1694: END IF;
1695: WHEN fnd_api.g_exc_unexpected_error THEN
1696: x_return_status := fnd_api.g_ret_sts_unexp_error;
1697:
1698: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1699: p_count => x_msg_count,

Line 1696: x_return_status := fnd_api.g_ret_sts_unexp_error;

1692: p_prefix=>l_debug_prefix,
1693: p_msg_level=>fnd_log.level_procedure);
1694: END IF;
1695: WHEN fnd_api.g_exc_unexpected_error THEN
1696: x_return_status := fnd_api.g_ret_sts_unexp_error;
1697:
1698: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1699: p_count => x_msg_count,
1700: p_data => x_msg_data);

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

1694: END IF;
1695: WHEN fnd_api.g_exc_unexpected_error THEN
1696: x_return_status := fnd_api.g_ret_sts_unexp_error;
1697:
1698: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1699: p_count => x_msg_count,
1700: p_data => x_msg_data);
1701:
1702: -- Debug info.

Line 1715: x_return_status := fnd_api.g_ret_sts_unexp_error;

1711: p_prefix=>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_procedure);
1713: END IF;
1714: WHEN OTHERS THEN
1715: x_return_status := fnd_api.g_ret_sts_unexp_error;
1716:
1717: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1718: fnd_message.set_token('ERROR' ,SQLERRM);
1719: fnd_msg_pub.add;

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

1717: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1718: fnd_message.set_token('ERROR' ,SQLERRM);
1719: fnd_msg_pub.add;
1720:
1721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1722: p_count => x_msg_count,
1723: p_data => x_msg_data);
1724:
1725: -- Debug info.

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

1758:
1759: -- OUT:
1760: -- x_sms_objs Logical sms record.
1761: -- x_return_status Return status after the call. The status can
1762: -- be fnd_api.g_ret_sts_success (success),
1763: -- fnd_api.g_ret_sts_error (error),
1764: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1765: -- x_msg_count Number of messages in message stack.
1766: -- x_msg_data Message text if x_msg_count is 1.

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

1759: -- OUT:
1760: -- x_sms_objs Logical sms record.
1761: -- x_return_status Return status after the call. The status can
1762: -- be fnd_api.g_ret_sts_success (success),
1763: -- fnd_api.g_ret_sts_error (error),
1764: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1765: -- x_msg_count Number of messages in message stack.
1766: -- x_msg_data Message text if x_msg_count is 1.
1767: --

Line 1764: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1760: -- x_sms_objs Logical sms record.
1761: -- x_return_status Return status after the call. The status can
1762: -- be fnd_api.g_ret_sts_success (success),
1763: -- fnd_api.g_ret_sts_error (error),
1764: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1765: -- x_msg_count Number of messages in message stack.
1766: -- x_msg_data Message text if x_msg_count is 1.
1767: --
1768: -- NOTES

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

1775:
1776:
1777:
1778: PROCEDURE get_sms_bos(
1779: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1780: p_sms_id IN NUMBER,
1781: p_parent_id IN NUMBER,
1782: p_parent_table_name IN VARCHAR2,
1783: p_action_type IN VARCHAR2 := NULL,

Line 1927: x_return_status := FND_API.G_RET_STS_SUCCESS;

1923:
1924: BEGIN
1925:
1926: -- initialize API return status to success.
1927: x_return_status := FND_API.G_RET_STS_SUCCESS;
1928:
1929: -- Initialize message list if p_init_msg_list is set to TRUE
1930: IF FND_API.to_Boolean(p_init_msg_list) THEN
1931: FND_MSG_PUB.initialize;

Line 1930: IF FND_API.to_Boolean(p_init_msg_list) THEN

1926: -- initialize API return status to success.
1927: x_return_status := FND_API.G_RET_STS_SUCCESS;
1928:
1929: -- Initialize message list if p_init_msg_list is set to TRUE
1930: IF FND_API.to_Boolean(p_init_msg_list) THEN
1931: FND_MSG_PUB.initialize;
1932: END IF;
1933:
1934: -- Debug info.

Line 1965: WHEN fnd_api.g_exc_error THEN

1961: END IF;
1962:
1963: EXCEPTION
1964:
1965: WHEN fnd_api.g_exc_error THEN
1966: x_return_status := fnd_api.g_ret_sts_error;
1967:
1968: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1969: p_count => x_msg_count,

Line 1966: x_return_status := fnd_api.g_ret_sts_error;

1962:
1963: EXCEPTION
1964:
1965: WHEN fnd_api.g_exc_error THEN
1966: x_return_status := fnd_api.g_ret_sts_error;
1967:
1968: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1969: p_count => x_msg_count,
1970: p_data => x_msg_data);

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

1964:
1965: WHEN fnd_api.g_exc_error THEN
1966: x_return_status := fnd_api.g_ret_sts_error;
1967:
1968: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1969: p_count => x_msg_count,
1970: p_data => x_msg_data);
1971:
1972: -- Debug info.

Line 1984: WHEN fnd_api.g_exc_unexpected_error THEN

1980: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1981: p_prefix=>l_debug_prefix,
1982: p_msg_level=>fnd_log.level_procedure);
1983: END IF;
1984: WHEN fnd_api.g_exc_unexpected_error THEN
1985: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986:
1987: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1988: p_count => x_msg_count,

Line 1985: x_return_status := fnd_api.g_ret_sts_unexp_error;

1981: p_prefix=>l_debug_prefix,
1982: p_msg_level=>fnd_log.level_procedure);
1983: END IF;
1984: WHEN fnd_api.g_exc_unexpected_error THEN
1985: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986:
1987: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1988: p_count => x_msg_count,
1989: p_data => x_msg_data);

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

1983: END IF;
1984: WHEN fnd_api.g_exc_unexpected_error THEN
1985: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986:
1987: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1988: p_count => x_msg_count,
1989: p_data => x_msg_data);
1990:
1991: -- Debug info.

Line 2004: x_return_status := fnd_api.g_ret_sts_unexp_error;

2000: p_prefix=>l_debug_prefix,
2001: p_msg_level=>fnd_log.level_procedure);
2002: END IF;
2003: WHEN OTHERS THEN
2004: x_return_status := fnd_api.g_ret_sts_unexp_error;
2005:
2006: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2007: fnd_message.set_token('ERROR' ,SQLERRM);
2008: fnd_msg_pub.add;

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

2006: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2007: fnd_message.set_token('ERROR' ,SQLERRM);
2008: fnd_msg_pub.add;
2009:
2010: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2011: p_count => x_msg_count,
2012: p_data => x_msg_data);
2013:
2014: -- Debug info.

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

2027:
2028: end;
2029:
2030: PROCEDURE get_cont_pref_objs(
2031: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2032: p_cont_level_table_id IN NUMBER,
2033: p_cont_level_table IN VARCHAR2,
2034: p_contact_type IN VARCHAR2,
2035: p_action_type IN VARCHAR2 := NULL,

Line 2081: x_return_status := FND_API.G_RET_STS_SUCCESS;

2077:
2078: begin
2079:
2080: -- initialize API return status to success.
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:
2083: -- Initialize message list if p_init_msg_list is set to TRUE
2084: IF FND_API.to_Boolean(p_init_msg_list) THEN
2085: FND_MSG_PUB.initialize;

Line 2084: IF FND_API.to_Boolean(p_init_msg_list) THEN

2080: -- initialize API return status to success.
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:
2083: -- Initialize message list if p_init_msg_list is set to TRUE
2084: IF FND_API.to_Boolean(p_init_msg_list) THEN
2085: FND_MSG_PUB.initialize;
2086: END IF;
2087:
2088: -- Debug info.

Line 2119: x_return_status := fnd_api.g_ret_sts_unexp_error;

2115:
2116: EXCEPTION
2117:
2118: WHEN OTHERS THEN
2119: x_return_status := fnd_api.g_ret_sts_unexp_error;
2120:
2121: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2122: fnd_message.set_token('ERROR' ,SQLERRM);
2123: fnd_msg_pub.add;

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

2121: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2122: fnd_message.set_token('ERROR' ,SQLERRM);
2123: fnd_msg_pub.add;
2124:
2125: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2126: p_count => x_msg_count,
2127: p_data => x_msg_data);
2128:
2129: -- Debug info.