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;
728:
729: x_return_status := fnd_api.g_ret_sts_error;
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;
728:
729: x_return_status := fnd_api.g_ret_sts_error;
730:
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;
752:
753: x_return_status := fnd_api.g_ret_sts_unexp_error;
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;
752:
753: x_return_status := fnd_api.g_ret_sts_unexp_error;
754:
769: p_msg_level=>fnd_log.level_procedure);
770: END IF;
771: WHEN OTHERS THEN
772: ROLLBACK TO create_credit_ratings_pub;
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;
770: END IF;
771: WHEN OTHERS THEN
772: ROLLBACK TO create_credit_ratings_pub;
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:
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;
782:
783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
782:
783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
784: p_count => x_msg_count,
870: hz_utility_v2pub.debug(p_message=>'Save Credit Ratings - Error occurred at hz_organization_bo_pub.check_credit_rating_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
871: p_prefix=>l_debug_prefix,
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:
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;
933:
934: x_return_status := fnd_api.g_ret_sts_error;
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;
933:
934: x_return_status := fnd_api.g_ret_sts_error;
935:
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;
957:
958: x_return_status := fnd_api.g_ret_sts_unexp_error;
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;
957:
958: x_return_status := fnd_api.g_ret_sts_unexp_error;
959:
974: p_msg_level=>fnd_log.level_procedure);
975: END IF;
976: WHEN OTHERS THEN
977: ROLLBACK TO save_credit_ratings_pub;
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;
975: END IF;
976: WHEN OTHERS THEN
977: ROLLBACK TO save_credit_ratings_pub;
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:
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;
987:
988: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
987:
988: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
989: p_count => x_msg_count,
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);
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
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);
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
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);
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;
1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);
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:
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;
1168:
1169: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
1168:
1169: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1170: p_count => x_msg_count,
1240: hz_utility_v2pub.debug(p_message=>'Save Financial Report - Error occurred at hz_organization_bo_pub.check_fin_report_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1241: p_prefix=>l_debug_prefix,
1242: p_msg_level=>fnd_log.level_procedure);
1243: END IF;
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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;
1242: p_msg_level=>fnd_log.level_procedure);
1243: END IF;
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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;
1243: END IF;
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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:
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);
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
1282: p_prefix=>l_debug_prefix,
1283: p_msg_level=>fnd_log.level_procedure);
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: ---------------------------------
1311: hz_utility_v2pub.debug(p_message=>'Save Financial Number - Error occurred at hz_organization_bo_pub.check_fin_number_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;
1315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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;
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;
1315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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;
1314: END IF;
1315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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:
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);
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;
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);
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;
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;
1424:
1425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
1424:
1425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1426: p_count => x_msg_count,
1879: -- reset Global variable
1880: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1881: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1882:
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;
1880: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1881: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1882:
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:
1909: -- reset Global variable
1910: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1911: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1912:
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;
1910: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1911: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1912:
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:
1939: -- reset Global variable
1940: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1941: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1942:
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;
1940: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1941: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1942:
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:
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;
1952:
1953: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
1952:
1953: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1954: p_count => x_msg_count,
2508: -- reset Global variable
2509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2511:
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;
2509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2511:
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:
2539: -- reset Global variable
2540: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2541: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2542:
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;
2540: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2541: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2542:
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:
2568: -- reset Global variable
2569: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2571:
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;
2569: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2571:
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:
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;
2581:
2582: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
2581:
2582: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2583: p_count => x_msg_count,
2715: p_parent_id => NULL,
2716: p_parent_obj_type=> NULL );
2717:
2718: IF(l_create_update_flag = 'E') THEN
2719: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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;
2717:
2718: IF(l_create_update_flag = 'E') THEN
2719: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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;
2718: IF(l_create_update_flag = 'E') THEN
2719: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
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:
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;
2820:
2821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
2820:
2821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2822: p_count => x_msg_count,
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;
3109:
3110: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
3109:
3110: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3111: p_count => x_msg_count,
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;
3318:
3319: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
3318:
3319: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3320: p_count => x_msg_count,
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;
3522:
3523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
3522:
3523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3524: p_count => x_msg_count,
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;
3712:
3713: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
3712:
3713: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3714: p_count => x_msg_count,
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;
3872:
3873: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
3872:
3873: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3874: p_count => x_msg_count,
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;
4006:
4007: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
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;
4006:
4007: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4008: p_count => x_msg_count,