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 1639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1635: x_msg_data => x_msg_data
1636: );
1637: END IF;
1638:
1639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1641: 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,
1642: p_prefix=>l_debug_prefix,
1643: p_msg_level=>fnd_log.level_procedure);

Line 1645: RAISE FND_API.G_EXC_ERROR;

1641: 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,
1642: p_prefix=>l_debug_prefix,
1643: p_msg_level=>fnd_log.level_procedure);
1644: END IF;
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647: ELSE
1648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1649: 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 1653: RAISE FND_API.G_EXC_ERROR;

1649: 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,
1650: p_prefix=>l_debug_prefix,
1651: p_msg_level=>fnd_log.level_procedure);
1652: END IF;
1653: RAISE FND_API.G_EXC_ERROR;
1654: END IF;
1655: END LOOP;
1656:
1657: -- Debug info.

Line 1670: WHEN fnd_api.g_exc_error THEN

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

Line 1676: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 1695: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 1701: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 1726: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

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

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

Line 1796: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1817: p_commit => FND_API.G_FALSE,

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

Line 1830: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1826:
1827: -- assign bank_acct_use_id
1828: p_bank_acct_use_objs(i).bank_acct_use_id := l_assign_id;
1829:
1830: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1831: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1832: 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,
1833: p_prefix=>l_debug_prefix,
1834: p_msg_level=>fnd_log.level_procedure);

Line 1836: RAISE FND_API.G_EXC_ERROR;

1832: 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,
1833: p_prefix=>l_debug_prefix,
1834: p_msg_level=>fnd_log.level_procedure);
1835: END IF;
1836: RAISE FND_API.G_EXC_ERROR;
1837: END IF;
1838: END LOOP;
1839:
1840: -- Debug info.

Line 1853: WHEN fnd_api.g_exc_error THEN

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

Line 1859: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 1878: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 1884: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 1909: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

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

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

Line 1975: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1999: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1995: x_msg_count => x_msg_count,
1996: x_msg_data => x_msg_data
1997: );
1998:
1999: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2001: 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,
2002: p_prefix=>l_debug_prefix,
2003: p_msg_level=>fnd_log.level_procedure);

Line 2005: RAISE FND_API.G_EXC_ERROR;

2001: 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,
2002: p_prefix=>l_debug_prefix,
2003: p_msg_level=>fnd_log.level_procedure);
2004: END IF;
2005: RAISE FND_API.G_EXC_ERROR;
2006: END IF;
2007:
2008: -- assign payment_method_id
2009: p_payment_method_obj.payment_method_id := l_pm_id;

Line 2024: WHEN fnd_api.g_exc_error THEN

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

Line 2030: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 2049: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2055: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2080: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

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

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

Line 2147: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2192: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2188: -- assign payment_method_id
2189: p_payment_method_obj.payment_method_id := l_payment_method_rec.cust_receipt_method_id;
2190: END IF;
2191:
2192: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2194: 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,
2195: p_prefix=>l_debug_prefix,
2196: p_msg_level=>fnd_log.level_procedure);

Line 2198: RAISE FND_API.G_EXC_ERROR;

2194: 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,
2195: p_prefix=>l_debug_prefix,
2196: p_msg_level=>fnd_log.level_procedure);
2197: END IF;
2198: RAISE FND_API.G_EXC_ERROR;
2199: END IF;
2200:
2201: -- Debug info.
2202: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2214: WHEN fnd_api.g_exc_error THEN

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

Line 2220: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 2239: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2245: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2270: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

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

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

Line 2346: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2366: p_validate_bo_flag => fnd_api.g_false,

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

Line 2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2378: px_parent_osr => l_parent_osr,
2379: px_parent_obj_type => l_parent_obj_type
2380: );
2381:
2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2384: 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,
2385: p_prefix=>l_debug_prefix,
2386: p_msg_level=>fnd_log.level_procedure);

Line 2388: RAISE FND_API.G_EXC_ERROR;

2384: 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,
2385: p_prefix=>l_debug_prefix,
2386: p_msg_level=>fnd_log.level_procedure);
2387: END IF;
2388: RAISE FND_API.G_EXC_ERROR;
2389: END IF;
2390:
2391: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2392: END LOOP;

Line 2397: p_validate_bo_flag => fnd_api.g_false,

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

Line 2413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2409: px_parent_osr => l_parent_osr,
2410: px_parent_obj_type => l_parent_obj_type
2411: );
2412:
2413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2414: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2415: 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,
2416: p_prefix=>l_debug_prefix,
2417: p_msg_level=>fnd_log.level_procedure);

Line 2419: RAISE FND_API.G_EXC_ERROR;

2415: 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,
2416: p_prefix=>l_debug_prefix,
2417: p_msg_level=>fnd_log.level_procedure);
2418: END IF;
2419: RAISE FND_API.G_EXC_ERROR;
2420: END IF;
2421:
2422: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2423: END LOOP;

Line 2439: WHEN fnd_api.g_exc_error THEN

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

Line 2440: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 2458: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2459: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2478: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

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

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

Line 2542: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2563: RAISE FND_API.G_EXC_ERROR;

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

Line 2569: WHEN fnd_api.g_exc_error THEN

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

Line 2572: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 2591: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2594: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2616: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

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

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

Line 2680: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2700: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2701: RAISE FND_API.G_EXC_ERROR;

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

Line 2707: WHEN fnd_api.g_exc_error THEN

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

Line 2713: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 2732: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2738: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2763: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

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

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

Line 2839: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2859: p_validate_bo_flag => fnd_api.g_false,

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

Line 2875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2871: px_parent_osr => l_parent_osr,
2872: px_parent_obj_type => l_parent_obj_type
2873: );
2874:
2875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2876: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2877: 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,
2878: p_prefix=>l_debug_prefix,
2879: p_msg_level=>fnd_log.level_procedure);

Line 2881: RAISE FND_API.G_EXC_ERROR;

2877: 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,
2878: p_prefix=>l_debug_prefix,
2879: p_msg_level=>fnd_log.level_procedure);
2880: END IF;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2885: END LOOP;

Line 2890: p_validate_bo_flag => fnd_api.g_false,

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

Line 2906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2902: px_parent_osr => l_parent_osr,
2903: px_parent_obj_type => l_parent_obj_type
2904: );
2905:
2906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2908: 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,
2909: p_prefix=>l_debug_prefix,
2910: p_msg_level=>fnd_log.level_procedure);

Line 2912: RAISE FND_API.G_EXC_ERROR;

2908: 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,
2909: p_prefix=>l_debug_prefix,
2910: p_msg_level=>fnd_log.level_procedure);
2911: END IF;
2912: RAISE FND_API.G_EXC_ERROR;
2913: END IF;
2914:
2915: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2916: END LOOP;

Line 2932: WHEN fnd_api.g_exc_error THEN

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

Line 2933: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 2951: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2952: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2971: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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