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

Line 4: p_init_msg_list VARCHAR2(25) := FND_API.G_FALSE;

1: PACKAGE BODY IMC_CSV_LOAD AS
2: /* $Header: IMCLOADB.pls 120.12.12000000.2 2007/10/12 14:18:27 idali ship $ */
3: PROCEDURE LOAD_DETAILS(loadId NUMBER, batchId NUMBER) IS
4: p_init_msg_list VARCHAR2(25) := FND_API.G_FALSE;
5: x_return_status VARCHAR2(50);
6: x_msg_count NUMBER;
7: x_msg_data VARCHAR2(100);
8: load_id imc_csv_interface_fields.LOAD_ID%TYPE;

Line 1065: WHEN FND_API.G_EXC_ERROR THEN

1061: close get_details;
1062: -- Activating the created batch
1063:
1064: EXCEPTION
1065: WHEN FND_API.G_EXC_ERROR THEN
1066: ROLLBACK;
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: FND_MSG_PUB.Count_And_Get(
1069: p_encoded => FND_API.G_FALSE,

Line 1067: x_return_status := FND_API.G_RET_STS_ERROR;

1063:
1064: EXCEPTION
1065: WHEN FND_API.G_EXC_ERROR THEN
1066: ROLLBACK;
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: FND_MSG_PUB.Count_And_Get(
1069: p_encoded => FND_API.G_FALSE,
1070: p_count => x_msg_count,
1071: p_data => x_msg_data);

Line 1069: p_encoded => FND_API.G_FALSE,

1065: WHEN FND_API.G_EXC_ERROR THEN
1066: ROLLBACK;
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: FND_MSG_PUB.Count_And_Get(
1069: p_encoded => FND_API.G_FALSE,
1070: p_count => x_msg_count,
1071: p_data => x_msg_data);
1072: RAISE FND_API.G_EXC_ERROR;
1073: execute immediate 'update hz_imp_batch_summary set csv_status=''ERROR'' where load_type=''CSV'' and batch_id = '||batchId;

Line 1072: RAISE FND_API.G_EXC_ERROR;

1068: FND_MSG_PUB.Count_And_Get(
1069: p_encoded => FND_API.G_FALSE,
1070: p_count => x_msg_count,
1071: p_data => x_msg_data);
1072: RAISE FND_API.G_EXC_ERROR;
1073: execute immediate 'update hz_imp_batch_summary set csv_status=''ERROR'' where load_type=''CSV'' and batch_id = '||batchId;
1074:
1075:
1076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1072: RAISE FND_API.G_EXC_ERROR;
1073: execute immediate 'update hz_imp_batch_summary set csv_status=''ERROR'' where load_type=''CSV'' and batch_id = '||batchId;
1074:
1075:
1076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1077: ROLLBACK;
1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: FND_MSG_PUB.Count_And_Get(
1080: p_encoded => FND_API.G_FALSE,

Line 1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1080: p_encoded => FND_API.G_FALSE,

1076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1077: ROLLBACK;
1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: FND_MSG_PUB.Count_And_Get(
1080: p_encoded => FND_API.G_FALSE,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data);
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: execute immediate 'update hz_imp_batch_summary set csv_status=''ERROR'' where load_type=''CSV'' and batch_id = '||batchId;

Line 1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1079: FND_MSG_PUB.Count_And_Get(
1080: p_encoded => FND_API.G_FALSE,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data);
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: execute immediate 'update hz_imp_batch_summary set csv_status=''ERROR'' where load_type=''CSV'' and batch_id = '||batchId;
1085:
1086:
1087: WHEN OTHERS THEN

Line 1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1085:
1086:
1087: WHEN OTHERS THEN
1088: ROLLBACK;
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090:
1091: FND_MESSAGE.SET_NAME('AR', 'IMC_API_OTHERS_EXCEP');
1092: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1093: FND_MSG_PUB.ADD;

Line 1096: p_encoded => FND_API.G_FALSE,

1092: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1093: FND_MSG_PUB.ADD;
1094:
1095: FND_MSG_PUB.Count_And_Get(
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data );
1099: RAISE FND_API.G_EXC_ERROR;
1100: execute immediate 'update hz_imp_batch_summary set csv_status=''ERROR'' where load_type=''CSV'' and batch_id = '||batchId;

Line 1099: RAISE FND_API.G_EXC_ERROR;

1095: FND_MSG_PUB.Count_And_Get(
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data );
1099: RAISE FND_API.G_EXC_ERROR;
1100: execute immediate 'update hz_imp_batch_summary set csv_status=''ERROR'' where load_type=''CSV'' and batch_id = '||batchId;
1101:
1102: END;
1103: END IMC_CSV_LOAD;