91: UTL_FILE.FCLOSE(l_file_handle);
92: END IF;
93: EXCEPTION
94: WHEN UTL_FILE.INVALID_PATH THEN
95: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_PATH');
96: FND_MSG_PUB.ADD;
97:
98: IF (g_stop_on_debug_error = 'Y') THEN
99: RAISE FND_API.G_EXC_ERROR;
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: WHEN UTL_FILE.INVALID_MODE THEN
103: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_MODE');
104: FND_MSG_PUB.ADD;
105: IF (g_stop_on_debug_error = 'Y') THEN
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
110: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_FILEHANDLE');
111: FND_MSG_PUB.ADD;
112: IF (g_stop_on_debug_error = 'Y') THEN
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116: WHEN UTL_FILE.INVALID_OPERATION THEN
117: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_OPERATION');
118: FND_MSG_PUB.ADD;
119: IF (g_stop_on_debug_error = 'Y') THEN
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:
123: WHEN UTL_FILE.WRITE_ERROR THEN
124: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_WRITE_ERROR');
125: FND_MSG_PUB.ADD;
126: IF (g_stop_on_debug_error = 'Y') THEN
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;
129:
130: WHEN OTHERS THEN
131: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_PUT_LINE_ERROR');
132: FND_MSG_PUB.ADD;
133: IF (g_stop_on_debug_error = 'Y') THEN
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
146: p_token4_name in varchar2 := null,
147: p_token4_val in varchar2 := null
148: ) IS
149: BEGIN
150: FND_MESSAGE.SET_NAME('CSI',p_msg_name);
151: IF p_token1_name is not null then
152: FND_MESSAGE.SET_TOKEN(p_token1_name, p_token1_val);
153: END IF;
154:
148: ) IS
149: BEGIN
150: FND_MESSAGE.SET_NAME('CSI',p_msg_name);
151: IF p_token1_name is not null then
152: FND_MESSAGE.SET_TOKEN(p_token1_name, p_token1_val);
153: END IF;
154:
155: IF p_token2_name is not null then
156: FND_MESSAGE.SET_TOKEN(p_token2_name, p_token2_val);
152: FND_MESSAGE.SET_TOKEN(p_token1_name, p_token1_val);
153: END IF;
154:
155: IF p_token2_name is not null then
156: FND_MESSAGE.SET_TOKEN(p_token2_name, p_token2_val);
157: END IF;
158:
159: IF p_token3_name is not null then
160: FND_MESSAGE.SET_TOKEN(p_token3_name, p_token3_val);
156: FND_MESSAGE.SET_TOKEN(p_token2_name, p_token2_val);
157: END IF;
158:
159: IF p_token3_name is not null then
160: FND_MESSAGE.SET_TOKEN(p_token3_name, p_token3_val);
161: END IF;
162:
163: IF p_token4_name is not null then
164: FND_MESSAGE.SET_TOKEN(p_token4_name, p_token4_val);
160: FND_MESSAGE.SET_TOKEN(p_token3_name, p_token3_val);
161: END IF;
162:
163: IF p_token4_name is not null then
164: FND_MESSAGE.SET_TOKEN(p_token4_name, p_token4_val);
165: END IF;
166: --
167:
168: FND_MSG_PUB.Add;
1150:
1151: PROCEDURE check_ib_active IS
1152: BEGIN
1153: /* IF NOT csi_gen_utility_pvt.IB_ACTIVE THEN
1154: FND_MESSAGE.Set_Name('CSI', 'CSI_IB_NOT_ACTIVE');
1155: FND_MSG_PUB.Add;
1156: RAISE FND_API.G_Exc_Error;
1157: END IF
1158: */
1160: EXCEPTION
1161: WHEN fnd_api.g_exc_error THEN
1162: RAISE fnd_api.g_exc_error;
1163: WHEN others THEN
1164: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
1165: FND_MESSAGE.Set_Token('API_NAME', 'Check_IB_Active');
1166: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
1167: FND_MSG_PUB.Add;
1168: RAISE fnd_api.g_exc_error;
1161: WHEN fnd_api.g_exc_error THEN
1162: RAISE fnd_api.g_exc_error;
1163: WHEN others THEN
1164: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
1165: FND_MESSAGE.Set_Token('API_NAME', 'Check_IB_Active');
1166: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
1167: FND_MSG_PUB.Add;
1168: RAISE fnd_api.g_exc_error;
1169: END check_ib_active;
1162: RAISE fnd_api.g_exc_error;
1163: WHEN others THEN
1164: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
1165: FND_MESSAGE.Set_Token('API_NAME', 'Check_IB_Active');
1166: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
1167: FND_MSG_PUB.Add;
1168: RAISE fnd_api.g_exc_error;
1169: END check_ib_active;
1170: