APPS.GMO_CERT_TRANS_DETAIL_DBL dependencies on FND_API

Line 65: x_return_status := fnd_api.g_ret_sts_success;

61:
62:
63: BEGIN
64: -- Initially let us assign the return status to success
65: x_return_status := fnd_api.g_ret_sts_success;
66:
67:
68:
69:

Line 90: x_return_status := fnd_api.g_ret_sts_error;

86: RETURNING trans_detail_id
87: INTO p_trans_detail_id ;
88:
89: IF SQL%NOTFOUND THEN
90: x_return_status := fnd_api.g_ret_sts_error;
91: END IF;
92:
93: EXCEPTION
94: WHEN FND_API.g_exc_error THEN

Line 94: WHEN FND_API.g_exc_error THEN

90: x_return_status := fnd_api.g_ret_sts_error;
91: END IF;
92:
93: EXCEPTION
94: WHEN FND_API.g_exc_error THEN
95: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
96: x_return_status := fnd_api.g_ret_sts_error;
97: WHEN OTHERS THEN
98: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 96: x_return_status := fnd_api.g_ret_sts_error;

92:
93: EXCEPTION
94: WHEN FND_API.g_exc_error THEN
95: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
96: x_return_status := fnd_api.g_ret_sts_error;
97: WHEN OTHERS THEN
98: x_return_status := fnd_api.g_ret_sts_unexp_error;
99: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
100:

Line 98: x_return_status := fnd_api.g_ret_sts_unexp_error;

94: WHEN FND_API.g_exc_error THEN
95: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
96: x_return_status := fnd_api.g_ret_sts_error;
97: WHEN OTHERS THEN
98: x_return_status := fnd_api.g_ret_sts_unexp_error;
99: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
100:
101: END insert_row;
102: