DBA Data[Home] [Help]

APPS.GMO_OPERT_CERT_GTMP_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 84: x_return_status := fnd_api.g_ret_sts_error;

80:
81: ) ;
82:
83: IF SQL%NOTFOUND THEN
84: x_return_status := fnd_api.g_ret_sts_error;
85: END IF;
86:
87: EXCEPTION
88: WHEN FND_API.g_exc_error THEN

Line 88: WHEN FND_API.g_exc_error THEN

84: x_return_status := fnd_api.g_ret_sts_error;
85: END IF;
86:
87: EXCEPTION
88: WHEN FND_API.g_exc_error THEN
89: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
90: x_return_status := fnd_api.g_ret_sts_error;
91: WHEN OTHERS THEN
92: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 90: x_return_status := fnd_api.g_ret_sts_error;

86:
87: EXCEPTION
88: WHEN FND_API.g_exc_error THEN
89: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
90: x_return_status := fnd_api.g_ret_sts_error;
91: WHEN OTHERS THEN
92: x_return_status := fnd_api.g_ret_sts_unexp_error;
93: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
94:

Line 92: x_return_status := fnd_api.g_ret_sts_unexp_error;

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