606: where file_id = X_file_id;
607:
608: EXCEPTION
609: when NO_DATA_FOUND then
610: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
611: fnd_message.set_token('ROUTINE','File ID: '||
612: update_file_metadata.X_file_id);
613: fnd_message.set_token('ERRNO', SQLCODE);
614: fnd_message.set_token('REASON', SQLERRM);
607:
608: EXCEPTION
609: when NO_DATA_FOUND then
610: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
611: fnd_message.set_token('ROUTINE','File ID: '||
612: update_file_metadata.X_file_id);
613: fnd_message.set_token('ERRNO', SQLCODE);
614: fnd_message.set_token('REASON', SQLERRM);
615: RAISE;
609: when NO_DATA_FOUND then
610: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
611: fnd_message.set_token('ROUTINE','File ID: '||
612: update_file_metadata.X_file_id);
613: fnd_message.set_token('ERRNO', SQLCODE);
614: fnd_message.set_token('REASON', SQLERRM);
615: RAISE;
616:
617: END update_file_metadata;
610: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
611: fnd_message.set_token('ROUTINE','File ID: '||
612: update_file_metadata.X_file_id);
613: fnd_message.set_token('ERRNO', SQLCODE);
614: fnd_message.set_token('REASON', SQLERRM);
615: RAISE;
616:
617: END update_file_metadata;
618: