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.OKL_TBC_DEFINITIONS_PUB dependencies on OKL_API

Line 120: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

116: FROM zx_fc_user_defined_v
117: WHERE classification_code = p_lookup_code;
118:
119: l_result_code VARCHAR2(300) := 'XXXXX';
120: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
121: l_meaning VARCHAR2(80);
122:
123: l_msg_name VARCHAR2(80);
124: l_token1 VARCHAR2(10);

Line 128: IF ((p_tbcv_rec.RESULT_CODE = OKL_API.G_MISS_CHAR OR p_tbcv_rec.RESULT_CODE IS NULL) ) THEN

124: l_token1 VARCHAR2(10);
125:
126: BEGIN
127:
128: IF ((p_tbcv_rec.RESULT_CODE = OKL_API.G_MISS_CHAR OR p_tbcv_rec.RESULT_CODE IS NULL) ) THEN
129:
130: x_return_status := OKC_API.G_RET_STS_ERROR;
131: --Unable to create Category definition as mandatory attributes are provided.
132: OKL_API.set_message(p_app_name => 'OKL',

Line 132: OKL_API.set_message(p_app_name => 'OKL',

128: IF ((p_tbcv_rec.RESULT_CODE = OKL_API.G_MISS_CHAR OR p_tbcv_rec.RESULT_CODE IS NULL) ) THEN
129:
130: x_return_status := OKC_API.G_RET_STS_ERROR;
131: --Unable to create Category definition as mandatory attributes are provided.
132: OKL_API.set_message(p_app_name => 'OKL',
133: p_msg_name => 'OKL_TX_NO_TBC_ATTR');
134: RAISE G_EXCEPTION_HALT_VALIDATION;
135:
136: END IF;

Line 137: IF (p_tbcv_rec.AGE_OF_EQUIP_FROM IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_FROM <> OKL_API.G_MISS_NUM) AND

133: p_msg_name => 'OKL_TX_NO_TBC_ATTR');
134: RAISE G_EXCEPTION_HALT_VALIDATION;
135:
136: END IF;
137: IF (p_tbcv_rec.AGE_OF_EQUIP_FROM IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_FROM <> OKL_API.G_MISS_NUM) AND
138: (p_tbcv_rec.AGE_OF_EQUIP_TO IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_TO <> OKL_API.G_MISS_NUM) THEN
139: IF p_tbcv_rec.AGE_OF_EQUIP_TO < p_tbcv_rec.AGE_OF_EQUIP_FROM THEN
140: x_return_status := OKC_API.G_RET_STS_ERROR;
141: --Unable to create Transcation Business Category definition as none of the attributes are provided.

Line 138: (p_tbcv_rec.AGE_OF_EQUIP_TO IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_TO <> OKL_API.G_MISS_NUM) THEN

134: RAISE G_EXCEPTION_HALT_VALIDATION;
135:
136: END IF;
137: IF (p_tbcv_rec.AGE_OF_EQUIP_FROM IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_FROM <> OKL_API.G_MISS_NUM) AND
138: (p_tbcv_rec.AGE_OF_EQUIP_TO IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_TO <> OKL_API.G_MISS_NUM) THEN
139: IF p_tbcv_rec.AGE_OF_EQUIP_TO < p_tbcv_rec.AGE_OF_EQUIP_FROM THEN
140: x_return_status := OKC_API.G_RET_STS_ERROR;
141: --Unable to create Transcation Business Category definition as none of the attributes are provided.
142: OKL_API.set_message(p_app_name => 'OKL',

Line 142: OKL_API.set_message(p_app_name => 'OKL',

138: (p_tbcv_rec.AGE_OF_EQUIP_TO IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_TO <> OKL_API.G_MISS_NUM) THEN
139: IF p_tbcv_rec.AGE_OF_EQUIP_TO < p_tbcv_rec.AGE_OF_EQUIP_FROM THEN
140: x_return_status := OKC_API.G_RET_STS_ERROR;
141: --Unable to create Transcation Business Category definition as none of the attributes are provided.
142: OKL_API.set_message(p_app_name => 'OKL',
143: p_msg_name => 'OKL_TX_INVALID_AGE_RANGE');
144: RAISE G_EXCEPTION_HALT_VALIDATION;
145:
146: END IF;

Line 198: OKL_API.set_message(p_app_name => 'OKL',

194: -- Another Category already exists for this combination of tax determinants.
195: -- modified by dcshanmu for eBTax project - modification start
196: -- modified default values passed to p_msg_name and p_token1
197: IF l_token1 = 'UFC_CODE' THEN
198: OKL_API.set_message(p_app_name => 'OKL',
199: p_msg_name => l_msg_name,
200: p_token1 => l_token1,
201: p_token1_value => l_meaning);
202:

Line 205: OKL_API.set_message(p_app_name => 'OKL',

201: p_token1_value => l_meaning);
202:
203: ELSE
204:
205: OKL_API.set_message(p_app_name => 'OKL',
206: p_msg_name => l_msg_name,
207: p_token1 => l_token1,
208: p_token1_value => l_meaning,
209: p_token2 => 'REC_NO',

Line 221: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

217: EXCEPTION
218: WHEN G_EXCEPTION_HALT_VALIDATION THEN
219: RETURN(x_return_status);
220: WHEN OTHERS THEN
221: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
222: ,p_msg_name => G_UNEXPECTED_ERROR
223: ,p_token1 => G_SQLCODE_TOKEN
224: ,p_token1_value => SQLCODE
225: ,p_token2 => G_SQLERRM_TOKEN

Line 227: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

223: ,p_token1 => G_SQLCODE_TOKEN
224: ,p_token1_value => SQLCODE
225: ,p_token2 => G_SQLERRM_TOKEN
226: ,p_token2_value => SQLERRM);
227: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
228: RETURN(x_return_status);
229: END Validate_Record;
230:
231: PROCEDURE insert_tbc_definition(

Line 250: OKL_API.init_msg_list(p_init_msg_list);

246: lp_tbcv_rec tbcv_rec_type;
247: lx_tbcv_rec tbcv_rec_type;
248:
249: BEGIN
250: OKL_API.init_msg_list(p_init_msg_list);
251: SAVEPOINT tbc_insert ;
252:
253:
254: l_api_version := p_api_version ;

Line 343: OKL_API.init_msg_list(p_init_msg_list);

339: lx_tbcv_tbl tbcv_tbl_type;
340: lx_tbcv_rec tbcv_rec_type;
341:
342: BEGIN
343: OKL_API.init_msg_list(p_init_msg_list);
344: SAVEPOINT tbc_insert;
345:
346:
347: l_api_version := p_api_version ;