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.XLA_DATAFIXES_PUB dependencies on FND_API

Line 130: IF (FND_API.to_boolean(p_init_msg_list)) THEN

126: p_module => l_log_module,
127: p_level => C_LEVEL_PROCEDURE);
128: END IF;
129:
130: IF (FND_API.to_boolean(p_init_msg_list)) THEN
131: FND_MSG_PUB.initialize;
132: END IF;
133:
134: -- Standard call to check for call compatibility.

Line 135: IF (NOT FND_API.compatible_api_call

131: FND_MSG_PUB.initialize;
132: END IF;
133:
134: -- Standard call to check for call compatibility.
135: IF (NOT FND_API.compatible_api_call
136: (p_current_version_number => l_api_version
137: ,p_caller_version_number => p_api_version
138: ,p_api_name => l_api_name
139: ,p_pkg_name => C_DEFAULT_MODULE))

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

137: ,p_caller_version_number => p_api_version
138: ,p_api_name => l_api_name
139: ,p_pkg_name => C_DEFAULT_MODULE))
140: THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
142: END IF;
143:
144: -- Initialize global variables
145: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
142: END IF;
143:
144: -- Initialize global variables
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: -----------------------------------------------------------------------------------
148: -- Validation
149: -----------------------------------------------------------------------------------

Line 221: WHEN FND_API.G_EXC_ERROR THEN

217: p_level => C_LEVEL_PROCEDURE);
218: END IF;
219:
220: EXCEPTION
221: WHEN FND_API.G_EXC_ERROR THEN
222: ROLLBACK;
223: x_return_status := FND_API.G_RET_STS_ERROR ;
224: FND_MSG_PUB.count_and_get(p_count => x_msg_count
225: ,p_data => x_msg_data);

Line 223: x_return_status := FND_API.G_RET_STS_ERROR ;

219:
220: EXCEPTION
221: WHEN FND_API.G_EXC_ERROR THEN
222: ROLLBACK;
223: x_return_status := FND_API.G_RET_STS_ERROR ;
224: FND_MSG_PUB.count_and_get(p_count => x_msg_count
225: ,p_data => x_msg_data);
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

223: x_return_status := FND_API.G_RET_STS_ERROR ;
224: FND_MSG_PUB.count_and_get(p_count => x_msg_count
225: ,p_data => x_msg_data);
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.count_and_get(p_count => x_msg_count
231: ,p_data => x_msg_data);

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

225: ,p_data => x_msg_data);
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.count_and_get(p_count => x_msg_count
231: ,p_data => x_msg_data);
232:
233: WHEN OTHERS THEN

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

231: ,p_data => x_msg_data);
232:
233: WHEN OTHERS THEN
234: ROLLBACK;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
237: FND_MSG_PUB.add_exc_msg(C_DEFAULT_MODULE, l_api_name);
238: END IF;
239: FND_MSG_PUB.count_and_get(p_count => x_msg_count

Line 347: IF (FND_API.to_boolean(p_init_msg_list)) THEN

343: p_module => l_log_module,
344: p_level => C_LEVEL_PROCEDURE);
345: END IF;
346:
347: IF (FND_API.to_boolean(p_init_msg_list)) THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350:
351: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 358: IF (NOT FND_API.compatible_api_call

354: p_level => C_LEVEL_PROCEDURE);
355: END IF;
356:
357: -- Standard call to check for call compatibility.
358: IF (NOT FND_API.compatible_api_call
359: (p_current_version_number => l_api_version
360: ,p_caller_version_number => p_api_version
361: ,p_api_name => l_api_name
362: ,p_pkg_name => C_DEFAULT_MODULE))

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

360: ,p_caller_version_number => p_api_version
361: ,p_api_name => l_api_name
362: ,p_pkg_name => C_DEFAULT_MODULE))
363: THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
365: END IF;
366:
367: -- Initialize global variables
368: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 368: x_return_status := FND_API.G_RET_STS_SUCCESS;

364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
365: END IF;
366:
367: -- Initialize global variables
368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369:
370:
371: -- Validation -------------------------------------------------------
372: /* Bug 7011889 - Modified from OPEN,FETCH to CURSOR FOR LOOP */

Line 917: WHEN FND_API.G_EXC_ERROR THEN

913: p_level => C_LEVEL_PROCEDURE);
914: END IF;
915:
916: EXCEPTION
917: WHEN FND_API.G_EXC_ERROR THEN
918: ROLLBACK;
919: x_return_status := FND_API.G_RET_STS_ERROR ;
920: FND_MSG_PUB.count_and_get(p_count => x_msg_count
921: ,p_data => x_msg_data);

Line 919: x_return_status := FND_API.G_RET_STS_ERROR ;

915:
916: EXCEPTION
917: WHEN FND_API.G_EXC_ERROR THEN
918: ROLLBACK;
919: x_return_status := FND_API.G_RET_STS_ERROR ;
920: FND_MSG_PUB.count_and_get(p_count => x_msg_count
921: ,p_data => x_msg_data);
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

919: x_return_status := FND_API.G_RET_STS_ERROR ;
920: FND_MSG_PUB.count_and_get(p_count => x_msg_count
921: ,p_data => x_msg_data);
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: ROLLBACK;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
926: FND_MSG_PUB.count_and_get(p_count => x_msg_count
927: ,p_data => x_msg_data);

Line 925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

921: ,p_data => x_msg_data);
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: ROLLBACK;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
926: FND_MSG_PUB.count_and_get(p_count => x_msg_count
927: ,p_data => x_msg_data);
928:
929: WHEN OTHERS THEN

Line 931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

927: ,p_data => x_msg_data);
928:
929: WHEN OTHERS THEN
930: ROLLBACK;
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
932: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
933: FND_MSG_PUB.add_exc_msg(C_DEFAULT_MODULE, l_api_name);
934: END IF;
935: FND_MSG_PUB.count_and_get(p_count => x_msg_count

Line 978: IF (FND_API.to_boolean(p_init_msg_list)) THEN

974: p_module => l_log_module,
975: p_level => C_LEVEL_PROCEDURE);
976: END IF;
977:
978: IF (FND_API.to_boolean(p_init_msg_list)) THEN
979: FND_MSG_PUB.initialize;
980: END IF;
981:
982: -- Standard call to check for call compatibility.

Line 983: IF (NOT FND_API.compatible_api_call

979: FND_MSG_PUB.initialize;
980: END IF;
981:
982: -- Standard call to check for call compatibility.
983: IF (NOT FND_API.compatible_api_call
984: (p_current_version_number => l_api_version
985: ,p_caller_version_number => p_api_version
986: ,p_api_name => l_api_name
987: ,p_pkg_name => C_DEFAULT_MODULE))

Line 989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

985: ,p_caller_version_number => p_api_version
986: ,p_api_name => l_api_name
987: ,p_pkg_name => C_DEFAULT_MODULE))
988: THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
990: END IF;
991:
992: -- Initialize global variables
993: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 993: x_return_status := FND_API.G_RET_STS_SUCCESS;

989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
990: END IF;
991:
992: -- Initialize global variables
993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994:
995: -- Validation ------------------------------------------------------------------------------------------
996: SELECT DECODE(NVL(budgetary_control_flag,'N'),'Y', C_STATUS_FUNDS_RESERVE, C_STATUS_FINAL),process_status_code
997: INTO l_accounting_mode, l_process_status

Line 1072: WHEN FND_API.G_EXC_ERROR THEN

1068: p_level => C_LEVEL_PROCEDURE);
1069: END IF;
1070:
1071: EXCEPTION
1072: WHEN FND_API.G_EXC_ERROR THEN
1073: ROLLBACK;
1074: x_return_status := FND_API.G_RET_STS_ERROR ;
1075: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1076: ,p_data => x_msg_data);

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR ;

1070:
1071: EXCEPTION
1072: WHEN FND_API.G_EXC_ERROR THEN
1073: ROLLBACK;
1074: x_return_status := FND_API.G_RET_STS_ERROR ;
1075: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1076: ,p_data => x_msg_data);
1077:
1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1074: x_return_status := FND_API.G_RET_STS_ERROR ;
1075: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1076: ,p_data => x_msg_data);
1077:
1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1079: ROLLBACK;
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1081: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1082: ,p_data => x_msg_data);

Line 1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1076: ,p_data => x_msg_data);
1077:
1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1079: ROLLBACK;
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1081: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1082: ,p_data => x_msg_data);
1083:
1084:

Line 1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1083:
1084:
1085: WHEN OTHERS THEN
1086: ROLLBACK;
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1089: FND_MSG_PUB.add_exc_msg(C_DEFAULT_MODULE, l_api_name);
1090: END IF;
1091: FND_MSG_PUB.count_and_get(p_count => x_msg_count

Line 1129: IF (FND_API.to_boolean(p_init_msg_list)) THEN

1125: p_module => l_log_module,
1126: p_level => C_LEVEL_PROCEDURE);
1127: END IF;
1128:
1129: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1130: FND_MSG_PUB.initialize;
1131: END IF;
1132:
1133: -- Standard call to check for call compatibility.

Line 1134: IF (NOT FND_API.compatible_api_call

1130: FND_MSG_PUB.initialize;
1131: END IF;
1132:
1133: -- Standard call to check for call compatibility.
1134: IF (NOT FND_API.compatible_api_call
1135: (p_current_version_number => l_api_version
1136: ,p_caller_version_number => p_api_version
1137: ,p_api_name => l_api_name
1138: ,p_pkg_name => C_DEFAULT_MODULE))

Line 1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1136: ,p_caller_version_number => p_api_version
1137: ,p_api_name => l_api_name
1138: ,p_pkg_name => C_DEFAULT_MODULE))
1139: THEN
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1141: END IF;
1142:
1143: -- Initialize global variables
1144: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1144: x_return_status := FND_API.G_RET_STS_SUCCESS;

1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1141: END IF;
1142:
1143: -- Initialize global variables
1144: x_return_status := FND_API.G_RET_STS_SUCCESS;
1145:
1146: UPDATE xla_ae_headers
1147: SET gl_transfer_status_code = 'NT'
1148: WHERE application_id = p_application_id

Line 1178: WHEN FND_API.G_EXC_ERROR THEN

1174: p_level => C_LEVEL_PROCEDURE);
1175: END IF;
1176:
1177: EXCEPTION
1178: WHEN FND_API.G_EXC_ERROR THEN
1179: ROLLBACK;
1180: x_return_status := FND_API.G_RET_STS_ERROR ;
1181: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1182: ,p_data => x_msg_data);

Line 1180: x_return_status := FND_API.G_RET_STS_ERROR ;

1176:
1177: EXCEPTION
1178: WHEN FND_API.G_EXC_ERROR THEN
1179: ROLLBACK;
1180: x_return_status := FND_API.G_RET_STS_ERROR ;
1181: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1182: ,p_data => x_msg_data);
1183:
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1180: x_return_status := FND_API.G_RET_STS_ERROR ;
1181: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1182: ,p_data => x_msg_data);
1183:
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1187: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1188: ,p_data => x_msg_data);

Line 1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1182: ,p_data => x_msg_data);
1183:
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1187: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1188: ,p_data => x_msg_data);
1189:
1190: WHEN OTHERS THEN

Line 1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1188: ,p_data => x_msg_data);
1189:
1190: WHEN OTHERS THEN
1191: ROLLBACK;
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1194: FND_MSG_PUB.add_exc_msg(C_DEFAULT_MODULE, l_api_name);
1195: END IF;
1196: FND_MSG_PUB.count_and_get(p_count => x_msg_count

Line 1233: IF (FND_API.to_boolean(p_init_msg_list)) THEN

1229: p_module => l_log_module,
1230: p_level => C_LEVEL_PROCEDURE);
1231: END IF;
1232:
1233: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1234: FND_MSG_PUB.initialize;
1235: END IF;
1236:
1237: -- Standard call to check for call compatibility.

Line 1238: IF (NOT FND_API.compatible_api_call

1234: FND_MSG_PUB.initialize;
1235: END IF;
1236:
1237: -- Standard call to check for call compatibility.
1238: IF (NOT FND_API.compatible_api_call
1239: (p_current_version_number => l_api_version
1240: ,p_caller_version_number => p_api_version
1241: ,p_api_name => l_api_name
1242: ,p_pkg_name => C_DEFAULT_MODULE))

Line 1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1240: ,p_caller_version_number => p_api_version
1241: ,p_api_name => l_api_name
1242: ,p_pkg_name => C_DEFAULT_MODULE))
1243: THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1245: END IF;
1246:
1247: -- Initialize global variables
1248: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1248: x_return_status := FND_API.G_RET_STS_SUCCESS;

1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1245: END IF;
1246:
1247: -- Initialize global variables
1248: x_return_status := FND_API.G_RET_STS_SUCCESS;
1249:
1250: SELECT count(*)
1251: INTO l_dummy
1252: FROM xla_ae_headers

Line 1299: WHEN FND_API.G_EXC_ERROR THEN

1295: p_level => C_LEVEL_PROCEDURE);
1296: END IF;
1297:
1298: EXCEPTION
1299: WHEN FND_API.G_EXC_ERROR THEN
1300: ROLLBACK;
1301: x_return_status := FND_API.G_RET_STS_ERROR ;
1302: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1303: ,p_data => x_msg_data);

Line 1301: x_return_status := FND_API.G_RET_STS_ERROR ;

1297:
1298: EXCEPTION
1299: WHEN FND_API.G_EXC_ERROR THEN
1300: ROLLBACK;
1301: x_return_status := FND_API.G_RET_STS_ERROR ;
1302: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1303: ,p_data => x_msg_data);
1304:
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1301: x_return_status := FND_API.G_RET_STS_ERROR ;
1302: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1303: ,p_data => x_msg_data);
1304:
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1306: ROLLBACK;
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1308: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1309: ,p_data => x_msg_data);

Line 1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1303: ,p_data => x_msg_data);
1304:
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1306: ROLLBACK;
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1308: FND_MSG_PUB.count_and_get(p_count => x_msg_count
1309: ,p_data => x_msg_data);
1310:
1311: WHEN OTHERS THEN

Line 1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1309: ,p_data => x_msg_data);
1310:
1311: WHEN OTHERS THEN
1312: ROLLBACK;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1315: FND_MSG_PUB.add_exc_msg(C_DEFAULT_MODULE, l_api_name);
1316: END IF;
1317: FND_MSG_PUB.count_and_get(p_count => x_msg_count

Line 1462: Raise FND_API.G_EXC_ERROR;

1458: ,p_msg_mode => g_msg_mode);
1459:
1460: END IF;
1461:
1462: Raise FND_API.G_EXC_ERROR;
1463:
1464: END log_error;
1465:
1466: