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

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

639: -- p_credit_rating_objs List of credit rating objects.
640: -- p_organization_id Organization Id.
641: -- OUT:
642: -- x_return_status Return status after the call. The status can
643: -- be fnd_api.g_ret_sts_success (success),
644: -- fnd_api.g_ret_sts_error (error),
645: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
646: -- x_msg_count Number of messages in message stack.
647: -- x_msg_data Message text if x_msg_count is 1.

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

640: -- p_organization_id Organization Id.
641: -- OUT:
642: -- x_return_status Return status after the call. The status can
643: -- be fnd_api.g_ret_sts_success (success),
644: -- fnd_api.g_ret_sts_error (error),
645: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
646: -- x_msg_count Number of messages in message stack.
647: -- x_msg_data Message text if x_msg_count is 1.
648: --

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

641: -- OUT:
642: -- x_return_status Return status after the call. The status can
643: -- be fnd_api.g_ret_sts_success (success),
644: -- fnd_api.g_ret_sts_error (error),
645: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
646: -- x_msg_count Number of messages in message stack.
647: -- x_msg_data Message text if x_msg_count is 1.
648: --
649: -- NOTES

Line 670: x_return_status := FND_API.G_RET_STS_SUCCESS;

666: -- Standard start of API savepoint
667: SAVEPOINT create_credit_ratings_pub;
668:
669: -- initialize API return status to success.
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: -- Debug info.
673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
674: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(+)',

Line 697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data
695: );
696:
697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
700: p_prefix=>l_debug_prefix,
701: p_msg_level=>fnd_log.level_procedure);

Line 703: RAISE FND_API.G_EXC_ERROR;

699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
700: p_prefix=>l_debug_prefix,
701: p_msg_level=>fnd_log.level_procedure);
702: END IF;
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705:
706: -- assign credit_rating_id
707: p_credit_rating_objs(i).credit_rating_id := l_dummy_id;

Line 723: WHEN fnd_api.g_exc_error THEN

719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722: EXCEPTION
723: WHEN fnd_api.g_exc_error THEN
724: ROLLBACK TO create_credit_ratings_pub;
725: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
726: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
727: FND_MSG_PUB.ADD;

Line 729: x_return_status := fnd_api.g_ret_sts_error;

725: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
726: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
727: FND_MSG_PUB.ADD;
728:
729: x_return_status := fnd_api.g_ret_sts_error;
730:
731: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
732: p_count => x_msg_count,
733: p_data => x_msg_data);

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

727: FND_MSG_PUB.ADD;
728:
729: x_return_status := fnd_api.g_ret_sts_error;
730:
731: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
732: p_count => x_msg_count,
733: p_data => x_msg_data);
734:
735: -- Debug info.

Line 747: WHEN fnd_api.g_exc_unexpected_error THEN

743: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;
747: WHEN fnd_api.g_exc_unexpected_error THEN
748: ROLLBACK TO create_credit_ratings_pub;
749: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
750: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
751: FND_MSG_PUB.ADD;

Line 753: x_return_status := fnd_api.g_ret_sts_unexp_error;

749: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
750: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
751: FND_MSG_PUB.ADD;
752:
753: x_return_status := fnd_api.g_ret_sts_unexp_error;
754:
755: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
756: p_count => x_msg_count,
757: p_data => x_msg_data);

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

751: FND_MSG_PUB.ADD;
752:
753: x_return_status := fnd_api.g_ret_sts_unexp_error;
754:
755: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
756: p_count => x_msg_count,
757: p_data => x_msg_data);
758:
759: -- Debug info.

Line 777: x_return_status := fnd_api.g_ret_sts_unexp_error;

773: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
774: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
775: FND_MSG_PUB.ADD;
776:
777: x_return_status := fnd_api.g_ret_sts_unexp_error;
778:
779: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
780: fnd_message.set_token('ERROR' ,SQLERRM);
781: fnd_msg_pub.add;

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

779: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
780: fnd_message.set_token('ERROR' ,SQLERRM);
781: fnd_msg_pub.add;
782:
783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
784: p_count => x_msg_count,
785: p_data => x_msg_data);
786:
787: -- Debug info.

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

810: -- p_credit_rating_objs List of credit rating objects.
811: -- p_organization_id Organization Id.
812: -- OUT:
813: -- x_return_status Return status after the call. The status can
814: -- be fnd_api.g_ret_sts_success (success),
815: -- fnd_api.g_ret_sts_error (error),
816: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
817: -- x_msg_count Number of messages in message stack.
818: -- x_msg_data Message text if x_msg_count is 1.

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

811: -- p_organization_id Organization Id.
812: -- OUT:
813: -- x_return_status Return status after the call. The status can
814: -- be fnd_api.g_ret_sts_success (success),
815: -- fnd_api.g_ret_sts_error (error),
816: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
817: -- x_msg_count Number of messages in message stack.
818: -- x_msg_data Message text if x_msg_count is 1.
819: --

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

812: -- OUT:
813: -- x_return_status Return status after the call. The status can
814: -- be fnd_api.g_ret_sts_success (success),
815: -- fnd_api.g_ret_sts_error (error),
816: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
817: -- x_msg_count Number of messages in message stack.
818: -- x_msg_data Message text if x_msg_count is 1.
819: --
820: -- NOTES

Line 842: x_return_status := FND_API.G_RET_STS_SUCCESS;

838: -- Standard start of API savepoint
839: SAVEPOINT save_credit_ratings_pub;
840:
841: -- initialize API return status to success.
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843:
844: -- Debug info.
845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
846: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(+)',

Line 876: RAISE FND_API.G_EXC_ERROR;

872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
875: FND_MSG_PUB.ADD;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:
879: IF(l_ovn IS NULL) THEN
880: HZ_PARTY_INFO_V2PUB.create_credit_rating(

Line 905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

901: -- assign credit_rating_id
902: p_credit_rating_objs(i).credit_rating_id := l_credit_rating_rec.credit_rating_id;
903: END IF;
904:
905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
908: p_prefix=>l_debug_prefix,
909: p_msg_level=>fnd_log.level_procedure);

Line 911: RAISE FND_API.G_EXC_ERROR;

907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
908: p_prefix=>l_debug_prefix,
909: p_msg_level=>fnd_log.level_procedure);
910: END IF;
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: END LOOP;
914:
915: -- Debug info.

Line 928: WHEN fnd_api.g_exc_error THEN

924: p_prefix=>l_debug_prefix,
925: p_msg_level=>fnd_log.level_procedure);
926: END IF;
927: EXCEPTION
928: WHEN fnd_api.g_exc_error THEN
929: ROLLBACK TO save_credit_ratings_pub;
930: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
931: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
932: FND_MSG_PUB.ADD;

Line 934: x_return_status := fnd_api.g_ret_sts_error;

930: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
931: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
932: FND_MSG_PUB.ADD;
933:
934: x_return_status := fnd_api.g_ret_sts_error;
935:
936: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
937: p_count => x_msg_count,
938: p_data => x_msg_data);

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

932: FND_MSG_PUB.ADD;
933:
934: x_return_status := fnd_api.g_ret_sts_error;
935:
936: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
937: p_count => x_msg_count,
938: p_data => x_msg_data);
939:
940: -- Debug info.

Line 952: WHEN fnd_api.g_exc_unexpected_error THEN

948: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
949: p_prefix=>l_debug_prefix,
950: p_msg_level=>fnd_log.level_procedure);
951: END IF;
952: WHEN fnd_api.g_exc_unexpected_error THEN
953: ROLLBACK TO save_credit_ratings_pub;
954: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
955: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
956: FND_MSG_PUB.ADD;

Line 958: x_return_status := fnd_api.g_ret_sts_unexp_error;

954: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
955: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
956: FND_MSG_PUB.ADD;
957:
958: x_return_status := fnd_api.g_ret_sts_unexp_error;
959:
960: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
961: p_count => x_msg_count,
962: p_data => x_msg_data);

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

956: FND_MSG_PUB.ADD;
957:
958: x_return_status := fnd_api.g_ret_sts_unexp_error;
959:
960: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
961: p_count => x_msg_count,
962: p_data => x_msg_data);
963:
964: -- Debug info.

Line 982: x_return_status := fnd_api.g_ret_sts_unexp_error;

978: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
979: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CREDIT_RATINGS');
980: FND_MSG_PUB.ADD;
981:
982: x_return_status := fnd_api.g_ret_sts_unexp_error;
983:
984: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
985: fnd_message.set_token('ERROR' ,SQLERRM);
986: fnd_msg_pub.add;

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

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

Line 1027: x_return_status := FND_API.G_RET_STS_SUCCESS;

1023: --SAVEPOINT create_credit_ratings_pub; --Bug 6619304
1024: SAVEPOINT create_financial_reports_pub; --Bug 6619304
1025:
1026: -- initialize API return status to success.
1027: x_return_status := FND_API.G_RET_STS_SUCCESS;
1028:
1029: -- Debug info.
1030: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'create_financial_reports(+)',

Line 1054: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1050: x_msg_count => x_msg_count,
1051: x_msg_data => x_msg_data
1052: );
1053:
1054: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, org id: '||p_organization_id,
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);

Line 1063: RAISE FND_API.G_EXC_ERROR;

1059: END IF;
1060: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1061: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_FINANCIAL_REPORTS');
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: ELSE
1065: -- assign financial_number_id
1066: p_fin_objs(i).financial_report_id := l_dummy_id;
1067:

Line 1089: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1085: x_msg_count => x_msg_count,
1086: x_msg_data => x_msg_data
1087: );
1088:
1089: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, fin_number_id: '||l_dummy_id,
1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094: END IF;
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1096: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_NUMBERS');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100:
1101: -- assign financial_number_id
1102: p_fin_objs(i).financial_number_objs(j).financial_number_id := l_dummy_id;

Line 1121: WHEN fnd_api.g_exc_error THEN

1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120: EXCEPTION
1121: WHEN fnd_api.g_exc_error THEN
1122: ROLLBACK TO create_financial_reports_pub;
1123: x_return_status := fnd_api.g_ret_sts_error;
1124:
1125: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1123: x_return_status := fnd_api.g_ret_sts_error;

1119: END IF;
1120: EXCEPTION
1121: WHEN fnd_api.g_exc_error THEN
1122: ROLLBACK TO create_financial_reports_pub;
1123: x_return_status := fnd_api.g_ret_sts_error;
1124:
1125: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data);

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

1121: WHEN fnd_api.g_exc_error THEN
1122: ROLLBACK TO create_financial_reports_pub;
1123: x_return_status := fnd_api.g_ret_sts_error;
1124:
1125: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data);
1128:
1129: -- Debug info.

Line 1141: WHEN fnd_api.g_exc_unexpected_error THEN

1137: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141: WHEN fnd_api.g_exc_unexpected_error THEN
1142: ROLLBACK TO create_financial_reports_pub;
1143: x_return_status := fnd_api.g_ret_sts_unexp_error;
1144:
1145: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1143: x_return_status := fnd_api.g_ret_sts_unexp_error;

1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141: WHEN fnd_api.g_exc_unexpected_error THEN
1142: ROLLBACK TO create_financial_reports_pub;
1143: x_return_status := fnd_api.g_ret_sts_unexp_error;
1144:
1145: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data);

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

1141: WHEN fnd_api.g_exc_unexpected_error THEN
1142: ROLLBACK TO create_financial_reports_pub;
1143: x_return_status := fnd_api.g_ret_sts_unexp_error;
1144:
1145: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data);
1148:
1149: -- Debug info.

Line 1163: x_return_status := fnd_api.g_ret_sts_unexp_error;

1159: p_msg_level=>fnd_log.level_procedure);
1160: END IF;
1161: WHEN OTHERS THEN
1162: ROLLBACK TO create_financial_reports_pub;
1163: x_return_status := fnd_api.g_ret_sts_unexp_error;
1164:
1165: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1166: fnd_message.set_token('ERROR' ,SQLERRM);
1167: fnd_msg_pub.add;

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

1165: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1166: fnd_message.set_token('ERROR' ,SQLERRM);
1167: fnd_msg_pub.add;
1168:
1169: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1170: p_count => x_msg_count,
1171: p_data => x_msg_data);
1172:
1173: -- Debug info.

Line 1209: x_return_status := FND_API.G_RET_STS_SUCCESS;

1205: --SAVEPOINT save_credit_ratings_pub; --Bug 6619304
1206: SAVEPOINT save_financial_reports_pub; --Bug 6619304
1207:
1208: -- initialize API return status to success.
1209: x_return_status := FND_API.G_RET_STS_SUCCESS;
1210:
1211: -- Debug info.
1212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug(p_message=>'save_financial_reports(+)',

Line 1249: RAISE FND_API.G_EXC_ERROR;

1245: FND_MSG_PUB.ADD;
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1247: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_FINANCIAL_REPORTS');
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_ERROR;
1250: END IF;
1251:
1252: IF(l_ovn IS NULL) THEN
1253: HZ_ORGANIZATION_INFO_V2PUB.create_financial_report(

Line 1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1275: -- assign financial_report_id
1276: p_fin_objs(i).financial_report_id := l_dummy_id;
1277: END IF;
1278:
1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, org id: '||p_organization_id,
1282: p_prefix=>l_debug_prefix,
1283: p_msg_level=>fnd_log.level_procedure);

Line 1288: RAISE FND_API.G_EXC_ERROR;

1284: END IF;
1285: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1286: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_FINANCIAL_REPORTS');
1287: FND_MSG_PUB.ADD;
1288: RAISE FND_API.G_EXC_ERROR;
1289: ELSE
1290: ---------------------------------
1291: -- Create/Update financial number
1292: ---------------------------------

Line 1320: RAISE FND_API.G_EXC_ERROR;

1316: FND_MSG_PUB.ADD;
1317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1318: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_NUMBERS');
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;
1322:
1323: IF(l_ovn IS NULL) THEN
1324: HZ_ORGANIZATION_INFO_V2PUB.create_financial_number(

Line 1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1344:
1345: -- assign financial_number_id
1346: p_fin_objs(i).financial_number_objs(j).financial_number_id := l_fin_number_rec.financial_number_id;
1347: END IF;
1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, fin_number_id: '||l_dummy_id,
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);

Line 1357: RAISE FND_API.G_EXC_ERROR;

1353: END IF;
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1355: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_NUMBERS');
1356: FND_MSG_PUB.ADD;
1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;
1359: END LOOP;
1360: END IF; --Bug 6619304
1361: END IF;

Line 1377: WHEN fnd_api.g_exc_error THEN

1373: p_prefix=>l_debug_prefix,
1374: p_msg_level=>fnd_log.level_procedure);
1375: END IF;
1376: EXCEPTION
1377: WHEN fnd_api.g_exc_error THEN
1378: ROLLBACK TO save_financial_reports_pub;
1379: x_return_status := fnd_api.g_ret_sts_error;
1380:
1381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1379: x_return_status := fnd_api.g_ret_sts_error;

1375: END IF;
1376: EXCEPTION
1377: WHEN fnd_api.g_exc_error THEN
1378: ROLLBACK TO save_financial_reports_pub;
1379: x_return_status := fnd_api.g_ret_sts_error;
1380:
1381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1382: p_count => x_msg_count,
1383: p_data => x_msg_data);

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

1377: WHEN fnd_api.g_exc_error THEN
1378: ROLLBACK TO save_financial_reports_pub;
1379: x_return_status := fnd_api.g_ret_sts_error;
1380:
1381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1382: p_count => x_msg_count,
1383: p_data => x_msg_data);
1384:
1385: -- Debug info.

Line 1397: WHEN fnd_api.g_exc_unexpected_error THEN

1393: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1394: p_prefix=>l_debug_prefix,
1395: p_msg_level=>fnd_log.level_procedure);
1396: END IF;
1397: WHEN fnd_api.g_exc_unexpected_error THEN
1398: ROLLBACK TO save_financial_reports_pub;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400:
1401: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1399: x_return_status := fnd_api.g_ret_sts_unexp_error;

1395: p_msg_level=>fnd_log.level_procedure);
1396: END IF;
1397: WHEN fnd_api.g_exc_unexpected_error THEN
1398: ROLLBACK TO save_financial_reports_pub;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400:
1401: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1402: p_count => x_msg_count,
1403: p_data => x_msg_data);

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

1397: WHEN fnd_api.g_exc_unexpected_error THEN
1398: ROLLBACK TO save_financial_reports_pub;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400:
1401: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1402: p_count => x_msg_count,
1403: p_data => x_msg_data);
1404:
1405: -- Debug info.

Line 1419: x_return_status := fnd_api.g_ret_sts_unexp_error;

1415: p_msg_level=>fnd_log.level_procedure);
1416: END IF;
1417: WHEN OTHERS THEN
1418: ROLLBACK TO save_financial_reports_pub;
1419: x_return_status := fnd_api.g_ret_sts_unexp_error;
1420:
1421: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1422: fnd_message.set_token('ERROR' ,SQLERRM);
1423: fnd_msg_pub.add;

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

1421: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1422: fnd_message.set_token('ERROR' ,SQLERRM);
1423: fnd_msg_pub.add;
1424:
1425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1426: p_count => x_msg_count,
1427: p_data => x_msg_data);
1428:
1429: -- Debug info.

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

1444: --
1445: -- DESCRIPTION
1446: -- Create organization business object.
1447: PROCEDURE do_create_organization_bo(
1448: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1449: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1450: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
1451: p_created_by_module IN VARCHAR2,
1452: p_obj_source IN VARCHAR2 := null,

Line 1449: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

1445: -- DESCRIPTION
1446: -- Create organization business object.
1447: PROCEDURE do_create_organization_bo(
1448: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1449: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1450: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
1451: p_created_by_module IN VARCHAR2,
1452: p_obj_source IN VARCHAR2 := null,
1453: x_return_status OUT NOCOPY VARCHAR2,

Line 1477: x_return_status := FND_API.G_RET_STS_SUCCESS;

1473: -- Standard start of API savepoint
1474: SAVEPOINT do_create_organization_bo_pub;
1475:
1476: -- initialize API return status to success.
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: -- Initialize message list if p_init_msg_list is set to TRUE.
1480: IF FND_API.to_Boolean(p_init_msg_list) THEN
1481: FND_MSG_PUB.initialize;

Line 1480: IF FND_API.to_Boolean(p_init_msg_list) THEN

1476: -- initialize API return status to success.
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: -- Initialize message list if p_init_msg_list is set to TRUE.
1480: IF FND_API.to_Boolean(p_init_msg_list) THEN
1481: FND_MSG_PUB.initialize;
1482: END IF;
1483:
1484: -- initialize Global variable

Line 1500: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;
1498:
1499: -- Base on p_validate_bo_flag to check completeness of business object
1500: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
1501: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
1502: p_bus_object_code => 'ORG',
1503: x_bus_object => l_bus_object
1504: );

Line 1510: RAISE fnd_api.g_exc_error;

1506: p_organization_obj => p_organization_obj,
1507: p_bus_object => l_bus_object
1508: );
1509: IF NOT(l_valid_obj) THEN
1510: RAISE fnd_api.g_exc_error;
1511: END IF;
1512:
1513: -- find out if raise event at the end
1514: l_raise_event := HZ_PARTY_BO_PVT.is_raising_create_event(

Line 1543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1539: x_return_status => x_return_status,
1540: x_msg_count => x_msg_count,
1541: x_msg_data => x_msg_data);
1542:
1543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:
1547: ---------------------------------------

Line 1544: RAISE FND_API.G_EXC_ERROR;

1540: x_msg_count => x_msg_count,
1541: x_msg_data => x_msg_data);
1542:
1543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:
1547: ---------------------------------------
1548: -- Assign organization and party record

Line 1568: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1564: x_msg_count => x_msg_count,
1565: x_msg_data => x_msg_data
1566: );
1567:
1568: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571:
1572: -- assign organization party_id

Line 1569: RAISE FND_API.G_EXC_ERROR;

1565: x_msg_data => x_msg_data
1566: );
1567:
1568: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571:
1572: -- assign organization party_id
1573: p_organization_obj.organization_id := x_organization_id;

Line 1591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1587: x_msg_count => x_msg_count,
1588: x_msg_data => x_msg_data
1589: );
1590:
1591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1592: RAISE FND_API.G_EXC_ERROR;
1593: END IF;
1594: END IF;
1595:

Line 1592: RAISE FND_API.G_EXC_ERROR;

1588: x_msg_data => x_msg_data
1589: );
1590:
1591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1592: RAISE FND_API.G_EXC_ERROR;
1593: END IF;
1594: END IF;
1595:
1596: ----------------------------

Line 1609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1605: x_msg_count => x_msg_count,
1606: x_msg_data => x_msg_data
1607: );
1608:
1609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;
1612: END IF;
1613:

Line 1610: RAISE FND_API.G_EXC_ERROR;

1606: x_msg_data => x_msg_data
1607: );
1608:
1609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;
1612: END IF;
1613:
1614: ----------------------------

Line 1628: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1624: x_msg_count => x_msg_count,
1625: x_msg_data => x_msg_data
1626: );
1627:
1628: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1631: END IF;
1632:

Line 1629: RAISE FND_API.G_EXC_ERROR;

1625: x_msg_data => x_msg_data
1626: );
1627:
1628: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1631: END IF;
1632:
1633: ----------------------------

Line 1647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1643: x_msg_count => x_msg_count,
1644: x_msg_data => x_msg_data
1645: );
1646:
1647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1648: RAISE FND_API.G_EXC_ERROR;
1649: END IF;
1650: END IF;
1651:

Line 1648: RAISE FND_API.G_EXC_ERROR;

1644: x_msg_data => x_msg_data
1645: );
1646:
1647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1648: RAISE FND_API.G_EXC_ERROR;
1649: END IF;
1650: END IF;
1651:
1652: ----------------------------

Line 1666: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1662: x_msg_count => x_msg_count,
1663: x_msg_data => x_msg_data
1664: );
1665:
1666: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: END IF;
1670:

Line 1667: RAISE FND_API.G_EXC_ERROR;

1663: x_msg_data => x_msg_data
1664: );
1665:
1666: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: END IF;
1670:
1671: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 1690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1686: p_parent_org_os => x_organization_os,
1687: p_parent_org_osr => x_organization_osr
1688: );
1689:
1690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: END IF;
1694:

Line 1691: RAISE FND_API.G_EXC_ERROR;

1687: p_parent_org_osr => x_organization_osr
1688: );
1689:
1690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: END IF;
1694:
1695: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1711: p_parent_osr => x_organization_osr,
1712: p_parent_obj_type => 'ORG'
1713: );
1714:
1715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: END IF;
1718: END IF;
1719:

Line 1716: RAISE FND_API.G_EXC_ERROR;

1712: p_parent_obj_type => 'ORG'
1713: );
1714:
1715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: END IF;
1718: END IF;
1719:
1720: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1746: x_msg_count => x_msg_count,
1747: x_msg_data => x_msg_data
1748: );
1749:
1750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1751: RAISE FND_API.G_EXC_ERROR;
1752: END IF;
1753: END IF;
1754:

Line 1751: RAISE FND_API.G_EXC_ERROR;

1747: x_msg_data => x_msg_data
1748: );
1749:
1750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1751: RAISE FND_API.G_EXC_ERROR;
1752: END IF;
1753: END IF;
1754:
1755: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1766: x_msg_count => x_msg_count,
1767: x_msg_data => x_msg_data
1768: );
1769:
1770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1771: RAISE FND_API.G_EXC_ERROR;
1772: END IF;
1773: END IF;
1774:

Line 1771: RAISE FND_API.G_EXC_ERROR;

1767: x_msg_data => x_msg_data
1768: );
1769:
1770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1771: RAISE FND_API.G_EXC_ERROR;
1772: END IF;
1773: END IF;
1774:
1775: ----------------------------

Line 1788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1784: x_msg_count => x_msg_count,
1785: x_msg_data => x_msg_data
1786: );
1787:
1788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1789: RAISE FND_API.G_EXC_ERROR;
1790: END IF;
1791: END IF;
1792:

Line 1789: RAISE FND_API.G_EXC_ERROR;

1785: x_msg_data => x_msg_data
1786: );
1787:
1788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1789: RAISE FND_API.G_EXC_ERROR;
1790: END IF;
1791: END IF;
1792:
1793: ----------------------------------

Line 1805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1801: x_return_status => x_return_status,
1802: x_msg_count => x_msg_count,
1803: x_msg_data => x_msg_data
1804: );
1805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1806: RAISE FND_API.G_EXC_ERROR;
1807: END IF;
1808: END IF;
1809:

Line 1806: RAISE FND_API.G_EXC_ERROR;

1802: x_msg_count => x_msg_count,
1803: x_msg_data => x_msg_data
1804: );
1805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1806: RAISE FND_API.G_EXC_ERROR;
1807: END IF;
1808: END IF;
1809:
1810:

Line 1824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1820: x_msg_count => x_msg_count,
1821: x_msg_data => x_msg_data
1822: );
1823:
1824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827: END IF;
1828:

Line 1825: RAISE FND_API.G_EXC_ERROR;

1821: x_msg_data => x_msg_data
1822: );
1823:
1824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827: END IF;
1828:
1829: ----------------------------

Line 1842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1838: x_msg_count => x_msg_count,
1839: x_msg_data => x_msg_data
1840: );
1841:
1842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1843: RAISE FND_API.G_EXC_ERROR;
1844: END IF;
1845: END IF;
1846:

Line 1843: RAISE FND_API.G_EXC_ERROR;

1839: x_msg_data => x_msg_data
1840: );
1841:
1842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1843: RAISE FND_API.G_EXC_ERROR;
1844: END IF;
1845: END IF;
1846:
1847: -- raise event

Line 1876: WHEN fnd_api.g_exc_error THEN

1872: p_msg_level=>fnd_log.level_procedure);
1873: END IF;
1874:
1875: EXCEPTION
1876: WHEN fnd_api.g_exc_error THEN
1877: ROLLBACK TO do_create_organization_bo_pub;
1878:
1879: -- reset Global variable
1880: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1887: x_return_status := fnd_api.g_ret_sts_error;

1883: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1884: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
1885: FND_MSG_PUB.ADD;
1886:
1887: x_return_status := fnd_api.g_ret_sts_error;
1888:
1889: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1890: p_count => x_msg_count,
1891: p_data => x_msg_data);

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

1885: FND_MSG_PUB.ADD;
1886:
1887: x_return_status := fnd_api.g_ret_sts_error;
1888:
1889: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1890: p_count => x_msg_count,
1891: p_data => x_msg_data);
1892:
1893: -- Debug info.

Line 1906: WHEN fnd_api.g_exc_unexpected_error THEN

1902: p_prefix=>l_debug_prefix,
1903: p_msg_level=>fnd_log.level_procedure);
1904: END IF;
1905:
1906: WHEN fnd_api.g_exc_unexpected_error THEN
1907: ROLLBACK TO do_create_organization_bo_pub;
1908:
1909: -- reset Global variable
1910: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1917: x_return_status := fnd_api.g_ret_sts_unexp_error;

1913: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1914: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
1915: FND_MSG_PUB.ADD;
1916:
1917: x_return_status := fnd_api.g_ret_sts_unexp_error;
1918:
1919: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1920: p_count => x_msg_count,
1921: p_data => x_msg_data);

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

1915: FND_MSG_PUB.ADD;
1916:
1917: x_return_status := fnd_api.g_ret_sts_unexp_error;
1918:
1919: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1920: p_count => x_msg_count,
1921: p_data => x_msg_data);
1922:
1923: -- Debug info.

Line 1947: x_return_status := fnd_api.g_ret_sts_unexp_error;

1943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1944: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
1945: FND_MSG_PUB.ADD;
1946:
1947: x_return_status := fnd_api.g_ret_sts_unexp_error;
1948:
1949: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1950: fnd_message.set_token('ERROR' ,SQLERRM);
1951: fnd_msg_pub.add;

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

1949: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1950: fnd_message.set_token('ERROR' ,SQLERRM);
1951: fnd_msg_pub.add;
1952:
1953: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:
1957: -- Debug info.

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

1968: END IF;
1969: END do_create_organization_bo;
1970:
1971: PROCEDURE create_organization_bo(
1972: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1973: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1974: p_organization_obj IN HZ_ORGANIZATION_BO,
1975: p_created_by_module IN VARCHAR2,
1976: x_return_status OUT NOCOPY VARCHAR2,

Line 1973: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

1969: END do_create_organization_bo;
1970:
1971: PROCEDURE create_organization_bo(
1972: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1973: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1974: p_organization_obj IN HZ_ORGANIZATION_BO,
1975: p_created_by_module IN VARCHAR2,
1976: x_return_status OUT NOCOPY VARCHAR2,
1977: x_msg_count OUT NOCOPY NUMBER,

Line 2002: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

1998: );
1999: END create_organization_bo;
2000:
2001: PROCEDURE create_organization_bo(
2002: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2003: p_organization_obj IN HZ_ORGANIZATION_BO,
2004: p_created_by_module IN VARCHAR2,
2005: p_obj_source IN VARCHAR2 := null,
2006: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

Line 2006: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

2002: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2003: p_organization_obj IN HZ_ORGANIZATION_BO,
2004: p_created_by_module IN VARCHAR2,
2005: p_obj_source IN VARCHAR2 := null,
2006: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2007: x_return_status OUT NOCOPY VARCHAR2,
2008: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2009: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2010: x_organization_id OUT NOCOPY NUMBER,

Line 2020: p_init_msg_list => fnd_api.g_true,

2016: l_org_obj HZ_ORGANIZATION_BO;
2017: BEGIN
2018: l_org_obj := p_organization_obj;
2019: do_create_organization_bo(
2020: p_init_msg_list => fnd_api.g_true,
2021: p_validate_bo_flag => p_validate_bo_flag,
2022: p_organization_obj => l_org_obj,
2023: p_created_by_module => p_created_by_module,
2024: p_obj_source => p_obj_source,

Line 2036: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2032: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2033: x_return_status => x_return_status,
2034: x_msg_count => l_msg_count,
2035: x_msg_data => l_msg_data);
2036: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2037: x_return_obj := l_org_obj;
2038: END IF;
2039: END create_organization_bo;
2040:

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

2042: --
2043: -- DESCRIPTION
2044: -- Update organization business object.
2045: PROCEDURE do_update_organization_bo(
2046: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2047: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
2048: p_created_by_module IN VARCHAR2,
2049: p_obj_source IN VARCHAR2 := null,
2050: x_return_status OUT NOCOPY VARCHAR2,

Line 2084: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2087: IF FND_API.to_Boolean(p_init_msg_list) THEN

2083: -- initialize API return status to success.
2084: x_return_status := FND_API.G_RET_STS_SUCCESS;
2085:
2086: -- Initialize message list if p_init_msg_list is set to TRUE.
2087: IF FND_API.to_Boolean(p_init_msg_list) THEN
2088: FND_MSG_PUB.initialize;
2089: END IF;
2090:
2091: -- initialize Global variable

Line 2121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2117: x_return_status => x_return_status,
2118: x_msg_count => x_msg_count,
2119: x_msg_data => x_msg_data);
2120:
2121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124:
2125: -- must check after calling validate_ssm_id because

Line 2122: RAISE FND_API.G_EXC_ERROR;

2118: x_msg_count => x_msg_count,
2119: x_msg_data => x_msg_data);
2120:
2121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124:
2125: -- must check after calling validate_ssm_id because
2126: -- if user pass os+osr and no id, validate_ssm_id will

Line 2187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2183: x_msg_count => x_msg_count,
2184: x_msg_data => x_msg_data
2185: );
2186:
2187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2188: RAISE FND_API.G_EXC_ERROR;
2189: END IF;
2190:
2191: -- assign organization party_id

Line 2188: RAISE FND_API.G_EXC_ERROR;

2184: x_msg_data => x_msg_data
2185: );
2186:
2187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2188: RAISE FND_API.G_EXC_ERROR;
2189: END IF;
2190:
2191: -- assign organization party_id
2192: p_organization_obj.organization_id := x_organization_id;

Line 2210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2206: x_msg_count => x_msg_count,
2207: x_msg_data => x_msg_data
2208: );
2209:
2210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2211: RAISE FND_API.G_EXC_ERROR;
2212: END IF;
2213: END IF;
2214:

Line 2211: RAISE FND_API.G_EXC_ERROR;

2207: x_msg_data => x_msg_data
2208: );
2209:
2210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2211: RAISE FND_API.G_EXC_ERROR;
2212: END IF;
2213: END IF;
2214:
2215: ----------------------------

Line 2228: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2224: x_msg_count => x_msg_count,
2225: x_msg_data => x_msg_data
2226: );
2227:
2228: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;
2231: END IF;
2232:

Line 2229: RAISE FND_API.G_EXC_ERROR;

2225: x_msg_data => x_msg_data
2226: );
2227:
2228: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;
2231: END IF;
2232:
2233: ----------------------------

Line 2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2243: x_msg_count => x_msg_count,
2244: x_msg_data => x_msg_data
2245: );
2246:
2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: END IF;
2250: END IF;
2251:

Line 2248: RAISE FND_API.G_EXC_ERROR;

2244: x_msg_data => x_msg_data
2245: );
2246:
2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: END IF;
2250: END IF;
2251:
2252: ----------------------------

Line 2266: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2262: x_msg_count => x_msg_count,
2263: x_msg_data => x_msg_data
2264: );
2265:
2266: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;
2269: END IF;
2270:

Line 2267: RAISE FND_API.G_EXC_ERROR;

2263: x_msg_data => x_msg_data
2264: );
2265:
2266: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;
2269: END IF;
2270:
2271: ----------------------------

Line 2285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2281: x_msg_count => x_msg_count,
2282: x_msg_data => x_msg_data
2283: );
2284:
2285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288: END IF;
2289:

Line 2286: RAISE FND_API.G_EXC_ERROR;

2282: x_msg_data => x_msg_data
2283: );
2284:
2285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288: END IF;
2289:
2290: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 2308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2304: p_parent_org_os => x_organization_os,
2305: p_parent_org_osr => x_organization_osr
2306: );
2307:
2308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2309: RAISE FND_API.G_EXC_ERROR;
2310: END IF;
2311: END IF;
2312:

Line 2309: RAISE FND_API.G_EXC_ERROR;

2305: p_parent_org_osr => x_organization_osr
2306: );
2307:
2308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2309: RAISE FND_API.G_EXC_ERROR;
2310: END IF;
2311: END IF;
2312:
2313: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 2333: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2329: p_parent_osr => x_organization_osr,
2330: p_parent_obj_type => 'ORG'
2331: );
2332:
2333: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2334: RAISE FND_API.G_EXC_ERROR;
2335: END IF;
2336: END IF;
2337:

Line 2334: RAISE FND_API.G_EXC_ERROR;

2330: p_parent_obj_type => 'ORG'
2331: );
2332:
2333: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2334: RAISE FND_API.G_EXC_ERROR;
2335: END IF;
2336: END IF;
2337:
2338: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 2368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2364: x_msg_count => x_msg_count,
2365: x_msg_data => x_msg_data
2366: );
2367:
2368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;
2371: END IF;
2372:

Line 2369: RAISE FND_API.G_EXC_ERROR;

2365: x_msg_data => x_msg_data
2366: );
2367:
2368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;
2371: END IF;
2372:
2373: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 2388: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2384: x_msg_count => x_msg_count,
2385: x_msg_data => x_msg_data
2386: );
2387:
2388: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2389: RAISE FND_API.G_EXC_ERROR;
2390: END IF;
2391: END IF;
2392:

Line 2389: RAISE FND_API.G_EXC_ERROR;

2385: x_msg_data => x_msg_data
2386: );
2387:
2388: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2389: RAISE FND_API.G_EXC_ERROR;
2390: END IF;
2391: END IF;
2392:
2393: ---------------------

Line 2406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2402: x_msg_count => x_msg_count,
2403: x_msg_data => x_msg_data
2404: );
2405:
2406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2407: RAISE FND_API.G_EXC_ERROR;
2408: END IF;
2409: END IF;
2410:

Line 2407: RAISE FND_API.G_EXC_ERROR;

2403: x_msg_data => x_msg_data
2404: );
2405:
2406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2407: RAISE FND_API.G_EXC_ERROR;
2408: END IF;
2409: END IF;
2410:
2411:

Line 2424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2420: x_return_status => x_return_status,
2421: x_msg_count => x_msg_count,
2422: x_msg_data => x_msg_data
2423: );
2424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;
2427: END IF;
2428:

Line 2425: RAISE FND_API.G_EXC_ERROR;

2421: x_msg_count => x_msg_count,
2422: x_msg_data => x_msg_data
2423: );
2424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;
2427: END IF;
2428:
2429:

Line 2443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2439: x_msg_count => x_msg_count,
2440: x_msg_data => x_msg_data
2441: );
2442:
2443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446: END IF;
2447:

Line 2444: RAISE FND_API.G_EXC_ERROR;

2440: x_msg_data => x_msg_data
2441: );
2442:
2443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446: END IF;
2447:
2448: ----------------------------

Line 2461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2457: x_msg_count => x_msg_count,
2458: x_msg_data => x_msg_data
2459: );
2460:
2461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2462: RAISE FND_API.G_EXC_ERROR;
2463: END IF;
2464: END IF;
2465:

Line 2462: RAISE FND_API.G_EXC_ERROR;

2458: x_msg_data => x_msg_data
2459: );
2460:
2461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2462: RAISE FND_API.G_EXC_ERROR;
2463: END IF;
2464: END IF;
2465:
2466: -- raise update org event

Line 2505: WHEN fnd_api.g_exc_error THEN

2501: p_prefix=>l_debug_prefix,
2502: p_msg_level=>fnd_log.level_procedure);
2503: END IF;
2504: EXCEPTION
2505: WHEN fnd_api.g_exc_error THEN
2506: ROLLBACK TO do_update_organization_bo_pub;
2507:
2508: -- reset Global variable
2509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2516: x_return_status := fnd_api.g_ret_sts_error;

2512: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2513: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2514: FND_MSG_PUB.ADD;
2515:
2516: x_return_status := fnd_api.g_ret_sts_error;
2517:
2518: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2519: p_count => x_msg_count,
2520: p_data => x_msg_data);

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

2514: FND_MSG_PUB.ADD;
2515:
2516: x_return_status := fnd_api.g_ret_sts_error;
2517:
2518: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2519: p_count => x_msg_count,
2520: p_data => x_msg_data);
2521:
2522: -- Debug info.

Line 2536: WHEN fnd_api.g_exc_unexpected_error THEN

2532: p_msg_level=>fnd_log.level_procedure);
2533: END IF;
2534:
2535:
2536: WHEN fnd_api.g_exc_unexpected_error THEN
2537: ROLLBACK TO do_update_organization_bo_pub;
2538:
2539: -- reset Global variable
2540: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2547: x_return_status := fnd_api.g_ret_sts_unexp_error;

2543: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2544: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2545: FND_MSG_PUB.ADD;
2546:
2547: x_return_status := fnd_api.g_ret_sts_unexp_error;
2548:
2549: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2550: p_count => x_msg_count,
2551: p_data => x_msg_data);

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

2545: FND_MSG_PUB.ADD;
2546:
2547: x_return_status := fnd_api.g_ret_sts_unexp_error;
2548:
2549: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2550: p_count => x_msg_count,
2551: p_data => x_msg_data);
2552:
2553: -- Debug info.

Line 2576: x_return_status := fnd_api.g_ret_sts_unexp_error;

2572: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2573: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2574: FND_MSG_PUB.ADD;
2575:
2576: x_return_status := fnd_api.g_ret_sts_unexp_error;
2577:
2578: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2579: fnd_message.set_token('ERROR' ,SQLERRM);
2580: fnd_msg_pub.add;

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

2578: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2579: fnd_message.set_token('ERROR' ,SQLERRM);
2580: fnd_msg_pub.add;
2581:
2582: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2583: p_count => x_msg_count,
2584: p_data => x_msg_data);
2585:
2586: -- Debug info.

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

2597: END IF;
2598: END do_update_organization_bo;
2599:
2600: PROCEDURE update_organization_bo(
2601: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2602: p_organization_obj IN HZ_ORGANIZATION_BO,
2603: p_created_by_module IN VARCHAR2,
2604: x_return_status OUT NOCOPY VARCHAR2,
2605: x_msg_count OUT NOCOPY NUMBER,

Line 2632: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

2628: PROCEDURE update_organization_bo(
2629: p_organization_obj IN HZ_ORGANIZATION_BO,
2630: p_created_by_module IN VARCHAR2,
2631: p_obj_source IN VARCHAR2 := null,
2632: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2633: x_return_status OUT NOCOPY VARCHAR2,
2634: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2635: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2636: x_organization_id OUT NOCOPY NUMBER,

Line 2646: p_init_msg_list => fnd_api.g_true,

2642: l_org_obj HZ_ORGANIZATION_BO;
2643: BEGIN
2644: l_org_obj := p_organization_obj;
2645: do_update_organization_bo(
2646: p_init_msg_list => fnd_api.g_true,
2647: p_organization_obj => l_org_obj,
2648: p_created_by_module => p_created_by_module,
2649: p_obj_source => p_obj_source,
2650: x_return_status => x_return_status,

Line 2661: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2657: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2658: x_return_status => x_return_status,
2659: x_msg_count => l_msg_count,
2660: x_msg_data => l_msg_data);
2661: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2662: x_return_obj := l_org_obj;
2663: END IF;
2664: END update_organization_bo;
2665:

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

2667: --
2668: -- DESCRIPTION
2669: -- Create or update organization business object.
2670: PROCEDURE do_save_organization_bo(
2671: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2672: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2673: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
2674: p_created_by_module IN VARCHAR2,
2675: p_obj_source IN VARCHAR2 := null,

Line 2672: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

2668: -- DESCRIPTION
2669: -- Create or update organization business object.
2670: PROCEDURE do_save_organization_bo(
2671: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2672: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2673: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
2674: p_created_by_module IN VARCHAR2,
2675: p_obj_source IN VARCHAR2 := null,
2676: x_return_status OUT NOCOPY VARCHAR2,

Line 2690: x_return_status := FND_API.G_RET_STS_SUCCESS;

2686: l_create_update_flag VARCHAR2(1);
2687: l_debug_prefix VARCHAR2(30);
2688: BEGIN
2689: -- initialize API return status to success.
2690: x_return_status := FND_API.G_RET_STS_SUCCESS;
2691:
2692: -- Initialize message list if p_init_msg_list is set to TRUE.
2693: IF FND_API.to_Boolean(p_init_msg_list) THEN
2694: FND_MSG_PUB.initialize;

Line 2693: IF FND_API.to_Boolean(p_init_msg_list) THEN

2689: -- initialize API return status to success.
2690: x_return_status := FND_API.G_RET_STS_SUCCESS;
2691:
2692: -- Initialize message list if p_init_msg_list is set to TRUE.
2693: IF FND_API.to_Boolean(p_init_msg_list) THEN
2694: FND_MSG_PUB.initialize;
2695: END IF;
2696:
2697: -- Debug info.

Line 2724: RAISE FND_API.G_EXC_ERROR;

2720: FND_MSG_PUB.ADD;
2721: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2722: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2723: FND_MSG_PUB.ADD;
2724: RAISE FND_API.G_EXC_ERROR;
2725: END IF;
2726:
2727: IF(l_create_update_flag = 'C') THEN
2728: do_create_organization_bo(

Line 2729: p_init_msg_list => fnd_api.g_false,

2725: END IF;
2726:
2727: IF(l_create_update_flag = 'C') THEN
2728: do_create_organization_bo(
2729: p_init_msg_list => fnd_api.g_false,
2730: p_validate_bo_flag => p_validate_bo_flag,
2731: p_organization_obj => p_organization_obj,
2732: p_created_by_module => p_created_by_module,
2733: p_obj_source => p_obj_source,

Line 2743: p_init_msg_list => fnd_api.g_false,

2739: x_organization_osr => x_organization_osr
2740: );
2741: ELSIF(l_create_update_flag = 'U') THEN
2742: do_update_organization_bo(
2743: p_init_msg_list => fnd_api.g_false,
2744: p_organization_obj => p_organization_obj,
2745: p_created_by_module => p_created_by_module,
2746: p_obj_source => p_obj_source,
2747: x_return_status => x_return_status,

Line 2755: RAISE FND_API.G_EXC_ERROR;

2751: x_organization_os => x_organization_os,
2752: x_organization_osr => x_organization_osr
2753: );
2754: ELSE
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757:
2758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2759: RAISE FND_API.G_EXC_ERROR;

Line 2758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2754: ELSE
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757:
2758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2759: RAISE FND_API.G_EXC_ERROR;
2760: END IF;
2761:
2762: -- Debug info.

Line 2759: RAISE FND_API.G_EXC_ERROR;

2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757:
2758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2759: RAISE FND_API.G_EXC_ERROR;
2760: END IF;
2761:
2762: -- Debug info.
2763: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2775: WHEN fnd_api.g_exc_error THEN

2771: p_prefix=>l_debug_prefix,
2772: p_msg_level=>fnd_log.level_procedure);
2773: END IF;
2774: EXCEPTION
2775: WHEN fnd_api.g_exc_error THEN
2776: x_return_status := fnd_api.g_ret_sts_error;
2777:
2778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2779: p_count => x_msg_count,

Line 2776: x_return_status := fnd_api.g_ret_sts_error;

2772: p_msg_level=>fnd_log.level_procedure);
2773: END IF;
2774: EXCEPTION
2775: WHEN fnd_api.g_exc_error THEN
2776: x_return_status := fnd_api.g_ret_sts_error;
2777:
2778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2779: p_count => x_msg_count,
2780: p_data => x_msg_data);

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

2774: EXCEPTION
2775: WHEN fnd_api.g_exc_error THEN
2776: x_return_status := fnd_api.g_ret_sts_error;
2777:
2778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2779: p_count => x_msg_count,
2780: p_data => x_msg_data);
2781:
2782: -- Debug info.

Line 2795: WHEN fnd_api.g_exc_unexpected_error THEN

2791: p_prefix=>l_debug_prefix,
2792: p_msg_level=>fnd_log.level_procedure);
2793: END IF;
2794:
2795: WHEN fnd_api.g_exc_unexpected_error THEN
2796: x_return_status := fnd_api.g_ret_sts_unexp_error;
2797:
2798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2799: p_count => x_msg_count,

Line 2796: x_return_status := fnd_api.g_ret_sts_unexp_error;

2792: p_msg_level=>fnd_log.level_procedure);
2793: END IF;
2794:
2795: WHEN fnd_api.g_exc_unexpected_error THEN
2796: x_return_status := fnd_api.g_ret_sts_unexp_error;
2797:
2798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2799: p_count => x_msg_count,
2800: p_data => x_msg_data);

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

2794:
2795: WHEN fnd_api.g_exc_unexpected_error THEN
2796: x_return_status := fnd_api.g_ret_sts_unexp_error;
2797:
2798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2799: p_count => x_msg_count,
2800: p_data => x_msg_data);
2801:
2802: -- Debug info.

Line 2815: x_return_status := fnd_api.g_ret_sts_unexp_error;

2811: p_prefix=>l_debug_prefix,
2812: p_msg_level=>fnd_log.level_procedure);
2813: END IF;
2814: WHEN OTHERS THEN
2815: x_return_status := fnd_api.g_ret_sts_unexp_error;
2816:
2817: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2818: fnd_message.set_token('ERROR' ,SQLERRM);
2819: fnd_msg_pub.add;

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

2817: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2818: fnd_message.set_token('ERROR' ,SQLERRM);
2819: fnd_msg_pub.add;
2820:
2821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2822: p_count => x_msg_count,
2823: p_data => x_msg_data);
2824:
2825: -- Debug info.

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

2836: END IF;
2837: END do_save_organization_bo;
2838:
2839: PROCEDURE save_organization_bo(
2840: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2841: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2842: p_organization_obj IN HZ_ORGANIZATION_BO,
2843: p_created_by_module IN VARCHAR2,
2844: x_return_status OUT NOCOPY VARCHAR2,

Line 2841: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

2837: END do_save_organization_bo;
2838:
2839: PROCEDURE save_organization_bo(
2840: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2841: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2842: p_organization_obj IN HZ_ORGANIZATION_BO,
2843: p_created_by_module IN VARCHAR2,
2844: x_return_status OUT NOCOPY VARCHAR2,
2845: x_msg_count OUT NOCOPY NUMBER,

Line 2870: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

2866: );
2867: END save_organization_bo;
2868:
2869: PROCEDURE save_organization_bo(
2870: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2871: p_organization_obj IN HZ_ORGANIZATION_BO,
2872: p_created_by_module IN VARCHAR2,
2873: p_obj_source IN VARCHAR2 := null,
2874: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

Line 2874: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

2870: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2871: p_organization_obj IN HZ_ORGANIZATION_BO,
2872: p_created_by_module IN VARCHAR2,
2873: p_obj_source IN VARCHAR2 := null,
2874: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2875: x_return_status OUT NOCOPY VARCHAR2,
2876: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2877: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2878: x_organization_id OUT NOCOPY NUMBER,

Line 2888: p_init_msg_list => fnd_api.g_true,

2884: l_org_obj HZ_ORGANIZATION_BO;
2885: BEGIN
2886: l_org_obj := p_organization_obj;
2887: do_save_organization_bo(
2888: p_init_msg_list => fnd_api.g_true,
2889: p_validate_bo_flag => p_validate_bo_flag,
2890: p_organization_obj => l_org_obj,
2891: p_created_by_module => p_created_by_module,
2892: p_obj_source => p_obj_source,

Line 2904: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2900: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2901: x_return_status => x_return_status,
2902: x_msg_count => l_msg_count,
2903: x_msg_data => l_msg_data);
2904: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2905: x_return_obj := l_org_obj;
2906: END IF;
2907: END save_organization_bo;
2908:

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

2916: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2917: --
2918: -- ARGUMENTS
2919: -- IN:
2920: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
2921: -- p_organization_id Organization ID.
2922: -- p_person_os Org orig system.
2923: -- p_person_osr Org orig system reference.
2924: -- OUT:

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

2923: -- p_person_osr Org orig system reference.
2924: -- OUT:
2925: -- x_organization_obj Logical organization record.
2926: -- x_return_status Return status after the call. The status can
2927: -- be fnd_api.g_ret_sts_success (success),
2928: -- fnd_api.g_ret_sts_error (error),
2929: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2930: -- x_msg_count Number of messages in message stack.
2931: -- x_msg_data Message text if x_msg_count is 1.

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

2924: -- OUT:
2925: -- x_organization_obj Logical organization record.
2926: -- x_return_status Return status after the call. The status can
2927: -- be fnd_api.g_ret_sts_success (success),
2928: -- fnd_api.g_ret_sts_error (error),
2929: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2930: -- x_msg_count Number of messages in message stack.
2931: -- x_msg_data Message text if x_msg_count is 1.
2932: --

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

2925: -- x_organization_obj Logical organization record.
2926: -- x_return_status Return status after the call. The status can
2927: -- be fnd_api.g_ret_sts_success (success),
2928: -- fnd_api.g_ret_sts_error (error),
2929: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2930: -- x_msg_count Number of messages in message stack.
2931: -- x_msg_data Message text if x_msg_count is 1.
2932: --
2933: -- NOTES

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

2977: */
2978:
2979:
2980: PROCEDURE get_organization_bo(
2981: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2982: p_organization_id IN NUMBER,
2983: p_organization_os IN VARCHAR2,
2984: p_organization_osr IN VARCHAR2,
2985: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,

Line 2998: x_return_status := FND_API.G_RET_STS_SUCCESS;

2994: l_organization_osr varchar2(255);
2995: BEGIN
2996:
2997: -- initialize API return status to success.
2998: x_return_status := FND_API.G_RET_STS_SUCCESS;
2999:
3000: -- Initialize message list if p_init_msg_list is set to TRUE
3001: IF FND_API.to_Boolean(p_init_msg_list) THEN
3002: FND_MSG_PUB.initialize;

Line 3001: IF FND_API.to_Boolean(p_init_msg_list) THEN

2997: -- initialize API return status to success.
2998: x_return_status := FND_API.G_RET_STS_SUCCESS;
2999:
3000: -- Initialize message list if p_init_msg_list is set to TRUE
3001: IF FND_API.to_Boolean(p_init_msg_list) THEN
3002: FND_MSG_PUB.initialize;
3003: END IF;
3004:
3005:

Line 3029: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3025: x_return_status => x_return_status,
3026: x_msg_count => x_msg_count,
3027: x_msg_data => x_msg_data);
3028:
3029: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3030: RAISE fnd_api.g_exc_error;
3031: END IF;
3032:
3033: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(

Line 3030: RAISE fnd_api.g_exc_error;

3026: x_msg_count => x_msg_count,
3027: x_msg_data => x_msg_data);
3028:
3029: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3030: RAISE fnd_api.g_exc_error;
3031: END IF;
3032:
3033: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
3034: p_init_msg_list => fnd_api.g_false,

Line 3034: p_init_msg_list => fnd_api.g_false,

3030: RAISE fnd_api.g_exc_error;
3031: END IF;
3032:
3033: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
3034: p_init_msg_list => fnd_api.g_false,
3035: p_organization_id => l_organization_id,
3036: p_action_type => NULL,
3037: x_organization_obj => x_organization_obj,
3038: x_return_status => x_return_status,

Line 3042: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3038: x_return_status => x_return_status,
3039: x_msg_count => x_msg_count,
3040: x_msg_data => x_msg_data);
3041:
3042: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045:
3046:

Line 3043: RAISE FND_API.G_EXC_ERROR;

3039: x_msg_count => x_msg_count,
3040: x_msg_data => x_msg_data);
3041:
3042: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045:
3046:
3047: -- Debug info.

Line 3065: WHEN fnd_api.g_exc_error THEN

3061:
3062:
3063: EXCEPTION
3064:
3065: WHEN fnd_api.g_exc_error THEN
3066: x_return_status := fnd_api.g_ret_sts_error;
3067:
3068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3069: p_count => x_msg_count,

Line 3066: x_return_status := fnd_api.g_ret_sts_error;

3062:
3063: EXCEPTION
3064:
3065: WHEN fnd_api.g_exc_error THEN
3066: x_return_status := fnd_api.g_ret_sts_error;
3067:
3068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3069: p_count => x_msg_count,
3070: p_data => x_msg_data);

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

3064:
3065: WHEN fnd_api.g_exc_error THEN
3066: x_return_status := fnd_api.g_ret_sts_error;
3067:
3068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3069: p_count => x_msg_count,
3070: p_data => x_msg_data);
3071:
3072: -- Debug info.

Line 3084: WHEN fnd_api.g_exc_unexpected_error THEN

3080: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3081: p_prefix=>l_debug_prefix,
3082: p_msg_level=>fnd_log.level_procedure);
3083: END IF;
3084: WHEN fnd_api.g_exc_unexpected_error THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086:
3087: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3088: p_count => x_msg_count,

Line 3085: x_return_status := fnd_api.g_ret_sts_unexp_error;

3081: p_prefix=>l_debug_prefix,
3082: p_msg_level=>fnd_log.level_procedure);
3083: END IF;
3084: WHEN fnd_api.g_exc_unexpected_error THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086:
3087: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3088: p_count => x_msg_count,
3089: p_data => x_msg_data);

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

3083: END IF;
3084: WHEN fnd_api.g_exc_unexpected_error THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086:
3087: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3088: p_count => x_msg_count,
3089: p_data => x_msg_data);
3090:
3091: -- Debug info.

Line 3104: x_return_status := fnd_api.g_ret_sts_unexp_error;

3100: p_prefix=>l_debug_prefix,
3101: p_msg_level=>fnd_log.level_procedure);
3102: END IF;
3103: WHEN OTHERS THEN
3104: x_return_status := fnd_api.g_ret_sts_unexp_error;
3105:
3106: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3107: fnd_message.set_token('ERROR' ,SQLERRM);
3108: fnd_msg_pub.add;

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

3106: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3107: fnd_message.set_token('ERROR' ,SQLERRM);
3108: fnd_msg_pub.add;
3109:
3110: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3111: p_count => x_msg_count,
3112: p_data => x_msg_data);
3113:
3114: -- Debug info.

Line 3141: p_init_msg_list => fnd_api.g_true,

3137: l_msg_data VARCHAR2(2000);
3138: l_msg_count NUMBER;
3139: BEGIN
3140: get_organization_bo(
3141: p_init_msg_list => fnd_api.g_true,
3142: p_organization_id => p_organization_id,
3143: p_organization_os => p_organization_os,
3144: p_organization_osr => p_organization_osr,
3145: x_organization_obj => x_organization_obj,

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

3168: -- ARGUMENTS
3169: -- IN:
3170: -- p_init_msg_list Initialize message stack if it is set to
3171: -- p_event_id BES Event identifier.
3172: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3173: -- OUT:
3174: -- x_organization_objs One or more created logical organization.
3175: -- x_return_status Return status after the call. The status can
3176: -- be fnd_api.g_ret_sts_success (success),

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

3172: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3173: -- OUT:
3174: -- x_organization_objs One or more created logical organization.
3175: -- x_return_status Return status after the call. The status can
3176: -- be fnd_api.g_ret_sts_success (success),
3177: -- fnd_api.g_ret_sts_error (error),
3178: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3179: -- x_msg_count Number of messages in message stack.
3180: -- x_msg_data Message text if x_msg_count is 1.

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

3173: -- OUT:
3174: -- x_organization_objs One or more created logical organization.
3175: -- x_return_status Return status after the call. The status can
3176: -- be fnd_api.g_ret_sts_success (success),
3177: -- fnd_api.g_ret_sts_error (error),
3178: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3179: -- x_msg_count Number of messages in message stack.
3180: -- x_msg_data Message text if x_msg_count is 1.
3181: --

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

3174: -- x_organization_objs One or more created logical organization.
3175: -- x_return_status Return status after the call. The status can
3176: -- be fnd_api.g_ret_sts_success (success),
3177: -- fnd_api.g_ret_sts_error (error),
3178: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3179: -- x_msg_count Number of messages in message stack.
3180: -- x_msg_data Message text if x_msg_count is 1.
3181: --
3182: -- NOTES

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

3202: */
3203:
3204:
3205: PROCEDURE get_organizations_created(
3206: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3207: p_event_id IN NUMBER,
3208: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
3209: x_return_status OUT NOCOPY VARCHAR2,
3210: x_msg_count OUT NOCOPY NUMBER,

Line 3217: x_return_status := FND_API.G_RET_STS_SUCCESS;

3213: l_debug_prefix VARCHAR2(30) := '';
3214: begin
3215:
3216: -- initialize API return status to success.
3217: x_return_status := FND_API.G_RET_STS_SUCCESS;
3218:
3219: -- Initialize message list if p_init_msg_list is set to TRUE
3220: IF FND_API.to_Boolean(p_init_msg_list) THEN
3221: FND_MSG_PUB.initialize;

Line 3220: IF FND_API.to_Boolean(p_init_msg_list) THEN

3216: -- initialize API return status to success.
3217: x_return_status := FND_API.G_RET_STS_SUCCESS;
3218:
3219: -- Initialize message list if p_init_msg_list is set to TRUE
3220: IF FND_API.to_Boolean(p_init_msg_list) THEN
3221: FND_MSG_PUB.initialize;
3222: END IF;
3223:
3224:

Line 3238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3234: p_event_type => 'C',
3235: p_bo_code => 'ORG',
3236: x_return_status => x_return_status);
3237:
3238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3239: RAISE FND_API.G_EXC_ERROR;
3240: END IF;
3241:
3242: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organizations_created(

Line 3239: RAISE FND_API.G_EXC_ERROR;

3235: p_bo_code => 'ORG',
3236: x_return_status => x_return_status);
3237:
3238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3239: RAISE FND_API.G_EXC_ERROR;
3240: END IF;
3241:
3242: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organizations_created(
3243: p_init_msg_list => fnd_api.g_false,

Line 3243: p_init_msg_list => fnd_api.g_false,

3239: RAISE FND_API.G_EXC_ERROR;
3240: END IF;
3241:
3242: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organizations_created(
3243: p_init_msg_list => fnd_api.g_false,
3244: p_event_id => p_event_id,
3245: x_organization_objs => x_organization_objs,
3246: x_return_status => x_return_status,
3247: x_msg_count => x_msg_count,

Line 3250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3246: x_return_status => x_return_status,
3247: x_msg_count => x_msg_count,
3248: x_msg_data => x_msg_data);
3249:
3250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3251: RAISE FND_API.G_EXC_ERROR;
3252: END IF;
3253:
3254:

Line 3251: RAISE FND_API.G_EXC_ERROR;

3247: x_msg_count => x_msg_count,
3248: x_msg_data => x_msg_data);
3249:
3250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3251: RAISE FND_API.G_EXC_ERROR;
3252: END IF;
3253:
3254:
3255:

Line 3274: WHEN fnd_api.g_exc_error THEN

3270:
3271:
3272: EXCEPTION
3273:
3274: WHEN fnd_api.g_exc_error THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276:
3277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3278: p_count => x_msg_count,

Line 3275: x_return_status := fnd_api.g_ret_sts_error;

3271:
3272: EXCEPTION
3273:
3274: WHEN fnd_api.g_exc_error THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276:
3277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3278: p_count => x_msg_count,
3279: p_data => x_msg_data);

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

3273:
3274: WHEN fnd_api.g_exc_error THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276:
3277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3278: p_count => x_msg_count,
3279: p_data => x_msg_data);
3280:
3281: -- Debug info.

Line 3293: WHEN fnd_api.g_exc_unexpected_error THEN

3289: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3290: p_prefix=>l_debug_prefix,
3291: p_msg_level=>fnd_log.level_procedure);
3292: END IF;
3293: WHEN fnd_api.g_exc_unexpected_error THEN
3294: x_return_status := fnd_api.g_ret_sts_unexp_error;
3295:
3296: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3297: p_count => x_msg_count,

Line 3294: x_return_status := fnd_api.g_ret_sts_unexp_error;

3290: p_prefix=>l_debug_prefix,
3291: p_msg_level=>fnd_log.level_procedure);
3292: END IF;
3293: WHEN fnd_api.g_exc_unexpected_error THEN
3294: x_return_status := fnd_api.g_ret_sts_unexp_error;
3295:
3296: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3297: p_count => x_msg_count,
3298: p_data => x_msg_data);

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

3292: END IF;
3293: WHEN fnd_api.g_exc_unexpected_error THEN
3294: x_return_status := fnd_api.g_ret_sts_unexp_error;
3295:
3296: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3297: p_count => x_msg_count,
3298: p_data => x_msg_data);
3299:
3300: -- Debug info.

Line 3313: x_return_status := fnd_api.g_ret_sts_unexp_error;

3309: p_prefix=>l_debug_prefix,
3310: p_msg_level=>fnd_log.level_procedure);
3311: END IF;
3312: WHEN OTHERS THEN
3313: x_return_status := fnd_api.g_ret_sts_unexp_error;
3314:
3315: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3316: fnd_message.set_token('ERROR' ,SQLERRM);
3317: fnd_msg_pub.add;

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

3315: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3316: fnd_message.set_token('ERROR' ,SQLERRM);
3317: fnd_msg_pub.add;
3318:
3319: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3320: p_count => x_msg_count,
3321: p_data => x_msg_data);
3322:
3323: -- Debug info.

Line 3348: p_init_msg_list => fnd_api.g_true,

3344: l_msg_data VARCHAR2(2000);
3345: l_msg_count NUMBER;
3346: BEGIN
3347: get_organizations_created(
3348: p_init_msg_list => fnd_api.g_true,
3349: p_event_id => p_event_id,
3350: x_organization_objs => x_organization_objs,
3351: x_return_status => x_return_status,
3352: x_msg_count => l_msg_count,

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

3374: -- ARGUMENTS
3375: -- IN:
3376: -- p_init_msg_list Initialize message stack if it is set to
3377: -- p_event_id BES Event identifier.
3378: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3379: -- OUT:
3380: -- x_organization_objs One or more created logical organization.
3381: -- x_return_status Return status after the call. The status can
3382: -- be fnd_api.g_ret_sts_success (success),

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

3378: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3379: -- OUT:
3380: -- x_organization_objs One or more created logical organization.
3381: -- x_return_status Return status after the call. The status can
3382: -- be fnd_api.g_ret_sts_success (success),
3383: -- fnd_api.g_ret_sts_error (error),
3384: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3385: -- x_msg_count Number of messages in message stack.
3386: -- x_msg_data Message text if x_msg_count is 1.

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

3379: -- OUT:
3380: -- x_organization_objs One or more created logical organization.
3381: -- x_return_status Return status after the call. The status can
3382: -- be fnd_api.g_ret_sts_success (success),
3383: -- fnd_api.g_ret_sts_error (error),
3384: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3385: -- x_msg_count Number of messages in message stack.
3386: -- x_msg_data Message text if x_msg_count is 1.
3387: --

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

3380: -- x_organization_objs One or more created logical organization.
3381: -- x_return_status Return status after the call. The status can
3382: -- be fnd_api.g_ret_sts_success (success),
3383: -- fnd_api.g_ret_sts_error (error),
3384: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3385: -- x_msg_count Number of messages in message stack.
3386: -- x_msg_data Message text if x_msg_count is 1.
3387: --
3388: -- NOTES

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

3405: structure and returns them to the caller.
3406: */
3407:
3408: PROCEDURE get_organizations_updated(
3409: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3410: p_event_id IN NUMBER,
3411: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
3412: x_return_status OUT NOCOPY VARCHAR2,
3413: x_msg_count OUT NOCOPY NUMBER,

Line 3421: x_return_status := FND_API.G_RET_STS_SUCCESS;

3417: l_debug_prefix VARCHAR2(30) := '';
3418: begin
3419:
3420: -- initialize API return status to success.
3421: x_return_status := FND_API.G_RET_STS_SUCCESS;
3422:
3423: -- Initialize message list if p_init_msg_list is set to TRUE
3424: IF FND_API.to_Boolean(p_init_msg_list) THEN
3425: FND_MSG_PUB.initialize;

Line 3424: IF FND_API.to_Boolean(p_init_msg_list) THEN

3420: -- initialize API return status to success.
3421: x_return_status := FND_API.G_RET_STS_SUCCESS;
3422:
3423: -- Initialize message list if p_init_msg_list is set to TRUE
3424: IF FND_API.to_Boolean(p_init_msg_list) THEN
3425: FND_MSG_PUB.initialize;
3426: END IF;
3427:
3428:

Line 3442: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3438: p_event_type => 'U',
3439: p_bo_code => 'ORG',
3440: x_return_status => x_return_status);
3441:
3442: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3443: RAISE FND_API.G_EXC_ERROR;
3444: END IF;
3445:
3446: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organizations_updated(

Line 3443: RAISE FND_API.G_EXC_ERROR;

3439: p_bo_code => 'ORG',
3440: x_return_status => x_return_status);
3441:
3442: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3443: RAISE FND_API.G_EXC_ERROR;
3444: END IF;
3445:
3446: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organizations_updated(
3447: p_init_msg_list => fnd_api.g_false,

Line 3447: p_init_msg_list => fnd_api.g_false,

3443: RAISE FND_API.G_EXC_ERROR;
3444: END IF;
3445:
3446: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organizations_updated(
3447: p_init_msg_list => fnd_api.g_false,
3448: p_event_id => p_event_id,
3449: x_organization_objs => x_organization_objs,
3450: x_return_status => x_return_status,
3451: x_msg_count => x_msg_count,

Line 3454: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3450: x_return_status => x_return_status,
3451: x_msg_count => x_msg_count,
3452: x_msg_data => x_msg_data);
3453:
3454: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3455: RAISE FND_API.G_EXC_ERROR;
3456: END IF;
3457:
3458:

Line 3455: RAISE FND_API.G_EXC_ERROR;

3451: x_msg_count => x_msg_count,
3452: x_msg_data => x_msg_data);
3453:
3454: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3455: RAISE FND_API.G_EXC_ERROR;
3456: END IF;
3457:
3458:
3459:

Line 3478: WHEN fnd_api.g_exc_error THEN

3474:
3475:
3476: EXCEPTION
3477:
3478: WHEN fnd_api.g_exc_error THEN
3479: x_return_status := fnd_api.g_ret_sts_error;
3480:
3481: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3482: p_count => x_msg_count,

Line 3479: x_return_status := fnd_api.g_ret_sts_error;

3475:
3476: EXCEPTION
3477:
3478: WHEN fnd_api.g_exc_error THEN
3479: x_return_status := fnd_api.g_ret_sts_error;
3480:
3481: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3482: p_count => x_msg_count,
3483: p_data => x_msg_data);

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

3477:
3478: WHEN fnd_api.g_exc_error THEN
3479: x_return_status := fnd_api.g_ret_sts_error;
3480:
3481: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3482: p_count => x_msg_count,
3483: p_data => x_msg_data);
3484:
3485: -- Debug info.

Line 3497: WHEN fnd_api.g_exc_unexpected_error THEN

3493: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3494: p_prefix=>l_debug_prefix,
3495: p_msg_level=>fnd_log.level_procedure);
3496: END IF;
3497: WHEN fnd_api.g_exc_unexpected_error THEN
3498: x_return_status := fnd_api.g_ret_sts_unexp_error;
3499:
3500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3501: p_count => x_msg_count,

Line 3498: x_return_status := fnd_api.g_ret_sts_unexp_error;

3494: p_prefix=>l_debug_prefix,
3495: p_msg_level=>fnd_log.level_procedure);
3496: END IF;
3497: WHEN fnd_api.g_exc_unexpected_error THEN
3498: x_return_status := fnd_api.g_ret_sts_unexp_error;
3499:
3500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3501: p_count => x_msg_count,
3502: p_data => x_msg_data);

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

3496: END IF;
3497: WHEN fnd_api.g_exc_unexpected_error THEN
3498: x_return_status := fnd_api.g_ret_sts_unexp_error;
3499:
3500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3501: p_count => x_msg_count,
3502: p_data => x_msg_data);
3503:
3504: -- Debug info.

Line 3517: x_return_status := fnd_api.g_ret_sts_unexp_error;

3513: p_prefix=>l_debug_prefix,
3514: p_msg_level=>fnd_log.level_procedure);
3515: END IF;
3516: WHEN OTHERS THEN
3517: x_return_status := fnd_api.g_ret_sts_unexp_error;
3518:
3519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3520: fnd_message.set_token('ERROR' ,SQLERRM);
3521: fnd_msg_pub.add;

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

3519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3520: fnd_message.set_token('ERROR' ,SQLERRM);
3521: fnd_msg_pub.add;
3522:
3523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3524: p_count => x_msg_count,
3525: p_data => x_msg_data);
3526:
3527: -- Debug info.

Line 3552: p_init_msg_list => fnd_api.g_true,

3548: l_msg_data VARCHAR2(2000);
3549: l_msg_count NUMBER;
3550: BEGIN
3551: get_organizations_updated(
3552: p_init_msg_list => fnd_api.g_true,
3553: p_event_id => p_event_id,
3554: x_organization_objs => x_organization_objs,
3555: x_return_status => x_return_status,
3556: x_msg_count => l_msg_count,

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

3576: -- ARGUMENTS
3577: -- IN:
3578: -- p_init_msg_list Initialize message stack if it is set to
3579: -- p_event_id BES Event identifier.
3580: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3581: -- OUT:
3582: -- x_organization_objs One or more created logical organization.
3583: -- x_return_status Return status after the call. The status can
3584: -- be fnd_api.g_ret_sts_success (success),

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

3580: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3581: -- OUT:
3582: -- x_organization_objs One or more created logical organization.
3583: -- x_return_status Return status after the call. The status can
3584: -- be fnd_api.g_ret_sts_success (success),
3585: -- fnd_api.g_ret_sts_error (error),
3586: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3587: -- x_msg_count Number of messages in message stack.
3588: -- x_msg_data Message text if x_msg_count is 1.

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

3581: -- OUT:
3582: -- x_organization_objs One or more created logical organization.
3583: -- x_return_status Return status after the call. The status can
3584: -- be fnd_api.g_ret_sts_success (success),
3585: -- fnd_api.g_ret_sts_error (error),
3586: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3587: -- x_msg_count Number of messages in message stack.
3588: -- x_msg_data Message text if x_msg_count is 1.
3589: --

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

3582: -- x_organization_objs One or more created logical organization.
3583: -- x_return_status Return status after the call. The status can
3584: -- be fnd_api.g_ret_sts_success (success),
3585: -- fnd_api.g_ret_sts_error (error),
3586: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3587: -- x_msg_count Number of messages in message stack.
3588: -- x_msg_data Message text if x_msg_count is 1.
3589: --
3590: -- NOTES

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

3594: -- 06-JUN-2005 AWU Created.
3595: --
3596:
3597: PROCEDURE get_organization_updated(
3598: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3599: p_event_id IN NUMBER,
3600: p_organization_id IN NUMBER,
3601: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
3602: x_return_status OUT NOCOPY VARCHAR2,

Line 3610: x_return_status := FND_API.G_RET_STS_SUCCESS;

3606: l_debug_prefix VARCHAR2(30) := '';
3607: begin
3608:
3609: -- initialize API return status to success.
3610: x_return_status := FND_API.G_RET_STS_SUCCESS;
3611:
3612: -- Initialize message list if p_init_msg_list is set to TRUE
3613: IF FND_API.to_Boolean(p_init_msg_list) THEN
3614: FND_MSG_PUB.initialize;

Line 3613: IF FND_API.to_Boolean(p_init_msg_list) THEN

3609: -- initialize API return status to success.
3610: x_return_status := FND_API.G_RET_STS_SUCCESS;
3611:
3612: -- Initialize message list if p_init_msg_list is set to TRUE
3613: IF FND_API.to_Boolean(p_init_msg_list) THEN
3614: FND_MSG_PUB.initialize;
3615: END IF;
3616:
3617:

Line 3631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3627: p_event_type => 'U',
3628: p_bo_code => 'ORG',
3629: x_return_status => x_return_status);
3630:
3631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3632: RAISE FND_API.G_EXC_ERROR;
3633: END IF;
3634:
3635: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_updated(

Line 3632: RAISE FND_API.G_EXC_ERROR;

3628: p_bo_code => 'ORG',
3629: x_return_status => x_return_status);
3630:
3631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3632: RAISE FND_API.G_EXC_ERROR;
3633: END IF;
3634:
3635: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_updated(
3636: p_init_msg_list => fnd_api.g_false,

Line 3636: p_init_msg_list => fnd_api.g_false,

3632: RAISE FND_API.G_EXC_ERROR;
3633: END IF;
3634:
3635: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_updated(
3636: p_init_msg_list => fnd_api.g_false,
3637: p_event_id => p_event_id,
3638: p_organization_id => p_organization_id,
3639: x_organization_obj => x_organization_obj,
3640: x_return_status => x_return_status,

Line 3644: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3640: x_return_status => x_return_status,
3641: x_msg_count => x_msg_count,
3642: x_msg_data => x_msg_data);
3643:
3644: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3645: RAISE FND_API.G_EXC_ERROR;
3646: END IF;
3647:
3648:

Line 3645: RAISE FND_API.G_EXC_ERROR;

3641: x_msg_count => x_msg_count,
3642: x_msg_data => x_msg_data);
3643:
3644: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3645: RAISE FND_API.G_EXC_ERROR;
3646: END IF;
3647:
3648:
3649:

Line 3668: WHEN fnd_api.g_exc_error THEN

3664:
3665:
3666: EXCEPTION
3667:
3668: WHEN fnd_api.g_exc_error THEN
3669: x_return_status := fnd_api.g_ret_sts_error;
3670:
3671: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3672: p_count => x_msg_count,

Line 3669: x_return_status := fnd_api.g_ret_sts_error;

3665:
3666: EXCEPTION
3667:
3668: WHEN fnd_api.g_exc_error THEN
3669: x_return_status := fnd_api.g_ret_sts_error;
3670:
3671: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3672: p_count => x_msg_count,
3673: p_data => x_msg_data);

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

3667:
3668: WHEN fnd_api.g_exc_error THEN
3669: x_return_status := fnd_api.g_ret_sts_error;
3670:
3671: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3672: p_count => x_msg_count,
3673: p_data => x_msg_data);
3674:
3675: -- Debug info.

Line 3687: WHEN fnd_api.g_exc_unexpected_error THEN

3683: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3684: p_prefix=>l_debug_prefix,
3685: p_msg_level=>fnd_log.level_procedure);
3686: END IF;
3687: WHEN fnd_api.g_exc_unexpected_error THEN
3688: x_return_status := fnd_api.g_ret_sts_unexp_error;
3689:
3690: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3691: p_count => x_msg_count,

Line 3688: x_return_status := fnd_api.g_ret_sts_unexp_error;

3684: p_prefix=>l_debug_prefix,
3685: p_msg_level=>fnd_log.level_procedure);
3686: END IF;
3687: WHEN fnd_api.g_exc_unexpected_error THEN
3688: x_return_status := fnd_api.g_ret_sts_unexp_error;
3689:
3690: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3691: p_count => x_msg_count,
3692: p_data => x_msg_data);

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

3686: END IF;
3687: WHEN fnd_api.g_exc_unexpected_error THEN
3688: x_return_status := fnd_api.g_ret_sts_unexp_error;
3689:
3690: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3691: p_count => x_msg_count,
3692: p_data => x_msg_data);
3693:
3694: -- Debug info.

Line 3707: x_return_status := fnd_api.g_ret_sts_unexp_error;

3703: p_prefix=>l_debug_prefix,
3704: p_msg_level=>fnd_log.level_procedure);
3705: END IF;
3706: WHEN OTHERS THEN
3707: x_return_status := fnd_api.g_ret_sts_unexp_error;
3708:
3709: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3710: fnd_message.set_token('ERROR' ,SQLERRM);
3711: fnd_msg_pub.add;

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

3709: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3710: fnd_message.set_token('ERROR' ,SQLERRM);
3711: fnd_msg_pub.add;
3712:
3713: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3714: p_count => x_msg_count,
3715: p_data => x_msg_data);
3716:
3717: -- Debug info.

Line 3743: p_init_msg_list => fnd_api.g_true,

3739: l_msg_data VARCHAR2(2000);
3740: l_msg_count NUMBER;
3741: BEGIN
3742: get_organization_updated(
3743: p_init_msg_list => fnd_api.g_true,
3744: p_event_id => p_event_id,
3745: p_organization_id => p_organization_id,
3746: x_organization_obj => x_organization_obj,
3747: x_return_status => x_return_status,

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

3756:
3757:
3758: -- get TCA identifiers for create event
3759: PROCEDURE get_ids_organizations_created (
3760: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3761: p_event_id IN NUMBER,
3762: x_organization_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
3763: x_return_status OUT NOCOPY VARCHAR2,
3764: x_msg_count OUT NOCOPY NUMBER,

Line 3772: x_return_status := FND_API.G_RET_STS_SUCCESS;

3768: l_debug_prefix VARCHAR2(30) := '';
3769:
3770: begin
3771: -- initialize API return status to success.
3772: x_return_status := FND_API.G_RET_STS_SUCCESS;
3773:
3774: -- Initialize message list if p_init_msg_list is set to TRUE
3775: IF FND_API.to_Boolean(p_init_msg_list) THEN
3776: FND_MSG_PUB.initialize;

Line 3775: IF FND_API.to_Boolean(p_init_msg_list) THEN

3771: -- initialize API return status to success.
3772: x_return_status := FND_API.G_RET_STS_SUCCESS;
3773:
3774: -- Initialize message list if p_init_msg_list is set to TRUE
3775: IF FND_API.to_Boolean(p_init_msg_list) THEN
3776: FND_MSG_PUB.initialize;
3777: END IF;
3778:
3779:

Line 3793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3789: p_event_type => 'C',
3790: p_bo_code => 'ORG',
3791: x_return_status => x_return_status);
3792:
3793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: END IF;
3796:
3797: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

Line 3794: RAISE FND_API.G_EXC_ERROR;

3790: p_bo_code => 'ORG',
3791: x_return_status => x_return_status);
3792:
3793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: END IF;
3796:
3797: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
3798: p_init_msg_list => fnd_api.g_false,

Line 3798: p_init_msg_list => fnd_api.g_false,

3794: RAISE FND_API.G_EXC_ERROR;
3795: END IF;
3796:
3797: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
3798: p_init_msg_list => fnd_api.g_false,
3799: p_event_id => p_event_id,
3800: x_obj_root_ids => x_organization_ids,
3801: x_return_status => x_return_status,
3802: x_msg_count => x_msg_count,

Line 3805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3801: x_return_status => x_return_status,
3802: x_msg_count => x_msg_count,
3803: x_msg_data => x_msg_data);
3804:
3805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3806: RAISE FND_API.G_EXC_ERROR;
3807: END IF;
3808:
3809:

Line 3806: RAISE FND_API.G_EXC_ERROR;

3802: x_msg_count => x_msg_count,
3803: x_msg_data => x_msg_data);
3804:
3805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3806: RAISE FND_API.G_EXC_ERROR;
3807: END IF;
3808:
3809:
3810: -- Debug info.

Line 3828: WHEN fnd_api.g_exc_error THEN

3824:
3825:
3826: EXCEPTION
3827:
3828: WHEN fnd_api.g_exc_error THEN
3829: x_return_status := fnd_api.g_ret_sts_error;
3830:
3831: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3832: p_count => x_msg_count,

Line 3829: x_return_status := fnd_api.g_ret_sts_error;

3825:
3826: EXCEPTION
3827:
3828: WHEN fnd_api.g_exc_error THEN
3829: x_return_status := fnd_api.g_ret_sts_error;
3830:
3831: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3832: p_count => x_msg_count,
3833: p_data => x_msg_data);

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

3827:
3828: WHEN fnd_api.g_exc_error THEN
3829: x_return_status := fnd_api.g_ret_sts_error;
3830:
3831: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3832: p_count => x_msg_count,
3833: p_data => x_msg_data);
3834:
3835: -- Debug info.

Line 3847: WHEN fnd_api.g_exc_unexpected_error THEN

3843: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3844: p_prefix=>l_debug_prefix,
3845: p_msg_level=>fnd_log.level_procedure);
3846: END IF;
3847: WHEN fnd_api.g_exc_unexpected_error THEN
3848: x_return_status := fnd_api.g_ret_sts_unexp_error;
3849:
3850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3851: p_count => x_msg_count,

Line 3848: x_return_status := fnd_api.g_ret_sts_unexp_error;

3844: p_prefix=>l_debug_prefix,
3845: p_msg_level=>fnd_log.level_procedure);
3846: END IF;
3847: WHEN fnd_api.g_exc_unexpected_error THEN
3848: x_return_status := fnd_api.g_ret_sts_unexp_error;
3849:
3850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3851: p_count => x_msg_count,
3852: p_data => x_msg_data);

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

3846: END IF;
3847: WHEN fnd_api.g_exc_unexpected_error THEN
3848: x_return_status := fnd_api.g_ret_sts_unexp_error;
3849:
3850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3851: p_count => x_msg_count,
3852: p_data => x_msg_data);
3853:
3854: -- Debug info.

Line 3867: x_return_status := fnd_api.g_ret_sts_unexp_error;

3863: p_prefix=>l_debug_prefix,
3864: p_msg_level=>fnd_log.level_procedure);
3865: END IF;
3866: WHEN OTHERS THEN
3867: x_return_status := fnd_api.g_ret_sts_unexp_error;
3868:
3869: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3870: fnd_message.set_token('ERROR' ,SQLERRM);
3871: fnd_msg_pub.add;

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

3869: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3870: fnd_message.set_token('ERROR' ,SQLERRM);
3871: fnd_msg_pub.add;
3872:
3873: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3874: p_count => x_msg_count,
3875: p_data => x_msg_data);
3876:
3877: -- Debug info.

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

3891:
3892:
3893: -- get TCA identifiers for update event
3894: PROCEDURE get_ids_organizations_updated (
3895: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3896: p_event_id IN NUMBER,
3897: x_organization_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
3898: x_return_status OUT NOCOPY VARCHAR2,
3899: x_msg_count OUT NOCOPY NUMBER,

Line 3906: x_return_status := FND_API.G_RET_STS_SUCCESS;

3902: l_debug_prefix VARCHAR2(30) := '';
3903:
3904: begin
3905: -- initialize API return status to success.
3906: x_return_status := FND_API.G_RET_STS_SUCCESS;
3907:
3908: -- Initialize message list if p_init_msg_list is set to TRUE
3909: IF FND_API.to_Boolean(p_init_msg_list) THEN
3910: FND_MSG_PUB.initialize;

Line 3909: IF FND_API.to_Boolean(p_init_msg_list) THEN

3905: -- initialize API return status to success.
3906: x_return_status := FND_API.G_RET_STS_SUCCESS;
3907:
3908: -- Initialize message list if p_init_msg_list is set to TRUE
3909: IF FND_API.to_Boolean(p_init_msg_list) THEN
3910: FND_MSG_PUB.initialize;
3911: END IF;
3912:
3913:

Line 3927: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3923: p_event_type => 'U',
3924: p_bo_code => 'ORG',
3925: x_return_status => x_return_status);
3926:
3927: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3928: RAISE FND_API.G_EXC_ERROR;
3929: END IF;
3930:
3931: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

Line 3928: RAISE FND_API.G_EXC_ERROR;

3924: p_bo_code => 'ORG',
3925: x_return_status => x_return_status);
3926:
3927: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3928: RAISE FND_API.G_EXC_ERROR;
3929: END IF;
3930:
3931: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
3932: p_init_msg_list => fnd_api.g_false,

Line 3932: p_init_msg_list => fnd_api.g_false,

3928: RAISE FND_API.G_EXC_ERROR;
3929: END IF;
3930:
3931: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
3932: p_init_msg_list => fnd_api.g_false,
3933: p_event_id => p_event_id,
3934: x_obj_root_ids => x_organization_ids,
3935: x_return_status => x_return_status,
3936: x_msg_count => x_msg_count,

Line 3939: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3935: x_return_status => x_return_status,
3936: x_msg_count => x_msg_count,
3937: x_msg_data => x_msg_data);
3938:
3939: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3940: RAISE FND_API.G_EXC_ERROR;
3941: END IF;
3942:
3943:

Line 3940: RAISE FND_API.G_EXC_ERROR;

3936: x_msg_count => x_msg_count,
3937: x_msg_data => x_msg_data);
3938:
3939: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3940: RAISE FND_API.G_EXC_ERROR;
3941: END IF;
3942:
3943:
3944: -- Debug info.

Line 3962: WHEN fnd_api.g_exc_error THEN

3958:
3959:
3960: EXCEPTION
3961:
3962: WHEN fnd_api.g_exc_error THEN
3963: x_return_status := fnd_api.g_ret_sts_error;
3964:
3965: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3966: p_count => x_msg_count,

Line 3963: x_return_status := fnd_api.g_ret_sts_error;

3959:
3960: EXCEPTION
3961:
3962: WHEN fnd_api.g_exc_error THEN
3963: x_return_status := fnd_api.g_ret_sts_error;
3964:
3965: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3966: p_count => x_msg_count,
3967: p_data => x_msg_data);

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

3961:
3962: WHEN fnd_api.g_exc_error THEN
3963: x_return_status := fnd_api.g_ret_sts_error;
3964:
3965: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3966: p_count => x_msg_count,
3967: p_data => x_msg_data);
3968:
3969: -- Debug info.

Line 3981: WHEN fnd_api.g_exc_unexpected_error THEN

3977: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
3978: p_prefix=>l_debug_prefix,
3979: p_msg_level=>fnd_log.level_procedure);
3980: END IF;
3981: WHEN fnd_api.g_exc_unexpected_error THEN
3982: x_return_status := fnd_api.g_ret_sts_unexp_error;
3983:
3984: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3985: p_count => x_msg_count,

Line 3982: x_return_status := fnd_api.g_ret_sts_unexp_error;

3978: p_prefix=>l_debug_prefix,
3979: p_msg_level=>fnd_log.level_procedure);
3980: END IF;
3981: WHEN fnd_api.g_exc_unexpected_error THEN
3982: x_return_status := fnd_api.g_ret_sts_unexp_error;
3983:
3984: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3985: p_count => x_msg_count,
3986: p_data => x_msg_data);

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

3980: END IF;
3981: WHEN fnd_api.g_exc_unexpected_error THEN
3982: x_return_status := fnd_api.g_ret_sts_unexp_error;
3983:
3984: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3985: p_count => x_msg_count,
3986: p_data => x_msg_data);
3987:
3988: -- Debug info.

Line 4001: x_return_status := fnd_api.g_ret_sts_unexp_error;

3997: p_prefix=>l_debug_prefix,
3998: p_msg_level=>fnd_log.level_procedure);
3999: END IF;
4000: WHEN OTHERS THEN
4001: x_return_status := fnd_api.g_ret_sts_unexp_error;
4002:
4003: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4004: fnd_message.set_token('ERROR' ,SQLERRM);
4005: fnd_msg_pub.add;

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

4003: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4004: fnd_message.set_token('ERROR' ,SQLERRM);
4005: fnd_msg_pub.add;
4006:
4007: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4008: p_count => x_msg_count,
4009: p_data => x_msg_data);
4010:
4011: -- Debug info.