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:
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
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;
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:
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: