4: /**********************
5: -- Package Constants
6: ************************/
7:
8: C_LOG_LEVEL_2 CONSTANT NUMBER := fnd_log.level_procedure;
9: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;
12: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
7:
8: C_LOG_LEVEL_2 CONSTANT NUMBER := fnd_log.level_procedure;
9: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;
12: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13: c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
186: x_source_system_code OUT NOCOPY NUMBER,
187: x_return_status OUT NOCOPY VARCHAR2
188: )
189: IS
190: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE := 'FTP_PAYMENT_SCHDULDE.validate_source_system';
191:
192: BEGIN
193: FEM_ENGINES_PKG.TECH_MESSAGE(
194: p_severity => C_LOG_LEVEL_2,
223: PROCEDURE Validate_Inst_Type_Code(
224: p_inst_type_code IN NUMBER,
225: x_return_status OUT NOCOPY VARCHAR2
226: ) IS
227: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE := 'FTP_PAYMENT_SCHDULDE.validate_Inst_Type_code';
228: x_inst_type_code Varchar2(100);
229: l_inst_type_code Varchar2(100);
230: BEGIN
231: l_inst_type_code := to_char(p_inst_type_code);