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

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

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

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

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

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

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

Line 596: x_return_status := FND_API.G_RET_STS_SUCCESS;

592: -- Standard start of API savepoint
593: SAVEPOINT create_cp_pvt;
594:
595: -- initialize API return status to success.
596: x_return_status := FND_API.G_RET_STS_SUCCESS;
597:
598: -- Debug info.
599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug(p_message=>'create_cust_profile(+)',

Line 615: p_create_profile_amt => FND_API.G_FALSE,

611: );
612:
613: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
614: p_customer_profile_rec => l_cp_rec,
615: p_create_profile_amt => FND_API.G_FALSE,
616: x_cust_account_profile_id => x_cp_id,
617: x_return_status => x_return_status,
618: x_msg_count => x_msg_count,
619: x_msg_data => x_msg_data

Line 622: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

618: x_msg_count => x_msg_count,
619: x_msg_data => x_msg_data
620: );
621:
622: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_profile, cust account id: '||p_ca_id||' cust site use id: '||p_casu_id,
625: p_prefix=>l_debug_prefix,
626: p_msg_level=>fnd_log.level_procedure);

Line 628: RAISE fnd_api.g_exc_error;

624: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_profile, cust account id: '||p_ca_id||' cust site use id: '||p_casu_id,
625: p_prefix=>l_debug_prefix,
626: p_msg_level=>fnd_log.level_procedure);
627: END IF;
628: RAISE fnd_api.g_exc_error;
629: END IF;
630:
631: -- assign profile_id
632: p_cp_obj.cust_acct_profile_id := x_cp_id;

Line 647: WHEN fnd_api.g_exc_error THEN

643: p_prefix=>l_debug_prefix,
644: p_msg_level=>fnd_log.level_procedure);
645: END IF;
646: EXCEPTION
647: WHEN fnd_api.g_exc_error THEN
648: ROLLBACK TO create_cp_pvt;
649: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
650: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
651: FND_MSG_PUB.ADD;

Line 653: x_return_status := fnd_api.g_ret_sts_error;

649: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
650: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
651: FND_MSG_PUB.ADD;
652:
653: x_return_status := fnd_api.g_ret_sts_error;
654:
655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
656: p_count => x_msg_count,
657: p_data => x_msg_data);

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

651: FND_MSG_PUB.ADD;
652:
653: x_return_status := fnd_api.g_ret_sts_error;
654:
655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
656: p_count => x_msg_count,
657: p_data => x_msg_data);
658:
659: -- Debug info.

Line 672: WHEN fnd_api.g_exc_unexpected_error THEN

668: p_prefix=>l_debug_prefix,
669: p_msg_level=>fnd_log.level_procedure);
670: END IF;
671:
672: WHEN fnd_api.g_exc_unexpected_error THEN
673: ROLLBACK TO create_cp_pvt;
674: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
675: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
676: FND_MSG_PUB.ADD;

Line 678: x_return_status := fnd_api.g_ret_sts_unexp_error;

674: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
675: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
676: FND_MSG_PUB.ADD;
677:
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679:
680: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
681: p_count => x_msg_count,
682: p_data => x_msg_data);

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

676: FND_MSG_PUB.ADD;
677:
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679:
680: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
681: p_count => x_msg_count,
682: p_data => x_msg_data);
683:
684: -- Debug info.

Line 703: x_return_status := fnd_api.g_ret_sts_unexp_error;

699: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
700: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
701: FND_MSG_PUB.ADD;
702:
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704:
705: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
706: fnd_message.set_token('ERROR' ,SQLERRM);
707: fnd_msg_pub.add;

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

705: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
706: fnd_message.set_token('ERROR' ,SQLERRM);
707: fnd_msg_pub.add;
708:
709: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
710: p_count => x_msg_count,
711: p_data => x_msg_data);
712:
713: -- Debug info.

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

738: -- p_casu_id Customer account site use Id.
739: -- OUT:
740: -- x_cp_id Customer profile Id.
741: -- x_return_status Return status after the call. The status can
742: -- be fnd_api.g_ret_sts_success (success),
743: -- fnd_api.g_ret_sts_error (error),
744: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
745: -- x_msg_count Number of messages in message stack.
746: -- x_msg_data Message text if x_msg_count is 1.

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

739: -- OUT:
740: -- x_cp_id Customer profile Id.
741: -- x_return_status Return status after the call. The status can
742: -- be fnd_api.g_ret_sts_success (success),
743: -- fnd_api.g_ret_sts_error (error),
744: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
745: -- x_msg_count Number of messages in message stack.
746: -- x_msg_data Message text if x_msg_count is 1.
747: --

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

740: -- x_cp_id Customer profile Id.
741: -- x_return_status Return status after the call. The status can
742: -- be fnd_api.g_ret_sts_success (success),
743: -- fnd_api.g_ret_sts_error (error),
744: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
745: -- x_msg_count Number of messages in message stack.
746: -- x_msg_data Message text if x_msg_count is 1.
747: --
748: -- NOTES

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

780: -- Standard start of API savepoint
781: SAVEPOINT update_cp_pvt;
782:
783: -- initialize API return status to success.
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: -- Debug info.
787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
788: hz_utility_v2pub.debug(p_message=>'update_cust_profile(+)',

Line 803: RAISE fnd_api.g_exc_error;

799: IF(nvl(l_ca_id, -99) <> nvl(p_ca_id, -99)) THEN
800: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
801: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id');
802: FND_MSG_PUB.ADD();
803: RAISE fnd_api.g_exc_error;
804: END IF;
805: IF(nvl(l_casu_id, -99) <> nvl(p_casu_id, -99)) THEN
806: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
807: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id');

Line 809: RAISE fnd_api.g_exc_error;

805: IF(nvl(l_casu_id, -99) <> nvl(p_casu_id, -99)) THEN
806: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
807: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id');
808: FND_MSG_PUB.ADD();
809: RAISE fnd_api.g_exc_error;
810: END IF;
811: ELSE
812: OPEN get_ovn(p_ca_id, p_casu_id);
813: FETCH get_ovn INTO x_cp_id, l_cp_ovn;

Line 836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

832: x_msg_count => x_msg_count,
833: x_msg_data => x_msg_data
834: );
835:
836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.update_cust_profile, cust account id: '||p_ca_id||' cust site use id: '||p_casu_id,
839: p_prefix=>l_debug_prefix,
840: p_msg_level=>fnd_log.level_procedure);

Line 842: RAISE fnd_api.g_exc_error;

838: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.update_cust_profile, cust account id: '||p_ca_id||' cust site use id: '||p_casu_id,
839: p_prefix=>l_debug_prefix,
840: p_msg_level=>fnd_log.level_procedure);
841: END IF;
842: RAISE fnd_api.g_exc_error;
843: END IF;
844:
845: -- assign profile_id
846: p_cp_obj.cust_acct_profile_id := x_cp_id;

Line 861: WHEN fnd_api.g_exc_error THEN

857: p_prefix=>l_debug_prefix,
858: p_msg_level=>fnd_log.level_procedure);
859: END IF;
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: ROLLBACK TO update_cp_pvt;
863: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
864: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
865: FND_MSG_PUB.ADD;

Line 867: x_return_status := fnd_api.g_ret_sts_error;

863: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
864: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
865: FND_MSG_PUB.ADD;
866:
867: x_return_status := fnd_api.g_ret_sts_error;
868:
869: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
870: p_count => x_msg_count,
871: p_data => x_msg_data);

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

865: FND_MSG_PUB.ADD;
866:
867: x_return_status := fnd_api.g_ret_sts_error;
868:
869: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
870: p_count => x_msg_count,
871: p_data => x_msg_data);
872:
873: -- Debug info.

Line 886: WHEN fnd_api.g_exc_unexpected_error THEN

882: p_prefix=>l_debug_prefix,
883: p_msg_level=>fnd_log.level_procedure);
884: END IF;
885:
886: WHEN fnd_api.g_exc_unexpected_error THEN
887: ROLLBACK TO update_cp_pvt;
888: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
889: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
890: FND_MSG_PUB.ADD;

Line 892: x_return_status := fnd_api.g_ret_sts_unexp_error;

888: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
889: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
890: FND_MSG_PUB.ADD;
891:
892: x_return_status := fnd_api.g_ret_sts_unexp_error;
893:
894: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
895: p_count => x_msg_count,
896: p_data => x_msg_data);

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

890: FND_MSG_PUB.ADD;
891:
892: x_return_status := fnd_api.g_ret_sts_unexp_error;
893:
894: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
895: p_count => x_msg_count,
896: p_data => x_msg_data);
897:
898: -- Debug info.

Line 917: x_return_status := fnd_api.g_ret_sts_unexp_error;

913: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
914: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
915: FND_MSG_PUB.ADD;
916:
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918:
919: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
920: fnd_message.set_token('ERROR' ,SQLERRM);
921: fnd_msg_pub.add;

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

919: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
920: fnd_message.set_token('ERROR' ,SQLERRM);
921: fnd_msg_pub.add;
922:
923: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
924: p_count => x_msg_count,
925: p_data => x_msg_data);
926:
927: -- Debug info.

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

952: -- p_ca_id Customer account Id.
953: -- p_casu_id Customer account site use Id.
954: -- OUT:
955: -- x_return_status Return status after the call. The status can
956: -- be fnd_api.g_ret_sts_success (success),
957: -- fnd_api.g_ret_sts_error (error),
958: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
959: -- x_msg_count Number of messages in message stack.
960: -- x_msg_data Message text if x_msg_count is 1.

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

953: -- p_casu_id Customer account site use Id.
954: -- OUT:
955: -- x_return_status Return status after the call. The status can
956: -- be fnd_api.g_ret_sts_success (success),
957: -- fnd_api.g_ret_sts_error (error),
958: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
959: -- x_msg_count Number of messages in message stack.
960: -- x_msg_data Message text if x_msg_count is 1.
961: --

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

954: -- OUT:
955: -- x_return_status Return status after the call. The status can
956: -- be fnd_api.g_ret_sts_success (success),
957: -- fnd_api.g_ret_sts_error (error),
958: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
959: -- x_msg_count Number of messages in message stack.
960: -- x_msg_data Message text if x_msg_count is 1.
961: --
962: -- NOTES

Line 985: x_return_status := FND_API.G_RET_STS_SUCCESS;

981: -- Standard start of API savepoint
982: SAVEPOINT create_cpa_pvt;
983:
984: -- initialize API return status to success.
985: x_return_status := FND_API.G_RET_STS_SUCCESS;
986:
987: -- Debug info.
988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
989: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(+)',

Line 1004: p_check_foreign_key => FND_API.G_FALSE,

1000: px_cust_profile_amt_rec => l_cpa_rec
1001: );
1002:
1003: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (
1004: p_check_foreign_key => FND_API.G_FALSE,
1005: p_cust_profile_amt_rec => l_cpa_rec,
1006: x_cust_acct_profile_amt_id => l_cpa_id,
1007: x_return_status => x_return_status,
1008: x_msg_count => x_msg_count,

Line 1012: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1008: x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data
1010: );
1011:
1012: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1013: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1014: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_profile_amts, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1015: p_prefix=>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_procedure);

Line 1018: RAISE FND_API.G_EXC_ERROR;

1014: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_profile_amts, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1015: p_prefix=>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_procedure);
1017: END IF;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1021: -- assign profile amount id
1022: p_cpa_objs(i).cust_acct_profile_amt_id := l_cpa_id;

Line 1039: WHEN fnd_api.g_exc_error THEN

1035: p_msg_level=>fnd_log.level_procedure);
1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN fnd_api.g_exc_error THEN
1040: ROLLBACK TO create_cpa_pvt;
1041: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1042: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1043: FND_MSG_PUB.ADD;

Line 1045: x_return_status := fnd_api.g_ret_sts_error;

1041: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1042: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1043: FND_MSG_PUB.ADD;
1044:
1045: x_return_status := fnd_api.g_ret_sts_error;
1046:
1047: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1048: p_count => x_msg_count,
1049: p_data => x_msg_data);

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

1043: FND_MSG_PUB.ADD;
1044:
1045: x_return_status := fnd_api.g_ret_sts_error;
1046:
1047: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1048: p_count => x_msg_count,
1049: p_data => x_msg_data);
1050:
1051: -- Debug info.

Line 1064: WHEN fnd_api.g_exc_unexpected_error THEN

1060: p_prefix=>l_debug_prefix,
1061: p_msg_level=>fnd_log.level_procedure);
1062: END IF;
1063:
1064: WHEN fnd_api.g_exc_unexpected_error THEN
1065: ROLLBACK TO create_cpa_pvt;
1066: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1067: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1068: FND_MSG_PUB.ADD;

Line 1070: x_return_status := fnd_api.g_ret_sts_unexp_error;

1066: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1067: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1068: FND_MSG_PUB.ADD;
1069:
1070: x_return_status := fnd_api.g_ret_sts_unexp_error;
1071:
1072: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1073: p_count => x_msg_count,
1074: p_data => x_msg_data);

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

1068: FND_MSG_PUB.ADD;
1069:
1070: x_return_status := fnd_api.g_ret_sts_unexp_error;
1071:
1072: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1073: p_count => x_msg_count,
1074: p_data => x_msg_data);
1075:
1076: -- Debug info.

Line 1095: x_return_status := fnd_api.g_ret_sts_unexp_error;

1091: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1092: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1093: FND_MSG_PUB.ADD;
1094:
1095: x_return_status := fnd_api.g_ret_sts_unexp_error;
1096:
1097: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1098: fnd_message.set_token('ERROR' ,SQLERRM);
1099: fnd_msg_pub.add;

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

1097: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1098: fnd_message.set_token('ERROR' ,SQLERRM);
1099: fnd_msg_pub.add;
1100:
1101: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1102: p_count => x_msg_count,
1103: p_data => x_msg_data);
1104:
1105: -- Debug info.

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

1130: -- p_ca_id Customer account Id.
1131: -- p_casu_id Customer account site use Id.
1132: -- OUT:
1133: -- x_return_status Return status after the call. The status can
1134: -- be fnd_api.g_ret_sts_success (success),
1135: -- fnd_api.g_ret_sts_error (error),
1136: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1137: -- x_msg_count Number of messages in message stack.
1138: -- x_msg_data Message text if x_msg_count is 1.

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

1131: -- p_casu_id Customer account site use Id.
1132: -- OUT:
1133: -- x_return_status Return status after the call. The status can
1134: -- be fnd_api.g_ret_sts_success (success),
1135: -- fnd_api.g_ret_sts_error (error),
1136: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1137: -- x_msg_count Number of messages in message stack.
1138: -- x_msg_data Message text if x_msg_count is 1.
1139: --

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

1132: -- OUT:
1133: -- x_return_status Return status after the call. The status can
1134: -- be fnd_api.g_ret_sts_success (success),
1135: -- fnd_api.g_ret_sts_error (error),
1136: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1137: -- x_msg_count Number of messages in message stack.
1138: -- x_msg_data Message text if x_msg_count is 1.
1139: --
1140: -- NOTES

Line 1164: x_return_status := FND_API.G_RET_STS_SUCCESS;

1160: -- Standard start of API savepoint
1161: SAVEPOINT save_cpa_pvt;
1162:
1163: -- initialize API return status to success.
1164: x_return_status := FND_API.G_RET_STS_SUCCESS;
1165:
1166: -- Debug info.
1167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1168: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(+)',

Line 1202: RAISE FND_API.G_EXC_ERROR;

1198: FND_MSG_PUB.ADD;
1199: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1200: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1201: FND_MSG_PUB.ADD;
1202: RAISE FND_API.G_EXC_ERROR;
1203: END IF;
1204:
1205: IF(l_cpa_ovn IS NULL) THEN
1206: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt(

Line 1207: p_check_foreign_key => FND_API.G_FALSE,

1203: END IF;
1204:
1205: IF(l_cpa_ovn IS NULL) THEN
1206: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt(
1207: p_check_foreign_key => FND_API.G_FALSE,
1208: p_cust_profile_amt_rec => l_cpa_rec,
1209: x_cust_acct_profile_amt_id => l_cpa_id,
1210: x_return_status => x_return_status,
1211: x_msg_count => x_msg_count,

Line 1232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1228: -- assign profile amount id
1229: p_cpa_objs(i).cust_acct_profile_amt_id := l_cpa_rec.cust_acct_profile_amt_id;
1230: END IF;
1231:
1232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_profile_amts, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);

Line 1238: RAISE FND_API.G_EXC_ERROR;

1234: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_profile_amts, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;
1238: RAISE FND_API.G_EXC_ERROR;
1239: END IF;
1240: END LOOP;
1241:
1242: -- Debug info.

Line 1255: WHEN fnd_api.g_exc_error THEN

1251: p_prefix=>l_debug_prefix,
1252: p_msg_level=>fnd_log.level_procedure);
1253: END IF;
1254: EXCEPTION
1255: WHEN fnd_api.g_exc_error THEN
1256: ROLLBACK TO save_cpa_pvt;
1257: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1258: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1259: FND_MSG_PUB.ADD;

Line 1261: x_return_status := fnd_api.g_ret_sts_error;

1257: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1258: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1259: FND_MSG_PUB.ADD;
1260:
1261: x_return_status := fnd_api.g_ret_sts_error;
1262:
1263: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1264: p_count => x_msg_count,
1265: p_data => x_msg_data);

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

1259: FND_MSG_PUB.ADD;
1260:
1261: x_return_status := fnd_api.g_ret_sts_error;
1262:
1263: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1264: p_count => x_msg_count,
1265: p_data => x_msg_data);
1266:
1267: -- Debug info.

Line 1280: WHEN fnd_api.g_exc_unexpected_error THEN

1276: p_prefix=>l_debug_prefix,
1277: p_msg_level=>fnd_log.level_procedure);
1278: END IF;
1279:
1280: WHEN fnd_api.g_exc_unexpected_error THEN
1281: ROLLBACK TO save_cpa_pvt;
1282: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1283: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1284: FND_MSG_PUB.ADD;

Line 1286: x_return_status := fnd_api.g_ret_sts_unexp_error;

1282: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1283: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1284: FND_MSG_PUB.ADD;
1285:
1286: x_return_status := fnd_api.g_ret_sts_unexp_error;
1287:
1288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1289: p_count => x_msg_count,
1290: p_data => x_msg_data);

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

1284: FND_MSG_PUB.ADD;
1285:
1286: x_return_status := fnd_api.g_ret_sts_unexp_error;
1287:
1288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1289: p_count => x_msg_count,
1290: p_data => x_msg_data);
1291:
1292: -- Debug info.

Line 1311: x_return_status := fnd_api.g_ret_sts_unexp_error;

1307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1308: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_PROFILE_AMTS');
1309: FND_MSG_PUB.ADD;
1310:
1311: x_return_status := fnd_api.g_ret_sts_unexp_error;
1312:
1313: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1314: fnd_message.set_token('ERROR' ,SQLERRM);
1315: fnd_msg_pub.add;

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

1313: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1314: fnd_message.set_token('ERROR' ,SQLERRM);
1315: fnd_msg_pub.add;
1316:
1317: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1318: p_count => x_msg_count,
1319: p_data => x_msg_data);
1320:
1321: -- Debug info.

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

1344: -- p_car_objs List of customer account relationship objects.
1345: -- p_ca_id Customer account Id.
1346: -- OUT:
1347: -- x_return_status Return status after the call. The status can
1348: -- be fnd_api.g_ret_sts_success (success),
1349: -- fnd_api.g_ret_sts_error (error),
1350: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1351: -- x_msg_count Number of messages in message stack.
1352: -- x_msg_data Message text if x_msg_count is 1.

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

1345: -- p_ca_id Customer account Id.
1346: -- OUT:
1347: -- x_return_status Return status after the call. The status can
1348: -- be fnd_api.g_ret_sts_success (success),
1349: -- fnd_api.g_ret_sts_error (error),
1350: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1351: -- x_msg_count Number of messages in message stack.
1352: -- x_msg_data Message text if x_msg_count is 1.
1353: --

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

1346: -- OUT:
1347: -- x_return_status Return status after the call. The status can
1348: -- be fnd_api.g_ret_sts_success (success),
1349: -- fnd_api.g_ret_sts_error (error),
1350: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1351: -- x_msg_count Number of messages in message stack.
1352: -- x_msg_data Message text if x_msg_count is 1.
1353: --
1354: -- NOTES

Line 1377: x_return_status := FND_API.G_RET_STS_SUCCESS;

1373: -- Standard start of API savepoint
1374: SAVEPOINT create_car_pvt;
1375:
1376: -- initialize API return status to success.
1377: x_return_status := FND_API.G_RET_STS_SUCCESS;
1378:
1379: -- Debug info.
1380: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1381: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(+)',

Line 1406: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1402: x_msg_count => x_msg_count,
1403: x_msg_data => x_msg_data);
1404:
1405: -- proceed if cust_account_id and os+osr are valid
1406: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1407: assign_cust_acct_relate_rec(
1408: p_cust_acct_relate_obj => p_car_objs(i),
1409: p_cust_acct_id => p_ca_id,
1410: p_related_cust_acct_id => l_rca_id,

Line 1421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1417: x_msg_count => x_msg_count,
1418: x_msg_data => x_msg_data
1419: );
1420:
1421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1422: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1423: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1424: p_prefix=>l_debug_prefix,
1425: p_msg_level=>fnd_log.level_procedure);

Line 1427: RAISE FND_API.G_EXC_ERROR;

1423: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1424: p_prefix=>l_debug_prefix,
1425: p_msg_level=>fnd_log.level_procedure);
1426: END IF;
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429: ELSE
1430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,

Line 1435: RAISE FND_API.G_EXC_ERROR;

1431: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1432: p_prefix=>l_debug_prefix,
1433: p_msg_level=>fnd_log.level_procedure);
1434: END IF;
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: END LOOP;
1438:
1439: -- Debug info.

Line 1452: WHEN fnd_api.g_exc_error THEN

1448: p_prefix=>l_debug_prefix,
1449: p_msg_level=>fnd_log.level_procedure);
1450: END IF;
1451: EXCEPTION
1452: WHEN fnd_api.g_exc_error THEN
1453: ROLLBACK TO create_car_pvt;
1454: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1455: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1456: FND_MSG_PUB.ADD;

Line 1458: x_return_status := fnd_api.g_ret_sts_error;

1454: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1455: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1456: FND_MSG_PUB.ADD;
1457:
1458: x_return_status := fnd_api.g_ret_sts_error;
1459:
1460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1461: p_count => x_msg_count,
1462: p_data => x_msg_data);

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

1456: FND_MSG_PUB.ADD;
1457:
1458: x_return_status := fnd_api.g_ret_sts_error;
1459:
1460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1461: p_count => x_msg_count,
1462: p_data => x_msg_data);
1463:
1464: -- Debug info.

Line 1477: WHEN fnd_api.g_exc_unexpected_error THEN

1473: p_prefix=>l_debug_prefix,
1474: p_msg_level=>fnd_log.level_procedure);
1475: END IF;
1476:
1477: WHEN fnd_api.g_exc_unexpected_error THEN
1478: ROLLBACK TO create_car_pvt;
1479: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1480: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1481: FND_MSG_PUB.ADD;

Line 1483: x_return_status := fnd_api.g_ret_sts_unexp_error;

1479: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1480: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1481: FND_MSG_PUB.ADD;
1482:
1483: x_return_status := fnd_api.g_ret_sts_unexp_error;
1484:
1485: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1486: p_count => x_msg_count,
1487: p_data => x_msg_data);

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

1481: FND_MSG_PUB.ADD;
1482:
1483: x_return_status := fnd_api.g_ret_sts_unexp_error;
1484:
1485: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1486: p_count => x_msg_count,
1487: p_data => x_msg_data);
1488:
1489: -- Debug info.

Line 1508: x_return_status := fnd_api.g_ret_sts_unexp_error;

1504: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1505: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1506: FND_MSG_PUB.ADD;
1507:
1508: x_return_status := fnd_api.g_ret_sts_unexp_error;
1509:
1510: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1511: fnd_message.set_token('ERROR' ,SQLERRM);
1512: fnd_msg_pub.add;

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

1510: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1511: fnd_message.set_token('ERROR' ,SQLERRM);
1512: fnd_msg_pub.add;
1513:
1514: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);
1517:
1518: -- Debug info.

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

1541: -- p_car_objs List of customer account relationship objects.
1542: -- p_ca_id Customer account Id.
1543: -- OUT:
1544: -- x_return_status Return status after the call. The status can
1545: -- be fnd_api.g_ret_sts_success (success),
1546: -- fnd_api.g_ret_sts_error (error),
1547: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1548: -- x_msg_count Number of messages in message stack.
1549: -- x_msg_data Message text if x_msg_count is 1.

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

1542: -- p_ca_id Customer account Id.
1543: -- OUT:
1544: -- x_return_status Return status after the call. The status can
1545: -- be fnd_api.g_ret_sts_success (success),
1546: -- fnd_api.g_ret_sts_error (error),
1547: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1548: -- x_msg_count Number of messages in message stack.
1549: -- x_msg_data Message text if x_msg_count is 1.
1550: --

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

1543: -- OUT:
1544: -- x_return_status Return status after the call. The status can
1545: -- be fnd_api.g_ret_sts_success (success),
1546: -- fnd_api.g_ret_sts_error (error),
1547: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1548: -- x_msg_count Number of messages in message stack.
1549: -- x_msg_data Message text if x_msg_count is 1.
1550: --
1551: -- NOTES

Line 1575: x_return_status := FND_API.G_RET_STS_SUCCESS;

1571: -- Standard start of API savepoint
1572: SAVEPOINT save_car_pvt;
1573:
1574: -- initialize API return status to success.
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;
1576:
1577: -- Debug info.
1578: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1579: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(+)',

Line 1604: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1600: x_msg_count => x_msg_count,
1601: x_msg_data => x_msg_data);
1602:
1603: -- proceed if cust_account_id and os+osr are valid
1604: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1605: assign_cust_acct_relate_rec(
1606: p_cust_acct_relate_obj => p_car_objs(i),
1607: p_cust_acct_id => p_ca_id,
1608: p_related_cust_acct_id => l_rca_id,

Line 1638: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1634: x_msg_data => x_msg_data
1635: );
1636: END IF;
1637:
1638: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1640: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1641: p_prefix=>l_debug_prefix,
1642: p_msg_level=>fnd_log.level_procedure);

Line 1644: RAISE FND_API.G_EXC_ERROR;

1640: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1641: p_prefix=>l_debug_prefix,
1642: p_msg_level=>fnd_log.level_procedure);
1643: END IF;
1644: RAISE FND_API.G_EXC_ERROR;
1645: END IF;
1646: ELSE
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,

Line 1652: RAISE FND_API.G_EXC_ERROR;

1648: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;
1654: END LOOP;
1655:
1656: -- Debug info.

Line 1669: WHEN fnd_api.g_exc_error THEN

1665: p_prefix=>l_debug_prefix,
1666: p_msg_level=>fnd_log.level_procedure);
1667: END IF;
1668: EXCEPTION
1669: WHEN fnd_api.g_exc_error THEN
1670: ROLLBACK TO save_car_pvt;
1671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1672: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1673: FND_MSG_PUB.ADD;

Line 1675: x_return_status := fnd_api.g_ret_sts_error;

1671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1672: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1673: FND_MSG_PUB.ADD;
1674:
1675: x_return_status := fnd_api.g_ret_sts_error;
1676:
1677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data);

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

1673: FND_MSG_PUB.ADD;
1674:
1675: x_return_status := fnd_api.g_ret_sts_error;
1676:
1677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data);
1680:
1681: -- Debug info.

Line 1694: WHEN fnd_api.g_exc_unexpected_error THEN

1690: p_prefix=>l_debug_prefix,
1691: p_msg_level=>fnd_log.level_procedure);
1692: END IF;
1693:
1694: WHEN fnd_api.g_exc_unexpected_error THEN
1695: ROLLBACK TO save_car_pvt;
1696: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1697: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1698: FND_MSG_PUB.ADD;

Line 1700: x_return_status := fnd_api.g_ret_sts_unexp_error;

1696: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1697: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1698: FND_MSG_PUB.ADD;
1699:
1700: x_return_status := fnd_api.g_ret_sts_unexp_error;
1701:
1702: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1703: p_count => x_msg_count,
1704: p_data => x_msg_data);

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

1698: FND_MSG_PUB.ADD;
1699:
1700: x_return_status := fnd_api.g_ret_sts_unexp_error;
1701:
1702: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1703: p_count => x_msg_count,
1704: p_data => x_msg_data);
1705:
1706: -- Debug info.

Line 1725: x_return_status := fnd_api.g_ret_sts_unexp_error;

1721: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1722: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CUST_ACCT_RELATE_ALL');
1723: FND_MSG_PUB.ADD;
1724:
1725: x_return_status := fnd_api.g_ret_sts_unexp_error;
1726:
1727: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1728: fnd_message.set_token('ERROR' ,SQLERRM);
1729: fnd_msg_pub.add;

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

1727: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1728: fnd_message.set_token('ERROR' ,SQLERRM);
1729: fnd_msg_pub.add;
1730:
1731: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1732: p_count => x_msg_count,
1733: p_data => x_msg_data);
1734:
1735: -- Debug info.

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

1760: -- p_ca_id Customer account Id.
1761: -- p_casu_id Customer account site use Id.
1762: -- OUT:
1763: -- x_return_status Return status after the call. The status can
1764: -- be fnd_api.g_ret_sts_success (success),
1765: -- fnd_api.g_ret_sts_error (error),
1766: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1767: -- x_msg_count Number of messages in message stack.
1768: -- x_msg_data Message text if x_msg_count is 1.

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

1761: -- p_casu_id Customer account site use Id.
1762: -- OUT:
1763: -- x_return_status Return status after the call. The status can
1764: -- be fnd_api.g_ret_sts_success (success),
1765: -- fnd_api.g_ret_sts_error (error),
1766: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1767: -- x_msg_count Number of messages in message stack.
1768: -- x_msg_data Message text if x_msg_count is 1.
1769: --

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

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

Line 1795: x_return_status := FND_API.G_RET_STS_SUCCESS;

1791: -- Standard start of API savepoint
1792: SAVEPOINT save_bau_pvt;
1793:
1794: -- initialize API return status to success.
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: -- Debug info.
1798: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1799: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(+)',

Line 1816: p_commit => FND_API.G_FALSE,

1812: );
1813:
1814: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
1815: p_api_version => 1.0,
1816: p_commit => FND_API.G_FALSE,
1817: x_return_status => x_return_status,
1818: x_msg_count => x_msg_count,
1819: x_msg_data => x_msg_data,
1820: p_payer => l_payer_context_rec,

Line 1829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1825:
1826: -- assign bank_acct_use_id
1827: p_bank_acct_use_objs(i).bank_acct_use_id := l_assign_id;
1828:
1829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1831: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_bank_acct_uses, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
1832: p_prefix=>l_debug_prefix,
1833: p_msg_level=>fnd_log.level_procedure);

Line 1835: RAISE FND_API.G_EXC_ERROR;

1831: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_bank_acct_uses, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
1832: p_prefix=>l_debug_prefix,
1833: p_msg_level=>fnd_log.level_procedure);
1834: END IF;
1835: RAISE FND_API.G_EXC_ERROR;
1836: END IF;
1837: END LOOP;
1838:
1839: -- Debug info.

Line 1852: WHEN fnd_api.g_exc_error THEN

1848: p_prefix=>l_debug_prefix,
1849: p_msg_level=>fnd_log.level_procedure);
1850: END IF;
1851: EXCEPTION
1852: WHEN fnd_api.g_exc_error THEN
1853: ROLLBACK TO save_bau_pvt;
1854: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1855: FND_MESSAGE.SET_TOKEN('ENTITY', 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V');
1856: FND_MSG_PUB.ADD;

Line 1858: x_return_status := fnd_api.g_ret_sts_error;

1854: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1855: FND_MESSAGE.SET_TOKEN('ENTITY', 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V');
1856: FND_MSG_PUB.ADD;
1857:
1858: x_return_status := fnd_api.g_ret_sts_error;
1859:
1860: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1861: p_count => x_msg_count,
1862: p_data => x_msg_data);

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

1856: FND_MSG_PUB.ADD;
1857:
1858: x_return_status := fnd_api.g_ret_sts_error;
1859:
1860: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1861: p_count => x_msg_count,
1862: p_data => x_msg_data);
1863:
1864: -- Debug info.

Line 1877: WHEN fnd_api.g_exc_unexpected_error THEN

1873: p_prefix=>l_debug_prefix,
1874: p_msg_level=>fnd_log.level_procedure);
1875: END IF;
1876:
1877: WHEN fnd_api.g_exc_unexpected_error THEN
1878: ROLLBACK TO save_bau_pvt;
1879: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1880: FND_MESSAGE.SET_TOKEN('ENTITY', 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V');
1881: FND_MSG_PUB.ADD;

Line 1883: x_return_status := fnd_api.g_ret_sts_unexp_error;

1879: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1880: FND_MESSAGE.SET_TOKEN('ENTITY', 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V');
1881: FND_MSG_PUB.ADD;
1882:
1883: x_return_status := fnd_api.g_ret_sts_unexp_error;
1884:
1885: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1886: p_count => x_msg_count,
1887: p_data => x_msg_data);

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

1881: FND_MSG_PUB.ADD;
1882:
1883: x_return_status := fnd_api.g_ret_sts_unexp_error;
1884:
1885: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1886: p_count => x_msg_count,
1887: p_data => x_msg_data);
1888:
1889: -- Debug info.

Line 1908: x_return_status := fnd_api.g_ret_sts_unexp_error;

1904: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1905: FND_MESSAGE.SET_TOKEN('ENTITY', 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V');
1906: FND_MSG_PUB.ADD;
1907:
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909:
1910: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1911: fnd_message.set_token('ERROR' ,SQLERRM);
1912: fnd_msg_pub.add;

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

1910: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1911: fnd_message.set_token('ERROR' ,SQLERRM);
1912: fnd_msg_pub.add;
1913:
1914: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1915: p_count => x_msg_count,
1916: p_data => x_msg_data);
1917:
1918: -- Debug info.

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

1942: -- p_ca_id Customer account Id.
1943: -- p_casu_id Customer account site use Id.
1944: -- OUT:
1945: -- x_return_status Return status after the call. The status can
1946: -- be fnd_api.g_ret_sts_success (success),
1947: -- fnd_api.g_ret_sts_error (error),
1948: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1949: -- x_msg_count Number of messages in message stack.
1950: -- x_msg_data Message text if x_msg_count is 1.

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

1943: -- p_casu_id Customer account site use Id.
1944: -- OUT:
1945: -- x_return_status Return status after the call. The status can
1946: -- be fnd_api.g_ret_sts_success (success),
1947: -- fnd_api.g_ret_sts_error (error),
1948: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1949: -- x_msg_count Number of messages in message stack.
1950: -- x_msg_data Message text if x_msg_count is 1.
1951: --

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

1944: -- OUT:
1945: -- x_return_status Return status after the call. The status can
1946: -- be fnd_api.g_ret_sts_success (success),
1947: -- fnd_api.g_ret_sts_error (error),
1948: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1949: -- x_msg_count Number of messages in message stack.
1950: -- x_msg_data Message text if x_msg_count is 1.
1951: --
1952: -- NOTES

Line 1974: x_return_status := FND_API.G_RET_STS_SUCCESS;

1970: -- Standard start of API savepoint
1971: SAVEPOINT create_pm_pvt;
1972:
1973: -- initialize API return status to success.
1974: x_return_status := FND_API.G_RET_STS_SUCCESS;
1975:
1976: -- Debug info.
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',

Line 1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1994: x_msg_count => x_msg_count,
1995: x_msg_data => x_msg_data
1996: );
1997:
1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2000: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_payment_method, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
2001: p_prefix=>l_debug_prefix,
2002: p_msg_level=>fnd_log.level_procedure);

Line 2004: RAISE FND_API.G_EXC_ERROR;

2000: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_payment_method, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
2001: p_prefix=>l_debug_prefix,
2002: p_msg_level=>fnd_log.level_procedure);
2003: END IF;
2004: RAISE FND_API.G_EXC_ERROR;
2005: END IF;
2006:
2007: -- assign payment_method_id
2008: p_payment_method_obj.payment_method_id := l_pm_id;

Line 2023: WHEN fnd_api.g_exc_error THEN

2019: p_prefix=>l_debug_prefix,
2020: p_msg_level=>fnd_log.level_procedure);
2021: END IF;
2022: EXCEPTION
2023: WHEN fnd_api.g_exc_error THEN
2024: ROLLBACK TO create_pm_pvt;
2025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2026: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2027: FND_MSG_PUB.ADD;

Line 2029: x_return_status := fnd_api.g_ret_sts_error;

2025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2026: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2027: FND_MSG_PUB.ADD;
2028:
2029: x_return_status := fnd_api.g_ret_sts_error;
2030:
2031: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2032: p_count => x_msg_count,
2033: p_data => x_msg_data);

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

2027: FND_MSG_PUB.ADD;
2028:
2029: x_return_status := fnd_api.g_ret_sts_error;
2030:
2031: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2032: p_count => x_msg_count,
2033: p_data => x_msg_data);
2034:
2035: -- Debug info.

Line 2048: WHEN fnd_api.g_exc_unexpected_error THEN

2044: p_prefix=>l_debug_prefix,
2045: p_msg_level=>fnd_log.level_procedure);
2046: END IF;
2047:
2048: WHEN fnd_api.g_exc_unexpected_error THEN
2049: ROLLBACK TO create_pm_pvt;
2050: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2051: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2052: FND_MSG_PUB.ADD;

Line 2054: x_return_status := fnd_api.g_ret_sts_unexp_error;

2050: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2051: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2052: FND_MSG_PUB.ADD;
2053:
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;
2055:
2056: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2057: p_count => x_msg_count,
2058: p_data => x_msg_data);

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

2052: FND_MSG_PUB.ADD;
2053:
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;
2055:
2056: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2057: p_count => x_msg_count,
2058: p_data => x_msg_data);
2059:
2060: -- Debug info.

Line 2079: x_return_status := fnd_api.g_ret_sts_unexp_error;

2075: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2076: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2077: FND_MSG_PUB.ADD;
2078:
2079: x_return_status := fnd_api.g_ret_sts_unexp_error;
2080:
2081: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2082: fnd_message.set_token('ERROR' ,SQLERRM);
2083: fnd_msg_pub.add;

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

2081: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2082: fnd_message.set_token('ERROR' ,SQLERRM);
2083: fnd_msg_pub.add;
2084:
2085: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2086: p_count => x_msg_count,
2087: p_data => x_msg_data);
2088:
2089: -- Debug info.

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

2113: -- p_ca_id Customer account Id.
2114: -- p_casu_id Customer account site use Id.
2115: -- OUT:
2116: -- x_return_status Return status after the call. The status can
2117: -- be fnd_api.g_ret_sts_success (success),
2118: -- fnd_api.g_ret_sts_error (error),
2119: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2120: -- x_msg_count Number of messages in message stack.
2121: -- x_msg_data Message text if x_msg_count is 1.

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

2114: -- p_casu_id Customer account site use Id.
2115: -- OUT:
2116: -- x_return_status Return status after the call. The status can
2117: -- be fnd_api.g_ret_sts_success (success),
2118: -- fnd_api.g_ret_sts_error (error),
2119: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2120: -- x_msg_count Number of messages in message stack.
2121: -- x_msg_data Message text if x_msg_count is 1.
2122: --

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

2115: -- OUT:
2116: -- x_return_status Return status after the call. The status can
2117: -- be fnd_api.g_ret_sts_success (success),
2118: -- fnd_api.g_ret_sts_error (error),
2119: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2120: -- x_msg_count Number of messages in message stack.
2121: -- x_msg_data Message text if x_msg_count is 1.
2122: --
2123: -- NOTES

Line 2146: x_return_status := FND_API.G_RET_STS_SUCCESS;

2142: -- Standard start of API savepoint
2143: SAVEPOINT save_pm_pvt;
2144:
2145: -- initialize API return status to success.
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147:
2148: -- Debug info.
2149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'save_payment_method(+)',

Line 2191: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2187: -- assign payment_method_id
2188: p_payment_method_obj.payment_method_id := l_payment_method_rec.cust_receipt_method_id;
2189: END IF;
2190:
2191: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_payment_method, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);

Line 2197: RAISE FND_API.G_EXC_ERROR;

2193: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_payment_method, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199:
2200: -- Debug info.
2201: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2213: WHEN fnd_api.g_exc_error THEN

2209: p_prefix=>l_debug_prefix,
2210: p_msg_level=>fnd_log.level_procedure);
2211: END IF;
2212: EXCEPTION
2213: WHEN fnd_api.g_exc_error THEN
2214: ROLLBACK TO save_pm_pvt;
2215: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2216: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2217: FND_MSG_PUB.ADD;

Line 2219: x_return_status := fnd_api.g_ret_sts_error;

2215: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2216: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2217: FND_MSG_PUB.ADD;
2218:
2219: x_return_status := fnd_api.g_ret_sts_error;
2220:
2221: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2222: p_count => x_msg_count,
2223: p_data => x_msg_data);

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

2217: FND_MSG_PUB.ADD;
2218:
2219: x_return_status := fnd_api.g_ret_sts_error;
2220:
2221: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2222: p_count => x_msg_count,
2223: p_data => x_msg_data);
2224:
2225: -- Debug info.

Line 2238: WHEN fnd_api.g_exc_unexpected_error THEN

2234: p_prefix=>l_debug_prefix,
2235: p_msg_level=>fnd_log.level_procedure);
2236: END IF;
2237:
2238: WHEN fnd_api.g_exc_unexpected_error THEN
2239: ROLLBACK TO save_pm_pvt;
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2241: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2242: FND_MSG_PUB.ADD;

Line 2244: x_return_status := fnd_api.g_ret_sts_unexp_error;

2240: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2241: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2242: FND_MSG_PUB.ADD;
2243:
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;
2245:
2246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2247: p_count => x_msg_count,
2248: p_data => x_msg_data);

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

2242: FND_MSG_PUB.ADD;
2243:
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;
2245:
2246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2247: p_count => x_msg_count,
2248: p_data => x_msg_data);
2249:
2250: -- Debug info.

Line 2269: x_return_status := fnd_api.g_ret_sts_unexp_error;

2265: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2266: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2267: FND_MSG_PUB.ADD;
2268:
2269: x_return_status := fnd_api.g_ret_sts_unexp_error;
2270:
2271: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2272: fnd_message.set_token('ERROR' ,SQLERRM);
2273: fnd_msg_pub.add;

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

2271: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2272: fnd_message.set_token('ERROR' ,SQLERRM);
2273: fnd_msg_pub.add;
2274:
2275: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2276: p_count => x_msg_count,
2277: p_data => x_msg_data);
2278:
2279: -- Debug info.

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

2306: -- p_parent_osr Parent original system reference.
2307: -- p_parent_obj_type Parent object type.
2308: -- OUT:
2309: -- x_return_status Return status after the call. The status can
2310: -- be fnd_api.g_ret_sts_success (success),
2311: -- fnd_api.g_ret_sts_error (error),
2312: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2313: -- x_msg_count Number of messages in message stack.
2314: -- x_msg_data Message text if x_msg_count is 1.

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

2307: -- p_parent_obj_type Parent object type.
2308: -- OUT:
2309: -- x_return_status Return status after the call. The status can
2310: -- be fnd_api.g_ret_sts_success (success),
2311: -- fnd_api.g_ret_sts_error (error),
2312: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2313: -- x_msg_count Number of messages in message stack.
2314: -- x_msg_data Message text if x_msg_count is 1.
2315: --

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

2308: -- OUT:
2309: -- x_return_status Return status after the call. The status can
2310: -- be fnd_api.g_ret_sts_success (success),
2311: -- fnd_api.g_ret_sts_error (error),
2312: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2313: -- x_msg_count Number of messages in message stack.
2314: -- x_msg_data Message text if x_msg_count is 1.
2315: --
2316: -- NOTES

Line 2345: x_return_status := FND_API.G_RET_STS_SUCCESS;

2341: l_parent_obj_type VARCHAR2(30);
2342: l_cbm VARCHAR2(30);
2343: BEGIN
2344: -- initialize API return status to success
2345: x_return_status := FND_API.G_RET_STS_SUCCESS;
2346:
2347: -- Debug info.
2348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2349: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',

Line 2365: p_validate_bo_flag => fnd_api.g_false,

2361: IF(p_create_update_flag = 'C') THEN
2362: -- Create cust accounts
2363: FOR i IN 1..p_ca_objs.COUNT LOOP
2364: HZ_CUST_ACCT_BO_PUB.do_create_cust_acct_bo(
2365: p_validate_bo_flag => fnd_api.g_false,
2366: p_cust_acct_obj => p_ca_objs(i),
2367: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2368: p_obj_source => p_obj_source,
2369: x_return_status => x_return_status,

Line 2381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2377: px_parent_osr => l_parent_osr,
2378: px_parent_obj_type => l_parent_obj_type
2379: );
2380:
2381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2383: hz_utility_v2pub.debug(p_message=>'Create error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2384: p_prefix=>l_debug_prefix,
2385: p_msg_level=>fnd_log.level_procedure);

Line 2387: RAISE FND_API.G_EXC_ERROR;

2383: hz_utility_v2pub.debug(p_message=>'Create error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2384: p_prefix=>l_debug_prefix,
2385: p_msg_level=>fnd_log.level_procedure);
2386: END IF;
2387: RAISE FND_API.G_EXC_ERROR;
2388: END IF;
2389:
2390: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2391: END LOOP;

Line 2396: p_validate_bo_flag => fnd_api.g_false,

2392: ELSE
2393: -- Create/update cust accounts
2394: FOR i IN 1..p_ca_objs.COUNT LOOP
2395: HZ_CUST_ACCT_BO_PUB.do_save_cust_acct_bo(
2396: p_validate_bo_flag => fnd_api.g_false,
2397: p_cust_acct_obj => p_ca_objs(i),
2398: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2399: p_obj_source => p_obj_source,
2400: x_return_status => x_return_status,

Line 2412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2408: px_parent_osr => l_parent_osr,
2409: px_parent_obj_type => l_parent_obj_type
2410: );
2411:
2412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2414: hz_utility_v2pub.debug(p_message=>'Save error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2415: p_prefix=>l_debug_prefix,
2416: p_msg_level=>fnd_log.level_procedure);

Line 2418: RAISE FND_API.G_EXC_ERROR;

2414: hz_utility_v2pub.debug(p_message=>'Save error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2415: p_prefix=>l_debug_prefix,
2416: p_msg_level=>fnd_log.level_procedure);
2417: END IF;
2418: RAISE FND_API.G_EXC_ERROR;
2419: END IF;
2420:
2421: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2422: END LOOP;

Line 2438: WHEN fnd_api.g_exc_error THEN

2434: p_prefix=>l_debug_prefix,
2435: p_msg_level=>fnd_log.level_procedure);
2436: END IF;
2437: EXCEPTION
2438: WHEN fnd_api.g_exc_error THEN
2439: x_return_status := fnd_api.g_ret_sts_error;
2440:
2441: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2442: p_count => x_msg_count,

Line 2439: x_return_status := fnd_api.g_ret_sts_error;

2435: p_msg_level=>fnd_log.level_procedure);
2436: END IF;
2437: EXCEPTION
2438: WHEN fnd_api.g_exc_error THEN
2439: x_return_status := fnd_api.g_ret_sts_error;
2440:
2441: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2442: p_count => x_msg_count,
2443: p_data => x_msg_data);

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

2437: EXCEPTION
2438: WHEN fnd_api.g_exc_error THEN
2439: x_return_status := fnd_api.g_ret_sts_error;
2440:
2441: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2442: p_count => x_msg_count,
2443: p_data => x_msg_data);
2444:
2445: -- Debug info.

Line 2457: WHEN fnd_api.g_exc_unexpected_error THEN

2453: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2454: p_prefix=>l_debug_prefix,
2455: p_msg_level=>fnd_log.level_procedure);
2456: END IF;
2457: WHEN fnd_api.g_exc_unexpected_error THEN
2458: x_return_status := fnd_api.g_ret_sts_unexp_error;
2459:
2460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2461: p_count => x_msg_count,

Line 2458: x_return_status := fnd_api.g_ret_sts_unexp_error;

2454: p_prefix=>l_debug_prefix,
2455: p_msg_level=>fnd_log.level_procedure);
2456: END IF;
2457: WHEN fnd_api.g_exc_unexpected_error THEN
2458: x_return_status := fnd_api.g_ret_sts_unexp_error;
2459:
2460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2461: p_count => x_msg_count,
2462: p_data => x_msg_data);

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

2456: END IF;
2457: WHEN fnd_api.g_exc_unexpected_error THEN
2458: x_return_status := fnd_api.g_ret_sts_unexp_error;
2459:
2460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2461: p_count => x_msg_count,
2462: p_data => x_msg_data);
2463:
2464: -- Debug info.

Line 2477: x_return_status := fnd_api.g_ret_sts_unexp_error;

2473: p_prefix=>l_debug_prefix,
2474: p_msg_level=>fnd_log.level_procedure);
2475: END IF;
2476: WHEN OTHERS THEN
2477: x_return_status := fnd_api.g_ret_sts_unexp_error;
2478:
2479: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2480: fnd_message.set_token('ERROR' ,SQLERRM);
2481: fnd_msg_pub.add;

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

2479: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2480: fnd_message.set_token('ERROR' ,SQLERRM);
2481: fnd_msg_pub.add;
2482:
2483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2484: p_count => x_msg_count,
2485: p_data => x_msg_data);
2486:
2487: -- Debug info.

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

2511: -- p_ca_id Customer account Id.
2512: -- p_casu_id Customer account site use Id.
2513: -- OUT:
2514: -- x_return_status Return status after the call. The status can
2515: -- be fnd_api.g_ret_sts_success (success),
2516: -- fnd_api.g_ret_sts_error (error),
2517: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2518: -- x_msg_count Number of messages in message stack.
2519: -- x_msg_data Message text if x_msg_count is 1.

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

2512: -- p_casu_id Customer account site use Id.
2513: -- OUT:
2514: -- x_return_status Return status after the call. The status can
2515: -- be fnd_api.g_ret_sts_success (success),
2516: -- fnd_api.g_ret_sts_error (error),
2517: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2518: -- x_msg_count Number of messages in message stack.
2519: -- x_msg_data Message text if x_msg_count is 1.
2520: --

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

2513: -- OUT:
2514: -- x_return_status Return status after the call. The status can
2515: -- be fnd_api.g_ret_sts_success (success),
2516: -- fnd_api.g_ret_sts_error (error),
2517: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2518: -- x_msg_count Number of messages in message stack.
2519: -- x_msg_data Message text if x_msg_count is 1.
2520: --
2521: -- NOTES

Line 2541: x_return_status := FND_API.G_RET_STS_SUCCESS;

2537: -- Standard start of API savepoint
2538: SAVEPOINT create_pms_v2_pvt;
2539:
2540: -- initialize API return status to success.
2541: x_return_status := FND_API.G_RET_STS_SUCCESS;
2542:
2543: -- Debug info.
2544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2545: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',

Line 2561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2557: x_msg_count => x_msg_count,
2558: x_msg_data => x_msg_data
2559: );
2560:
2561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2562: RAISE FND_API.G_EXC_ERROR;
2563: END IF;
2564: END LOOP;
2565:

Line 2562: RAISE FND_API.G_EXC_ERROR;

2558: x_msg_data => x_msg_data
2559: );
2560:
2561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2562: RAISE FND_API.G_EXC_ERROR;
2563: END IF;
2564: END LOOP;
2565:
2566:

Line 2568: WHEN fnd_api.g_exc_error THEN

2564: END LOOP;
2565:
2566:
2567: EXCEPTION
2568: WHEN fnd_api.g_exc_error THEN
2569: ROLLBACK TO create_pms_v2_pvt;
2570:
2571: x_return_status := fnd_api.g_ret_sts_error;
2572:

Line 2571: x_return_status := fnd_api.g_ret_sts_error;

2567: EXCEPTION
2568: WHEN fnd_api.g_exc_error THEN
2569: ROLLBACK TO create_pms_v2_pvt;
2570:
2571: x_return_status := fnd_api.g_ret_sts_error;
2572:
2573: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2574: p_count => x_msg_count,
2575: p_data => x_msg_data);

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

2569: ROLLBACK TO create_pms_v2_pvt;
2570:
2571: x_return_status := fnd_api.g_ret_sts_error;
2572:
2573: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2574: p_count => x_msg_count,
2575: p_data => x_msg_data);
2576:
2577: -- Debug info.

Line 2590: WHEN fnd_api.g_exc_unexpected_error THEN

2586: p_prefix=>l_debug_prefix,
2587: p_msg_level=>fnd_log.level_procedure);
2588: END IF;
2589:
2590: WHEN fnd_api.g_exc_unexpected_error THEN
2591: ROLLBACK TO create_pms_v2_pvt;
2592:
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594:

Line 2593: x_return_status := fnd_api.g_ret_sts_unexp_error;

2589:
2590: WHEN fnd_api.g_exc_unexpected_error THEN
2591: ROLLBACK TO create_pms_v2_pvt;
2592:
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594:
2595: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2596: p_count => x_msg_count,
2597: p_data => x_msg_data);

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

2591: ROLLBACK TO create_pms_v2_pvt;
2592:
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594:
2595: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2596: p_count => x_msg_count,
2597: p_data => x_msg_data);
2598:
2599: -- Debug info.

Line 2615: x_return_status := fnd_api.g_ret_sts_unexp_error;

2611:
2612: WHEN OTHERS THEN
2613: ROLLBACK TO create_pms_v2_pvt;
2614:
2615: x_return_status := fnd_api.g_ret_sts_unexp_error;
2616:
2617: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2618: fnd_message.set_token('ERROR' ,SQLERRM);
2619: fnd_msg_pub.add;

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

2617: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2618: fnd_message.set_token('ERROR' ,SQLERRM);
2619: fnd_msg_pub.add;
2620:
2621: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2622: p_count => x_msg_count,
2623: p_data => x_msg_data);
2624:
2625: -- Debug info.

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

2649: -- p_ca_id Customer account Id.
2650: -- p_casu_id Customer account site use Id.
2651: -- OUT:
2652: -- x_return_status Return status after the call. The status can
2653: -- be fnd_api.g_ret_sts_success (success),
2654: -- fnd_api.g_ret_sts_error (error),
2655: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2656: -- x_msg_count Number of messages in message stack.
2657: -- x_msg_data Message text if x_msg_count is 1.

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

2650: -- p_casu_id Customer account site use Id.
2651: -- OUT:
2652: -- x_return_status Return status after the call. The status can
2653: -- be fnd_api.g_ret_sts_success (success),
2654: -- fnd_api.g_ret_sts_error (error),
2655: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2656: -- x_msg_count Number of messages in message stack.
2657: -- x_msg_data Message text if x_msg_count is 1.
2658: --

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

2651: -- OUT:
2652: -- x_return_status Return status after the call. The status can
2653: -- be fnd_api.g_ret_sts_success (success),
2654: -- fnd_api.g_ret_sts_error (error),
2655: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2656: -- x_msg_count Number of messages in message stack.
2657: -- x_msg_data Message text if x_msg_count is 1.
2658: --
2659: -- NOTES

Line 2679: x_return_status := FND_API.G_RET_STS_SUCCESS;

2675: -- Standard start of API savepoint
2676: SAVEPOINT save_pm_v2_pvt;
2677:
2678: -- initialize API return status to success.
2679: x_return_status := FND_API.G_RET_STS_SUCCESS;
2680:
2681: -- Debug info.
2682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',

Line 2699: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2695: x_msg_count => x_msg_count,
2696: x_msg_data => x_msg_data
2697: );
2698:
2699: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2700: RAISE FND_API.G_EXC_ERROR;
2701: END IF;
2702: END LOOP;
2703:

Line 2700: RAISE FND_API.G_EXC_ERROR;

2696: x_msg_data => x_msg_data
2697: );
2698:
2699: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2700: RAISE FND_API.G_EXC_ERROR;
2701: END IF;
2702: END LOOP;
2703:
2704:

Line 2706: WHEN fnd_api.g_exc_error THEN

2702: END LOOP;
2703:
2704:
2705: EXCEPTION
2706: WHEN fnd_api.g_exc_error THEN
2707: ROLLBACK TO save_pm_v2_pvt;
2708: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2709: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2710: FND_MSG_PUB.ADD;

Line 2712: x_return_status := fnd_api.g_ret_sts_error;

2708: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2709: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2710: FND_MSG_PUB.ADD;
2711:
2712: x_return_status := fnd_api.g_ret_sts_error;
2713:
2714: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2715: p_count => x_msg_count,
2716: p_data => x_msg_data);

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

2710: FND_MSG_PUB.ADD;
2711:
2712: x_return_status := fnd_api.g_ret_sts_error;
2713:
2714: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2715: p_count => x_msg_count,
2716: p_data => x_msg_data);
2717:
2718: -- Debug info.

Line 2731: WHEN fnd_api.g_exc_unexpected_error THEN

2727: p_prefix=>l_debug_prefix,
2728: p_msg_level=>fnd_log.level_procedure);
2729: END IF;
2730:
2731: WHEN fnd_api.g_exc_unexpected_error THEN
2732: ROLLBACK TO save_pm_v2_pvt;
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2734: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2735: FND_MSG_PUB.ADD;

Line 2737: x_return_status := fnd_api.g_ret_sts_unexp_error;

2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2734: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2735: FND_MSG_PUB.ADD;
2736:
2737: x_return_status := fnd_api.g_ret_sts_unexp_error;
2738:
2739: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2740: p_count => x_msg_count,
2741: p_data => x_msg_data);

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

2735: FND_MSG_PUB.ADD;
2736:
2737: x_return_status := fnd_api.g_ret_sts_unexp_error;
2738:
2739: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2740: p_count => x_msg_count,
2741: p_data => x_msg_data);
2742:
2743: -- Debug info.

Line 2762: x_return_status := fnd_api.g_ret_sts_unexp_error;

2758: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2759: FND_MESSAGE.SET_TOKEN('ENTITY', 'RA_CUST_RECEIPT_METHODS');
2760: FND_MSG_PUB.ADD;
2761:
2762: x_return_status := fnd_api.g_ret_sts_unexp_error;
2763:
2764: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2765: fnd_message.set_token('ERROR' ,SQLERRM);
2766: fnd_msg_pub.add;

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

2764: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2765: fnd_message.set_token('ERROR' ,SQLERRM);
2766: fnd_msg_pub.add;
2767:
2768: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2769: p_count => x_msg_count,
2770: p_data => x_msg_data);
2771:
2772: -- Debug info.

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

2799: -- p_parent_osr Parent original system reference.
2800: -- p_parent_obj_type Parent object type.
2801: -- OUT:
2802: -- x_return_status Return status after the call. The status can
2803: -- be fnd_api.g_ret_sts_success (success),
2804: -- fnd_api.g_ret_sts_error (error),
2805: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2806: -- x_msg_count Number of messages in message stack.
2807: -- x_msg_data Message text if x_msg_count is 1.

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

2800: -- p_parent_obj_type Parent object type.
2801: -- OUT:
2802: -- x_return_status Return status after the call. The status can
2803: -- be fnd_api.g_ret_sts_success (success),
2804: -- fnd_api.g_ret_sts_error (error),
2805: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2806: -- x_msg_count Number of messages in message stack.
2807: -- x_msg_data Message text if x_msg_count is 1.
2808: --

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

2801: -- OUT:
2802: -- x_return_status Return status after the call. The status can
2803: -- be fnd_api.g_ret_sts_success (success),
2804: -- fnd_api.g_ret_sts_error (error),
2805: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2806: -- x_msg_count Number of messages in message stack.
2807: -- x_msg_data Message text if x_msg_count is 1.
2808: --
2809: -- NOTES

Line 2838: x_return_status := FND_API.G_RET_STS_SUCCESS;

2834: l_parent_obj_type VARCHAR2(30);
2835: l_cbm VARCHAR2(30);
2836: BEGIN
2837: -- initialize API return status to success
2838: x_return_status := FND_API.G_RET_STS_SUCCESS;
2839:
2840: -- Debug info.
2841: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2842: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',

Line 2858: p_validate_bo_flag => fnd_api.g_false,

2854: IF(p_create_update_flag = 'C') THEN
2855: -- Create cust accounts
2856: FOR i IN 1..p_ca_v2_objs.COUNT LOOP
2857: HZ_CUST_ACCT_BO_PUB.do_create_cust_acct_v2_bo(
2858: p_validate_bo_flag => fnd_api.g_false,
2859: p_cust_acct_v2_obj => p_ca_v2_objs(i),
2860: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2861: p_obj_source => p_obj_source,
2862: x_return_status => x_return_status,

Line 2874: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2870: px_parent_osr => l_parent_osr,
2871: px_parent_obj_type => l_parent_obj_type
2872: );
2873:
2874: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2876: hz_utility_v2pub.debug(p_message=>'Create error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2877: p_prefix=>l_debug_prefix,
2878: p_msg_level=>fnd_log.level_procedure);

Line 2880: RAISE FND_API.G_EXC_ERROR;

2876: hz_utility_v2pub.debug(p_message=>'Create error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2877: p_prefix=>l_debug_prefix,
2878: p_msg_level=>fnd_log.level_procedure);
2879: END IF;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;
2882:
2883: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2884: END LOOP;

Line 2889: p_validate_bo_flag => fnd_api.g_false,

2885: ELSE
2886: -- Create/update cust accounts
2887: FOR i IN 1..p_ca_v2_objs.COUNT LOOP
2888: HZ_CUST_ACCT_BO_PUB.do_save_cust_acct_v2_bo(
2889: p_validate_bo_flag => fnd_api.g_false,
2890: p_cust_acct_v2_obj => p_ca_v2_objs(i),
2891: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2892: p_obj_source => p_obj_source,
2893: x_return_status => x_return_status,

Line 2905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2901: px_parent_osr => l_parent_osr,
2902: px_parent_obj_type => l_parent_obj_type
2903: );
2904:
2905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2907: hz_utility_v2pub.debug(p_message=>'Save error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2908: p_prefix=>l_debug_prefix,
2909: p_msg_level=>fnd_log.level_procedure);

Line 2911: RAISE FND_API.G_EXC_ERROR;

2907: hz_utility_v2pub.debug(p_message=>'Save error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2908: p_prefix=>l_debug_prefix,
2909: p_msg_level=>fnd_log.level_procedure);
2910: END IF;
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;
2913:
2914: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2915: END LOOP;

Line 2931: WHEN fnd_api.g_exc_error THEN

2927: p_prefix=>l_debug_prefix,
2928: p_msg_level=>fnd_log.level_procedure);
2929: END IF;
2930: EXCEPTION
2931: WHEN fnd_api.g_exc_error THEN
2932: x_return_status := fnd_api.g_ret_sts_error;
2933:
2934: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2935: p_count => x_msg_count,

Line 2932: x_return_status := fnd_api.g_ret_sts_error;

2928: p_msg_level=>fnd_log.level_procedure);
2929: END IF;
2930: EXCEPTION
2931: WHEN fnd_api.g_exc_error THEN
2932: x_return_status := fnd_api.g_ret_sts_error;
2933:
2934: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2935: p_count => x_msg_count,
2936: p_data => x_msg_data);

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

2930: EXCEPTION
2931: WHEN fnd_api.g_exc_error THEN
2932: x_return_status := fnd_api.g_ret_sts_error;
2933:
2934: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2935: p_count => x_msg_count,
2936: p_data => x_msg_data);
2937:
2938: -- Debug info.

Line 2950: WHEN fnd_api.g_exc_unexpected_error THEN

2946: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2947: p_prefix=>l_debug_prefix,
2948: p_msg_level=>fnd_log.level_procedure);
2949: END IF;
2950: WHEN fnd_api.g_exc_unexpected_error THEN
2951: x_return_status := fnd_api.g_ret_sts_unexp_error;
2952:
2953: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2954: p_count => x_msg_count,

Line 2951: x_return_status := fnd_api.g_ret_sts_unexp_error;

2947: p_prefix=>l_debug_prefix,
2948: p_msg_level=>fnd_log.level_procedure);
2949: END IF;
2950: WHEN fnd_api.g_exc_unexpected_error THEN
2951: x_return_status := fnd_api.g_ret_sts_unexp_error;
2952:
2953: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2954: p_count => x_msg_count,
2955: p_data => x_msg_data);

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

2949: END IF;
2950: WHEN fnd_api.g_exc_unexpected_error THEN
2951: x_return_status := fnd_api.g_ret_sts_unexp_error;
2952:
2953: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2954: p_count => x_msg_count,
2955: p_data => x_msg_data);
2956:
2957: -- Debug info.

Line 2970: x_return_status := fnd_api.g_ret_sts_unexp_error;

2966: p_prefix=>l_debug_prefix,
2967: p_msg_level=>fnd_log.level_procedure);
2968: END IF;
2969: WHEN OTHERS THEN
2970: x_return_status := fnd_api.g_ret_sts_unexp_error;
2971:
2972: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2973: fnd_message.set_token('ERROR' ,SQLERRM);
2974: fnd_msg_pub.add;

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

2972: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2973: fnd_message.set_token('ERROR' ,SQLERRM);
2974: fnd_msg_pub.add;
2975:
2976: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2977: p_count => x_msg_count,
2978: p_data => x_msg_data);
2979:
2980: -- Debug info.