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

Line 1646: x_return_status := FND_API.G_RET_STS_SUCCESS;

1642: END IF;
1643: -- savepoint process_cr_ins;
1644: FND_MSG_PUB.initialize;
1645: --Initialize API return status to success.
1646: x_return_status := FND_API.G_RET_STS_SUCCESS;
1647:
1648: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
1649: IF P_DML_RECORD.RERUN = 'N' /*** First Run ***/ THEN
1650: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1693: x_return_status := FND_API.G_RET_STS_ERROR;

1689: p_prefix=>'ERROR',
1690: p_msg_level=>fnd_log.level_error);
1691: END IF;
1692: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: WHEN OTHERS THEN
1695: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1696: hz_utility_v2pub.debug(p_message=>'CR: others err in exec imm',
1697: p_prefix=>'SQL ERROR',

Line 1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1700: p_prefix=>'SQL ERROR',
1701: p_msg_level=>fnd_log.level_error);
1702: END IF;
1703: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1705: END; -- end anonymous block for MTI with diabled lookups -ends
1706:
1707: ELSE -- enabled lookup case
1708:

Line 1755: x_return_status := FND_API.G_RET_STS_ERROR;

1751: p_prefix=>'ERROR',
1752: p_msg_level=>fnd_log.level_error);
1753: END IF;
1754: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
1755: x_return_status := FND_API.G_RET_STS_ERROR;
1756: WHEN OTHERS THEN
1757: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1758: hz_utility_v2pub.debug(p_message=>'CR: others err in exec imm',
1759: p_prefix=>'SQL ERROR',

Line 1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1762: p_prefix=>'SQL ERROR',
1763: p_msg_level=>fnd_log.level_error);
1764: END IF;
1765: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1767: END; -- end anonymous block for MTI with enabled lookups - ends
1768: END IF; -- disaled lookup check ends
1769: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1770: hz_utility_v2pub.debug(p_message=>'CR:bfr exec imm',

Line 1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1787: hz_utility_v2pub.debug(p_message=>sqlerrm,
1788: p_prefix=>'SQL ERROR',
1789: p_msg_level=>fnd_log.level_error);
1790: END IF;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792: END process_cr_ins;
1793: --------------------------------------
1794: /**
1795: * PRIVATE PROCEDURE process_cr_upd

Line 1837: x_return_status := FND_API.G_RET_STS_SUCCESS;

1833: -- savepoint process_cr_ins;
1834: FND_MSG_PUB.initialize;
1835:
1836: --Initialize API return status to success.
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838: open_upd_cursor (
1839: P_DML_RECORD
1840: ,c_update_cursor);
1841:

Line 2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2150: p_prefix=>'SQL ERROR',
2151: p_msg_level=>fnd_log.level_error);
2152: END IF;
2153: l_dml_exception := 'Y';
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: END; -- anonymous block end
2156: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2157: hz_utility_v2pub.debug(p_message=>'CR:credit rating id count bfr rep err:'||l_CREDIT_RATING_ID.COUNT,
2158: p_prefix =>l_debug_prefix,

Line 2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2174: hz_utility_v2pub.debug(p_message=>sqlerrm,
2175: p_prefix=>'ERROR',
2176: p_msg_level=>fnd_log.level_error);
2177: END IF;
2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179: END process_cr_upd;
2180: --------------------------------------
2181: /**
2182: * PRIVATE PROCEDURE populate_error_table

Line 2431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2427: hz_utility_v2pub.debug(p_message=>'CR:exception is:'||l_errm,
2428: p_prefix=>'ERROR',
2429: p_msg_level=>fnd_log.level_error);
2430: END IF;
2431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2432: END IF; -- error code 1 check ends
2433: ELSE
2434: -- if the error index is not the current interface row, exit
2435:

Line 2693: x_return_status := FND_API.G_RET_STS_SUCCESS;

2689: savepoint load_creditratings;
2690: -- Initialize teh message stack
2691: FND_MSG_PUB.initialize;
2692: -- Initialize API return status to success.
2693: x_return_status := FND_API.G_RET_STS_SUCCESS;
2694:
2695: process_cr_ins (
2696: P_DML_RECORD
2697: ,x_return_status

Line 2720: WHEN FND_API.G_EXC_ERROR THEN

2716: -- if enabled, disable debug
2717: --disable_debug;
2718: EXCEPTION
2719:
2720: WHEN FND_API.G_EXC_ERROR THEN
2721: ROLLBACK TO load_creditratings;
2722: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2723: hz_utility_v2pub.debug(p_message=>'CR:In load_creditratings() G_EXC_ERROR excp blk-',
2724: p_prefix=>'ERROR',

Line 2732: x_return_status := FND_API.G_RET_STS_ERROR;

2728: p_msg_level=>fnd_log.level_error);
2729: END IF;
2730: -- FND_FILE.put_line(fnd_file.log,'Expected error occurs while loading credit ratings');
2731: -- FND_FILE.put_line(fnd_file.log, l_errm);
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733: FND_MSG_PUB.Count_And_Get(
2734: p_encoded => FND_API.G_FALSE,
2735: p_count => x_msg_count,
2736: p_data => x_msg_data);

Line 2734: p_encoded => FND_API.G_FALSE,

2730: -- FND_FILE.put_line(fnd_file.log,'Expected error occurs while loading credit ratings');
2731: -- FND_FILE.put_line(fnd_file.log, l_errm);
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733: FND_MSG_PUB.Count_And_Get(
2734: p_encoded => FND_API.G_FALSE,
2735: p_count => x_msg_count,
2736: p_data => x_msg_data);
2737:
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2734: p_encoded => FND_API.G_FALSE,
2735: p_count => x_msg_count,
2736: p_data => x_msg_data);
2737:
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: ROLLBACK TO load_creditratings;
2740: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2741: hz_utility_v2pub.debug(p_message=>'CR:In load_creditratings() G_EXC_UNEXPECTED_ERROR excp blk-',
2742: p_prefix=>'UNEXPECTED ERROR',

Line 2750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2746: p_msg_level=>fnd_log.level_error);
2747: END IF;
2748: -- FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading credit ratings');
2749: -- FND_FILE.put_line(fnd_file.log, l_errm);
2750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2751: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2752: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
2753: FND_MSG_PUB.ADD;
2754: FND_MSG_PUB.Count_And_Get(

Line 2755: p_encoded => FND_API.G_FALSE,

2751: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2752: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
2753: FND_MSG_PUB.ADD;
2754: FND_MSG_PUB.Count_And_Get(
2755: p_encoded => FND_API.G_FALSE,
2756: p_count => x_msg_count,
2757: p_data => x_msg_data);
2758:
2759: WHEN OTHERS THEN

Line 2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2767: hz_utility_v2pub.debug(p_message=>sqlerrm,
2768: p_prefix=>'SQL ERROR',
2769: p_msg_level=>fnd_log.level_error);
2770: END IF;
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2773: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2774: FND_MSG_PUB.ADD;
2775: FND_MSG_PUB.Count_And_Get(

Line 2776: p_encoded => FND_API.G_FALSE,

2772: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2773: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2774: FND_MSG_PUB.ADD;
2775: FND_MSG_PUB.Count_And_Get(
2776: p_encoded => FND_API.G_FALSE,
2777: p_count => x_msg_count,
2778: p_data => x_msg_data);
2779:
2780: END load_creditratings;