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

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

11: */
12:
13: -- Private local procedure
14: PROCEDURE get_cust_acct_relate_objs(
15: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
16: p_cust_acct_id IN NUMBER,
17: p_action_type IN VARCHAR2 := NULL,
18: x_cust_acct_relate_objs OUT NOCOPY HZ_CUST_ACCT_RELATE_OBJ_TBL,
19: x_return_status OUT NOCOPY VARCHAR2,

Line 114: x_return_status := FND_API.G_RET_STS_SUCCESS;

110: BEGIN
111:
112:
113: -- initialize API return status to success.
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: -- Initialize message list if p_init_msg_list is set to TRUE
117: IF FND_API.to_Boolean(p_init_msg_list) THEN
118: FND_MSG_PUB.initialize;

Line 117: IF FND_API.to_Boolean(p_init_msg_list) THEN

113: -- initialize API return status to success.
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: -- Initialize message list if p_init_msg_list is set to TRUE
117: IF FND_API.to_Boolean(p_init_msg_list) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120:
121:

Line 151: WHEN fnd_api.g_exc_error THEN

147:
148:
149: EXCEPTION
150:
151: WHEN fnd_api.g_exc_error THEN
152: x_return_status := fnd_api.g_ret_sts_error;
153:
154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
155: p_count => x_msg_count,

Line 152: x_return_status := fnd_api.g_ret_sts_error;

148:
149: EXCEPTION
150:
151: WHEN fnd_api.g_exc_error THEN
152: x_return_status := fnd_api.g_ret_sts_error;
153:
154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
155: p_count => x_msg_count,
156: p_data => x_msg_data);

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

150:
151: WHEN fnd_api.g_exc_error THEN
152: x_return_status := fnd_api.g_ret_sts_error;
153:
154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
155: p_count => x_msg_count,
156: p_data => x_msg_data);
157:
158: -- Debug info.

Line 170: WHEN fnd_api.g_exc_unexpected_error THEN

166: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
167: p_prefix=>l_debug_prefix,
168: p_msg_level=>fnd_log.level_procedure);
169: END IF;
170: WHEN fnd_api.g_exc_unexpected_error THEN
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172:
173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
174: p_count => x_msg_count,

Line 171: x_return_status := fnd_api.g_ret_sts_unexp_error;

167: p_prefix=>l_debug_prefix,
168: p_msg_level=>fnd_log.level_procedure);
169: END IF;
170: WHEN fnd_api.g_exc_unexpected_error THEN
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172:
173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
174: p_count => x_msg_count,
175: p_data => x_msg_data);

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

169: END IF;
170: WHEN fnd_api.g_exc_unexpected_error THEN
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172:
173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:
177: -- Debug info.

Line 190: x_return_status := fnd_api.g_ret_sts_unexp_error;

186: p_prefix=>l_debug_prefix,
187: p_msg_level=>fnd_log.level_procedure);
188: END IF;
189: WHEN OTHERS THEN
190: x_return_status := fnd_api.g_ret_sts_unexp_error;
191:
192: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
193: fnd_message.set_token('ERROR' ,SQLERRM);
194: fnd_msg_pub.add;

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

192: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
193: fnd_message.set_token('ERROR' ,SQLERRM);
194: fnd_msg_pub.add;
195:
196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
197: p_count => x_msg_count,
198: p_data => x_msg_data);
199:
200: -- Debug info.

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

214:
215:
216: -- Private local procedure
217: PROCEDURE get_cust_profile_bo(
218: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
219: p_cust_acct_id IN NUMBER,
220: p_action_type IN VARCHAR2 := NULL,
221: x_cust_profile_obj OUT NOCOPY HZ_CUSTOMER_PROFILE_BO,
222: x_return_status OUT NOCOPY VARCHAR2,

Line 444: x_return_status := FND_API.G_RET_STS_SUCCESS;

440: BEGIN
441:
442:
443: -- initialize API return status to success.
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445:
446: -- Initialize message list if p_init_msg_list is set to TRUE
447: IF FND_API.to_Boolean(p_init_msg_list) THEN
448: FND_MSG_PUB.initialize;

Line 447: IF FND_API.to_Boolean(p_init_msg_list) THEN

443: -- initialize API return status to success.
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445:
446: -- Initialize message list if p_init_msg_list is set to TRUE
447: IF FND_API.to_Boolean(p_init_msg_list) THEN
448: FND_MSG_PUB.initialize;
449: END IF;
450:
451:

Line 481: WHEN fnd_api.g_exc_error THEN

477:
478:
479: EXCEPTION
480:
481: WHEN fnd_api.g_exc_error THEN
482: x_return_status := fnd_api.g_ret_sts_error;
483:
484: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
485: p_count => x_msg_count,

Line 482: x_return_status := fnd_api.g_ret_sts_error;

478:
479: EXCEPTION
480:
481: WHEN fnd_api.g_exc_error THEN
482: x_return_status := fnd_api.g_ret_sts_error;
483:
484: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
485: p_count => x_msg_count,
486: p_data => x_msg_data);

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

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

Line 500: WHEN fnd_api.g_exc_unexpected_error THEN

496: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
497: p_prefix=>l_debug_prefix,
498: p_msg_level=>fnd_log.level_procedure);
499: END IF;
500: WHEN fnd_api.g_exc_unexpected_error THEN
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:
503: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
504: p_count => x_msg_count,

Line 501: x_return_status := fnd_api.g_ret_sts_unexp_error;

497: p_prefix=>l_debug_prefix,
498: p_msg_level=>fnd_log.level_procedure);
499: END IF;
500: WHEN fnd_api.g_exc_unexpected_error THEN
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:
503: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
504: p_count => x_msg_count,
505: p_data => x_msg_data);

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

499: END IF;
500: WHEN fnd_api.g_exc_unexpected_error THEN
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:
503: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
504: p_count => x_msg_count,
505: p_data => x_msg_data);
506:
507: -- Debug info.

Line 520: x_return_status := fnd_api.g_ret_sts_unexp_error;

516: p_prefix=>l_debug_prefix,
517: p_msg_level=>fnd_log.level_procedure);
518: END IF;
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521:
522: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
523: fnd_message.set_token('ERROR' ,SQLERRM);
524: fnd_msg_pub.add;

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

522: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
523: fnd_message.set_token('ERROR' ,SQLERRM);
524: fnd_msg_pub.add;
525:
526: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
527: p_count => x_msg_count,
528: p_data => x_msg_data);
529:
530: -- Debug info.

Line 563: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

559: -- IN:
560: -- p_init_msg_list Initialize message stack if it is set to
561: -- p_cust_acct_id customer account ID.
562: -- p_parent_id Parent Id.
563: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
564: -- OUT:
565: -- x_cust_acct_obj Logical customer account record.
566: -- x_return_status Return status after the call. The status can
567: -- be fnd_api.g_ret_sts_success (success),

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

563: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
564: -- OUT:
565: -- x_cust_acct_obj Logical customer account record.
566: -- x_return_status Return status after the call. The status can
567: -- be fnd_api.g_ret_sts_success (success),
568: -- fnd_api.g_ret_sts_error (error),
569: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
570: -- x_msg_count Number of messages in message stack.
571: -- x_msg_data Message text if x_msg_count is 1.

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

564: -- OUT:
565: -- x_cust_acct_obj Logical customer account record.
566: -- x_return_status Return status after the call. The status can
567: -- be fnd_api.g_ret_sts_success (success),
568: -- fnd_api.g_ret_sts_error (error),
569: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
570: -- x_msg_count Number of messages in message stack.
571: -- x_msg_data Message text if x_msg_count is 1.
572: --

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

565: -- x_cust_acct_obj Logical customer account record.
566: -- x_return_status Return status after the call. The status can
567: -- be fnd_api.g_ret_sts_success (success),
568: -- fnd_api.g_ret_sts_error (error),
569: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
570: -- x_msg_count Number of messages in message stack.
571: -- x_msg_data Message text if x_msg_count is 1.
572: --
573: -- NOTES

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

607:
608:
609:
610: PROCEDURE get_cust_acct_bos(
611: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
612: p_parent_id IN NUMBER,
613: p_cust_acct_id IN NUMBER,
614: p_action_type IN VARCHAR2 := NULL,
615: x_cust_acct_objs OUT NOCOPY HZ_CUST_ACCT_BO_TBL,

Line 847: x_return_status := FND_API.G_RET_STS_SUCCESS;

843:
844: BEGIN
845:
846: -- initialize API return status to success.
847: x_return_status := FND_API.G_RET_STS_SUCCESS;
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE
850: IF FND_API.to_Boolean(p_init_msg_list) THEN
851: FND_MSG_PUB.initialize;

Line 850: IF FND_API.to_Boolean(p_init_msg_list) THEN

846: -- initialize API return status to success.
847: x_return_status := FND_API.G_RET_STS_SUCCESS;
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE
850: IF FND_API.to_Boolean(p_init_msg_list) THEN
851: FND_MSG_PUB.initialize;
852: END IF;
853:
854:

Line 869: p_init_msg_list => fnd_api.g_false,

865: close c1;
866:
867: for i in 1..x_cust_acct_objs.count loop
868: HZ_EXTRACT_ACCT_SITE_BO_PVT.get_cust_acct_site_bos(
869: p_init_msg_list => fnd_api.g_false,
870: p_parent_id => x_cust_acct_objs(i).cust_acct_id,
871: p_cust_acct_site_id => NULL,
872: p_action_type => p_action_type,
873: x_cust_acct_site_objs => x_cust_acct_objs(i).cust_acct_site_objs,

Line 878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

874: x_return_status => x_return_status,
875: x_msg_count => x_msg_count,
876: x_msg_data => x_msg_data);
877:
878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881:
882: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(

Line 879: RAISE FND_API.G_EXC_ERROR;

875: x_msg_count => x_msg_count,
876: x_msg_data => x_msg_data);
877:
878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881:
882: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(
883: p_init_msg_list => fnd_api.g_false,

Line 883: p_init_msg_list => fnd_api.g_false,

879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881:
882: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(
883: p_init_msg_list => fnd_api.g_false,
884: p_parent_id => x_cust_acct_objs(i).cust_acct_id,
885: p_cust_acct_contact_id => NULL,
886: p_action_type => p_action_type,
887: x_cust_acct_contact_objs => x_cust_acct_objs(i).cust_acct_contact_objs,

Line 892: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

888: x_return_status => x_return_status,
889: x_msg_count => x_msg_count,
890: x_msg_data => x_msg_data);
891:
892: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
893: RAISE FND_API.G_EXC_ERROR;
894: END IF;
895:
896:

Line 893: RAISE FND_API.G_EXC_ERROR;

889: x_msg_count => x_msg_count,
890: x_msg_data => x_msg_data);
891:
892: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
893: RAISE FND_API.G_EXC_ERROR;
894: END IF;
895:
896:
897: get_cust_profile_bo(

Line 898: p_init_msg_list => fnd_api.g_false,

894: END IF;
895:
896:
897: get_cust_profile_bo(
898: p_init_msg_list => fnd_api.g_false,
899: p_cust_acct_id => x_cust_acct_objs(i).cust_acct_id,
900: p_action_type => p_action_type,
901: x_cust_profile_obj => x_cust_acct_objs(i).cust_profile_obj,
902: x_return_status => x_return_status,

Line 906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

902: x_return_status => x_return_status,
903: x_msg_count => x_msg_count,
904: x_msg_data => x_msg_data);
905:
906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: get_cust_acct_relate_objs(

Line 907: RAISE FND_API.G_EXC_ERROR;

903: x_msg_count => x_msg_count,
904: x_msg_data => x_msg_data);
905:
906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: get_cust_acct_relate_objs(
911: p_init_msg_list => fnd_api.g_false,

Line 911: p_init_msg_list => fnd_api.g_false,

907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: get_cust_acct_relate_objs(
911: p_init_msg_list => fnd_api.g_false,
912: p_cust_acct_id => x_cust_acct_objs(i).cust_acct_id,
913: p_action_type => p_action_type,
914: x_cust_acct_relate_objs => x_cust_acct_objs(i).acct_relate_objs,
915: x_return_status => x_return_status,

Line 919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

915: x_return_status => x_return_status,
916: x_msg_count => x_msg_count,
917: x_msg_data => x_msg_data);
918:
919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922:
923:

Line 920: RAISE FND_API.G_EXC_ERROR;

916: x_msg_count => x_msg_count,
917: x_msg_data => x_msg_data);
918:
919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922:
923:
924: end loop;

Line 944: WHEN fnd_api.g_exc_error THEN

940:
941:
942: EXCEPTION
943:
944: WHEN fnd_api.g_exc_error THEN
945: x_return_status := fnd_api.g_ret_sts_error;
946:
947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
948: p_count => x_msg_count,

Line 945: x_return_status := fnd_api.g_ret_sts_error;

941:
942: EXCEPTION
943:
944: WHEN fnd_api.g_exc_error THEN
945: x_return_status := fnd_api.g_ret_sts_error;
946:
947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
948: p_count => x_msg_count,
949: p_data => x_msg_data);

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

943:
944: WHEN fnd_api.g_exc_error THEN
945: x_return_status := fnd_api.g_ret_sts_error;
946:
947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
948: p_count => x_msg_count,
949: p_data => x_msg_data);
950:
951: -- Debug info.

Line 963: WHEN fnd_api.g_exc_unexpected_error THEN

959: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
960: p_prefix=>l_debug_prefix,
961: p_msg_level=>fnd_log.level_procedure);
962: END IF;
963: WHEN fnd_api.g_exc_unexpected_error THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965:
966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
967: p_count => x_msg_count,

Line 964: x_return_status := fnd_api.g_ret_sts_unexp_error;

960: p_prefix=>l_debug_prefix,
961: p_msg_level=>fnd_log.level_procedure);
962: END IF;
963: WHEN fnd_api.g_exc_unexpected_error THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965:
966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
967: p_count => x_msg_count,
968: p_data => x_msg_data);

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

962: END IF;
963: WHEN fnd_api.g_exc_unexpected_error THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965:
966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
967: p_count => x_msg_count,
968: p_data => x_msg_data);
969:
970: -- Debug info.

Line 983: x_return_status := fnd_api.g_ret_sts_unexp_error;

979: p_prefix=>l_debug_prefix,
980: p_msg_level=>fnd_log.level_procedure);
981: END IF;
982: WHEN OTHERS THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984:
985: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
986: fnd_message.set_token('ERROR' ,SQLERRM);
987: fnd_msg_pub.add;

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

985: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
986: fnd_message.set_token('ERROR' ,SQLERRM);
987: fnd_msg_pub.add;
988:
989: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
990: p_count => x_msg_count,
991: p_data => x_msg_data);
992:
993: -- Debug info.

Line 1023: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

1019: -- IN:
1020: -- p_init_msg_list Initialize message stack if it is set to
1021: -- p_cust_acct_id customer account ID.
1022: -- p_parent_id Parent Id.
1023: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1024: -- OUT:
1025: -- x_cust_acct_v2_obj Logical customer account record.
1026: -- x_return_status Return status after the call. The status can
1027: -- be fnd_api.g_ret_sts_success (success),

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

1023: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1024: -- OUT:
1025: -- x_cust_acct_v2_obj Logical customer account record.
1026: -- x_return_status Return status after the call. The status can
1027: -- be fnd_api.g_ret_sts_success (success),
1028: -- fnd_api.g_ret_sts_error (error),
1029: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1030: -- x_msg_count Number of messages in message stack.
1031: -- x_msg_data Message text if x_msg_count is 1.

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

1024: -- OUT:
1025: -- x_cust_acct_v2_obj Logical customer account record.
1026: -- x_return_status Return status after the call. The status can
1027: -- be fnd_api.g_ret_sts_success (success),
1028: -- fnd_api.g_ret_sts_error (error),
1029: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1030: -- x_msg_count Number of messages in message stack.
1031: -- x_msg_data Message text if x_msg_count is 1.
1032: --

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

1025: -- x_cust_acct_v2_obj Logical customer account record.
1026: -- x_return_status Return status after the call. The status can
1027: -- be fnd_api.g_ret_sts_success (success),
1028: -- fnd_api.g_ret_sts_error (error),
1029: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1030: -- x_msg_count Number of messages in message stack.
1031: -- x_msg_data Message text if x_msg_count is 1.
1032: --
1033: -- NOTES

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

1067:
1068:
1069:
1070: PROCEDURE get_cust_acct_v2_bos(
1071: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1072: p_parent_id IN NUMBER,
1073: p_cust_acct_id IN NUMBER,
1074: p_action_type IN VARCHAR2 := NULL,
1075: x_cust_acct_v2_objs OUT NOCOPY HZ_CUST_ACCT_V2_BO_TBL,

Line 1306: x_return_status := FND_API.G_RET_STS_SUCCESS;

1302:
1303: BEGIN
1304:
1305: -- initialize API return status to success.
1306: x_return_status := FND_API.G_RET_STS_SUCCESS;
1307:
1308: -- Initialize message list if p_init_msg_list is set to TRUE
1309: IF FND_API.to_Boolean(p_init_msg_list) THEN
1310: FND_MSG_PUB.initialize;

Line 1309: IF FND_API.to_Boolean(p_init_msg_list) THEN

1305: -- initialize API return status to success.
1306: x_return_status := FND_API.G_RET_STS_SUCCESS;
1307:
1308: -- Initialize message list if p_init_msg_list is set to TRUE
1309: IF FND_API.to_Boolean(p_init_msg_list) THEN
1310: FND_MSG_PUB.initialize;
1311: END IF;
1312:
1313:

Line 1328: p_init_msg_list => fnd_api.g_false,

1324: close c1;
1325:
1326: for i in 1..x_cust_acct_v2_objs.count loop
1327: HZ_EXTRACT_ACCT_SITE_BO_PVT.get_cust_acct_site_v2_bos(
1328: p_init_msg_list => fnd_api.g_false,
1329: p_parent_id => x_cust_acct_v2_objs(i).cust_acct_id,
1330: p_cust_acct_site_id => NULL,
1331: p_action_type => p_action_type,
1332: x_cust_acct_site_v2_objs => x_cust_acct_v2_objs(i).cust_acct_site_objs,

Line 1337: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1333: x_return_status => x_return_status,
1334: x_msg_count => x_msg_count,
1335: x_msg_data => x_msg_data);
1336:
1337: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1338: RAISE FND_API.G_EXC_ERROR;
1339: END IF;
1340:
1341: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(

Line 1338: RAISE FND_API.G_EXC_ERROR;

1334: x_msg_count => x_msg_count,
1335: x_msg_data => x_msg_data);
1336:
1337: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1338: RAISE FND_API.G_EXC_ERROR;
1339: END IF;
1340:
1341: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(
1342: p_init_msg_list => fnd_api.g_false,

Line 1342: p_init_msg_list => fnd_api.g_false,

1338: RAISE FND_API.G_EXC_ERROR;
1339: END IF;
1340:
1341: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(
1342: p_init_msg_list => fnd_api.g_false,
1343: p_parent_id => x_cust_acct_v2_objs(i).cust_acct_id,
1344: p_cust_acct_contact_id => NULL,
1345: p_action_type => p_action_type,
1346: x_cust_acct_contact_objs => x_cust_acct_v2_objs(i).cust_acct_contact_objs,

Line 1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1347: x_return_status => x_return_status,
1348: x_msg_count => x_msg_count,
1349: x_msg_data => x_msg_data);
1350:
1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF;
1354:
1355:

Line 1352: RAISE FND_API.G_EXC_ERROR;

1348: x_msg_count => x_msg_count,
1349: x_msg_data => x_msg_data);
1350:
1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF;
1354:
1355:
1356: get_cust_profile_bo(

Line 1357: p_init_msg_list => fnd_api.g_false,

1353: END IF;
1354:
1355:
1356: get_cust_profile_bo(
1357: p_init_msg_list => fnd_api.g_false,
1358: p_cust_acct_id => x_cust_acct_v2_objs(i).cust_acct_id,
1359: p_action_type => p_action_type,
1360: x_cust_profile_obj => x_cust_acct_v2_objs(i).cust_profile_obj,
1361: x_return_status => x_return_status,

Line 1365: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1361: x_return_status => x_return_status,
1362: x_msg_count => x_msg_count,
1363: x_msg_data => x_msg_data);
1364:
1365: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:
1369: get_cust_acct_relate_objs(

Line 1366: RAISE FND_API.G_EXC_ERROR;

1362: x_msg_count => x_msg_count,
1363: x_msg_data => x_msg_data);
1364:
1365: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:
1369: get_cust_acct_relate_objs(
1370: p_init_msg_list => fnd_api.g_false,

Line 1370: p_init_msg_list => fnd_api.g_false,

1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:
1369: get_cust_acct_relate_objs(
1370: p_init_msg_list => fnd_api.g_false,
1371: p_cust_acct_id => x_cust_acct_v2_objs(i).cust_acct_id,
1372: p_action_type => p_action_type,
1373: x_cust_acct_relate_objs => x_cust_acct_v2_objs(i).acct_relate_objs,
1374: x_return_status => x_return_status,

Line 1378: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1374: x_return_status => x_return_status,
1375: x_msg_count => x_msg_count,
1376: x_msg_data => x_msg_data);
1377:
1378: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1379: RAISE FND_API.G_EXC_ERROR;
1380: END IF;
1381:
1382:

Line 1379: RAISE FND_API.G_EXC_ERROR;

1375: x_msg_count => x_msg_count,
1376: x_msg_data => x_msg_data);
1377:
1378: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1379: RAISE FND_API.G_EXC_ERROR;
1380: END IF;
1381:
1382:
1383: end loop;

Line 1403: WHEN fnd_api.g_exc_error THEN

1399:
1400:
1401: EXCEPTION
1402:
1403: WHEN fnd_api.g_exc_error THEN
1404: x_return_status := fnd_api.g_ret_sts_error;
1405:
1406: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1407: p_count => x_msg_count,

Line 1404: x_return_status := fnd_api.g_ret_sts_error;

1400:
1401: EXCEPTION
1402:
1403: WHEN fnd_api.g_exc_error THEN
1404: x_return_status := fnd_api.g_ret_sts_error;
1405:
1406: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data);

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

1402:
1403: WHEN fnd_api.g_exc_error THEN
1404: x_return_status := fnd_api.g_ret_sts_error;
1405:
1406: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data);
1409:
1410: -- Debug info.

Line 1422: WHEN fnd_api.g_exc_unexpected_error THEN

1418: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1419: p_prefix=>l_debug_prefix,
1420: p_msg_level=>fnd_log.level_procedure);
1421: END IF;
1422: WHEN fnd_api.g_exc_unexpected_error THEN
1423: x_return_status := fnd_api.g_ret_sts_unexp_error;
1424:
1425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1426: p_count => x_msg_count,

Line 1423: x_return_status := fnd_api.g_ret_sts_unexp_error;

1419: p_prefix=>l_debug_prefix,
1420: p_msg_level=>fnd_log.level_procedure);
1421: END IF;
1422: WHEN fnd_api.g_exc_unexpected_error THEN
1423: x_return_status := fnd_api.g_ret_sts_unexp_error;
1424:
1425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1426: p_count => x_msg_count,
1427: p_data => x_msg_data);

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

1421: END IF;
1422: WHEN fnd_api.g_exc_unexpected_error THEN
1423: x_return_status := fnd_api.g_ret_sts_unexp_error;
1424:
1425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1426: p_count => x_msg_count,
1427: p_data => x_msg_data);
1428:
1429: -- Debug info.

Line 1442: x_return_status := fnd_api.g_ret_sts_unexp_error;

1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;
1441: WHEN OTHERS THEN
1442: x_return_status := fnd_api.g_ret_sts_unexp_error;
1443:
1444: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1445: fnd_message.set_token('ERROR' ,SQLERRM);
1446: fnd_msg_pub.add;

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

1444: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1445: fnd_message.set_token('ERROR' ,SQLERRM);
1446: fnd_msg_pub.add;
1447:
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.