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

Line 56: X_return_status := FND_API.g_ret_sts_success;

52: /* Establish the savepoint initially */
53: SAVEPOINT parse_expression;
54:
55: /* First let us assign the return status to success */
56: X_return_status := FND_API.g_ret_sts_success;
57:
58: /* Delete any parsed expression which was existing already */
59: DELETE FROM gmd_parsed_expression
60: WHERE tech_parm_id = p_tech_parm_id;

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: x_return_status := l_return_status;
126: ROLLBACK TO SAVEPOINT parse_expression;
127: WHEN circular_reference THEN
128: GMD_API_GRP.log_message ('GMD_EXP_CIRC_REF');
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: WHEN OTHERS THEN
131: ROLLBACK TO SAVEPOINT parse_expression;
132: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Parse_Expression');
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

129: x_return_status := FND_API.G_RET_STS_ERROR;
130: WHEN OTHERS THEN
131: ROLLBACK TO SAVEPOINT parse_expression;
132: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Parse_Expression');
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: END parse_expression;
135:
136: /*******************************************************************************
137: * Procedure insert_expression_key

Line 158: X_return_status := FND_API.g_ret_sts_success;

154:
155: INSERT_EXPRESSION_ERR EXCEPTION;
156: BEGIN
157: /* First let us assign the return status to success */
158: X_return_status := FND_API.g_ret_sts_success;
159:
160: /* Lets initialize the message stack */
161: FND_MSG_PUB.initialize;
162:

Line 245: RAISE fnd_api.g_exc_error;

241: RAISE insert_expression_err;
242: END IF;
243: ELSE
244: GMD_API_GRP.log_message ('GMD_EXP_PARM_NOT_DEF', 'PARAMETER', P_key);
245: RAISE fnd_api.g_exc_error;
246: END IF;
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR;

Line 248: WHEN FND_API.G_EXC_ERROR THEN

244: GMD_API_GRP.log_message ('GMD_EXP_PARM_NOT_DEF', 'PARAMETER', P_key);
245: RAISE fnd_api.g_exc_error;
246: END IF;
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: WHEN insert_expression_err THEN
251: x_return_status := l_return_status;
252: WHEN OTHERS THEN

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: RAISE fnd_api.g_exc_error;
246: END IF;
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: WHEN insert_expression_err THEN
251: x_return_status := l_return_status;
252: WHEN OTHERS THEN
253: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Insert_Expression_Key');

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: WHEN insert_expression_err THEN
251: x_return_status := l_return_status;
252: WHEN OTHERS THEN
253: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Insert_Expression_Key');
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: END insert_expression_key;
256:
257: /*******************************************************************************
258: * Function is_operator

Line 357: X_return_status := FND_API.g_ret_sts_success;

353: ) IS
354: l_user_id NUMBER(15) DEFAULT FND_PROFILE.VALUE('USER_ID');
355: BEGIN
356: /* First let us assign the return status to success */
357: X_return_status := FND_API.g_ret_sts_success;
358:
359: INSERT INTO GMD_PARSED_EXPRESSION (tech_exp_seq_id, tech_parm_id, expression_key, expression_type,
360: expression_parm_id, creation_date, created_by, last_updated_by,
361: last_update_date,data_type)

Line 367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

363: l_user_id, sysdate,p_data_type);
364: EXCEPTION
365: WHEN OTHERS THEN
366: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Add_Expression_Row');
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: END add_expression_row;
369:
370: /*******************************************************************************
371: * Procedure evaluate_expression_value

Line 400: X_return_status := FND_API.g_ret_sts_success;

396:
397: EXPRESSION_EVAL_ERR EXCEPTION;
398: BEGIN
399: /* First let us assign the return status to success */
400: X_return_status := FND_API.g_ret_sts_success;
401:
402: gmd_debug.put_line('Evaluating....Line:'||p_line_id);
403: FOR m IN 1..p_expression_tab.COUNT LOOP
404: l_temp := l_temp||p_expression_tab(m).expression_key;

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

497: x_return_status := l_return_status;
498: WHEN OTHERS THEN
499: gmd_debug.put_line('ERROR:'||sqlerrm);
500: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Evaluate_Expression_Value');
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: END evaluate_expression_value;
503:
504:
505: /*******************************************************************************

Line 601: X_return_status := FND_API.g_ret_sts_success;

597: CIRCULAR_REFERENCE EXCEPTION;
598: PRAGMA EXCEPTION_INIT(circular_reference, -01436);
599: BEGIN
600: /* First let us assign the return status to success */
601: X_return_status := FND_API.g_ret_sts_success;
602:
603: /* Lets initialize the message stack */
604: FND_MSG_PUB.initialize;
605:

Line 627: IF x_return_status = FND_API.g_ret_sts_success THEN

623: evaluate_expression_value (p_line_id => p_line_id,
624: p_expression_tab => l_expression_tab,
625: x_value => l_value,
626: x_return_status => x_return_status);
627: IF x_return_status = FND_API.g_ret_sts_success THEN
628: X_value := l_value;
629: END IF;
630: END IF;
631: EXCEPTION

Line 634: x_return_status := FND_API.G_RET_STS_ERROR;

630: END IF;
631: EXCEPTION
632: WHEN circular_reference THEN
633: GMD_API_GRP.log_message ('GMD_EXP_CIRC_REF');
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: WHEN OTHERS THEN
636: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Evaluate_Expression');
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: END evaluate_expression;

Line 637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

633: GMD_API_GRP.log_message ('GMD_EXP_CIRC_REF');
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: WHEN OTHERS THEN
636: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Evaluate_Expression');
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: END evaluate_expression;
639:
640:
641: END GMD_EXPRESSION_UTIL;